Include (Is this Tax included in Basic Rate) in PrintFormat

Frappe Framework Print Formats
1

Hello Everybody!
I woud like to print item with tax (Is this Tax included in Basic Rate) in PrintFormat (Custom Format).

Code here:

@import url('https://fonts.googleapis.com/css?family=Angkor|Hanuman|Moul|Nokora'); .print-format table, .print-format tr, .print-format td, .print-format div, .print-format p { font-family: times; font-family: 'Moul', cursive; font-family: 'Hanuman', serif; font-family: Monospace line-height: 200%; vertical-align: middle;} @media screen { .print-format { width: 8.27in; padding: 0.7in; min-height: 11.69in; } } .p0 { padding-left: 0px; } .pl { padding-left: 520px; } .p470 { padding-left: 470px; } .pl450 { padding-left: 450px; } .pl220 { padding-left: 220px; } .pl20 { padding-left: 20px; } .pl70 { padding-left: 160px; } .alignleft { float: left; } .alignright { float: right; } .lh{line-height: 1;} .l8{line-height: 0.8;} .l5{line-height: 0.5;} .th50{height: 5px;} .th5{height: 0.5px;} .th60{height: 13px;} .th12{height: 9px;}

សៀវ សុផល រៀល អុីស្ទេត ឯ.ក
{{ _("SIEV SOPHAL REAL ESTATE CO., LTD.") }}

{{ _("លេខអត្តសញ្ញាណកម្ម អតប") }} (VATTIN) K006-901701949

អាសយដ្ឋានៈ ផ្លូវ ២១៧​   សង្កាត់ ជើងឯក

Address      Street 217    Sangkat Choeung Aek

ខណ្ឌ ដង្កោ   រាជធានី ភ្នំពេញ   ទូរស័ព្ទលេខ ០៩៨៧៨២៧១៣

Khan Dang Kor   City Phnom Penh   Telephone Nº 098782713

{{ _("វិក្កយបត្រអាករ") }}
{{ _("TAX INVOICE") }}

លេខរៀងវិក្កយបត្រ៖ {{ doc.name }}

អតិថិជន / Customer :

Invoice Nº

<div id="textbox">
		<p class="alignleft">
			<b>ឈ្មោះក្រុមហ៊ុន ឬអតិថិជន:&emsp;&ensp;{{ frappe.get_fullname(doc.customer_name) }}</b><br>

Company name /Customer



{{ _(“កាលបរិច្ឆេទ”) }} {{ frappe.utils.get_datetime(doc.posting_date).strftime(‘%d %m %Y’) }}

Date



ទូរស័ព្ទលេខ:  {{ (doc.contact_mobile) }}

Telephone Nº
លេខអត្តសញ្ញាណកម្ម អតប (VATTIN) ☐☐☐☐-☐☐☐☐☐☐☐☐☐ (ប្រសិនជាមាន\ If any)
{%- for item in doc.items -%} {%- endfor -%} {% if doc.flags.show_inclusive_tax_in_print %} {% else %}
{{ _("ល.រ") }}
{{ _("Nº") }}		 {{ _("បរិយាយមុខទំនិញ") }}
{{ _("Description") }}		 {{ _("បរិមាណ") }}
{{ _("Quantity") }}		 {{ _("ថ្លៃឯកតា") }}
{{ _("Unit Price") }}		 {{ _("ថ្លៃទំនិញ") }}
{{ _("Amount") }}
{{loop.index}} {{ item.item_name }} {{ item.qty }} {{ item.get_formatted("rate") }} {{ item.get_formatted("amount") }}
{{ _("Total Excl. Tax") }} {{ doc.get_formatted("net_total", doc) }} {{ _("សរុប") }}
{{ _("​Sub Total") }} 
			</td>
			<td class="text-center th5" colspan= "4">
				{{ doc.get_formatted("total", doc) }}
			</td>
		{% endif %}
	</tr>
	{%- for row in doc.taxes -%}
	  {%- if not row.included_in_print_rate or doc.flags.show_inclusive_tax_in_print -%}
		<tr>
			<td class="text-right" style="width: 70%" colspan= "4" class="th50">
				<b>{{ _("អាករលើតម្លៃបន្ថែម ១០%") }}<br>{{ row.description }}<b/>
			</td>
			<td class="text-center" colspan= "4" class="th50">
				{{ row.get_formatted("tax_amount", doc) }}
				{{ format_currency(row.tax_amount, currency) }}
			</td>
		</tr>
	  {%- endif -%}
	{%- endfor -%}

	{#{%- if doc.discount_amount -%}

	<tr>
		<td class="text-right" style="width: 75%" colspan= "4">
			{{ _("Discount") }}
		</td>
		<td class="text-center" colspan= "4">
			{{ doc.get_formatted("discount_amount") }}
		</td>
	</tr>
	{%- endif -%}#}
	
	<tr>
		
		<td class="text-right" style="width: 75%" colspan= "4">
			<b>{{ _("សរុបរួម") }}<br>{{ _("Grand Total") }}</b>
		</td>
		<td class="text-center" colspan= "4">
			{{ doc.get_formatted("grand_total") }}
		</td>
	</tr>
	{%- if doc.rounded_total -%}
	<tr>
		<td class="text-right" style="width: 75%" colspan= "4">
			<b>{{ _("Rounded Total") }}</b>
		</td>
		<td class="text-center" colspan= "4">
			{{ doc.get_formatted("rounded_total") }}
		</td>
	</tr>
	{%- endif -%}
	<tr>
		{#
		<td class="text-right" style="width: 75%" colspan= "4">
			<b>{{ _("Paid Amount") }}</b>
		</td>
		<td class="text-center" colspan= "4">
			{{ doc.get_formatted("paid_amount") }}
		</td>#}
	</tr>
	{#
		{%- if doc.change_amount -%}
		<tr>
			<td class="text-right" style="width: 75%" colspan= "4">
				<b>{{ _("Change Amount") }}</b>
			</td>
			<td class="text-center" colspan= "4">
				{{ doc.get_formatted("change_amount") }}
			</td>
		</tr>
	{%- endif -%} #}
</tbody>



         _____________________________

_____________________________

           ហត្ថលេខា និងឈ្មោះអ្នកលក់

  ហត្ថលេខា និងឈ្មោះអ្នកទិញ 

<div id="textbox">
		<p class="alignleft l8">
			 &emsp;&emsp;&emsp;&emsp;&emsp;&emsp;&nbsp;&nbsp;&nbsp;&nbsp;Customer's Signature & Name  </p>
		<p class="pl450 l8">
			&emsp;&emsp;Seller's Signature & Name  </p>
 		<div style="clear: both;"></div>
	</div><br>

សម្គាល់៖ ច្បាប់ដើមសម្រាប់អ្នកទិញ ច្បាប់ចម្លងសម្រាប់អ្នកលក់
Note: Original Invoice for customer, Copied invoice for seller

Thank you.

2

{# Don’t forget to check->Setup->Accounts Settings->Print Setting->Show Inclusive Tax In Print if you want to print item with Is this Tax included in Basic Rate?#}

It’s working.

1 Like