Notes

Notes - notes.io

{% macro above_items() %}
<div class="page-break">
<div class="header">


{% if doc.company=="Aarjavam Polymer Private Limited (Bangalore)"%}
<div class="Header"><table border="0">

<tbody><tr>
<td class="text-right" width="1000">
<div class="text-left"><h4><p style="color: red;">Aarjavam Polymer Private Limited (Bangalore)</p></h4>
<h5>
<font size="2" style="font-size: 12px;">Plot no.109,110,113,114,<br>OBEDANAHALLI INDUSTRIAL AREA,DODDABALLAPUR,<br>
Banglore,Karnataka, India<br>
State Code: 29, Postal Code: 561203<br>
GSTIN: 29AAUCA2300E1ZV<br></font></h5>
</div>
</td>
<td class="text-right" width="1000px"><font size="3">
<img src="/files/12.png">
</p>
</font>
</td> </tr>
</tbody></table>
</div>
{%- endif -%}

{%- if doc.meta.is_submittable and doc.docstatus==0-%}
<div class="alert alert-info text-center">
<h5 style="margin: 0px;">{{ _(" DRAFT ") }}</h5></div>
{%- endif -%}
<div style="width: 100%;display: inline-block;border: 1px solid black;border-bottom: 0px;">
<div style="width: 75%;text-align:center;display: inline-block;padding-left: 24%;">

<p style="font-size: 15px;">{% if doc.is_return == 1 -%}Sales Return(Credit Note) {% else %} TAX INVOICE{%- endif %}</p>
</div>
</div>

<table border=1 width="100%">
<tbody>
<tr>
<td style=" padding: 0px 6px 0px 6px !important;" colspan=1 width = "200">
<div><font size = "2">Delivery Note No </font>
</div>
<div><font size = "2"> Date </font></div>

</td>
<td style=" padding: 0px 6px 0px 6px !important;" colspan=1 width = "200">
<div><font size = "2"><b>{{ doc.name }}</b></font></div>
<div><font size = "2"><b> {{ doc.get_formatted("posting_date") }}</b></font>
</td>

</tr>

</tbody>
</table>


<div class="seller-info new-seller-info">
<table border=1 style="width:100%;" style="border-top: 0px;">
<tbody>
<tr>
<td style=" padding: 0px 6px 0px 6px !important;" width="200" colspan=2>
<div style="font-weight:bold;font-size:10px;text-decoration:underline;">Details of Receiver (Billed To)</div>
<div>
<b>
<font size="1"><b>{{ doc.customer_name }}</b></font>
</b>
</div>
{% set customer_address = doc.address_display %}
<div>
<font size="1"> {{ customer_address }} </font>
</div>
</td>
<td style=" padding: 0px 6px 0px 6px !important;" width="200" colspan=2>
<div style="font-weight:bold;font-size:10px;text-decoration:underline;">Details of Consignee(Shipped To)</div>

<div> <font size="1">{%- if doc.shipping_address!= none -%}{{doc.shipping_address}} {%- endif -%}</font></div>
</td>
</tr>
</tbody>
</table>
</div>

{% endmacro %} {% macro below_items() %}

</div>

</div>

{% endmacro %}

{{ above_items() }}
<div class="row">
<div class="col-xs-12">
<table border=1 ; width="100%" rules="cols" style="border-top: none;">
<tbody>
<tr style="border-bottom:1px solid black;">
<th rowspan="1">
<font style="font-size: 8px;">Sr</font>
</th>
<th rowspan="1">
<font style="font-size: 7px;">Item Name</font>
</th>

<th rowspan="1" class="text-center">
<font style="font-size: 8px; ">Qty(MTR)</font>
</th>
<th rowspan="1">
<font style="font-size: 7px;">HSN Code</font>
</th>
<th rowspan="1">
<font style="font-size: 8px;">Tax Rate</font>
</th>
<th rowspan="1" class="text-center">
<font style="font-size: 8px;">Rate</font>
</th>
<th rowspan="1" class="text-center">
<font style="font-size: 8px;">Amount</font>
</th>

