INACCURATE PROFIT AND MARGIN REPORT

Hello,

I found the Profit & Margin Report to be inaccurate as it has issues with the Cost Price. Let's say, we are looking for profit and margin report for a product X.

Firstly, We ordered 100 pcs (quantity) of product X with a cost price of $50. This creates a total cost of product X to be $5000 which is fine. Suppose I sold 80 pcs (quantity) of product X and now only 20 pcs (quantity) are left.

The actual individual cost of each of the 20 pcs of product X is $50. Now, If I reorder the stock and I order 30 pcs with an increased cost price of $80 this time. Then, My total stock for product X is going to be 50 pcs with the system assuming the total cost of product X to be $4000 which is not accurate. As 20 pcs of product X had a cost price of $50 dollars earlier. Actual cost of the total 50 pcs should have been $3400 (20 x $50 + 30 x $80) as the remaining 20 pcs didn't cost me an extra $30 each.

If I sell 5 pcs again, The new cost price for each item will be $80. The remaining 20 pcs will have an extra $30 cost in profit & margin report if sold. So, It messes up with the profit amount.

When entire of the original 100 pcs stock with the cost price of $50 get sold with $50 cost then only the system should start to calculate the value of goods with the new cost price of $80. This will ensure a completely accurate profit amount.

I would appreciate it if you could provide a solution as soon as possible. Thanks for your time !