I'm trying to give our company president a simple report - current inventory, and number of turns. To figure out how long our current inventory should last, I need to look at the previous sales rate.
It would seem that the sales/week should be idea for this, and I can even add it as a column to an inventory valuation summary report.
But I can't figure out how it's being calculated. Because it doesn't appear to be coming anywhere close to "units sold" / "weeks in selected period" like I would expect. For example, an item that we sold 49 of last year (and none so far this year) will show 4.3 sales per week if the report is set to "last fiscal year", 74.7 if set to "this month to date", 50.8 if set to "this month", and 1,568 if set to today's date.
Is there a way to make sense of the sales/week entry, or, even better, a simple way to get "units invoiced" for a given time period?