Product Administration Daily Average Inventory Calculation Report overview
Function acronym: ICAAA
Use this report to perform a daily calculation of average inventory value.
The Product Administration ABC Inventory Evaluation Report and Classification Report requires an accurate average inventory value to calculate the gross margin return on investment (GMROI).
If you run this function daily, the average inventory value for a warehouse product is a blended average of the product value for the entire month.
If you specify a range of vendors, they are validated against the ARP vendors in Product Warehouse Product Setup before a product is processed. The average inventory value updates usage for the warehouse product, based on the number of days since the previous run.