[Lapi]

Hello,

I believe I now understand how the internal calculation is performed:

The tax is calculated at the end and added to the total of all line items (excluding tax), rather than being computed line by line and then summed. This likely explains why the result is rounded up in this example for times 1 and 2, as well as time 501. In other cases, the value remains below XXX.995 after the third decimal place.

It appears that the system rounds up when the third digit after the decimal point is 995 or higher.

Unless the user can select an alternative method of tax calculation or rounding in the settings, it may be preferable to leave the current behaviour unchanged, as implementing such an option would require considerable effort and may not be of interest to most users.

Thank you for your great support,
Best regards

[Lapi]

Please find a screenshot of the operation

Attachments:

1. 

   Screenshot-2026-04-15-at-07-09-37-invoices-Edit.png
   

[Lapi]

I should have mentioned the 10% GST(tax)
1*$58.18*1.1 = $64.00

[Lapi]

Hello R Rowley!

It was a very interesting challenge and finally everything worked as I hoped!

The forum is very helpful as it contains some of the direct answers to issues or helps finding our own by cross referencing…

The improvements offered in the 2020 version are very significant and useful.

Thank you very much for your guidance and brilliant achievements!

Kindest regards,

All the best.

Claude

[Author]

Posts