Menu Mix Status Summary

This report allows corporate users to monitor Menu Mix files at multiple locations for multiple dates. In particular, this report will identify Location/Date combinations without any Menu Mix files processed and those that require action because of failed, undone, or missing data.

{Franchise Note}: Franchisees can retrieve data for their own locations and franchisors can retrieve data for their own locations.

Report Controls

File Date Range Start/Finish: Select the date range for which to view files; limited to 31 days

Funnel (Filters): Any/All visible columns

Location Filter: Concept, Hierarchy, Market, User Defined Category
Filter for Locations/Dates with: Show All Records, No Menu Mix Files, Failed Files, Undone Files, All Files That Require Action

Printer (Export): PDF, Excel, CSV formats

Report Columns:

Click any column header to sort by the data in that column.

Location Code – Denotes the location code associated with the file(s).
Location (hyperlink) – Denotes the location name associated with the file(s); the link will open a window to display Menu Mix file details.
Menu Mix File Date – The date for which the file was imported.
Successful Files – Total number of successfully imported files. This may include files that were imported or reprocessed.
CDP Imported Files – Total number of files imported via the CDP. This may include files that were successful, reprocessed, failed, or undone.
Last CDP Import Date and Time – The last date and time a file was imported.
Reprocessed Files – The total number of reprocessed files.
Last Reprocess Date and Time – The last date and time a file was reprocessed.
Failed Files – The total number of failed files.
Last Failed Date and Time – The last date and time a file failed to import.
Undone Files – The total number of undone files.
Last Undo Date and Time – The last date and time a file was undone.

Note: The "file count" columns (Successful, CDP Imported, Reprocessed, Failed, and Undone Files) function as status bins for the current status of the files; no individual file can be represented in more than one column at a time. However, a column can shows zero files yet show a date and time stamp for the action. For example, if 2 files were undone and then successfully reprocessed, the screen would show '0' in the Undone Files bin (because they are now in the Reprocessed Files bin), but still show the date and time when the files were last undone.