Dear All,
How does the BC calculate the average unit cost of a inventory item?
In the Item card, when we go to Unit Cost. It will reflect the average unit cost. When we click in, we can see a list of cost movement.

based on the above, how does the system calculate the Average cost and shown in the closing entry?
on 27 March, we make a purchase with a lower purchase price, and it bring down the average cost to be 941.77.
in 9 April, we make a sell. However the system picked the unit cost 980.79 as the cost for this sales order. Why system does not use 941.77? How does the system decide which cost to use?
starting from this entry, the average cost all went wrong
How do we correct this issues?
we can see on 29 June, the closing quantity is 0, but we have a cost amount of - 785.28