Here is one scenario,
So, we purchase in USD and sell in USD/EUR/GBP etc. For the sake or reporting gross profit and margin in one single currency, LCY ( GBP) how do we do it at line level?
Currently how we do is, Purchase order, receive and invoice items, create sales order, ship and invoice items. The exchange rates have been set up already in the system. In the purchase invoice the Unit Cost (LCY) is correct as per the exchange rate. However, the same is not reflected in the sales invoice. Please see the below dummy invoices for more clarification.
In the sale invoice statistics as below, note that the amount is adjusted for LCY and also the profit %.
The question is, for reporting purposes, what would be the best way to report Gross Profit at invoice line level preferably? How do we make sure that the Unit Cost LCY in purchase invoice at line level is reflected in the sales invoice Unit Cost LCY?
Any help to sort this out is much appreciated.
Many thanks.
