Possible Errors Screen in the Web Countsheets – Definition of the Below Errors
Error Messages
- No Usage This Week
- Negative Usage
- 0.0%
- Negative percentage amounts
Countsheet Types
The explanations below refer to “weeks” when describing the different types of possible counting errors, which assumes the countsheet type is “Weekly”. But this information applies to Daily and Monthly countsheet types as well; just substitute “day” or “month” for “week”. Likewise, the term “this week” refers to the week (or day or month for Daily or Monthly counts) for which this countsheet is an ENDING count, and “last week” refers to the week (or day or month) before that.
Negative Usage: The item has negative actual usage for this week. The quantity counted on this countsheet is greater than the purchases and transfers indicate it should be. This is usually due to a counting error or missing invoice(s) or transfer between the previous countsheet and this one. You can select the item and see in the bottom grid all the recent “events” for that item (counts and purchases). Or check the Actual Food Cost Detail report for more info.
No Usage This Week: The item had some amount of usage last week, but is currently showing 0 usage for this week. May or may not indicate a counting error.
No Usage Last Week: The item had 0 usage last week, but is currently showing some amount of usage this week. May or may not indicate a counting error.
X.X% (positive percentage): The item’s actual usage quantity (# of CASE or EACH used) is X.X% HIGHER this week than the previous week. If the store used 1.0 cases during the previous week and is currently showing 5.0 cases used during this week, then the item will show up as “500%” usage increase in the possible counting errors, because this week’s usage quantity was 5x higher than the previous week’s. X.X% = (ActualUsageCasesThisWeek – ActualUsageCasesLastWeek) / ActualUsageCasesLastWeek
-X.X% (negative percentage): This is actually using the same formula as the “X.X%” above, but the percentage shows up as a negative because this item had NEGATIVE USAGE last week. This can easily cause confusion, so Development working on fixing/clarifying it.