Narration explode

Discussion in 'Tally Integration' started by Ramprasad, Jan 9, 2021.

         
  1. Ramprasad

    Ramprasad New Member


    Sir,
    With below TDL, I got all the fields except narration. I tried with (Compute :LedNarration:$Narration) but not worked. Kindly advise how to get narration also...

    [Collection:CompanyCollLed]
    Type:Company
    Fetch:Name

    [Collection: LedCollection]
    Type :Vouchers


    [Collection: LedCollectionBranch]
    Source Collection : LedCollection
    Filter:ledfilter
    Walk :LedgerEntries
    Fetch:MasterID,GUID,Narration,Date,VouchertypeName,VoucherNumber,ISDEEMEDPOSITIVE
    Compute :LedName:$LedgerName
    Compute :LedAmount:$Amount
    Compute :LedBD:$BankAllocations.BankersDate
    Compute:CmpName:$$LoopCollObj:$Name

    [System: Formula]
    ledfilter:$LedName = "Test Ledger1" OR+
    $LedName="Test Ledger2" OR+


    [Collection: BranchLedCollection]
    Collection:LedCollectionBranch:CompanyCollLed

    ;;Select $CmpName,$GUID,$VouchertypeName from BranchLedCollection
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Try....... Compute : LedNarration : $LedgerEntries.Narration
     
    Jaydeep Shah likes this.


  3. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    Try This

    Compute : Narration : $().Narration
     
    Jaydeep Shah likes this.


  4. Ramprasad

    Ramprasad New Member


    Thanks you very much Sir. It's worked...
     


  5. Ramprasad

    Ramprasad New Member


    Sir,

    I am trying to get all voucher data based on given ledger name, with the below code. But the all the lines in the voucher are not appearing instead only one line is appearing:

    [Collection:CompanyCollLed]
    Type:Company
    Fetch:Name

    [Collection: LedCollection]
    Type :Vouchers

    [Collection: LedCollectionBranch]
    Source Collection : LedCollection
    Filter:ledfilter
    Walk :LedgerEntries
    Fetch:MasterID,GUID,Narration,Date,VouchertypeName,VoucherNumber,ISDEEMEDPOSITIVE
    Compute :LedName:$LedgerName
    Compute :LedAmount:$Amount
    Compute :LedBD:$BankAllocations.BankersDate
    Compute:CmpName:$$LoopCollObj:$Name

    [System: Formula]
    ledfilter:$LedName = "Ledger1" OR+
    $LedName="Ledger2" OR+

    [Collection: BranchLedCollection]
    Collection:LedCollectionBranch:CompanyCollLed

    ;;Select $CmpName,$GUID,$VouchertypeName from BranchLedCollection

    Kindly suggest...
     


  6. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    [System: Formula]
    ledfilter: $LedName = "Ledger1" or $Ledname ="Ledger2"
     
    Jaydeep Shah likes this.


  7. Ramprasad

    Ramprasad New Member


    Sir,

    I modified the code as below, to get target ledgers with full voucher explode. but it not done.

    [Collection:CompanyCollLed]
    Type:Company
    Fetch:Name

    [Collection: LedCollection]
    Type :Vouchers


    [Collection: LedCollectionBranch]
    Source Collection : LedCollection
    Filter:ledfilter
    Walk :LedgerEntries
    Fetch:MasterID,GUID,Date,VouchertypeName,VoucherNumber,ISDEEMEDPOSITIVE
    Compute :LedName:$LedgerName
    Compute :LedAmount:$Amount
    Compute :LedBD:$BankAllocations.BankersDate
    Compute :Narration:$().Narration
    Compute:CmpName:$$LoopCollObj:$Name

    [System: Formula]
    ledfilter:$LedName = "Test"

    [Collection: BranchLedCollection]
    Collection:LedCollectionBranch:CompanyCollLed

    ;;Select $CmpName,$GUID,$LedBD,$Date,$VouchertypeName,$VoucherNumber,$LedName,$LedAmount,$ISDEEMEDPOSITIVE,$Narration from BranchLedCollection

    Sir,

    My object is to get all the voucher (exploded with all lines) of target ledger as per Target.Jpeg but the actual outcome, with the code given below, is as per Actual.jpeg.

    Request you to advise necessary correction for the code:

    [Collection:CompanyCollLed]
    Type:Company
    Fetch:Name

    [Collection: LedCollection]
    Type :Vouchers


    [Collection: LedCollectionBranch]
    Source Collection : LedCollection
    Filter:ledfilter
    Walk :LedgerEntries
    Fetch:MasterID,GUID,Date,VouchertypeName,VoucherNumber,ISDEEMEDPOSITIVE
    Compute :LedName:$LedgerName
    Compute :LedAmount:$Amount
    Compute :LedBD:$BankAllocations.BankersDate
    Compute :Narration:$().Narration
    Compute:CmpName:$$LoopCollObj:$Name

    [System: Formula]
    ledfilter:$LedName = "Ledger 1" or $LedName = "Ledger 2"

    [Collection: BranchLedCollection]
    Collection:LedCollectionBranch:CompanyCollLed

    ;;Select $CmpName,$GUID,$LedBD,$Date,$VouchertypeName,$VoucherNumber,$LedName,$LedAmount,$ISDEEMEDPOSITIVE,$Narration from BranchLedCollection
     

    Attached Files:

    Last edited: Jan 11, 2021


  8. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    [Collection: LedCollectionBranch]
    Source Collection : LedCollection
    Filter:ledfilter
    Walk :LedgerEntries

    Add grouping

    by : Ledname:$Ledgername
     
    Jaydeep Shah likes this.


  9. Ramprasad

    Ramprasad New Member


    Sir,

    We require all the transactions list (with all lines of all the vouchers) for the Ledger1 and Ledger2.

    Even with the code shared "by : Ledname:$Ledgername", we only got first line only.

    Kindly support...
     


  10. NAGARAJKMAR SUBRAMANIAN

    NAGARAJKMAR SUBRAMANIAN Active Member


    [Collection:CompanyCollLed]
    Type:Company
    Fetch:Name

    [Collection: LedCollection]
    Type :Vouchers
    Fetch: PartyLedgername,Vouchernumber
    Filter:ledfilter

    [Collection: LedCollectionBranch]
    Source Collection : LedCollection

    Walk :LedgerEntries
    By:Ledname:$Ledgername
    By:Vouchernumber:$Vouchernumber

    Fetch:partyLedgername,MasterID,GUID,Date,VouchertypeName,VoucherNumber,ISDEEMEDPOSITIVE
    ;Compute :LedName:$LedgerName
    Compute :LedAmount:$Amount
    Compute :LedBD:$BankAllocations.BankersDate
    Compute :Narration:$().Narration
    Compute:CmpName:$$LoopCollObj:$Name

    [System: Formula]
    ledfilter:$Partyledgername = "Ledger 1" or $PartyLedgername = "Ledger 2"

    [Collection: BranchLedCollection]
    Collection:LedCollectionBranch:CompanyCollLed
     
    Jaydeep Shah likes this.


Share This Page