The issue I am facing is that when I sell a quantity of sugar, the cost price of the quantity sold is not being recorded under “Inventory - Cost.”
For example, if I sell 10 bags at $40 per bag, the total sales amount is $400. If the cost price is $37 per bag, the total cost should be $370.
I need the system to automatically record the $370 under “Inventory - Cost” and deduct it from the $400 sales revenue, so that the $30 gross profit is correctly shown.