Hi Susan,

Indeed the Average Unit Cost is not stored on the Item Master file. It is calculated from the Total Cost of the item divided by the Total Quantity on Hand (across all locations). Cost is not stored separately for each location.

You would have to create a custom report (such as with GridView) to sum the costs of all 5 costing lots, and divide by the sum of the quantities of the 5 lots, if you use FIFO or LIFO costing.

If you use another costing method, it is a simpler calculation by simply dividing the cost of lot #1 by the quantity of lot #1.

If you have outstanding invoices in OE that have not been processed by Day End, you may also need to incorporate the 'Quantity Shipped not Costed' value in the above calculations, which will have a non-zero value until Day End is performed.