Dear Experts, Please help me to make a formula for filter in Collection. I want purchase amount done from Purchase and Journal vouchers. i tried these collection but not working. [Collection: PurVoucher] Type : Vouchers : VoucherType Child of : $$VchTypePurchase ;Child of : $$AccountingVch ;$$VchTypeJournal or $$VchTypePurchase Belongs to : Yes Fetch : Date,VoucherTypeName,PartyLedgerName,BasicPurchaseOrderNo,Amount if Child of : $$VchTypePurchase is done .purchase done from purchase voucher is only working if Child of : $$VchTypeJournal is done .purchase done from Journal voucher is only working I WANT BOTH VOUCHER
[Collection: PurVoucher] Type : Vouchers Fetch : Date,VoucherTypeName,PartyLedgerName,BasicPurchaseOrderNo,Amount Filter : yourfilter [system : formula] yourfilter : $$IsPurchase:$VoucherTypeName OR $$IsJournal:$VoucherTypeName
Amit sir how to make collection for closing Balance in Dr Cr Format. i am getting the Closing balance but not in Cr Dr format. i tried with code in Field and Collection but not coming [FieldurClosing1] Use :Amount Field ;Short Name Field Set as :$ClosingBalance ;Set as :If $$IsDr:$_ClosingBalance then $$String:$_ClosingBalance + " Dr" else $$String:$_ClosingBalance + " Cr" Type : Amount Width : 12 Align : Right ;Format : "No Zero, Symbol," + ##ShowForex ;Format : "DRCR" ;Color : if $$IsDebit:$ClosingBalance then "Blue" Else "Red" Space Left : 2 mms Border : Thin Right [CollectionurPartyWise1] Source Collection : PurVoucher1 Walk : Inventory Entries ;Walk : Ledger Entries By : PartyName : $PartyLedgerName By : ClosingBalance:$ClosingBalance:Ledger:$PartyLedgerName Aggr Compute: TotAmount : Sum : $Amount Sort : Default : $PartyName
[Field : PurClosing1] Use :Amount Field Set as :$ClosingBalance Width : 12 Align : Right Format : "DRCR" Space Left : 2 mms Border : Thin Right
thank you amit sir for your reply but its not working. i want ledger closing balance of that party whose closing balnce is if in Dr it should show Dr else Cr
Source Collection : PurVoucher1 Walk : LedgerEntries, Inventory Entries By : PartyName : $PartyLedgerName Compute : ClosingBalance : $ClosingBalance:Ledger:$PartyLedgerName Aggr Compute: TotAmount : Sum : $Amount Sort : Default : $PartyName