</tr>
{% set cgst_rate = [] -%} {% set sgst_rate = [] -%} {% set igst_rate = [] -%} {% set cgst_account_head = [] -%} {% set sgst_account_head
= [] -%} {% set igst_account_head = [] -%} {% set tot_cgst_amount = [] %} {% set tot_sgst_amount = []
%} {% set grand_total = {"qty":0.0, "amount":0.0, "cgst_amt":0.0, "sgst_amt":0.0, "igst_amt":0.0} %}
{%- for row in doc.taxes -%} {% if 'CGST' in row.account_head -%} {% set _ = cgst_account_head.append(row.account_head)
%} {% set _ = cgst_rate.append(row.rate) %} {%- endif -%} {% if 'SGST' in row.account_head -%} {% set
_ = sgst_account_head.append(row.account_head) %} {% set _ = sgst_rate.append(row.rate) %} {%- endif
-%} {% if 'IGST' in row.account_head -%} {% set _ = igst_account_head.append(row.account_head) %} {%
set _ = igst_rate.append(row.rate) %} {%- endif -%} {%- endfor -%} {%- for row in doc.items -%}
{% if row.idx % 12 == 0 %}
</tbody>
</table>
</div>
</div>

<div id="footer-html" >
{{ below_items() }}
</div>

{{ above_items() }}

<div class="row">
<div class="col-xs-12">
<table border=1 ; width="100%" rules="cols" style="border-top: none;">
<tbody>
<tr style="border-bottom:1px solid black;">
<th rowspan="1">
<font style="font-size: 6px;">Sr</font>
</th>
<th rowspan="1">
<font style="font-size: 6px;">Item Name</font>
</th>
<th rowspan="1" class="text-center">
<font style="font-size: 6px;">Qty(MTR)</font>
</th>
<th rowspan="1">
<font style="font-size: 6px;">HSN Code</font>
</th>
<th rowspan="1">
<font style="font-size: 6px;">Tax Rate</font>
</th>
<th rowspan="1" class="text-center">
<font style="font-size: 6px;">Rate</font>
</th>
<th rowspan="1" class="text-center">
<font style="font-size: 6px;">Amount</font>
</th>


{% endif %}
<tr>
{% set cgst_amt = [] -%} {% set sgst_amt = [] -%} {% set igst_amt = [] -%} {% set it_cgst_rate = [] -%} {% set it_sgst_rate
= [] -%} {% set it_igst_rate = [] -%} {% set rate_found_item = 0 -%} {%- set item_record = frappe.get_doc("Item",
row.item_code) -%} {% for item_tax in item_record.taxes %} {% if item_tax.tax_type in sgst_account_head
%} {% set _ = it_sgst_rate.append(item_tax.tax_rate) %} {% set _ = sgst_amt.append(row.amount * it_sgst_rate[0]
/ 100) -%} {% set rate_found_item = 1 -%} {% endif %} {% if item_tax.tax_type in igst_account_head
%} {% set _ = it_igst_rate.append(item_tax.tax_rate) %} {% set _ = igst_amt.append(row.amount * it_igst_rate[0]
/ 100) -%} {% set rate_found_item = 1 -%} {% endif %} {% if item_tax.tax_type in cgst_account_head
%} {% set _ = it_cgst_rate.append(item_tax.tax_rate) %} {% set _ = cgst_amt.append(row.amount * it_cgst_rate[0]
/ 100) -%} {% set rate_found_item = 1 -%} {% endif %} {% endfor %} {% if rate_found_item == 0 %}
{% if cgst_rate[0] -%} {% set _ = cgst_amt.append((row.amount * cgst_rate[0])/100) -%} {% set _=
it_cgst_rate.append(cgst_rate[0]) -%} {% set rate_found_inv = 1 -%} {%- endif -%} {% if sgst_rate[0]
-%} {% set _ = sgst_amt.append((row.amount * sgst_rate[0])/100) -%} {% set _= it_sgst_rate.append(cgst_rate[0])
-%} {% set rate_found_inv = 1 -%} {%- endif -%} {% if igst_rate[0] -%} {% set _ = igst_amt.append((row.amount
* igst_rate[0])/100) -%} {% set _= it_igst_rate.append(igst_rate[0]) -%} {% set rate_found_inv =
1 -%} {%- endif -%} {% endif %} {% if not it_cgst_rate[0] %} {% set _ = it_cgst_rate.append(0) %}
{% set _ = cgst_amt.append(0) %} {% endif %} {% if not it_sgst_rate[0] %} {% set _ = it_sgst_rate.append(0)
%} {% set _ = sgst_amt.append(0) %} {% endif %} {% if not it_igst_rate[0] %} {% set _ = it_igst_rate.append(0)
%} {% set _ = igst_amt.append(0) %} {% endif %} {% set temp_cgst_amt = grand_total["cgst_amt"] +
cgst_amt[0] %} {% set temp_sgst_amt = grand_total["sgst_amt"] + sgst_amt[0] %} {% set temp_igst_amt
= grand_total["igst_amt"] + igst_amt[0] %} {% set temp_qty = grand_total["qty"] + row.qty %} {% set
temp_amount = grand_total["amount"] + row.amount %} {% set temp_item_taxable_amount = row.amount
%} {% set check = grand_total.update({"qty": temp_qty, "amount": temp_amount, "cgst_amt":temp_cgst_amt,
"sgst_amt":temp_sgst_amt, "igst_amt":temp_igst_amt}) %}
<td style="width: 1%;">
<font size="1">{{ row.idx }}</font>
</td>
<td style="width: 15%;">
<font size="1" style="font-size:8px;">
<b> {{ row.item_code }}</b>
</font>
</td>
<td style="width: 13%;">
<font size="2" style="font-size:8px;">{%- if row.meter!= none -%}{{ row.meter }} {%- endif -%}</font>
</td>
<td style="width: 5%;">
<font size="1" style="font-size:8px;">
<b> {{ row.gst_hsn_code }}</b>
</font>
</td>
<td style="width: 5%;">
<font size="1" style="font-size:8px;">
<b> {{ row.tax_rate}}</b>
</font>
</td>
<td style="width: 8%; text-align: right;">
<font size="2" style="font-size:8px;">{{"{:,.2f}".format(row.meter_rate_c) }}</font>
</td>
<td style="width: 20%; text-align: right;">
<font size="2" style="font-size:8px;">{{"{:,.2f}".format(row.amount) }}</font>
</td>


