Dear Experts, I am unable to report the transactions "debit and credit" amount in amount field. Could I get the code to fetch the debit and credit balance of a group or a ledger in my report. My TDL is attached below please help me out.
This Collection will bring Debit/Credit Balance now you have to manage to Make one combined collection which bring both Ledger/Voucher details [Collection : TransactionsBookColl2] Type :Ledger:vouchers Belongs To : Yes Child Of : ##SunDebtors Sort : @@Default : $Name Fetch : Name, Address, LedgerContact, LedgerMobile, Email, IncomeTaxNumber, VATTINNumber, STXNumber, CurrentTurnover, ClosingBalance, StateName, PinCode, LedDrClosingBalance, LedCrClosingBalance,TotLedDrAmt,TotLedCrAmt Fetch : AllLedgerEntries Fetch : Date, VoucherTypeName, VoucherNumber, Narration Fetch : AllLedgerEntries.LedgerName, AllLedgerEntries.Amount Search Key : $Name Compute : TotLedDrAmt : $$OrigVchLedDrTotal:$LedgerName Compute : TotLedCrAmt : $$OrigVchLedCrTotal:$LedgerName