Skip to Content
This question has been flagged
2 Replies
947 Views
Avatar
karo

Hi,

Please apologize if this topic was already tackled before, we didn't find any resolution. 

We are knew to the Odoo and we are planning to migrate our old solution to the Odoo Online version. While preparing for a migration we have encountered the following problem with creating a sale order lines (everything is done via RPC). Our current sales platform has a very specific way of dealing with prices, products are always including taxes therefore creating an invoice is always a pain due to a different decimal accuracy and calculation from a total value per line. 

Odoo provides ability to create a sale order and add the order lines - this is great, it works like a charm but... in some cases the total value per sale.order.line is different to ours. Reason: we calculate the price unit with 2 decimals and provide it to Odoo. The final calculation is not always the same due to the rounding up/down method that differs between two systems. Is there a chance to adjust the total value per sale.order.line by adding a field e.g. "correction" which could be used to correct the final number? or create a sale.order.line not on price unit/quantity but rather total value (incl. tax) / quantity? In the latter, the price unit & tax visible on sale.order.line would be calculated it based on input?

Thanks for support in this matter.

Avatar
Discard
Avatar
karo
Author Best Answer

yes, we are talking about "round off correction". Your proposal would be the last resort option. For now, we want to avoid it and keep this type of changes on sale.order.line so this type of correction is also reflected on final price we sold a product.

Avatar
Discard
Fadi Ezzeddine

Basically what you need is to have a Round-Off Column on each item (similar to the discount) option. In that case, You would need an Odoo partner to develop a custom module/solution for you.

Avatar
Fadi Ezzeddine
Best Answer

Hello,

If I understand what you are asking for correctly (i am 90% sure than I do), you can create a new Service in your "Products" that you can call "Round-off Correction" (or whatever you want), and you can add it as a product to your invoice and modify its value positively or negatively to have the final invoice value you desire.

It is like adding an fixed discount to an invoice, I do it the same way.


Hope this helps

Avatar
Discard