Cusomise Sales Invoice Print format

I want to print sales invoice in my formate. In Company details CIN no., excise reg.no,
ECC no., Tin GST,Tin CST no., Excise Range,Division,chaper no., Tariff sub heading no. & name of excisable good
& In buyer details LSt no & Cst no.
& Mode of transport, LR date, Vechical no. etc…

??? Confusion is company have not any above menttion field
??? Buyer master have not above mentioned field
??? Suppose i customise the above field in company,buyer master then how can we call this field
in sales invoice printing format.

Hi Anil

I have been struggling with this for days so maybe this will help you:

Customise form> Company
Add the custom field - e.g. excise_reg_no

Custom Script (+New)
DocType = Sales Invoice
copy this in
cur_frm.add_fetch(‘company’,‘excise_reg_no’,“excise_reg_no”)
This should pull the value from company into sales invoice

Now in print format you should be able to use the following to pull in the value:
{{ doc.excise_reg_no }}

Hope this helps

2 Likes

You can also add these in your standard Terms and Conditions.

Thnx, Necessary field added & Working.

i have created some custom field in customer master like… ECC_NO,GST NO, & more…
How to call customer master field like ECC_NO & Other which is related with customer
into customise sales invoice printing HTML formate ???