GST Invoice Format

nabenduroy · September 7, 2020, 10:46am

Hello All,

I,m using below HTML for GST Invoice Format, it was working fine on version Manager_19.12.13 but on latest version it’s malfunctioning.

Can anyone please help me to short out the issue?

Screenshot

HTML Code

{% assign i = 0 %} {% for row in table.rows %} {% assign i = i | plus: 1 %} {% for cell in row.cells %} {% endfor %} {% endfor %} {% for column in table.columns %} {% endfor %} {% for total in table.totals %} {% endfor %} {% for field in custom_fields %} {% if title == 'Invoice' %} {% if field.label != "Notes" %}{% continue %}{% endif %} {% endif %} {% endfor %} {% if title == 'Invoice' %} {% endif %}

{% if business.logo != null %}{% endif %}

{% if title != 'Tax Invoice' %}{{ title }}{% endif %}{% if title == 'Tax Invoice' %}{{ title | replace: "Tax Invoice", "Invoice" }}{% endif %}

        <table style="margin-bottom: 20px"><tr>
            <td style="width: 200px; border-left-width: 5px; padding-left: 10px; text-align: left">
                {% for field in fields %}
                <div style="font-weight: bold; font-size: 12px">{{ field.label }}</div>
                <div style="margin-bottom: 10px; font-weight: bold; font-size: 16px">{{ field.text }}</div>
                {% endfor %}
            </td>
            {% if title == 'Invoice' %}
            <td style="width: 260px; padding-left: 20px; border-color: #000000; border-left-width: 1px">
            {% for field in custom_fields %}
            {% if field.label == "Shipped To:" %}{% continue %}{% endif %}
            {% if field.label == "Notes" %}{% continue %}{% endif %}
            {% if field.label == 'Total in words' %}{% continue %}{% endif %}
            <div style="font-size: 12px; padding-bottom: 10px"><b>{{ field.label }}</b> {{ field.text | newline_to_br }}</div>
            {% endfor %}</td>{% endif %}
            <td style="width: 300px; padding-left: 10px; padding-right: 5px; text-align: left; vertical-align: top; border-top-width: 3px; border-bottom-width: 5px">
                <div style="text-align:LEFT;font-weight: bold;font-size: 18px">{{ business.name }}</div>
                <div style="text-align:LEFT;font-size: 12px">{{ business.address | newline_to_br }}</div>
                <div style="text-align:LEFT;font-weight: bold;font-size: 14px">{{ business.identifier }}</div>
            </td>
        </tr></table>
        <table style="margin-bottom: 20px">
        <td style="width: 380px; text-align: left; border-color: #000000; border-bottom-width: 2px; border-top-width: 2px; border-left-width: 2px; border-right-width: 2px">
            {% if title == 'Invoice' %}<div style="padding-left: 5px; border-bottom-width: 2px; text-align:LEFT;font-weight: bold">Billed To:</div>{% endif %}
            <div style="padding-left: 20px">
            <div><b>{{ recipient.name }}</b> {{ recipient.code }}</div>
            <div>{{ recipient.address | newline_to_br }}</div>
            <div><b>{{ recipient.identifier }}</b></div></div>
        </td>
        {% if title == 'Invoice' %}
            <td style="width: 375px; padding-left: 5px; text-align: left; border-color: #000000; border-bottom-width: 2px; border-top-width: 2px; border-left-width: 0px; border-right-width: 2px">
                {% for field in custom_fields %}{% if field.label == 'Shipped To:' %}{% assign consignee = field.text %}
                <div style="padding-left: 5px; border-bottom-width: 2px; text-align:LEFT;font-weight: bold">{{ field.label }}</div>
                <div style="padding-left: 20px">{{ field.text | newline_to_br }}</div>
                {% endif %}{% endfor %}
                {% if consignee == null %}
                <div style="padding-left: 5px; border-bottom-width: 2px; text-align:LEFT;font-weight: bold">Shipped To:</div>
                <div style="padding-left: 20px">
                <div><b>{{ recipient.name }}</b> {{ recipient.code }}</div>
                <div>{{ recipient.address | newline_to_br }}</div>
                <div><b>{{ recipient.identifier }}</b></div></div>{% endif %}
            </td>
        {% endif %}
        </table>

        <div style="font-size: 14px; font-weight: bold; margin-bottom: 20px">{{ description }}</div>
    
</td></tr>

<tr>
    <td style="width: 25px; font-weight: bold; padding: 5px 5px; border-bottom-width: 1px; border-left-width: 1px; border-top-width: 1px; text-align:CENTER">#</td>
    {% for column in table.columns %}            
    <td style="font-weight: bold; padding: 5px 10px; text-align: {{ column.align }}; border-left-width: 1px; border-bottom-width: 1px; border-top-width: 1px{% if forloop.last == true %}; border-right-width: 1px{% endif %}{% if column.nowrap %}; white-space: nowrap; width: 80px{% endif %}">{{ column.label }}</td>
    {% endfor %}
