- Days to Average in Setup > Inventory > Inventory > General tab determines how many days back to use to determine your average usage. This value is divided by the Qty on Hand to find how many days are remaining, if consumption continues at the same rate.
- Daily Average Usage (DAU) considers Monday - Friday as business days, and excludes Saturday and Sunday. It then sums all material used in the date range and divides by the days to average. If there is production running on Saturday and Sunday, that will end up inflating the average usage.
- The DAU calculation does not consider holidays, block days, or any other date overrides.
- Version 18.1 Added the ability for users to input a custom DAU value in Inventory Detail Setup, which will override the system-calculated DAU for Days on Hand calculations. The overridden DAU will be displayed in bold and can be removed if no longer needed, while the system DAU will remain updated in the background. (Internal note: feature ticket number is 37589)
- The stored procedure usp_inventoryCalculateDailyAverageUsage in the FVMaster database is used to calculate DAU.
- This procedure is run every time an inventory transaction is made. If an inventory adjustment is made, it takes the total adjustment quantity and negates it, then divides by the number of days. The stored procedure will list the exact calculation steps.
How is Daily Average Usage (DAU) Calculated?
