hello, how to get the last receipt date and amount of ledgers through ledger entries in my tdl report. $$LastVoucherDate:ledger:$Name brings the last entry whichever is made. like sales, purchase, journal etc. but i need to find only last receipt entry amount and date. Help.
Hi Vishnu, Although I am not an expert but i tried this collection code for myself and it worked....... ;;;;RECEIPT COLL;;;;;;;;;; [Collection:AllRcptVchrs] Type : Vouchers Sort : -$Date Filter : MyRcptEntries Fetch : Amount, AllLedgerEntries.Amount, Date, AllLedgerEntries.Date, VoucherTypeName, AllLedgerEntries.VoucherTypeName [System: Formulae] MyRcptEntries : $LedgerName = #DisplayGrpItem AND $$IsReceipt:$VoucherTypeName #DisplayGrpItem <<<<<<<<<<< this is a Group
sorry i haven't done any project on the same. and do try your own code instead of depending on others' codes. If concept is clear, then code is just the replica of the algorithm