</tr>
{%- endfor -%} {% set row_count_threshold = 10- doc.items|length -%} {% for i in range(row_count_threshold) %}
<tr>
<td></td>
<td> </td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>

</tr>
{%- endfor -%}
<tr style="border-top:1px solid black;">
<td style="width: 5%;" colspan=1>
<font size="1" style="font-size:9px;">Total</font>
</td>
<td style="width: 15%; text-align: left;">
<font size="1" style="font-size:9px;"></font>
</td>
<td style="width: 5%; text-align: left;">
<font size="1" style="font-size:9px;"></font>
</td>
<td style="width: 20%;">
<font size="1"></font>
</td>
<td style="width: 10%;">
<font size="1"></font>
</td>
<td style="width: 10%;">
<font size="1"></font>
</td>
<td style="width: 15%; text-align: right;">
<font size="1" style="font-size:9px;">{{ "{:,.2f}".format(grand_total["amount"]) }}</font>
</td>

</tr>
</tbody>
</table>



</div>

</div>

<table width="100%" border="1" style="font-size:9px;border-bottom:0px;">
<tbody>
<tr>
<td width="56%" text-align="left">

<p><b>INVOICE TOTAL SUMMARY</b></p>
<table border = 1; width = "300">
<tbody>

<th><font size = "1">GST HSN Code</font></th>
<th class="text-right"><font size = "1">Tax Rate</font></th>
<th class="text-right"><font size = "1">Taxable Value</font></th>
<th class="text-right"><font size = "1">Tax Amount</font></th>
</tr>

{% set list = [] %}
{% set dict = {} %}
{% set tot_qty = [] %}
{% set tax_amt = [] %}
{% set tot_amt = 0 %}
{% set grand_total = {"qty":0.0, "amount":0.0} %}
{% set groups = doc.items|groupby('gst_hsn_code') %}
{% set no_of_group = groups|length %}
{% set total_count = 0 %}

{% set group_count = 0 %}
{% set tot_inv_qty = doc.items|sum(attribute='qty') %}

{% set item_details = {"total_qty":0.0} %}

{% for group in doc.items | groupby('gst_hsn_code') %}
{% set group_count = group.list|length %}
{% set total_count = total_count + group_count %}
{% set count = 1 %}
{% set item_desc = [] %}
{% set mrp = [] %}
{% set rate = 0 %}
{% set gstin = [] %}
{% for item in group.list %}

{% if count == 1 -%}
{% set _ = item_desc.append(item.gst_hsn_code) %}
{% set _ = gstin.append(item.gst_hsn_code) %}
{% set _ = mrp.append(item.rate) %}
{% set _ = item_desc.append(item.gst_hsn_code) %}
{% set _ = item.item_tax_template %}

{%- endif %}
{% set count = count + 1 %}
{% set temp_qty = grand_total["qty"] + item.qty %}
{% set temp_amount = grand_total["amount"] + item.net_amount %}
{% set check = grand_total.update({"qty": temp_qty, "amount": temp_amount}) %}
{%- endfor %}

<tr>
<div class="row" style="padding-top:0px;" !important;">
<td style="width: 10%; text-align: left;"><font size = "1">{{ item_desc[0] }}<font></td></div>
{% set ns = namespace(flag=1) %}
{% for item in group.list %}
{%if item.tax_rate and ns.flag %}
{% set ns.flag = 0 %}
{% set tot_qty = item.tax_rate %}
<td style="width: 20%; text-align: right;"><font size = "1">{{ tot_qty}}</font></td>
{% endif %}
{%- endfor %}
{% set grand_tot_qty = tot_qty %}
{% set tot_amt = group.list|sum(attribute='net_amount') %}
{% set tax_amt = 0 %}
{% set tot_mrp = group.list|sum(attribute='amount')%}

