Hello Experts, need help. I need to export Sales Register Voucher Item wise data. For Service GST where items don't exists in a voucher then Sales Ledger(For e.g. Profession Services Ledger) needs to be sent as an item. Expected Output is as below where in Voucher 123 Stock item is present and in Voucher 456 Stock item is not present but Sales Ledger is present: Voucher Item Amount Rate IGST 123 Stock item 1 100 18 18 456 Professional Service 100 12 12 Below is the code I tried: [Collection : My Src Coll] Parm Var:SVFromDate : Date : ##SVFROMDATE Parm Var:SVtoDate : Date : ##SVTODATE Type : Vouchers : Voucher Type Child of : $$VchTypeSales Filter: OnlySal belongs to : yes Object:Vouchers: $MasterID Fetch: VoucherNumber, Date, PartyLedgerName, PartyName, Narration, PARTYGSTIN Fetch: InventoryEntries.*, LedgerEntries.* [Collection: SalesVoucherItems] Source Collection : My Src Coll WalkEx : TSPLVchInv, TSPlVchLed [Collection : TSPlVchLed] Source Collection : My Src Coll Filter: FilterSalesLedgers Walk: LedgerEntries By: LedgerName : $LedgerName Compute: LedgerName: $LedgerName Format: $LedgerName [Collection : TSPLVchInv] Source Collection : My Src Coll Walk:Inventory Entries By : StockItemName : $StockItemName Compute: StockItem: $StockItemName Format :$StockItem [System : Formula] OnlySalesLedgers: $$IsLedOfGrp:$LedgerName:$$GroupSales FilterSalesLedgers: $LedgerEntries[1,@@OnlySalesLedgers]
