Please help me with adding two additional fields in Invoice...sample JPG attached

Hi Experts,

Attached please find a sample of what I'm looking for.

Basically, I wish to have two additional field ("No. of Carton" and "Packing") before "quantity" in invoice. The modification should also reflect in the invoice printing.

PLEASE HELP

Regards,
Remya

 

Hi Remya,

For modificlation in printing layout kindly modify "EXPINV InvDetails" line.
You have to also modify titile line and also ledger detail line.

 

Thanks for your reply, Khushbu. I have Zero to No knowledge about TDL programming. I wish someone could help me with the TDL text file

 

hi Remya,

Try this attached file.

other wise in default tally u use the No.of container and packages field also.

 

Thanks for the TDL file. Your help is greatly appreciated.

however, whatever number I enter in "Carton" fld should multiply with whatever number I enter in "Pkg" fld and the result should reflect in "Quantity" fld. Also, could you please recheck the coding for PRINT.. both the above fields are coming in the description of goods instead before "quantity" fld...invoice print looks all messed up. Thanks again for your help

 

Hi Ramya,

Try this...

 

Thanks a lot...thanks a lot....Just a small request, how can I get the total of "No of carton" at the bottom of the invoice..the same way how we get the total "quantity" at the bottom! Also, can you add "border" before "Carton" and "packing".

 

Sir,I want to create additional field in sales register like "warranty" Please Help me

 

You can use "Expiry Date" for "Batch" for your requirement

 

;;------------------------------------

[#Line: EI ColumnOne]

Option : DNS EI ColumnOne : @@IsSales

[!Line : DNS EI ColumnOne]

Add : Right Fields : Before : VCH QtyTitle : DNS NoofCar
Local : Field : DNS NoofCar : Info : "Warranty"


[#Line : EI InvInfo]

Option : DNS EI InvInfo : @@IsSales

[!Line : DNS EI InvInfo]

Add : Right Fields : After : VCH ActualQty : DNS NoofCar

[Field : DNS NoofCar]

Use : Number Field
Type : Number : Forced
Storage : DNSNoofCar
Set Always : Yes
Width : 10
Align : Center
Format : "NoZero"



[System : UDF]

DNS NoofCar : Number : 701


[#Line: EXPINV Column1]

Option : DNS EXPINV Column1 : @@IsSales

[!Line : DNS EXPINV Column1]

Add : Left Fields : After : EXPINV DescTitle : DNS NoofCar, DNS Packing

Local : Field : DNS NoofCar : Info : "No. of Carton"
Local : Field : DNS Packing : Info : "Packing"
Local : Field : DNS NoofCar : Delete: Storage
Local : Field : DNS Packing : Delete: Storage
Local : Field : DNS NoofCar : Type : String
Local : Field : DNS Packing : Type : String

[#Line: EXPINV InvDetails]

Option : DNS EXPINV InvDetails : @@IsSales

[!Line : DNS EXPINV InvDetails]

Add : Left Fields : After : EXPINV Desc : DNS NoofCarPrint, DNS PackingPrint

[Field : DNS NoofCarPrint]

Use : Number Field
Set as : $DNSNoofCar
Set Always : Yes
Width : 10
Align : Center
Format : "NoZero"



[#Field : VCH BilledQty]

Option : DNS VCH NrmlBilledQty : @@ISSales

[!Field : DNS VCH NrmlBilledQty]

Set By Condition : Yes : @@QtyCalculation

 

sir is code mai warranty ke baad mai "year" auto matic lika aa jaye.

 

hellow there,, can anyone assist me on how to use the tdl extensions, or i have downloaded some but then how do i install them in my tally software?, i have so many items and i want to export them to tally from excel.. ....

 

;;------------------------------------

[#Line: EI ColumnOne]

Option : DNS EI ColumnOne : @@IsSales

[!Line : DNS EI ColumnOne]

Add : Right Fields : Before : VCH QtyTitle : DNS NoofCar
Local : Field : DNS NoofCar : Info : "Warranty"


[#Line : EI InvInfo]

Option : DNS EI InvInfo : @@IsSales

[!Line : DNS EI InvInfo]

Add : Right Fields : After : VCH ActualQty : DNS NoofCar

[Field : DNS NoofCar]

Use : Number Field
Type : Number : Forced
Storage : DNSNoofCar
Set Always : Yes
Width : 10
Align : Center
Format : "NoZero"



[System : UDF]

DNS NoofCar : Number : 701


[#Line: EXPINV Column1]

Option : DNS EXPINV Column1 : @@IsSales

[!Line : DNS EXPINV Column1]

Add : Left Fields : After : EXPINV DescTitle : DNS NoofCar, DNS Packing

Local : Field : DNS NoofCar : Info : "No. of Carton"
Local : Field : DNS Packing : Info : "Packing"
Local : Field : DNS NoofCar : Delete: Storage
Local : Field : DNS Packing : Delete: Storage
Local : Field : DNS NoofCar : Type : String
Local : Field : DNS Packing : Type : String

[#Line: EXPINV InvDetails]

Option : DNS EXPINV InvDetails : @@IsSales

[!Line : DNS EXPINV InvDetails]

Add : Left Fields : After : EXPINV Desc : DNS NoofCarPrint, DNS PackingPrint

[Field : DNS NoofCarPrint]

Use : Number Field
Set as : $DNSNoofCar
Set Always : Yes
Width : 10
Align : Center
Format : "NoZero"



[#Field : VCH BilledQty]

Option : DNS VCH NrmlBilledQty : @@ISSales

[!Field : DNS VCH NrmlBilledQty]

Set By Condition : Yes : @@QtyCalculation


sir is code mai warranty ke baad mai "year" auto matic lika aa jaye.

 

Hai experts,

i am fresher in TDL so i need your help much more. i need to add a new column in default tally invoice after the actual quanty i need schame as new column, for Ex. 12 qty actual, 10 qty billed and balance will be schame. thanks is advance

 

Can you please help me with the following request
http://tdlexperts.com/index.php?thr...lp-link-the-udf-storage-to-a-collection.3675/
Thanks in advance

 

;

Hi Lokesh
The code given by you works very well without sales class defined
but I cant get it to to work with Sales Class
Please help me

 

Can any one assist me on the above

 

DEAR

I WANT TO ADD ABOVE FIELDS IN SIMPLE PRINT FORMAT

PLZ ADVISE