PLEASE SHARE TDL / CODES FOR INSERTING ROWS IN THE SALES INVOICE ( F8 ) VOUCHER ENTRY FOR ALREADY CREATED INVOICE / PROFORMA INVOICE
[#Line: EXPINV InvDetails] Border:Thin Bottom ---------------------------------------------------------------------------------------------------- [#Line: EXPSMP InvDetails] Border:Thin Bottom ;;---------------------------------------------------------------------------------------------------
@tejeet try this one , i hope this tdl works for you [#Line:EI ColumnOne] Add : Right Field : Before : VCH QtyTitle : OWNFIELD Local : Field : OWNFIELD : INFO : “Own Heading” [#Line:EI InvInfo] add : right field : before : VCH ActualQty :OWNFIELD [Field : OWNFIELD] use : Name field Storage :OWNFIELDStorage Set always : yes Width : 15 Align : Center invisible : not@@ISSALES @@ISSALESORDER [System : UDF] OWNFIELDStorage : String : 6000 [#Line: ExpInv Column1] Add : left Field : After :EXPINV DescTitle : OWNFIELD Local : Field : OWNFIELD : Info : ” Own Heading” Local : Field : OWNFIELD : Delete : Storage Local : Field : OWNFIELD : Type : String Local : Field : OWNFIELD : align : Center Local : Field : OWNFIELD : Width : 10 Local : Field : OWNFIELD : border : thin left [#Line :ExpInv InvDetails] add : left Fields : after : EXPINV Desc :OWNFIELDStorage [ Field : OWNFIELDStorage] use : Name Field Set as :$OWNFIELDStorage Set Always : Yes Width : 10 Align : Center Border : Thin Left
Thanks for your above TDL, but it has not solved my problem, your TDL has created extra colume in invoice with title "own field" , but i need Tdl to insert row between 2 already exisitng entry , just like in invoice entry in bottom row tally has give 3 button - quit , accept , delect, - i need 1 extra button for to insert new row between already 2 existing entry , so that i can add new item between already exisiting 2 items, so please help me with tdl for insertion of new row
Dear Tejeet, If you need invoice print to display the inserted item in a particular line then I think of a logic. Add a starting field as serial no with $$Line (auto increasing) and one more field say user serial No which auto copies serial no field but can be edited add line at end and number it your way. While printing sort inventory lines on user serial no. Please inform whether this will serve the purpose
One may duplicate the voucher and export it to excel and insert or delete or meddle with the lines and import it back as a new voucher or in lieu of old voucher. Duplication of voucher is not necessary but it is a precaution. There are 70 odd schools and salaries are being disbursed every month by one voucher only. The order (of place of schools) and teachers grades remain more or less same every month. However there are new insertions or deletions of teachers. In such type of situations you can resort to it and minimize the mistakes and reduce the data entry time.
