Exporting Average Cost
Hello, is it an option to export the Inventory "Average Cost" thanks.
Forum Discussion
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.
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
