Hello, I want to Excel export Sales Register with Voucher and Item Details. I am unable to get BasicBuyer Address, BasicBuyerName, BasicShippedBy etc. fields. Below is my Collection. Any Help is appreciated... [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: BasicShippedBy Fetch: BasicShipDocumentNo,BasicFinalDestination, PlaceOfSupply Fetch: BillOfLandingNo, BillOfLandingDate, BasicShipVesselNo, BasicBuyerName Fetch: InventoryEntries.*, Address.*,BasicBuyerAddress.* [Collection : SalesVoucherItems] Source Collection : My Src Coll Walk : Inventory Entries By : ValMasterID: $$Sprintf@VchMasterID:$MasterID ;;$MasterID By : StockItemName : $StockItemName Compute: StockItem: $StockItemName Format :$StockItem Compute: VBuyerAddress: $$FullList:BasicBuyerAddress:$BasicBuyerAddress Format: $VBuyerAddress Compute: VVehicleNo: $BasicShipVesselNo Format: $VVehicleNo Compute: VShippedBy: $BasicShippedBy Format: $VShippedBy Compute: VBuyerName: $BasicBuyerName Format: $VBuyerName
I solved it by below way.... Compute : TNeVATVchNo : $$CollSrcObj:$VoucherNumber Compute: NEPSRBuyerAddress: $$LocaleString:$$CollSrcObj:$$FullList:BasicBuyerAddress:$BasicBuyerAddress
Since you are in inventory entries, use $$Owner Eg : Compute: VBuyerAddress: ($$Owner:$$FullList:BasicBuyerAddress:$BasicBuyerAddress) Format: $VBuyerAddress Compute: VVehicleNo: ($$Owner:$BasicShipVesselNo) Format: $VVehicleNo Compute: VShippedBy: ($$Owner:$BasicShippedBy) Format: $VShippedBy Compute: VBuyerName: ($$Owner:$BasicBuyerName) Format: $VBuyerName