Skip to Content
เมนู
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
คำถามนี้ถูกตั้งค่าสถานะ
1 ตอบกลับ
4099 มุมมอง

Hello there :)

I wrote some code to export orders from my online shop and import them into Odoo 14 as sales orders (plain csv file). This works pretty great, but I encounter a rounding problem.

My exported sales orders have no limit on the number of decimal places (prices). I found out, that Odoo rounds these decimal places to the number defined in "Settings > Decimal accuracy" and then the given value for "Product Price".

A simple solution would be to set this value (the number of digits for "Product Price") to something high like 8 or 16. I've tested the import of sales orders and with such a high No. of digits I do not have rounding problems. Unfortunately, though, Odoo shows those digits on the sales order in the column for price per UoM.

Another unfortunate thing is, that I have to export things like discounts as order lines with a negative value, since Odoo works so very differently to my shop system. So I absolutely rely on a fix for the rounding problem, hopefully with a higher number of decimal places. 

Anyone got a hint? 😟

PS: I've set the "Rounding Method" to "Round Globally" in "Settings > Accounting". "Line Subtotals Tax Display" is set to "Tax-Excluded".



อวตาร
ละทิ้ง
คำตอบที่ดีที่สุด

Edit the report using an inherited view that rounds the numbers on your invoices/etc.

อวตาร
ละทิ้ง
Related Posts ตอบกลับ มุมมอง กิจกรรม
0
มี.ค. 22
2219
How to modify sales order date manually? แก้ไขแล้ว
5
ธ.ค. 23
22287
0
เม.ย. 22
2526
2
เม.ย. 21
7757
How can I stop round decimals in odoo 12 แก้ไขแล้ว
2
ก.ค. 20
7750