good after noon kindly help me to create 5 additional column with storage in sales voucher as well as in print out in sale invoice thanks
Search for Garment Invoice THREAD .......... modify that as per your use.......... for addl. Col in Display and Print.
HI SIR SIR I HAVE THIS CODE HERE ALL THE COLUMN ADDING IN QUANTITY COLUMN BUT I WANT ALL DDITION IN AMOUNT COLUM MEANS TO SAT FARE+TAXES+OTHR=IN AMOUNT COLUMN PLZZZ SEE AND CORRECT THE FORMOLA PLZZZZZZZZZZZZZ [#LINE: EI COLUMNONE] OPTION : KC EI COLUMNONE : @@ISSALES [!LINE : KC EI COLUMNONE] ADD : RIGHT FIELDS : BEFORE : VCH QTYTITLE : KC NO OF PCS, KC MTS, KC NO OF PCS1 LOCAL : FIELD : KC NO OF PCS : INFO : "NO OF PCS" LOCAL : FIELD : KC MTS : INFO : "MTS" LOCAL : FIELD : KC NO OF PCS1 : INFO : "NO OF PCS1" [#LINE : EI INVINFO] OPTION : KC EI INVINFO : @@ISSALES [!LINE : KC EI INVINFO] ADD : RIGHT FIELDS : AFTER : VCH ACTUALQTY : KC NO OF PCS, KC MTS, KC NO OF PCS1 [FIELD : KC NO OF PCS] USE : NUMBER FIELD TYPE : NUMBER : FORCED STORAGE : KCNO OF PCS SET ALWAYS : YES WIDTH : 12 ALIGN : CENTER [FIELD : KC MTS] USE : NUMBER FIELD TYPE : NUMBER : FORCED STORAGE : KCMTS SET ALWAYS : YES WIDTH : 12 ALIGN : CENTER [FIELD : KC NO OF PCS1] USE : NUMBER FIELD TYPE : NUMBER : FORCED STORAGE : KCNO OF PCS1 SET ALWAYS : YES WIDTH : 12 ALIGN : CENTER [SYSTEM : UDF] KC NO OF PCS : NUMBER : 500 KC MTS : NUMBER : 505 KC NO OF PCS1 : NUMBER :510 [#LINE: EXPINV COLUMN1] OPTION : KC EXPINV COLUMN1 : @@ISSALES [!LINE : KC EXPINV COLUMN1] ADD : LEFT FIELDS : AFTER : EXPINV DESCTITLE : KC NO OF PCS, KC MTS, KC NO OF PCS1 LOCAL : FIELD : KC NO OF PCS : INFO : "Fare" LOCAL : FIELD : KC MTS : INFO : "Taxes" LOCAL : FIELD : KC NO OF PCS1 : INFO : "Others" LOCAL : FIELD : KC NO OF PCS : DELETE: STORAGE LOCAL : FIELD : KC MTS : DELETE: STORAGE LOCAL : FIELD : KC NO OF PCS1 : DELETE: STORAGE LOCAL : FIELD : KC NO OF PCS : TYPE : STRING LOCAL : FIELD : KC MTS : TYPE : STRING LOCAL : FIELD : KC NO OF PCS1 : TYPE : STRING [#LINE: EXPINV INVDETAILS] OPTION : KC EXPINV INVDETAILS : @@ISSALES [!LINE : KC EXPINV INVDETAILS] ADD : LEFT FIELDS : AFTER : EXPINV : KC NO OF PCSPRINT, KC MTSPRINT, KC NO OF PCS1PRINT [FIELD : KC NO OF PCSPRINT] USE : NUMBER FIELD SET AS : $KCNOOFPCS SET ALWAYS : YES WIDTH : 12 ALIGN : CENTER [FIELD : KC MTSPRINT] USE : NUMBER FIELD SET AS : $KCMTS SET ALWAYS : YES WIDTH : 12 ALIGN : CENTER [FIELD : KC NO OF PCS1PRINT] USE : NUMBER FIELD SET AS : $KCNOOFPCS1 SET ALWAYS : YES WIDTH : 12 ALIGN : CENTER [#FIELD : VCH bILLAMT ] OPTION : KC VCH NRMLBILLEDAMT : @@ISSALES [!FIELD : KC VCH NRMLBILLEAMT] SET BY CONDITION : YES : @@amtCALCULATION [#FIELD : VCH RATE] OPTION : KC VCH RATE : @@ISSALES [!FIELD : KC VCH RATE] DELETE : SET BY CONDITION [SYSTEM : FORMULA] amtCALCULATION : (($$ASQTY:#KCNOOFPCS * $$ASQTY:#KCMTS) + ($$ASQTY:#KCNOOFPCS1 * $$ASQTY)
Just add the Field names ......... #field1 + #field2 + #field3 replace the above with your field name as per your code.
sir actually i have tried kindly can u guide ma i want to add all value in amount column not in quantity ow can i change quantity field to amount field please sir
I have already helped you....guided you....... It is upto you now to make some sincere efforts to learn and implement TDL codes. Do not expect ready made solutions. No professor/teacher writes answers for the students. It is for students to learn and answer them.
sir field KC NO OF PCSPRINT + KC MTSPRINT + KC NO OF PCS1PRINT = Amount or amount =????????? sir now how can i set these fields how can i start formula plzzzzzzzzzz
I HAVE ADD 3 ADITIONAL COLUMN WHEN I ENTER THE VALUE IN THREE COLUMN ITS ADDING TOTAL IN QUANTITY COLUMN BUT I WANT TO ADD TOTAL IN AMOUNT COLUMN PLZZZZ CHECK THE SYSTEM FORMULA
You have to start learning a little.... and make genuine efforts.... this is a learning site. It is obvious you are not making any sincere efforts at all.
i will try again bcoz sir i am not very well trained my brother started a new business about travel line he need some invoices formate differ then tally default so i have tried and sucess to add column in invoice but about formulas and others i have a weak knowledge,,so kindly do complete my code plzzzz
Do not keep the SPACES in the field name......... AMTCALCULATION : #KCNOOFPCSPRINT+ #KCMTSPRINT+ #KCNOOFPCS1PRINT
Sorry Sir Not working [#LINE: EI COLUMNONE] OPTION : KC EI COLUMNONE : @@ISSALES [!LINE : KC EI COLUMNONE] ADD : RIGHT FIELDS : BEFORE : VCH QTYTITLE : KC NO OF PCS, KC MTS, KC NO OF PCS1 LOCAL : FIELD : KC NO OF PCS : INFO : "Fare" LOCAL : FIELD : KC MTS : INFO : "Taxes" LOCAL : FIELD : KC NO OF PCS1 : INFO : "Others" [#LINE : EI INVINFO] OPTION : KC EI INVINFO : @@ISSALES [!LINE : KC EI INVINFO] ADD: RIGHT FIELDS: AFTER : VCH ACTUALQTY : KC NO OF PCS, KC MTS, KC NO OF PCS1 [FIELD : KC NO OF PCS] USE : NUMBER FIELD TYPE : NUMBER: FORCED STORAGE : KCNO OF PCS SET ALWAYS : YES WIDTH : 10 ALIGN : CENTER Print Fg :Maroon Border:Thin Left right [FIELD : KC MTS] USE : NUMBER FIELD TYPE : NUMBER: FORCED STORAGE : KCMTS SET ALWAYS : YES WIDTH : 10 ALIGN : CENTER Print Fg :Maroon Border:Thin Left right [FIELD : KC NO OF PCS1] USE : NUMBER FIELD TYPE : NUMBER: FORCED STORAGE : KCNO OF PCS1 SET ALWAYS : YES WIDTH : 10 Print Fg :Maroon ALIGN : CENTER Border:Thin Left right [SYSTEM : UDF] KC NO OF PCS : NUMBER : 500 KC MTS : NUMBER : 505 KC NO OF PCS1 : NUMBER :510 [#LINE: EXPINV COLUMN1] OPTION : KC EXPINV COLUMN1 : @@ISSALES [!LINE : KC EXPINV COLUMN1] ADD : LEFT FIELDS : AFTER : EXPINV DESCTITLE : KC NO OF PCS, KC MTS, KC NO OF PCS1 LOCAL : FIELD : KC NO OF PCS : INFO : "Fare" LOCAL : FIELD : KC MTS : INFO : "Taxes" LOCAL : FIELD : KC NO OF PCS1 : INFO : "Others" LOCAL : FIELD : KC NO OF PCS : DELETE: STORAGE LOCAL : FIELD : KC MTS : DELETE: STORAGE LOCAL : FIELD : KC NO OF PCS1 : DELETE: STORAGE LOCAL : FIELD : KC NO OF PCS : TYPE : STRING LOCAL : FIELD : KC MTS : TYPE : STRING LOCAL : FIELD : KC NO OF PCS1 : TYPE : STRING [#LINE: EXPINV INVDETAILS] OPTION : KC EXPINV INVDETAILS : @@ISSALES [!LINE : KC EXPINV INVDETAILS] ADD : LEFT FIELDS : AFTER : EXPINV DESC : KC NO OF PCSPRINT, KC MTSPRINT, KC NO OF PCS1PRINT [FIELD : KC NO OF PCSPRINT] USE : NUMBER FIELD SET AS : $KCNOOFPCS SET ALWAYS : YES WIDTH : 10 ALIGN : CENTER Print Fg :Blue Border:Thin Left right [FIELD : KC MTSPRINT] USE : NUMBER FIELD SET AS : $KCMTS SET ALWAYS : YES WIDTH : 10 ALIGN : CENTER Print Fg :Blue Border:Thin Left right [FIELD : KC NO OF PCS1PRINT] USE : NUMBER FIELD SET AS : $KCNOOFPCS1 SET ALWAYS : YES WIDTH : 10 ALIGN : CENTER Print Fg :Blue Border:Thin Left right [#FIELD : VCH BilledQty] OPTION : KC VCH NRMQty : @@ISSALES [!FIELD : KC VCH NRMLAMT] SET BY CONDITION : YES : @@AMTCALCULATION [#FIELD : VCH RATE] OPTION : KC VCH RATE : @@ISSALES [!FIELD : KC VCH RATE] DELETE : SET BY CONDITION [SYSTEM : FORMULA] AMTCALCULATION :#KCNOOFPCSPRINT + #KCMTSPRINT + #KCNOOFPCS1PRINT
Cannot Understand your requirement, Nor do have relevant Tally Data to try your code. Explain with screenshot what you want and require and also share your Dummy Data.