Auto-Daily Prep for Sales Depletion
When a Menu Mix file (001 or 267) is imported, the system will do the following for each prep recipe represented in the file. This includes those that are sub-recipe components of depleted POS recipes.
- It will compare the "Sold" quantity to the "On Hand" quantity (both in Inventory Units) and calculate the difference.
- In performing this calculation, the system will consider the "On Hand" quantity in all central storage locations, not just the one associated with Menu Mix depletion.
- If the depletion is for an internal customer (i.e. for a standard Menu Mix file, the "Code" in the file header can also correlate to a customer linked to a storage location, and not a regular customer or the location itself), the system will also consider "On Hand" in that customer's storage location.
- Next, it will automatically create a Daily Prep transaction that includes each prep recipe where the "On Hand" quantity was < the "Sold" quantity, using the difference (in Batch Units) as the "Actual Production" quantity. (Rounding rules will NOT be applied to these quantities, except that anything < .01 will be rounded up to that.)
- Then, it will Finalize this transaction PRIOR to processing the Menu Mix depletion, so that the Issue Cost of each prep recipe is accurate.
Note: The Menu Mix sales date will be used as the Daily Prep date. If Undo Menu Mix is performed for the location/date, all auto-Daily Prep transactions for that location/date will also be "undone".