Code: [#Line: BILLWithDates] Delete: Right Fields : BILLOverdue [#Field: BILLFixed] Add : Fields : After : BILLRef : BillLPONo [Field : BillLPONo] use : namefield Width:8 Set as : $$FilterValue:$BasicPurchaseOrderNo:LedgerEntries:First:PolyfabSales My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo [System: Formula] Polyfab Sales : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName [#Line: BILLCol1] Local:Field:BillLPONo:Setas:"LPO No" [#Line: BILLCol2] Local:Field:BillLPONo:Setas:""
[#Object:Voucher] SSDNNumber : $$FullList:InvoiceDelNotes:$BasicShipDeliveryNote [Field : BillLPONo] use : namefield Width:8 Set as : $$FilterValue:$SSDNNumber :LedgerEntries:FirstolyfabSales My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo
Code: [#Line: BILLWithDates] Delete: Right Fields : BILLOverdue [#Field: BILLFixed] Add : Fields : After : BILLRef : BillLPONo Add : Fields: After: BillLPONO : BILLDONO [Field : BillLPONo] use : namefield Width:8 Set as : $$FilterValue:$BasicPurchaseOrderNo:LedgerEntries:First:fabpurchase My Value:$$FullList:InvoiceOrderList:$BasicPurchaseOrderNo [System: Formula] fab Purchase : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName [#Line: BILLCol1] Local:Field:BillLPONo:Setas:"LPO No" ;;====================================== [#Line: BILLWithDates] Delete: Right Fields : BILLOverdue [#Field: BILLFixed] Add : Fields: After: BillLPONO : BILLDONO [#Line: BILLCol2] Local:Field:BillDONo:Setas:"DO No." [Field : BillDONo] use : namefield Width: 8 Set as : $$FilterValue:$SSDNNumber :LedgerEntries:First:polyfabSales my value :$$FullList:InvoiceDelNotes:$BasicShipDeliveryNote [#Object:Voucher] SSDNNumber : $$FullList:InvoiceDelNotes:$BasicShipDeliveryNote
Error! cannot understand. Bad formula! '$$FilterValue:$SSDNNumber :LedgerEntries:FirstolyfabSales' please help
Add this line [System: Formula] Polyfab Sales : $$IsSales:$VoucherTypeName or $$IsPurchase:$VoucherTypeName
dear ahmed sir, please add lpo dt. in your above lpo codes & please update new codes or email me new codes @ tejeet1@gmail.com