I need to write a collection in below conditions. Walk Inventory entries of the invoices which are fully cleared (settled) from a given period receipts entries. For example ;; Receipts Collection [Collection: TR_TotalReceipts_Collect] Type : Vouchers : Voucher Type Child Of : $$VchTypeReceipt Belongs To : Yes [Collection: NGSTReceipts_MonthColl] Source Collection: TR_TotalReceipts_Collect Walk: Ledger Entries , Billallocations Compute: InvoiceNum : $Name Compute: CustName : $...PartyLedgerName From above collection I could get all invoice nos which are collected on given period. From this invoice nos I need to filter which Invoices are fully Settled and need to Walk the inventory Entries of those invoice. Pls let me know how to write that collection
Am presuming -- you need to see Sales Bills which have been cleared fully/partly in the Sales Register. -- you have activated made Bill-to-Bill in your data. Then from your above code -- the methodology is incorrect. 1 - You should be making a Collection of Bills, where the Child Of will be the Field where the LedgerName appears. Compute the various UDFs you need here. 2 - Sourcing from above Collection - Walk the Ledger Entries and Match the BillName of Collection to the BillName of the Report and Vouchertype as Receipt and extract the amount. I think a TDL of that type should be existing on this forum, you can refer to that also.
