Help

0

How to calculate the cost of the goods according to the amount of payments (prepayments)?

Avatar
Alexandra

Hello colleagues,

Our customer usually prepays for goods, as per Payment Terms. But, !important! goods can be paid by several prepayments and by the time the goods are received, they are already 100% paid for. Customer works with different countries and different currencies and wants to calculate the cost of the goods according to the amount of payments (prepayments) he has made for the goods + Landed Costs and use the exchange rate from the date, when payments have been done, - not according to the exchange rate when the goods are received. Customer uses AVCO to determine the cost of the goods. We understand that this flow does not exactly correspond to AVCO, but at the same time we understand the customer, because he gets the wrong cost of the goods in this way.

BTW: I'm attaching a screenshot to make it easier to understand visually.

https://drive.google.com/file/d/1Dmnpcs9fBDLKExU7RWJb6ik3zagf_ERB/view?usp=sharing


What are your thoughts on this? 


Avatar
Discard
1 Answer
0
Avatar
Ray Carnes (ray)
Best Answer

If you want to modify the value of inventory, you can do this manually (as many times as you need to) via revaluation. See https://www.odoo.com/forum/help-1/how-do-i-revalue-my-inventory-write-off-mark-down-185340

Avatar
Discard