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?