helllo all i make 1 field in sales vocher his and its show only 1 row rate if i have a bill and i sales 10 item on this bill then next bill its show 1st item rate in box i want show all rate ??? [System: UDF] vchtest : String: 22001 [#Line: EI InvInfo] Add: Right Fields: Before: VCH ActualQty:vchtest1 [#Line: CI InvInfo] Add: Right Fields: Before: VCH ActualQty:vchtest1 [#Line: EI ColumnOne] Add: Right Fields: Before : VCH QtyTitle : vchtest2 [#Line: EI ColumnTwo] Add: Right Fields: Before : VCH QtyTitle : vchtest2 [Field : vchtest2] Info : "VCH Test" Style : Normal Bold Width:10 [Field : vchtest1] Use : Name Field Storage : vchtest Width : 10 this collection not show udf value ............... [Collection: DSD Batches VchSrc2] Type : Vouchers : VoucherType Child Of : "Sales" Belongs To : Yes Fetch : LedgerEntries.* , LedgerEntries.MasterID , LedgerEntries.AllInventoryEntries.*,LedgerEntries.AllInventoryEntries.BatchAllocations.* Fetch : LedgerEntries.AllInventoryEntries.vchtest Filter : Is Same Party Sort : @@Increasing : $MasterId ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [Collection : DSD Batches VCH Extract2] Title : "List Of Serial Numbers" Source Collection : DSD Batches VchSrc2 Walk : InventoryEntries,BatchAllocations BY : Ledger Name : $LedgerEntries.LedgerName By : Master ID : $LedgerEntries.MasterID By : StockItemName : $StockItemName By : Batch Rate : $BatchRate BY : date :$Date BY : VoucherNumber : $VoucherNumber BY :Billed Qty:$BilledQty BY : vchtest1 : $LedgerEntries.AllInventoryEntries.vchtest SubTitle : "Last Rate" SubTitle : "StockItem Name" SubTitle : "Bill no" SubTitle : "Date" SubTitle : "Ledger Name" SubTitle : "SHEET" SubTitle : "BANDING" Full Height : Yes Align : right Format : $StockItemName ,25 Format : $BatchRate,8 Format : $VoucherNumber,15 Format : $date,15 Format : $Ledger Name ,10 Format : $BilledQty ,10 Format : $vchtest1 ,10
Try with this below code [Collection : DSD Batches VCH Extract2] Title : "List Of Serial Numbers" Source Collection : DSD Batches VchSrc2 Walk : InventoryEntries,BatchAllocations BY : Ledger Name : $LedgerEntries.LedgerName By : Master ID : $LedgerEntries.MasterID By : StockItemName : $StockItemName By : Batch Rate : $BatchRate BY : date :$Date BY : VoucherNumber : $VoucherNumber BY :Billed Qty:$BilledQty BY : vchtest1 : $().AllInventoryEntries.vchtest