Dear Ms. Madeline
I believe the "Actual" cost your looking for highly depends on the valuation method of your inventory. Let me give you a further explanation on this issue;
Suppose you have increased your inventory balance of Item (A) through several receipts, those receipts might have different cost. As follows;
(IV10200 | Purchase Receipts)
Document_Date Item Document_Number Quantity_Received Unit_Cost Ext_Cost
1/1/2013 A RCV00000000001 100 5 500
1/2/2013 A RCV00000000002 50 5 250
1/3/2013 A RCV00000000003 10 6 60
1/4/2013 A RCV00000000004 20 6 120
1/5/2013 A RCV00000000005 100 7 700
Now, If you were asked to deliver the same report including Item, unit cost, You need to determine exactly what is it that you are looking to include in your report.
In this case, the current cost will differ according to the valuation method of your inventory.
The current cost will be updated after every increase transaction posted for the item (A), and therefore, the current cost for the item above is the last receipt cost which is (7).
Unless the item is valued using an average valuation method, the current cost will be the average cost of all the receipts transactions [ Sum(Extended Cost) / Sum(Quantity Received) ] , and the current cost is (5.82). Therefore, In the case of average valuation method, the current cost will be updated after every increase transaction.
Note:
You can check the valuation method of the item from: Cards > Inventory > Item > Valuation Method.
