adjust Pricing Decimal Places in reports

[mabroens]

Hi, is there a way to influence the number of Decimal Places for pricing when creating a report.
in my case i would like a report to be only 2 digits in the pricing information for a sales report but for a BOM i would like it to be 4 digits.

is this somehow possibel?

br martijn

[LavissaWoW]

A new helper function was added in 0.11 afaik.

InvenTree/InvenTree/report/templates/report/inventree_po_report_base.html

Line 48 in 011b591

<td>{% render_currency line.price decimal_places=2 %}</td>

InvenTree/InvenTree/report/templates/report/inventree_po_report_base.html

Line 73 in 011b591

<td>{% render_currency order.total_price decimal_places=2 currency=order.supplier.currency %}</td>

[SchrodingersGat]

Yep the answer by @LavissaWoW is the correct approach - you can directly specify the number of decimal places you want to use

[mabroens]

Wow again brilliant work.
yes this solved the issue for me.

just wish i would be able to figure out what variables i have available to put in the template. any hints where i can find the docu or src for that?? example: order.customer_reference i was able to figure out by trial and error but obviously there must be better solution.

I have also made a small improvement to the script. since in the original it was taking the currency per part in $ and the total in Euro.
<td>{% render_currency order.total_price decimal_places=2 currency=order.customer.currency %}</td>

i also have some additional fields that i hope will be available in the future updates like customer.steet, customer.zip email etc.
Invoice-Template.html.txt
Any change the name of the report.pdf can be changed on the fly to match for example the {{ prefix }}{{ reference }}.pdf????

br martijn

[SchrodingersGat]

@mabroens the documentation is here - https://docs.inventree.org/en/latest/report/sales_order/ - but there is no guarantee that all of the available context variables are reported there.

If you have found some that are not documented I'd suggest you submit a pull request to update the documentation :)

[mabroens]

@SchrodingersGat thanx but i already had a look over there. and i'm willing to participate in the project no problem with that at all. but i lack the experience (for now).
as an example:
how can i find out what parameters the variable lines offers or customer what additional parameters are available.

i'm guessing i should be able to extract this some how from the python code. but had no luck yet finding it.

Br Martijn

[LavissaWoW]

While it's not a complete answer, I've turned to the API before to see what elements are exposed there.
Try /api/order/so-line/?order=6 on the demo for example.