I am showing some discrepancies in the Inventory Profit margin. The items are showing only their sale value, even though I have both a sales invoice and a purchase Invoice for the same.
Steps I performed are as follows:
- Created an Inventory Item “QNAP”
- Created a Purchase invoice for the item “QNAP”. This is in currency AED.
- This amount is spent from my bank account to pay supplier
- Created a Sales invoice for “QNAP”. This is in USD
- Received Payment in my Bank Account from Customer.
- Now this is where the problem arises: When I check the Inventory Profit margin, only Sale value shows, and not the purchase value - so it shows as 100% margin, while it clearly is not.
If you notice, I am facing same issue with several transactions which are showing up with no purchase value.
Can you please help?