Currency Rounding Driving me Insane...cannot get the right amount

Question

Exchange Rate: 0.302480339
Exchange Rage in OpenERP: 0.302480
Rounding Factor: 0.010000
Computational Accuracy: 4

Using Excel = 11825/0.302480 = *39093.45*
Using Windows Calculator = 11825/0.302480 = /39093.49/
Using Windows Calculator = 11825/0.302480339 = *39093.45*

Using OpenERP = 11825/0.302480 = /39093.51/

I need OpenERP to compute the amount *39093.45*. How do I go about doing that?

Damian Phang · Answer

I've fixed this.

edit res_currency.py file to display all 12 digits instead of 6 digits. Somehow, though, the accuracy is not perfect still. But for the most part the total is correct.

相关帖文	回复	查看
Change currency rounding in existing DB currency rounding odoo16features	3 12月 23	3443
[7.0] How can I set decimal precision to 6 for product prices but round actual invoices and sales orders to 2 decimals? 已解决 account currency rounding	1 1月 24	12742
Default Currency currency	1 4月 24	1813
accounting account default currency currency	2 1月 24	1841
Error message 已解决 currency	2 11月 23	2744

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！