Requesting for help to fetch Transportaor ID

Discussion in 'Free Source Codes' started by Dilip S H, Jul 4, 2025.

  1. Dilip S H

    Dilip S H New Member


    Dear Team,

    Please find the below snap and code for your reference.
    where as i given given option in ledger creation to select the transporter name , which should automatically pick while passing sales entry in dispatch through option is fetching , where as i e way bill form Transporter ID not fetching automatically Fetch. Kindly help to solve this

    upload_2025-7-4_21-15-40.png
    [#Form:Ledger]

    [#Part:LED MAILING PARTS]
    Add:parts:After:LED MAILING ADDRESS:TRASNPORTUDF


    [Part:TRASNPORTUDF]
    Line:TRASNPORTUDF
    [Line:TRASNPORTUDF]
    Field:Medium Prompt,TRASNPORTUDF
    Local :field:Medium Prompt:Set as: "Transportor Name"
    Local :field:Medium Prompt:Color:Blue

    [Field:TRASNPORTUDF]
    Use:Name Field
    Width:5% Page
    Storage:TRASNPORTUDF
    Set as : If $$IsEmpty:##vGSTeWayTransportName OR $$IsEmpty:##GSTTrasactionType Then $$SysName:None Else ##vGSTeWayTransportName
    Table : GSTEWayPartyLedgersExtract, New, None
    Show Table : Always
    Set Always : Yes
    Trigger : New TransporterName : $$IsSysNameEqual:New:$$EditData
    Dynamic : ""
    Width : @@NameWidth
    Max : 100

    [System:UDF]
    TRASNPORTUDF:String:2



    [#Field: GST ewayTransporterName]

    Use : Ledger Name Field
    Storage : tempGSTewayTransporterName
    Set as :$TRASNPORTUDF:Ledger:$partyledgername ;if $$IsEmpty:##vGSTeWayTransportName OR $$IsEmpty:##GSTTrasactionType Then $$SysName:None Else ##vGSTeWayTransportName

    ; Trigger : New TransporterName : $$IsSysNameEqual:New:$$EditData
    ; Dynamic : ""
    Width : @@NameWidth
    Max : 100

    ; On : Focus : Yes : Set : vGSTeWayTransportName : $tempGSTewayTransporterName
    ; On : Accept : ($$Value != ##vGSTeWayTransportName) : Set Object Values : tempGSTewayTransporterID : @@GSTeWayTransportID
    ; On : Accept : Yes : Field Accept
    ;MYUDF:;


    [#Field: GST ewayTransporterID]

    Use : Name Field
    Storage : tempGSTewayTransporterID
    Set as : $LedTransporterId:Ledger:$GSTewayTransporterName;##vGSTeWayTransportID
    Set Always : Yes
    Max : 15
    Case : Upper Case


    ;;;=========================modification of dispatched through====
    [#Field: EI PreCarriage]
    Use : Short Name Field
    Set as:$TRASNPORTUDF:Ledger:$partyledgername
     
    Dilip S H, Jul 4, 2025
    #1


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Find the Collection of the above Report -- And FETCH your UDF in that collection.
     
    Amit Kamdar, Jul 4, 2025
    #2


  3. Dilip S H

    Dilip S H New Member


    Transportor Id is not UDF sir
    its in default tally
    Kindly suggest
     
    Dilip S H, Jul 5, 2025
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    If it is default --- then ##vGSTeWayTransportID would be picking up the value.

    You are over writing that with $LedTransporterId:Ledger:$GSTewayTransporterName -- so what and from where is this ?????
     
    Amit Kamdar, Jul 5, 2025
    #4


  5. J.Ravi Kumar Rao

    J.Ravi Kumar Rao New Member


    ; PLEASE TRY WITH THE BELOW CODE




    [#Form:Ledger]
    [#Part:LED MAILING PARTS]
    Add:parts:After:LED MAILING ADDRESS:TRASNPORTUDF
    [Part:TRASNPORTUDF]
    Line:TRASNPORTUDF,TRASNPORTID
    [Line:TRASNPORTUDF]
    Field:Medium Prompt,TRASNPORTUDF
    Local :field:Medium Prompt:Set as: "Transportor Name"
    Local :field:Medium Prompt:Color:Blue
    [Line:TRASNPORTID]
    Field:Medium Prompt,TRASNPORTID
    Local :field:Medium Prompt:Set as: "Transportor ID"
    Local :field:Medium Prompt:Color:Blue
    [Field:TRASNPORTUDF]
    Use:Name Field
    Width:5% Page
    Storage:TRASNPORTUDF
    Set as : If $$IsEmpty:##vGSTeWayTransportName OR $$IsEmpty:##GSTTrasactionType Then $$SysName:None Else ##vGSTeWayTransportName
    Table : GSTEWayPartyLedgersExtract, New, None
    Show Table : Always
    Set Always : Yes
    Trigger : New TransporterName : $$IsSysNameEqual:New:$$EditData
    Dynamic : ""
    Width : @@NameWidth
    Max : 100
    [Field:TRASNPORTID]
    Use:Number Field
    Width:5% Page
    Storage:TRASNPORTID
    [System:UDF]
    TRASNPORTUDF:String:2000
    TRASNPORTID:Number:2001
    [#Field: GST ewayTransporterName]
    Use : Ledger Name Field
    Storage : tempGSTewayTransporterName
    Set as :$TRASNPORTUDF:Ledger:$partyledgername
    ;if $$IsEmpty:##vGSTeWayTransportName OR $$IsEmpty:##GSTTrasactionType Then $$SysName:None Else ##vGSTeWayTransportName
    ; Trigger : New TransporterName : $$IsSysNameEqual:New:$$EditData
    ; Dynamic : ""
    Width : @@NameWidth
    Max : 100
    ; On : Focus : Yes : Set : vGSTeWayTransportName : $tempGSTewayTransporterName
    ; On : Accept : ($$Value != ##vGSTeWayTransportName) : Set Object Values : tempGSTewayTransporterID : @@GSTeWayTransportID
    ; On : Accept : Yes : Field Accept
    ;MYUDF:;
    [#Field: GST ewayTransporterID]
    Use : Name Field
    Storage : tempGSTewayTransporterID
    Set as : $TRASNPORTID:Ledger:$partyledgername;##vGSTeWayTransportID
    Set Always : Yes
    Max : 15
    Case : Upper Case
    Color:Blue
    ;;;=========================modification of dispatched through====
    [#Field: EI PreCarriage]
    Use : Short Name Field
    Set as:$TRASNPORTUDF:Ledger:$partyledgername
     

    Attached Files:

    • 1.png
      1.png
      File size:
      100 KB
      Views:
      72
    • 2.png
      2.png
      File size:
      72.5 KB
      Views:
      73
    • 3.png
      3.png
      File size:
      87.1 KB
      Views:
      66
    J.Ravi Kumar Rao, Aug 7, 2025
    #5


  6. tejeet

    tejeet Member


    Dear Sir,
    I need a transport ID - alphanumeric so that I can enter the GST no also, so please share the code for an alphanumeric transporter ID or it should pick the default gst no mentioned in the ledger


    [#Form:Ledger]
    [#Part:LED MAILING PARTS]
    Add:parts:After:LED MAILING ADDRESS:TRASNPORTUDF
    [Part:TRASNPORTUDF]
    Line:TRASNPORTUDF,TRASNPORTID
    [Line:TRASNPORTUDF]
    Field:Medium Prompt,TRASNPORTUDF
    Local :field:Medium Prompt:Set as: "Transportor Name"
    Local :field:Medium Prompt:Color:Blue
    [Line:TRASNPORTID]
    Field:Medium Prompt,TRASNPORTID
    Local :field:Medium Prompt:Set as: "Transportor ID"
    Local :field:Medium Prompt:Color:Blue
    [Field:TRASNPORTUDF]
    Use:Name Field
    Width:5% Page
    Storage:TRASNPORTUDF
    Set as : If $$IsEmpty:##vGSTeWayTransportName OR $$IsEmpty:##GSTTrasactionType Then $$SysName:None Else ##vGSTeWayTransportName
    Table : GSTEWayPartyLedgersExtract, New, None
    Show Table : Always
    Set Always : Yes
    Trigger : New TransporterName : $$IsSysNameEqual:New:$$EditData
    Dynamic : ""
    Width : @@NameWidth
    Max : 100
    [Field:TRASNPORTID]
    Use:Number Field
    Width:5% Page
    Storage:TRASNPORTID
    [System:UDF]
    TRASNPORTUDF:String:2000
    TRASNPORTID:Number:2001
    [#Field: GST ewayTransporterName]
    Use : Ledger Name Field
    Storage : tempGSTewayTransporterName
    Set as :$TRASNPORTUDF:Ledger:$partyledgername
    ;if $$IsEmpty:##vGSTeWayTransportName OR $$IsEmpty:##GSTTrasactionType Then $$SysName:None Else ##vGSTeWayTransportName
    ; Trigger : New TransporterName : $$IsSysNameEqual:New:$$EditData
    ; Dynamic : ""
    Width : @@NameWidth
    Max : 100
    ; On : Focus : Yes : Set : vGSTeWayTransportName : $tempGSTewayTransporterName
    ; On : Accept : ($$Value != ##vGSTeWayTransportName) : Set Object Values : tempGSTewayTransporterID : @@GSTeWayTransportID
    ; On : Accept : Yes : Field Accept
    ;MYUDF:;
    [#Field: GST ewayTransporterID]
    Use : Name Field
    Storage : tempGSTewayTransporterID
    Set as : $TRASNPORTID:Ledger:$partyledgername;##vGSTeWayTransportID
    Set Always : Yes
    Max : 15
    Case : Upper Case
    Color:Blue
    ;;;=========================modification of dispatched through====
    [#Field: EI PreCarriage]
    Use : Short Name Field
    Set as:$TRASNPORTUDF:Ledger:$partyledgername[/QUOTE]
     
    tejeet, Sep 9, 2025
    #6


  7. tejeet

    tejeet Member


    Dear Sir,
    I need a transport ID - alphanumeric so that I can enter the GST no also, so please share the code for an alphanumeric transporter ID or it should pick the default gst no mentioned in the ledger
     
    tejeet, Sep 10, 2025
    #7


Share This Page