</tr>

{% for field in custom_fields %}{% if field.label == 'Total in words' %}{{ field.text }} Only

{% endif %}{% endfor %}

We declare that this invoice shows the actual price of the goods or
service described and that all particulars are true and correct.
E. & O. E.
For {{ business.name }}

Authorised Signatory

Joe91 · September 7, 2020, 10:59am

You don’t say what edition of Manager you are using (Windows, Linux, iOS) but if it is Windows you probably need to update the .Net component of Windows

Search this forum for how to do that

nabenduroy · September 7, 2020, 11:18am

Thanks for reply…

I’m using Manager_20.8.99 for windows 10

nabenduroy · September 7, 2020, 11:33am

.net updated but not working…

nabenduroy · September 7, 2020, 12:18pm

Error Code

Liquid error: Could not load file or assembly ‘System.ValueTuple, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

Tut · September 7, 2020, 1:32pm

@nabenduroy, this forum is not intended for debugging custom themes. Users are responsible for performance of their own themes. If you do not have the coding skills yourself, you should hire a local programmer to assist.

You were almost 1,000 versions behind when you updated. During that time, there were several major changes to the program, including alterations of the database structure. One disadvantage of highly customized themes is that they are easily broken by program improvements.

MarV · September 7, 2020, 3:31pm

Also the HTML code you have pasted is incomplete and unreadable. Use Preformatted code button in reply editor or better attach an complete file.

nabenduroy · September 7, 2020, 5:12pm

<table style="padding: 20px 20px">
<thead>
    <tr>
    <td colspan="99">
        <table style="margin-bottom: 10px"><tr>
            <td style="font-weight: bold; font-size: 32px">{% if title != 'Tax Invoice' %}{{ title }}{% endif %}{% if title == 'Tax Invoice' %}{{ title | replace: "Tax Invoice", "Invoice" }}{% endif %}</td>
            {% if business.logo != null %}<td style="text-align: right"><img src="{{ business.logo }}" style="max-height: 150px; max-width: 300px"></td>{% endif %}
        </tr></table>
        
        <table style="margin-bottom: 20px"><tr>
            <td style="width: 200px; border-left-width: 5px; padding-left: 10px; text-align: left">
                {% for field in fields %}
                <div style="font-weight: bold; font-size: 12px">{{ field.label }}</div>
                <div style="margin-bottom: 10px; font-weight: bold; font-size: 16px">{{ field.text }}</div>
                {% endfor %}
            </td>
            {% if title == 'Invoice' %}
            <td style="width: 260px; padding-left: 20px; border-color: #000000; border-left-width: 1px">
            {% for field in custom_fields %}
            {% if field.label == "Shipped To:" %}{% continue %}{% endif %}
            {% if field.label == "Notes" %}{% continue %}{% endif %}
            {% if field.label == 'Total in words' %}{% continue %}{% endif %}
            <div style="font-size: 12px; padding-bottom: 10px"><b>{{ field.label }}</b> {{ field.text | newline_to_br }}</div>
            {% endfor %}</td>{% endif %}
            <td style="width: 300px; padding-left: 10px; padding-right: 5px; text-align: left; vertical-align: top; border-top-width: 3px; border-bottom-width: 5px">
                <div style="text-align:LEFT;font-weight: bold;font-size: 18px">{{ business.name }}</div>
                <div style="text-align:LEFT;font-size: 12px">{{ business.address | newline_to_br }}</div>
                <div style="text-align:LEFT;font-weight: bold;font-size: 14px">{{ business.identifier }}</div>
            </td>
        </tr></table>
        <table style="margin-bottom: 20px">
        <td style="width: 380px; text-align: left; border-color: #000000; border-bottom-width: 2px; border-top-width: 2px; border-left-width: 2px; border-right-width: 2px">
            {% if title == 'Invoice' %}<div style="padding-left: 5px; border-bottom-width: 2px; text-align:LEFT;font-weight: bold">Billed To:</div>{% endif %}
            <div style="padding-left: 20px">
            <div><b>{{ recipient.name }}</b> {{ recipient.code }}</div>
            <div>{{ recipient.address | newline_to_br }}</div>
            <div><b>{{ recipient.identifier }}</b></div></div>
        </td>
        {% if title == 'Invoice' %}
            <td style="width: 375px; padding-left: 5px; text-align: left; border-color: #000000; border-bottom-width: 2px; border-top-width: 2px; border-left-width: 0px; border-right-width: 2px">
                {% for field in custom_fields %}{% if field.label == 'Shipped To:' %}{% assign consignee = field.text %}
                <div style="padding-left: 5px; border-bottom-width: 2px; text-align:LEFT;font-weight: bold">{{ field.label }}</div>
                <div style="padding-left: 20px">{{ field.text | newline_to_br }}</div>
                {% endif %}{% endfor %}
                {% if consignee == null %}
                <div style="padding-left: 5px; border-bottom-width: 2px; text-align:LEFT;font-weight: bold">Shipped To:</div>
                <div style="padding-left: 20px">
                <div><b>{{ recipient.name }}</b> {{ recipient.code }}</div>
                <div>{{ recipient.address | newline_to_br }}</div>
                <div><b>{{ recipient.identifier }}</b></div></div>{% endif %}
            </td>
        {% endif %}
        </table>

        <div style="font-size: 14px; font-weight: bold; margin-bottom: 20px">{{ description }}</div>
    
