Hi,
Here is the situation.
Buy and sell company XXX (only trading goods with moving average price).
Goods are purchased from intragroup companies of company xxx from other countries.
Goods come to country of company XXX. 3 PC of material-batch (split valuation batch) is will be custom cleared and 2PC exported. When purchasing there is no information sometimes will goods be imported or sell as export.
GR for 5 PC is posted in SAP when goods arrived - foreign currency (for example) USD is converted to local currency with exchange rate1.
Vendor invoice is posted in system in USD with exchange rate2 and in case of exchange rate differences from GR posting goods is revaluated automatically.
After custom clearance invoice for custom clearance is posted in system for custom clearance quantity (revaluation also occurs but on all quantity on stock not only imported). Now we lost real price of custom cleared materials.
Other part of goods is exported and COGS is 2 pcs * moving average price(local currency) in that moment. This is not correct data. COGS should be 2 pcs * invoiced price in USD * exchange rate on day of export sell.
Did anyone have experience with this kind of process and valuation requirements. How to track cost of material in this case?
Best Regards,
Neno