The computes formulas give by me and used by you will not work for your purposes. It is given to him, to enable him to transpose data to excel. In your case, you have to design and construct your collection in a way, that is required. e.g. Filter on Sales or Purchases....... CollectionField will work better and perfectly when you have a strict and consistent method of data entry or a Consistent Table of Data OR from another Collection. As per above CollectionField is getting the data for Line # 1 to 8 ......... and let's say your sales entries are as under: entry # 1 Party A/c DR ....to Sales A/c Cr ....to CGST 9% A/c Cr ....to SGST 9% A/c Cr entry # 2 Party A/c DR ....to Sales A/c Cr ....to IGST 28% A/c Cr ...to R/Off A/c Cr or Dr (as the case maybe) As you can see, in above case.....CollectionField will not work for you.......... it will pick data based on the Line number. There are many similar type of Reports on this Forum.......go through the same and learn how to collect your relevant data.
Amit Ji I'm relatively new to TDL, and can't figure out how to display the amount next to the ledger name and also display the primary group of the ledger [Collection : All Vouchers] Type : Voucher Fetch : Date, VoucherNumber, Reference, VoucherTypeName, LedgerName, Narration, PartyLedgerName, Amount ;Fetch : DrLed, CrLed Compute : Led1 : $$CollectionField:$LedgerName:1:AllLedgerEntries Compute : Amt1 : $$CollectionField:$Amount:1:AllLedgerEntries Compute : Led2 : $$CollectionField:$LedgerName:2:AllLedgerEntries Compute : Amt2 : $$CollectionField:$Amount:2:AllLedgerEntries Please help.
Explain clearly..... In what report you want? Which position??? Show by way of screenshot with remarks.
Following this thread I have been able to generate the following.(.jpg) attached. I have highlighted two columns in red. Wherein I want the primary group of a particular group to be entered and I also want to know whether it is a Dr or a Cr. I have used the following line to try and extract the Parent Group of a ledger " Compute : Parent1 : $$CollectionField:$Parent:1:AllLedgerEntries" but No Luck. Here's what the TDL looks like, " [Collection : All Vouchers] Type : Voucher Is ODBCTable: Yes Fetch : Date, VoucherNumber, Reference, VoucherTypeName, LedgerName, Parent , Narration, PartyLedgerName, Amount ;Fetch : DrLed, CrLed Compute : Led1 : $$CollectionField:$LedgerName:1:AllLedgerEntries Compute : Amt1 : $$CollectionField:$Amount:1:AllLedgerEntries Compute : Parent1 : $$CollectionField:$Parent:1:AllLedgerEntries Compute : Led2 : $$CollectionField:$LedgerName:2:AllLedgerEntries Compute : Amt2 : $$CollectionField:$Amount:2:AllLedgerEntries Compute : Led3 : $$CollectionField:$LedgerName:3:AllLedgerEntries Compute : Amt3 : $$CollectionField:$Amount:3:AllLedgerEntries Compute : Led4 : $$CollectionField:$LedgerName:4:AllLedgerEntries Compute : Amt4 : $$CollectionField:$Amount:4:AllLedgerEntries Compute : Led5 : $$CollectionField:$LedgerName:5:AllLedgerEntries Compute : Amt5 : $$CollectionField:$Amount:5:AllLedgerEntries Compute : Led6 : $$CollectionField:$LedgerName:6:AllLedgerEntries Compute : Amt6 : $$CollectionField:$Amount:6:AllLedgerEntries Compute : Led7 : $$CollectionField:$LedgerName:7:AllLedgerEntries Compute : Amt7 : $$CollectionField:$Amount:7:AllLedgerEntries Compute : Led8 : $$CollectionField:$LedgerName:8:AllLedgerEntries Compute : Amt8 : $$CollectionField:$Amount:8:AllLedgerEntries " I write the following command in the calculator panel to get the report: " select $Date, $VoucherTypeName, $VoucherNumber, $Led1,$Parent1, $Amt1, $Led2, $Amt2, $Led3, $Amt3, $Led4, $Amt4, $Led5, $Amt5, $Led6, $Amt6, $Led7, $Amt7, $Led8, $Amt8, $Amount from AllVouchers " Thanking you in anticipation.
If You want Vouchers in this format-(Every Ledger entry in rows) Instead of using ODBC use XML - https://documenter.getpostman.com/view/13855108/TzeRpAMt#05ddfdc7-e3af-4d09-840a-d71942c8dc21 This XML is for Sales Vouchers Load Xml in Power Query
Hi Experts, I want to Export all stock item Entered in invoice, through OBDC Connection, like below, can you to please suggest