Allow users to modify the tax and item calculation order

Well… you could donate $2000 and I may find a developer who has time and is able to solve this problem. :man_shrugging:

1 Like

Hi there,

Can anyone tell me how do it?

I want to create a button for every item until i create a invoice, that button will show a prompt box in which I will enter my full price (price including Vat) than that number I will divide with vat (if vat is 18%, than FullPrice/1.18).

A simple example of that I post below, but I don’t know how to modify InvoicePlane.

Script

Hi @Kovah, you closed my ticket and redirected me here, but this is a complete different issue.

I’m not looking for a fixed total price.

The way Invoice Plane calculates the item subtotal is in fact false.
The discount has to be subtracted from the net total, not the gross total.

No matter how you do it, the calculation in the current version is wrong.

Maybe it is not correct but the problem stays the same: the complete calculation process needs to be rewritten and the users need to be allowed to change the order in which his calculations are done.

This can’t be hotfixed in the next version as it would break the calculation for all existing quotes and invoices.

The issue that I mentioned seems to be very simple? Not sure in which file the calculation is done, but one simply has to change the order of the variables?

The fix seems simple but re-ordering would change the calculation for all existing invoices and quotes. That is the actual problem.
But me and @Maxime_GRIMLER are looking into this. Maybe we can get this into 1.6.

If you want to hotfix this just for yourself, the files that contain the calculation are Mdl_invoice_amounts.php and Mdl_item_amounts.php (for invoices).

1 Like

OK, Thanks! I’ll take a look on it.

Really appreciate your work!

I’ve already started the feature since yesterday night so if anyone has some requests ask it now I will try to do my best (and I understand yours @coderebels)

1 Like

@Maxime_GRIMLER Thank you so much!