Dear Experts Can you please help me; How can fix filter to get unique vouchers only on my report. my codes reporting well for group company Ledger report. for reconciliation purpose i need to see unique vouchers only based on voucher number on report. Please see attachment for details. Thank you
Dear Sir Thank you for your reply. I want only unique voucher numbers throughout multiple companies which belongs to the ledger. All the similar number of voucher should be invisible in report. please see the entire collection on tdl- Thank You zakirhossain.edu@gmail.com [Collection: Vouchers of Multiple Companies] Collection :Vouchers of Ledger: Company Collection Fetch: *, Date, Vouchernumber, VoucherTypeName, Amount, MasterID, LedgerName, VchAmount, MasterID Sort: @@Default :$VoucherNumber [Collection: MultiCmpDB VchCollection] Type : Vouchers : Ledger Fetch : Date, Vouchernumber, VoucherTypeName, Amount, MasterID, LedgerName, VchAmount, MasterID Child of : #LedgerName Filter: myfilt Belongs To: Yes [#Collection: Vouchers of Ledger] Fetch: * Compute : Owner Company : $$LoopCollObj:$Name [System: Formula] myfilt:$LedgerName = #LedgerName [Collection: Company Collection] Type : Company Fetch : *
In report both Company collection & Vouchers of Multiple Companies collection are getting repeated. Body part are repeating over Company Collection, where a line has been exploded for voucher details repeating over Vouchers of Multiple Companies collection. Followings are the two collection are used on tdl. ; collection to repeat group companies. [Collection: Company Collection] Type : Company Fetch : * ; collection to repeat vouchers of group company ledger [Collection: Vouchers of Multiple Companies] Collection :Vouchers of Ledger: Company Collection Fetch: *, Date, Vouchernumber, VoucherTypeName, Amount, MasterID, LedgerName, VchAmount, MasterID Sort: @@Default :$VoucherNumber [#Collection: Vouchers of Ledger] Fetch: * Compute : Owner Company : $$LoopCollObj:$Name
1. Add a compute in both collections. 2. In Repeat collection, use By Based on Voucher Number and Aggr Compute for your Computed Object. 3. Now you filter it based on Aggr Compute Object, which is more then one. Or else Send your TDL to my Mail id. Ill correct it and send you back.