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
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...
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
[Collection: LedCollectionBranch] Source Collection : LedCollection Filter:ledfilter Walk :LedgerEntries Add grouping by : Ledname:$Ledgername
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...
[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 FetchartyLedgername,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