<td style="width: 25%; text-align: right;"><font size = "1">{{ "{:,.2f}".format(tot_amt) }}</font></td>
<td style="width:25%;text-align: right; border-left:1px solid;">{{"₹{:,.2f}".format(doc.total_taxes_and_charges) }}</td>

</tr>{%- endfor %}
<tr>

<td style="width: 15%;"><font size = "1"><b>
Total</b></font></td>
<td style="width: 8%; text-align: right;"><font size = "1"><b> </b></font></td>
<td style="width: 10%; text-align: right;"><font size = "1"><b>
{{"{:,.2f}".format(grand_total["amount"])}}</b></font></td>

</tr>

</tbody>
</table>
<p style="text-align: left;">
<b> Beneficiary Name :{{doc.company}}</b><br>
<b> Account No. :_______________</b><br>
<b>Name of Bank :_______________</b><br>
<b>Branch :_______________</b><br>
<b>IFSC Code :_______________</b>
</P><br>

</td>
</td>
<td style="padding: 0px !important;">
<table width="100%" border="0">
<tbody>

<tr style="text-align: right; border-bottom:1px solid; font size = 1px">
<td>
<font style="font-size: 10px;"><b>Total Amount Before TaxRate</font></b>
</td>
<td style="width:45%;text-align: right; border-left:1px solid;"> <font style="font-size: 10px;"><b>{{"₹{:,.2f}".format(doc.net_total) }}</b></font></td>
</tr>
{%- for row in doc.taxes -%}
{%- if row.tax_amount != 0 -%}
<tr>
<tr style="text-align: right; border-bottom:1px solid">
<td>
<b><font style="font-size: 10px;">{{ row.description }}</font></b>
</td>
<td style="width:35%;text-align: right; border-left:1px solid;">
<font style="font-size: 10px;">{{ row.get_formatted("tax_amount", doc) }}</font>
</td>
</tr>{%- endif -%}
{%- endfor -%}
<tr style="text-align: right; border-bottom:1px solid">
<td>
<font style="font-size: 10px;"><b>Total Taxes & charges</b>
</td>
<td style="width:45%;text-align: right; border-left:1px solid;"><font style="font-size: 10px;">{{"₹{:,.2f}".format(doc.total_taxes_and_charges) }}</font></td>
</tr>

<tr style="text-align: right; border-bottom:1px solid">
<td>
<font style="font-size: 10px;"> <b>Total Amount After Tax</font></b>
</td>
<td style="width:45%;text-align: right;border-left:1px solid;"><b><font style="font-size: 10px;">{{"₹{:,.2f}".format(doc.rounded_total) }}</font></b></td>
</tr>

</tbody>
</table><font style="font-size: 10px;"> <b>In Words:</b></font>{{doc.in_words}}
</td>
</tr>
</tbody>
</table>

<div style="font-size: 10px">

<div class="footer">
<table width="100%" border="1" style="font-size:8px;">
<tbody>
<tr>
<td width="50%" text-align="left" style="font-size:8px;">
<p>Declaration: </P><br>
<p>
We declare that this Invoice shows that actual price of the
goods described and that all particulars are true and co</p>

</td>
<td width="50%" text-align="right" style="font-size:8px;">
<p style="text-align: center;">
<b>For {{doc.company}}<b/>
<br><br></br>
Name & Designation
<br>
</br>Authorized Signatory
</p>
</td>
</b>
</tr>
</tbody>
</table>

</div>

<div id="footer-html" class="visible-pdf">
<p class="text-center small page-number visible-pdf">
{{ _("Page {0} of {1}").format('
<span class="page"></span>', '
<span class="topage"></span>') }}
</p>
</div>

Notes.io is a web-based application for taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000 notes created and continuing...

With notes.io;

* You can take a note from anywhere and any device with internet connection.
* You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
* You can quickly share your contents without website, blog and e-mail.
* You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
* Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.

Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.

Easy: Notes.io doesn’t require installation. Just write and share note!

Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )

Free: Notes.io works for 12 years and has been free since the day it was started.

You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;

Email: [email protected]

Twitter: http://twitter.com/notesio

Instagram: http://instagram.com/notes.io

Facebook: http://facebook.com/notesio

Regards;
Notes.io Team

Notes

Notes - notes.io

Shortened Note Link

Long File

Notes