Hi,
We have a situation for a trading client.
For example, we do the product purchase(Product A) with the unit cost of 10 with total quantity 10. They haven't received the landed cost bills at the time of purchase and usually that takes one month delay after the receipt.
Inventory valuation, 10*10 = 100
Product Cost = 10
Now they are doing a sales/delivery of 2 quantities from the stock without entering the Landed Cost.
So, inventory valuation becomes, 8*10 = 80
Product Cost = 10
After the sales, they are getting Landed cost bills and they are entering in to the ERP. For example 100 is the LC.
Inventory valuation, (8*10) + 100 = 180
Product Cost, 180/8 = 22.5 (This supposed to be 20, if we were entering the LC along with Purchase)
The above scenario makes an issue for the profit, current cost calculation on the products level.
How can we solve this?