VAT INvoice Item price Inclusive of VAT

1

As per UAE VAT laws in sales invoice item price mentioned on the invocie should be inclusive of VAT but as per erpnext it calculates after the total amount.

Sample invoice is attached.

fta-vat
fta-vat822Ă—823 78.6 KB

SO i want link to add a new field in sales invocie next to item rate which calculates 5% based on item rate and print this price inclusive of VAT on invoice.

2

Did you got solution for this, i am still having this issue

3

Isnt it the same as Bahrain ?
Items VAT is pre-defined as per their HS-Code? So if the item is Vat@5% then it will calculate for those items with 5% vat and ignore those with Vat@0%.

Please share more details, Maybe I can help.

This depends on how you configure the Sales Tax Template. If you tick tax is Including in the Price then it will reverse Calculate.

4

yes but our price is not included in item price.

5

not really just its print Total of each line inclusive of VAT

6

But we want it in line wise item need to show vat, already we have total at down

We want it in below format

crop_173537798.png

Get
Outlook for Android

7

price total is shown inclusive of VAT in each line

8

This is a dummy format which we want

Right now in our format price is coming without vat

9

Go to

Ciustomize Form and select Sales Invoice Item
Total Amount remove its print hide

But can you confirm which print format you are using.

10

It will always come without vat. As there is no ready-made field to show with vat. Only thing you can do is right a whole new script with formula inside to get it to work the way you want it.

Please find the one we use in Bahrain for most of our clients.

IMG_20200106_232639
IMG_20200106_232639556Ă—1371 226 KB

I suppose this is what you’re looking for.

Also you have not mentioned whether you’re using A4 size print or receipt print.

11

It’s a receipt print

12

give me your email address i wills end you the print format i am using for receipt for tax invocie

13

Post it here! Then everyone can benefit. Best

14 
<style>
.print-format table, .print-format tr, 
.print-format td, .print-format div, .print-format p {
	font-family: Monospace;
	line-height: 200%;
	vertical-align: middle;
}
@media screen {
	.print-format {
		width: 4in;
		padding: 0in;
		min-height: 11.7in;
	}
}

{%- macro add_header(page_num, max_pages, doc, letter_head, no_letterhead) -%}
{% if letter_head and not no_letterhead %}

{{ letter_head }}

{% endif %}
{%- if doc.meta.is_submittable and doc.docstatus==0-%}

{{ _(“DRAFT”) }}


{%- endif -%}
{%- if doc.meta.is_submittable and doc.docstatus==2-%}

{{ _(“CANCELLED”) }}


{%- endif -%}
{% if max_pages > 1 %}

{{ _(“Page #{0} of {1}”).format(page_num, max_pages) }}


{% endif %}
{%- endmacro -%}

{{ add_header(0,1,doc,letter_head, no_letterhead) }} .print-format table, .print-format tr, .print-format td, .print-format div, .print-format p { font-family: Monospace; line-height: 200%; vertical-align: middle; } @media screen { .print-format { width: 4in; padding: 0.25in; min-height: 8in; } }

{{ _("TAX Invoice")}}
{{ _("Receipt No") }}: {{ doc.name }}
{{ _("Date") }}: {{ doc.get_formatted("posting_date") }}
{{ _("Customer") }}: {{ doc.customer_name }}
{{ _("TRN NO") }}: {{ doc.tax_id}}

{%- for item in doc.items -%} {%- endfor -%}
{{ _("Item") }} {{ _("Qty") }} {{ _("Amount") }}
{{ item.item_code }} {%- if item.item_name != item.item_code -%}
{{ item.item_name }}{%- endif -%} 		{{ item.qty }}
@ {{ item.get_formatted("rate") }}		 {{ item.get_formatted("total_amount") }}
{%- for row in doc.taxes -%} {%- if not row.included_in_print_rate -%} {%- endif -%} {%- endfor -%} {%- if doc.discount_amount -%} {%- endif -%}
{{ _("Net Total") }} {{ doc.get_formatted("net_total") }}
{{ row.description }} {{ row.get_formatted("tax_amount", doc) }}
{{ _("Discount") }} {{ doc.get_formatted("discount_amount") }}
{{ _("Grand Total") }} {{ doc.get_formatted("grand_total") }}
{% if doc.get("taxes", filters={"included_in_print_rate": 1}) %}

Taxes Included:

{%- for row in doc.taxes -%} {%- if row.included_in_print_rate -%} {%- endif -%} {%- endfor -%}
{{ row.description }} {{ row.get_formatted("tax_amount_after_discount_amount", doc) }}
{%- endif -%}

{{ doc.terms or "" }}

{{ _("Thank you, please visit again.") }}

1 Like
15

Thanks alot , Its Solved. It was just amount in my code, i changed to total amount