Need only the amount figures in the items table. How do we do this?

There are a couple of things to be customised here.

  1. The table headers have to be slightly changed For example, Item Name to Item, Quantity to Qty
  2. The currency must not be printed in the items table at all. For example, the Rate column must only print 20.00 instead of AED 20.00; and similarly for Tax Amount as well as Total Amount.


This link might be helpful:

Which form is the Item Table from in your case?


This is a custom Sales Invoice report.

For the Sales Invoice Item form, can you try changing the relevant fields from currency type to something else, say float? I don’t know if this will also change the sales invoice report or not. Otherwise custom fields could be tried.

Please try the below

{%- for row in doc.items -%}
            <td style="width: 3%;">{{ row.idx }}</td>
            <td style="width: 20%;">
                {{ row.item_name }}
                {% if row.item_code != row.item_name -%}
                <br>Item Code: {{ row.item_code}}
                {%- endif %}
            <td style="width: 37%;">
                <div style="border: 0px;">{{ row.description }}</div></td>
            <td style="width: 10%; text-align: right;">{{ row.qty }} </td>
            <td style="width: 15%; text-align: right;">{{
            <td style="width: 15%; text-align: right;">{{
        {%- endfor -%}
ID Material Description Quantity (PCS) Rate(AED) Amount(AED)