Dear all, i created the report for payment advice , i attach to the customer previous payment details for Based upon the bill reference . This collection work ok, But i want Filter the particular reference only . Please find the following screen shot & Collections of report thanking you. Murali.R [Collection:myled bills] Type : Voucher Child Of: ##LedgerName Filter : myurgentfilter Fetch : AllLedgerEntries.*, BillAllocations.* [System:Formula] myurgentfilter:$VoucherTypeName contains "Journal" or $VoucherTypeName contains "Payment" Mybledger$$IsLedofGrp:$LedgerName:$$GroupBank Or $$IsLedofGrp:$LedgerName:$$GroupBankOD) ;Ledger Name : All Ledger Entries : Last : @@IsVchCashBankAcctRE [Collection:myledger bills] Source Collection : myled bills Walk : All Ledger Entries, Bill Allocations By : MasterId : $MasterID By : LedgerName : If $LedgerName = ##LedgerPartyName Then $LedgerName Else "" By : BillName : If $LedgerName = ##LedgerPartyName Then If $$IsEmpty:$Name Then "On Account" Else $Name Else "" Fetch: Date,Amount,Vouchernumber,Partyledgername,Name,Bil lName
