Tally format for Tax Invoice

[tanuj82685]

@fkardame Hey Thanks for your prompt reply.

I am using Item tax template to call correct tax rate. I have set tax category in party master to In state / Out state. In item master I have created 6 item tax templates according to tax % in india for ex. In state 18% / out state 18%, In state 12% / Out State 12%.

Please see screenshot below.
Item Master Form

Item Tax Template

Item Tax Template

Customer Master Form

Also I tried other_charges_calculation field in my print format, its gives me this :-

I want this print format, it gives gst rate and amount row wise. Also a total column at the end will be good. Please see below

[fkardame]

Looks like you’re using V12 and I am not familiar with V12 tax methods. Sorry about that, I thought you were on V11.

Maybe some else can help you with this.

[tanuj82685]

Ok. Thanks for your reply

Can anybody please help overcome this issue in v12 ?

[tanuj82685]

Can anybody resolve this issue please ?

[Vikasg]

Please confirm whether Tally Format available in ERPNext,
If yes, how to configure the same

[aakvatech]

Tally format for Tax Invoice

[ { "align_labels_right": 0, "css": ".print-format {\npadding-left: 5mm;\npadding-right: 5mm;\npadding-top: 10mm;\npadding-bottom: 5mm;\n}\n", "custom_format": 1, "default_print_language": null, "disabled": 0, "doc_type": "Sales Invoice", "docstatus": 0, "doctype": "Print Format", "font": "Default", "format_data": "[{\"fieldname\": \"print_heading_template\", \"fieldtype\": \"Custom HTML\", \"options\": \"\\t\\t\\t\\t\\n Tax Invoice\\n\"}, {\"fieldtype\": \"Sectio…

See if this helps.

[tanuj82685]

Hi

Can someone help achieve this in V12 !!??

Tally format for Tax Invoice

@aakvatech Hey thanks for prompt reply. Here is print format screenshot of the code you sent. [image] This is what we have setup, based on your print format. [image] We have three tax heads CGST, SGST & IGST. In the print format above of sales invoice two tax heads are applicable, CGST 6% & SGST 6% (These are applicable for inter-state, if supply would have been made intra-state then IGST would have been applicable @ 12%) What I want, please find s.s below [image] Can you please hel…

[a1008]

i want to generate invoice click on custom button in custom doctype and custom button
so can u help me

[iteerstech]

Could you please give more details.

[aakvatech]

Welcome to the community. You can use custom script. You will need to use Javascript and you may find information https://docs.erpnext.com/docs/user/manual/en/customize-erpnext/custom-scripts useful

[sachin1]

Hi,
I did not get how to use this script to create a print format. Please describe how to create a print format using this script. Or if possible, please make a short video.
Regards

[C_Balak]

You don’t need a custom script to create print format. You need custom script to add additional functionalities on a custom or existing doc.

29. Build Custom Print Format - Frappe ERPNExt

check out this video. You may get an idea

[aakvatech]

https://docs.erpnext.com/docs/user/manual/en/customize-erpnext/print-format

See this to add the tally print format code into custom HTML field on Print Format

[sachin1]

Hi, I got this error whenever I select the print format for printing:-
Server Error

Close Report

TypeError: ‘NoneType’ object is not callable

[sachin1]

Is there anyone who can solve the issue?

[fkardame]

You need to check with the person who deployed the server for you, as this looks like a server issue or if you have written a custom print format then look into the print format for mistakes.

[sachin1]

I am using this custom print format:

Tally format for Tax Invoice

Does this help? <center><h3>Tax Invoice</h3><center> <table width=90% height=30% border=1> <tr> <td width=50% rowspan=3> <strong>{{ doc.company or "" }}</strong><br> {{ frappe.db.get_value("Company", doc.company, "registration_details") or "" }} </td> <td width=25%> Invoice No.<br> <b>{{ doc.name }}</b> </td> <td width=25%> Dated<br> <b>{{ frappe.utils.formatdate(doc.posting_date) }}</b> </td>…

[fkardame]

@sachin1

I am using this custom print format:

Then you need to find the issue in the custom print format.
Or ask the developer of the custom print to help you.

[aakvatech]

Please use this print format after changing to your needs. This was developed specific for our use case and may not be 100% usable for you.

You will need some jinja skills to get over this error.

[Santhosh_Aerotek]

Can you please help me to get two separate rows for SGST and CGST

Currently I have used below code:

Tax Invoice

{{ doc.company or "" }} {{ frappe.db.get_value("Company", doc.company, "registration_details") or "" }}	Invoice No. {{ doc.name }}	Dated {{ frappe.utils.formatdate(doc.posting_date) }}
Delivery Note	Mode/Terms of Payment
Supplier's Ref.	Other Reference(s)
Customer {{ doc.customer_name or "" }} {{ doc.address_display or "" }}	Buyer's Order No.	Dated
Despatch Document No.	Dated
Despatched through	Destination
Terms of Delivery

{% for item in doc.items %}
{% set remrows = 10 - loop.revindex %}

{% set trate = "" %} {% endfor %}

Sl	Particulars	QTY	Rate	GST	Amount
{{ loop.index }}	{{ item.item_name }}	{{ item.get_formatted("qty", 0) }}	{{ item.get_formatted("rate", doc) }}	{% set mydict = json.loads(item.item_tax_rate) %} {% if item.item_tax_rate == "{}" %} {% for row in doc.taxes %} {{ row.rate }}.0% {% endfor %} {% else %} {% for key, value in mydict.items() %} {{ value }}% {% endfor %} {% endif %} </td> <TD align=right>{{ item.get_formatted("amount", doc) }}</TD>

Amount in Words {{ doc.in_words }} {{ doc.base_in_words }}	SUB TOTAL	{{ doc.get_formatted("base_total", doc) }}	{{ doc.get_formatted("total", doc) }}
GST	{{ doc.get_formatted("base_total_taxes_and_charges", doc) }}	{{ doc.get_formatted("total_taxes_and_charges", doc) }}
TOTAL	{{ doc.get_formatted("base_grand_total", doc) }}	{{ doc.get_formatted("grand_total", doc) }}
{{ doc.remarks }}	for {{ doc.company }} Authorised Signatory