How to use doc.get_formatted for child table

How to use doc.get_format while looping though items for e.g

  • i want to format these by using get_formatted.

{%- for row in doc.items -%}

    <td>{{ row.description}}</td>
    <td>{{ row.qty}}</td>
    <td>{{ row.base_price_list_rate}}</td>
    <td>{{ row.base_price_list_rate  * row.qty}}</td>
    <td>{{ row.base_price_list_rate - row.base_net_rate}}</td>
    <td>{{ row.base_net_amount}}</td>
    <td>{{ frappe.db.get_value("Sales Order Item", row.so_detail, "reorder_date") }}</td>
{%- endfor -%}

i found a way to do it:
{{ row.get_formatted(“qty”)}}

but having problem in this scenario:
{{ row.get_formatted(“base_price_list_rate”) * row.get_formatted(“qty”)}}

2 Likes