request for TDL to add no. of pieces col in sale & purchase voucher before quantity col. and printing the same in invoice. Also to get the no. of pieces in the report for stock item along with quantity. ( This is a request also made by our co member in wrongly in free source code section) which i also wanted to know please help.....
Code: [#Line : EI Column One] ;; Title Line1 Add : Right Fields: Before : VCH QtyTitle : VCS SI Piece Title [#Line : EI Column Two] ;; Title Line2 Add : Right Fields: Before : VCH ActualQtyTitle : VCS SI Piece Title Local : Field : VCS SI Piece Title : Set As : "" [Field : VCS SI Piece Title] Use : Name Field Width : 6 Skip : Yes Set As : "Pcs" [#Line : EI Inv Info] ;; Inventory Repeat Line - - With out Class Add : Right Fields: Before : VCH ActualQty : VCS SI Piece [#Line : CI Inv Info] ;; Inventory Repeat Line - - With Class Add : Right Fields: Before : VCH ActualQty : VCS SI Piece [Field : VCS SI Piece] Use : Number Field Storage : VCS SI Piece Width : 6 Format : "No Zero" [#Part: EI InvInfo] ;; Part Where Inventory ENtries are repeating - With out Class Total : VCS SI Piece [#Part: CI InvInfo] ;; Part Where Inventory ENtries are repeating - Class Mode Total : VCS SI Piece [#Form : Export Invoice] Local : Line : VCH NarrPrompt : Add : Right Fields : Before : EI QtyTotal : VCS SI Piece Total [Field : VCS SI Piece Total] Use : Number Field Set As : $$Total:VCSSIPiece Width : 6 Border : Totals Skip : Yes [System : UDF] VCS SI Piece : Number : 5000 ;; Print [#Line: EXPINV Column1] Add : Right Field : Before : EXPINV QtyTitle : VCS SI Piece Title [#Line : EXPINV Column2] Add : Right Field : Before : EXPINV ActualQtyTitle : VCS SI Piece Title Local : Field : VCS SI Piece Title : Set As : "" Local : Field : VCS SI Piece Title : Border : Thin Left [#Line : EXPINV InvDetails] Add : Right Field : Before : EXPINV ActualQty : VCS SI Piece Print [#Line: EXPINV Totals] Add : Right Field : Before : EXPINV ActualQtyTotal : VCS SI Piece Print Total [#Part: EXPINV InvInfo] Total : VCS SI Piece Print [Field : VCS SI Piece Print] Use : Number Field Set As : $VCSSIPiece Width : 6 Border : Thin Left Format : "No Zero" [Field : VCS SI Piece Print Total] Use : Number Field Set As : $$Total:VCSSIPiecePrint Width : 6 Border : Thin Left Format : "No Zero"
Sir, requested Tip / logic to Store +Ve in case of Purchase and -Ve Value in case of Sales. The similar thing I am waiting for logic http://tdlexperts.com/index.php?threads/using-basicnumpackages-field-in-invoice-for-tracking.2867/
thanks for the code. Kindly give code to get the no. of pieces in stock report for the particular item along with qty.
thanks for the code. Kindly give code to get the no. of pieces in stock report for the particular item along with qty.
