LR No not show in Sales Register Please Help

Discussion in 'Tally Developer' started by seyed mohamed, Feb 10, 2024.

    
  1. seyed mohamed

    seyed mohamed New Member


    [#Line: DBTitle1]
    Add: Right Field: At Beginning: DSP VCHGSTNTitle, BILLLR

    [Field:DSP VCHGSTNTitle]
    Set as: "Party GSTN No."
    width:20
    Align: Center
    Style: Normal Bold

    [#Line: DSP VchDetail]
    Add: Right field: At Beginning: DSPGSTN, LRRR

    [Field: DSPGSTN]
    Use: name field
    Set As:$PARTYGSTIN
    width:20
    Style: Normal
    Line : 0

    [Field:BILLLR]
    Set As : "LR No."
    Width : 20
    Align : center
    Style : Normal Bold

    [Field:LRRR]
    Use : Name Field
    Set As :$BillOFLADINGNO
    Width : 20
    Align : Left
    Style : Normal
    Line : 0
     


  2. vishnu joshi

    vishnu joshi Member


    :Try this
    ;Add : Fetch : $BillOFLADINGNO

    [Report: report name]
    Local:collection: Default: Add:Fetch:$BillOFLADINGNO
     
    seyed mohamed likes this.


  3. seyed mohamed

    seyed mohamed New Member


    Not Working
     


  4. vishnu joshi

    vishnu joshi Member


    Show your code.
     


  5. sivam

    sivam Active Member


    Add fetch in daybook collection.then only you can get it
     


  6. seyed mohamed

    seyed mohamed New Member


    Please correct my code


    [#Line: DBTitle1]
    Add: Right Field: At Beginning: DSP VCHGSTNTitle, BILLLR

    [Field:DSP VCHGSTNTitle]
    Set as: "Party GSTN No."
    width:20
    Align: Center
    Style: Normal Bold

    [#Line: DSP VchDetail]
    Add: Right field: At Beginning: DSPGSTN, LRRR


    [Field: DSPGSTN]
    Use: name field
    Set As:$PARTYGSTIN
    width:20
    Style: Normal
    Line : 0

    [Field:BILLLR]
    Set As : "LR Details"
    Width : 20
    Align : center
    Style : Normal Bold

    [Field:LRRR]
    Use : Name Field
    Set As : If $$IsEmpty:$BillofLadingDate Then $BillofLadingNo Else $BillofLadingNo + " dt. " + $$String:$BillofLadingDate
    Width : 20
    Align : right
    Style : Normal
    Line : 0

    [#Collection: Daybook Vouchers of Company]
    Add: Fetch: BillofLadingNo
    add: Fetch: BillofLadingDate
     


  7. sivam

    sivam Active Member


    [#Collection: Daybook Vouchers of Company]
    Add: Fetch: BillofLadingNo, BillofLadingDate, PARTYGSTIN

    It is Working Fine.
     


  8. seyed mohamed

    seyed mohamed New Member


    It's working in DayBook but LR details not show in Sales Register
     

    Attached Files:



  9. vishnu joshi

    vishnu joshi Member


    Sales Register ka alag collection ha..
    Add Both Collection..

    [#Collection: Specific Vouchers of Company]
    Add: Fetch: BillofLadingNo, BillofLadingDate, PARTYGSTIN
    [#Collection: SRC Specific Vouchers of Company]
    Add: Fetch: BillofLadingNo, BillofLadingDate, PARTYGSTIN
     


  10. seyed mohamed

    seyed mohamed New Member


    Not Working Sir
     


  11. vishnu joshi

    vishnu joshi Member


    ;Try This

    [#Collection: Filtered Vouchers of Company]
    Add: Fetch: BillofLadingNo, BillofLadingDate, PARTYGSTIN
    [#Collection: SRC Filtered Vouchers of Company]
    Add: Fetch: BillofLadingNo, BillofLadingDate, PARTYGSTIN
     
    seyed mohamed likes this.


  12. seyed mohamed

    seyed mohamed New Member


    Thank you Vishnu and knsivam89

    Working in below collection code

    [#Collection: Filtered Vouchers of Company]
    Fetch: BillofLadingNo, BillofLadingDate, PARTYGSTIN
     


  13. sivam

    sivam Active Member


    You Should add, Sales Register Collections.

    If you need ledger vouchers, add fetch related Collections
     


Share This Page