Please Help me, any one know, how to generate sundry debtors report with last receipt amount with date.
Try This [Line: VCH Party Last Payment] Invisible : Not $Printstatement:VoucherType:$VoucherTypeName Border : Thin Bottom Field : Simple Prompt, Party Last Pymt, Medium Prompt, Party Last Pymt Date Local : Field : Simple Prompt : Set as : $$LocaleString:"Last Received Payment :" Local : Field : Simple Prompt : Width : 20 Local : Field : Simple Prompt : Style : Normal Italic Local : Field : Medium Prompt : Set as : $$LocaleString:"Dt. :" Local : Field : Medium Prompt : Width : 3 Local : Field : Medium Prompt : Style : Normal Italic Local : Field : Medium Prompt : Inactive: $$IsEmpty:#PartyLastPymt [Field: Party Last Pymt] Use : Amount Field Type : Amount : Forced Set as : $$CollectionField:$Amount:1artyLastPayment ;else $$FilterValue:$AmountartyLastPayment:1ummyFormula Set Always : Yes ;Storage : Party Last Pymt ;Width : @@AmountWidth Style : Normal Bold Format : "No Zero, Symbol," + ##ShowForex Align : Left [Field: Party Last Pymt Date] Use : Uni Date Field ;Type : Date : Forced Set as : $$CollectionField:$Date:1artyLastPayment ;else $$FilterValue:$DateartyLastPayment:1ummyFormula Set Always : Yes ;Storage : Party Last Pymt Date Width : @@ShortDateWidth + 3 Style : Normal Bold Align : Left Inactive: $$IsEmpty:#PartyLastPymt [Collection : Party Last Payment] Parm VAR : SVCurrentDate : Date : ##SVCurrentDate Parm Var : svFromDate : Date : @@CMPStartDate Parm Var : svToDate : Date : @@FinYrEnding ;Parm Var : svCurrentDate : Date : ##SVCurrentDate Parm Var : pConsignee : String: #EXPINVPartyLedName Type : Vouchers : Ledger Child Of : ##pConsignee ;#EIConsignee; Walk : All Ledger Entries Filter : Receipt;, SameLedger Sort : @@Default : -$Date Fetch : Amount, AllLedgerEntries.Amount, Date, AllLedgerEntries.Date [System:Formulae] Receipt : $$IsReceipt:$VoucherTypeName