Exporting Average Cost

Hi Atlasstainless 

For the current average cost of stock on hand you could generate an Inventory Value Reconciliation report, send to Excel and divide the Value column by the On hand column - this should give you the same figure you see on the Item Profile.

Regards

Gavin

Hi Atlasstainless 

The only way that I can think you could export that information is to run the Price Analysis report (Reports>>Inventory>>Pricing -- Price Analysis). This report shows the Cost Basis which can be set to be the Average Cost (using the Refinements). You would then be able to export that out to Excel.

Although, interesting to see if other users in the Community have another method.