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
[#Collection : VCH Stock Item Extract] Add : Subtitle : "My CL.QTY as on voucher date " Add :Format : $$ToValue:$Date:$Closingbalance:StockItem:$StockItemName,10 ;;Set As:$$ToValue:$Date:$Closingbalance:StockItem:$StockItemName Dear admin sir, Please Rectify above problem. Advace Thank you.
Dear Amit Sir, How to get the sort list by "ClosingBalance" combined with "LedgerName"....in Value Descending order and Name in Alphabetical... Please
Dear Amit Sir, I tried the following option but not getting the result. I want to sort first by Closingbalance followed by Parent and then followed by Ledger name...that is Highest Balance--->Parent--->LedgerName... Please suggest correction [Collection : GR SDC Groups] Type : Ledger ;Childof : $$GroupSundryDebtors:$$GroupSundryCreditors Childof : $$GroupSundryDebtors Belongs To : Yes ;Sort : Default:$ClosingBalance:$Parent, $Name,;$Parent;$Closingbalance Sort : @@Default:$ClosingBalance,$Parent,;$Parent;$Closingbalance
Make Collection of LEDGERS of Sundry Debtors Compute -- Closing, parent and ledger name in this collection. Make another collection -- Use above collection as SOURCE SORT in this collection..........