Transport Master

Discussion in 'Tally Developer' started by seyed mohamed, Jun 17, 2025.

  1. seyed mohamed

    seyed mohamed New Member


    Please correct my code "Incorrect Storage" in [Field: CMPVehicleNo] Error Showing

    [#Menu: Gateway Of Tally]
    Add : Item :Before: @@locquit: "Transport Master" : Alter : transportmaster

    [Report: transportmaster]
    Form : transportfrm
    Object : Company

    [Form: transportfrm]
    Part : transportHPart, transporter
    Height : 70% Screen
    Width : 20% Screen
    Background : PurchaseVocherclr
    SpaceRight : 0.5
    SpaceLeft : 1.5
    Local : Field : Form SubTitle : Info : $$LocaleString:"Transporter Name"


    [Part:transportHPart]
    Line:transportTitle
    Vertical: Yes


    [Line:transportTitle]
    Left Field : transport SNoTitle,
    Right Field: transport Types,Vehicleno
    Border:Thin Box

    [Field: transport SNoTitle]
    Use: Name Field
    Info:"S.No"
    Align:Center
    Width:8

    [Field: transport Types]
    Use: Name Field
    Info:"Transporter Name"
    Align:Center
    Width:20

    [Field: Vehicleno]
    Use: Name Field
    Info:"Vehicle No"
    Align:Left
    Width:12

    [Part: transporter]
    Lines : CMP transport
    Repeat : CMP transport:mydbtransport
    Break on: $$IsEmpty:$transporterName
    Scroll : Vertical

    [Line: CMP transport]
    Field : transport SNo
    Right Field: CMPtransportName,CMPVehicleno
    Local : Field : Default : Delete : Border
    Local : Field : Default : Style:Normal Bold
    Space Top:0.25

    [Field: transport SNo]
    Use: Simple Field
    Set as: $$Line
    Align: Center
    Skip:Yes
    Width:8

    [Field: CMPtransportName]
    type:string
    Use : Name Field
    Storage : transporterName
    Set as :$transportername
    Unique : Yes
    Width:20
    Case : Title Case
    Style: Normal


    [Field: CMPVehicleNo]
    Type:String
    Use : Name Field
    Set as: $Vehicleno
    Storage : Vehicleno
    Align:Left


    [System: UDF]
    transporterName : String : 999: mydbtransport
    Vehicleno : String : 997: mydbtransport
    mydbtransport : Aggregate: 1000 : company

    [Collection : transportNameCollection]
    Type : mydbtransport : Company
    Childof : ##SVCurrentCompany
    Format : $transporterName, 15
    Title : Transporter


    [#Field: EI Precarriage]
    Table : transportnameCollection, not applicable
    Show Table : Always
    Key : Create transporterName
    Style : Tiny Bold
    Width : 20
     


  2. anish

    anish Member


    Try to Change this
    [System: UDF]
    transporterName : String : 1911: mydbtransport
    Vehicleno : String : 1912: mydbtransport
    mydbtransport : Aggregate: 1913 : company
     


  3. seyed mohamed

    seyed mohamed New Member


    Thank you for your reply but error repeated
     

    Attached Files:



  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    transporterName already defined in Tally. Use another UDF name.
     


  5. seyed mohamed

    seyed mohamed New Member


    Thank you Amitji it's working after transportername chamge
     


  6. seyed mohamed

    seyed mohamed New Member


    Full Working Source Code

    [#Menu: Gateway Of Tally]
    Add : Item :After: @@locVouchers: "Transport Master" : Alter : transportmaster

    [Report: transportmaster]
    Form : transportfrm
    Object : Company

    [Form: transportfrm]
    Part : transportHPart, transporter
    Height : 70% Screen
    Width : 30% Screen
    Background : PurchaseVocherclr
    SpaceRight : 0.5
    SpaceLeft : 1.5
    Local : Field : Form SubTitle : Info : $$LocaleString:"Transporter Name"


    [Part:transportHPart]
    Line:transportTitle
    Vertical: Yes


    [Line:transportTitle]
    Left Field : transport SNoTitle,
    Right Field: transport Types,Vehicleno
    Border:Thin Box

    [Field: transport SNoTitle]
    Use: Name Field
    Info:"S.No"
    Align:Center
    Width:8

    [Field: transport Types]
    Use: Name Field
    Info:"Transporter Name"
    Align:Center
    Width:20

    [Field: Vehicleno]
    Use: Name Field
    Info:"Vehicle No"
    Align:Left
    Width:12

    [Part: transporter]
    Lines : CMP transport
    Repeat : CMP transport:mydbtransport
    Break on: $$IsEmpty:$transporternames
    Scroll : Vertical
    Border:thin Box

    [Line: CMP transport]
    Field : transport SNo
    Right Field: CMPtransportName,CMPVehicleno
    Local : Field : Default : Delete : Border
    Local : Field : Default : Style:Normal Bold
    Space Top:0.25
    Border:Thin Bottom

    [Field: transport SNo]
    Use: Simple Field
    Set as: $$Line
    Align: Center
    Skip:Yes
    Width:8
    Border:thin left right

    [Field: CMPtransportName]
    type:string
    Use : Name Field
    Storage : transporterNames
    Set as :$transporternames
    Unique : Yes
    Width:20
    Case : Title Case
    Style: Normal
    Align:Center
    border:thin right

    [Field: CMPVehicleNo]
    Type:String
    Use : Name Field
    Set as: $Vehiclenos
    Storage : Vehiclenos
    Align:Center
    border:thin right


    [System: UDF]
    transporterNames : String : 999: mydbtransport
    Vehiclenos : String : 997: mydbtransport
    mydbtransport : Aggregate: 1000 : company

    [Collection : transportNameCollection]
    Type : mydbtransport : Company
    Childof : ##SVCurrentCompany
    Format : $transporterNames,20
    Format : $Vehiclenos,12
    Title :$$Localstring:"List Of Transporters"
    Fetch :transporternames,vehiclenos
    Unique:$transporternames


    [System:Formula]
    Onlythatvehiclenos:$transporternames = #EIPrecarriage

    [#Field: EI Precarriage]
    Table : transportnameCollection, not applicable
    ;;Table : TransHistoryCollection,not applicable
    Show Table : Always
    Key : Create transportfrm
    Style : Tiny Bold
    Width : 20

    [#Field: EI Trader MotorVehicleno]
    set always:yes
    Set as:$$FilterValue:$vehiclenos:transportNameCollection:1:eek:nlythatvehiclenos
     


Share This Page