How I can get the total value in words in sales invoice and purchase orders
This might help: Customized sales invoice
It would be only possible in sales invoices using custom HTML template.
But in what language do you need numbers to be shown as words? English or different?
I need in English language
Well, if you create custom HTML template, you can use code:
{{ balance_due_in_words }}
and this will print balance due in words.
See: Manager Cloud and Manager Cloud
Thanks Lubos , but if you please tell me where i use the code in custom HTML template . This is the custom fild
<div>{{ sales_quote }}</div>
{% endif %}
{% if purchase_order != empty %}
<div style="font-weight: bold; margin-top: 10px; white-space: nowrap">Purchase order</div>
<div>{{ purchase_order }}</div>
{% endif %}
</td>
<td style="vertical-align: top; width: 100px; border-left: 1px solid #000; padding-left: 20px; vertical-align: top">
<div style="font-weight: bold; white-space: nowrap">{{ business.name }}</div>
<div style="white-space: nowrap">{{ business.contact_information | newline_to_br }}</div>
<div style="white-space: nowrap">{{ business.identifier }}</div>
</tr>table style="width: 100%">
<thead>
<tr>
<td style="font-size: 36px; font-weight: bold; vertical-align: top; line-height: 36px">INVOICE</td>
<td style="text-align: right">{% if business.logo != empty %}<img src="{{ business.logo }}" style="max-width: 300px; max-height: 150px">{% endif %}</td>
</tr>
<tr>
<td colspan="2" style="padding: 20px 0px">
<table style="width: 100%">
<tr>
<td style="vertical-align: top; font-weight: bold; width: 1px; white-space: nowrap; padding-right: 10px">
To
</td>
<td style="vertical-align: top">
<div>{{ customer.name }}</div>
<div>{{ billing_address | newline_to_br }}</div>
<div>{{ customer.identifier }}</div>
</td>
<td style="vertical-align: top; width: 100px; padding-right: 20px; vertical-align: top; text-align: right">
<div style="font-weight: bold">Issue date</div>
<div>{{ issue_date | date_to_string }}</div>
{% if due_date != null %}
<div style="font-weight: bold; margin-top: 10px">Due date</div>
<div>{{ due_date | date_to_string }}</div>
{% endif %}
<div style="font-weight: bold; margin-top: 10px; white-space: nowrap">Invoice number</div>
<div>{{ reference }}</div>
{% if sales_quote != empty %}
<div style="font-weight: bold; margin-top: 10px; white-space: nowrap">Sales quote</div>
</table>
</td>
</tr>
</thead>
<tbody>
<tr>
<td colspan="2">
<div style="font-weight: bold; padding-bottom: 20px; font-size: 14px">{{ summary }}</div>
<table style="width: 100%">
<tr>
<th style="border: 1px solid #000; padding: 5px 10px">Item</th>
<th style="border: 1px solid #000; padding: 5px 10px">Description</th>
<th style="width: 40px; border: 1px solid #000; padding: 5px 10px; text-align: center">Qty</th>
<th style="width: 80px; border: 1px solid #000; padding: 5px 10px; text-align: center">Unit price</th>
<th style="width: 60px; border: 1px solid #000; padding: 5px 10px; text-align: center">Discount</th>
<th style="width: 100px; border: 1px solid #000; padding: 5px 10px; text-align: center">Amount</th>
</tr>
{% for line in lines %}
<tr>
<td style="border: 1px solid #000; padding: 5px 10px; border-bottom: none; border-top: none; vertical-align: top">{{ line.item.name }}</td>
<td style="border: 1px solid #000; padding: 5px 10px; border-bottom: none; border-top: none">{{ line.description | newline_to_br }}</td>
<td style="border: 1px solid #000; padding: 5px 10px; border-bottom: none; border-top: none; text-align: center; vertical-align: top">{{ line.qty }}</td>
<td style="border: 1px solid #000; padding: 5px 10px; border-bottom: none; border-top: none; text-align: right; vertical-align: top">{{ line.unit_price | money_without_currency }}</td>
<td style="border: 1px solid #000; padding: 5px 10px; border-bottom: none; border-top: none; text-align: center; vertical-align: top">{{ line.discount }}</td>
<td style="border: 1px solid #000; padding: 5px 10px; text-align: right; border-bottom: none; border-top: none; vertical-align: top; white-space: nowrap">{{ line.total | money_without_currency }}</td>
</tr>
{% endfor %}
<tr>
<td style="border: 1px solid #000; padding: 5px 10px; border-top: none"> </td>
<td style="border: 1px solid #000; padding: 5px 10px; border-top: none"> </td>
<td style="border: 1px solid #000; padding: 5px 10px; border-top: none"> </td>
<td style="border: 1px solid #000; padding: 5px 10px; border-top: none"> </td>
<td style="border: 1px solid #000; padding: 5px 10px; border-top: none"> </td>
<td style="border: 1px solid #000; padding: 5px 10px; border-top: none"> </td>
</tr>
{% if amounts_include_tax %}
{% if rounding != 0 %}
<tr>
<td colspan="5" style="text-align: right; padding: 5px 10px">Round off</td>
<td style="border: 1px solid #000; text-align: right; padding: 5px 10px; white-space: nowrap">{{ rounding | money }}</td>
</tr>
{% endif %}
<tr>
<td colspan="5" style="text-align: right; padding: 5px 10px; font-weight: bold">Total</td>
<td style="border: 1px solid #000; text-align: right; padding: 5px 10px; font-weight: bold; white-space: nowrap">{{ total | money }}</td>
</tr>
{% for tax_component in tax_components %}
<tr>
<td colspan="5" style="text-align: right; padding: 5px 10px">{{ tax_component.code }}</td>
<td style="border: 1px solid #000; text-align: right; padding: 5px 10px; white-space: nowrap">{{ tax_component.amount | money }}</td>
</tr>
{% endfor %}
{% else %}
{% assign tax_components_count = tax_components | size %}
{% if tax_components_count > 0 %}
<tr>
<td colspan="5" style="text-align: right; padding: 5px 10px; font-weight: bold">Subtotal</td>
<td style="border: 1px solid #000; text-align: right; padding: 5px 10px; font-weight: bold; white-space: nowrap">{{ subtotal | money }}</td>
</tr>
{% endif %}
{% for tax_component in tax_components %}
<tr>
<td colspan="5" style="text-align: right; padding: 5px 10px">{{ tax_component.code }}</td>
<td style="border: 1px solid #000; text-align: right; padding: 5px 10px; white-space: nowrap">{{ tax_component.amount | money }}</td>
</tr>
{% endfor %}
{% if rounding != 0 %}
<tr>
<td colspan="5" style="text-align: right; padding: 5px 10px">Round off</td>
<td style="border: 1px solid #000; text-align: right; padding: 5px 10px; white-space: nowrap">{{ rounding | money }}</td>
</tr>
{% endif %}
<tr>
<td colspan="5" style="text-align: right; padding: 5px 10px; font-weight: bold">Total</td>
<td style="border: 1px solid #000; text-align: right; padding: 5px 10px; font-weight: bold; white-space: nowrap">{{ total | money }}</td>
</tr>
{% endif %}
</table>
<div>{{ notes }}</div>
</td>
</tr>
</tbody>
</table>
its not apprearing the decimal amounts?
Plese help
See this topic on the forum: Number to words.
there is any html code for access a tax amount in words format for customised invoice