account: force account.invoice.tax recalculation when different currency used

[Normunds (Alistek)]

Affects all versions.

Requirements :
Any invoice with other currency than company.

Problem description:

In certain circumstances leads to significant differences in tax reports and accounting entries because of currency rate floats between dates in companies with international trade operations.

Steps to reproduce:
Company currency EUR
Currency rates must exist for test dates.

1. Create supplier invoice in USD. (note invoice create date! ), leave in draft state.
2. After 3 days confirm invoice.

Results:
account.invoice.tax values are different from corresponding accounting entries, what is wrong.

Cause:
Difference arise from currency rate changes between invoice creation date and invoice confirmation date or changing invoice date while not recomputing taxes.

account.invoice.tax is not recalculated while changing invoice state (values are calculated from invoice creation date's currency rate), but account.move.lines company currency values are calculated from invoice confirmation date's currency rate (if date not set) or invoice date's currency rate.

Solution:
Invoice write function should perform additional cheks, and if necessary recompute account.invoice.tax according to specific correct date.

Normunds
Alistek ltd

[Amit Parik (amit-parik)]

Hello Normunds,

"Update" button is already there, So before confirming the invoice you can re-compute the taxes by "Update" button.
So it will re-calculate the taxes.

If you want automatic re-calculation of taxed on validate button, you can call the update taxes method on validate invoice.

Currently I am considering this as a improvement.

Thank you!

[Normunds (Alistek) (3pm)]

Hello Amit!

" you can re-compute the taxes by "Update" button."

Yes I can. But users no not do. In fact they ALWAYS do not recompute.
So it can be considered design/ usability flaw rather than Wishlist.

How we can call this "imporvement" if that behaviour ALWAYS leads to inconsistency of accounting and tax entries?

"If you want automatic re-calculation of taxed on validate button, you can call the update taxes method on validate invoice."

It is not so straigthtforward, because we did not want always update tax on validate (note manual tax correction ). But we made solution for our local branch.

I will propose to merge in OCB.

[Amit Parik (amit-parik)]

Hi Normunds,

Thanks for the quick response!

Please put the MP for trunk branch and our core team will also look into this and take the appropriate decision.

Thank you!

[Grzegorz Grzelak (OpenGLOBE.pl) (grzegorz-og.pl)]

I vote for higher importance of this bug.