Dear Experts I Want Jobwork Module I Make one Material in Voucher For Goods Inward For Qty --100 nos In Sale Entry Material in Table is Come and I Select That No and make Sales For Qty -- 100 nos After Sales Go to New Sales the Table Displays All Material in Entry I Want Only Pending Qty Material in Vouchers Pls Do the needful. i attach my code. [#Part: EI DelNoteInfo] Option: SEI DelNoteInfo : @@IsSales [!Part : SEI DelNoteInfo] Add:Line: Lotwise [#Part: EI DelNoteInfo] Option: IMI DelNoteInfo : @@IsMaterialIn [!Part : IMI DelNoteInfo] Add:Line: MLotwise [Line: MLotwise] Add:Fields: MLotNoTitle,MLotNo [Field: MLotNoTitle] Use: Name Field Set as : "Lot No:" Width: 20 mms Skip: Yes [Field: MLotNo] Use: Name Field Storage: LotNo Width: 20 mms [Line: Lotwise] Add:Fields: SLotNoTitle,SLotNo,SLotDate [Field: SLotNoTitle] Use: Name Field Set as : "Lot No:" Width: 20 mms Skip: Yes [Field: SLotNo] Use: Name Field Table: Inward Table Storage: LotNo Width: 20 mms Show Table : On Blank [Field: SLotDate] Use : Uni Date Field Set As : $$Table:SLotNo:$Date Storage : SLotDt Invisible: Not @@IsSales [Collection: Inward Table] Collection : Inward Vouchers,Not Applicable Format : $LotNo,10 Format : $Date, 10 ;;Format : $InventoryEntries.BilledQty, 10 Format : @@ClBal,10 ;;Filter: ZeroFil [System : UDF] LotNo : String : 4512 SLotDt : Date : 4513 [Collection: Inward Vouchers] Type : Vouchers : VoucherType Child Of : "Material In" Fetch: Date,PartyLedgerName,VoucherNumber,MLotNo,VoucherTypeName Fetch: InventoryEntries.BilledQty [Collection: Outward Vouchers] Type : Vouchers :Voucher Type Child Of : "Sales" Fetch : Reference,VoucherTypeName,StockItemName,VoucherNumber,LotNo Fetch: InventoryEntries.BilledQty [Collection: Summ Vouchers] Source Collection : Inward Vouchers,Outward Vouchers Walk : Inventory Entries By : LotNo : $LotNo Compute: MBillQty : If @@MFil Then $BilledQty Else " " Compute: SBillQty : If @@SFil Then $BilledQty Else " " Compute: CLBillQty : MBillQty - SBillQty [System: Formula] IsMaterialIn : ##SVVoucherType = "Material In" MFil : $VoucherTypeName = "Material In" SFil : $VoucherTypeName = "Sales" CBal : $CLBillQty ZeroFil : @@CBal < 0