</td></tr>

<tr>
    <td style="width: 25px; font-weight: bold; padding: 5px 5px; border-bottom-width: 1px; border-left-width: 1px; border-top-width: 1px; text-align:CENTER">#</td>
    {% for column in table.columns %}            
    <td style="font-weight: bold; padding: 5px 10px; text-align: {{ column.align }}; border-left-width: 1px; border-bottom-width: 1px; border-top-width: 1px{% if forloop.last == true %}; border-right-width: 1px{% endif %}{% if column.nowrap %}; white-space: nowrap; width: 80px{% endif %}">{{ column.label }}</td>
    {% endfor %}
</tr>
</thead>
<tbody>
{% assign i = 0 %}
{% for row in table.rows %}
{% assign i = i | plus: 1 %}
<tr>
    <td style="width: 25px; padding: 5px 5px; border-left-width: 1px; text-align:CENTER">{{ i }}</td>
    {% for cell in row.cells %}
    <td style="padding: 5px 10px; text-align: {{ table.columns[forloop.index0].align }}; border-left-width: 1px{% if forloop.last == true %}; border-right-width: 1px{% endif %}{% if table.columns[forloop.index0].nowrap %}; white-space: nowrap; width: 80px{% endif %}">{{ cell.text | newline_to_br }}</td>
    {% endfor %}
</tr>
{% endfor %}
<tr>
{% for column in table.columns %}            
    <td style="border-bottom-width: 1px; border-left-width: 1px{% if forloop.last == true %}; border-right-width: 1px{% endif %}"></td>
{% endfor %}
</tr>
{% for total in table.totals %}
<tr>
    <td colspan="{{ table.columns | size }}" style="padding: 5px 10px; text-align: right{% if total.emphasis == true %}; font-weight: bold{% endif %}">{{ total.label }}</td>
    <td style="border-left-width: 1px; white-space: nowrap; border-right-width: 1px; border-bottom-width: 1px; padding: 5px 10px; text-align: right{% if forloop.first == true %}; border-top-width: 1px{% endif %}{% if total.emphasis == true %}; font-weight: bold{% endif %}">{{ total.text }}</td>
</tr>
{% endfor %}
<tr><td colspan="{{ table.columns | size | plus:1 }}" style="border-right-width: 1px; border-top-width: 1px; border-bottom-width: 1px; border-left-width: 1px"><div style="font-size: 12px; padding-left: 10px; padding-right: 10px; font-weight: bold">{% for field in custom_fields %}{% if field.label == 'Total in words' %}{{ field.text }} Only</div>{% endif %}{% endfor %}</td></tr>
{% for field in custom_fields %}
{% if title == 'Invoice' %}
{% if field.label != "Notes" %}{% continue %}{% endif %}
{% endif %}
<tr>
    <td colspan="99">
        <div style="font-weight: bold; padding-top: 20px">{{ field.label }}</div>
        <div>{{ field.text | newline_to_br }}</div>
    </td>
</tr>
{% endfor %}
</tbody>
<tfoot>
<tr>
{% if title == 'Invoice' %}
<td colspan="99">
    <div style="text-align: right; font-weight: bold">We declare that this invoice shows the actual price of the goods or<br>service described and that all particulars are true and correct.<br>E. & O. E.<br>For {{ business.name }}<br><br><br><br>Authorised Signatory</div></td>
{% endif %}
</tr>
</tfoot>

nabenduroy · September 7, 2020, 5:15pm

This Code was working fine before installing the update but after update Sl No. (#) column number is not showing.

in place of number it’s show only “Zero”

If you have any idea please share.

Tut · September 7, 2020, 5:28pm

You need to debug your own code.

nabenduroy · September 7, 2020, 5:33pm

Understand…

Thanks for your kind suggestion…

It’s really help me…

nabenduroy · September 7, 2020, 5:33pm

Understand…

Thanks for your kind suggestion…

It’s really help me…

MarV · September 7, 2020, 9:52pm

It is all good at my side with your theme.

Download, and unpack the Manager again. Try in new folder.

nabenduroy · September 8, 2020, 6:18am

Ok…

Topic		Replies	Views
Anatomy of India's New GST Invoice Format	64	22406	January 18, 2023
Problem with amount in words	2	799	January 18, 2023
Issue with displaying amount in words	4	1090	January 18, 2023
KSA QR code not working in custom theme	58	2336	January 18, 2023
Custom Invoice theme. I would like to fix it so I can use PDF button	4	721	April 12, 2022

GST Invoice Format

Related topics