I had a report which will be displayed by a button click from sales voucher the report will contain the details about the current sales voucher, which needs to be exported in the report, I had a line that repeats inventory entries the same line will explode a part for repeating ledger entries But I am unable to get ledger entries exploded under inventory entries Here is what I done: Code: [Collection:EVListofInv] Source Collection:... Walk:InventoryEntries Compute:StockItemName:$StockItemName Compute:Amount:$Amount [Collection:EvListOfLed] Source Collection:... Walk:LedgerEntries Compute:LedgerName:$LedgerName Compute:Amount:$Amount ;select $VoucherNumber from ListOfSalesvch [#Form:Voucher] Add:Button:EVsalesRpt [Button:EVsalesRpt] Title:"EV Sales Report" Key:ALT+T Action:Display:EvSalesReport Inactive:NOT @@Issales [Report:EvSalesReport] Form:EvSalesReport Title:"Sales Report" [Form:EvSalesReport] Part:EvInvEntries Width:100% page Height:100% page [Part:EvInvEntries] Line:EvInvEntries Repeat:EvInvEntries:EVListofInv [Line:EvInvEntries] Fields:Evfld4,Evfld5 Explode:EvLedEntries [Field:Evfld4] Use:Name Field Set as:$StockItemName [Field:Evfld5] Use:Amount Field Set as:$Amount [Part:EvLedEntries] Line:EvLedEntries Repeat:EvLedEntries:EvListOfLed [Line:EvLedEntries] Fields:Evfld6,Evfld7 [Field:Evfld6] Use:NameField Set as:$LedgerName [Field:Evfld7] Use:Amount Field Set as:$Amount Any suggestions will be helpfull.
Make a Collection of Vouchers and Filter it to get SALES Vouchers only......... Use Above collection as a SOURCE in your 2 collections.
But I want only the current voucher which user is entering. Is there any way to get only the current voucher collection?