This report will be run in the MealTime dashboard. afterwards, you will need to make a few small edits to the file before submitting in iNHdex
1.Login to MealTime and go to Point of Sale
2. Go to Customers and then Customer Export - Execute
3. Highlight the State FR Report on the left. Then press Export
4. When the report is ready click on the date of the report and then the Download button
5. Open the excel file you just downloaded. You need to delete the heading names. Select the top row with the column names. Right click and choose delete.
6. Now you need to create a new column. It needs to be between the first and second columns. Select the second column then right click and choose insert.
7. You need to enter the number '342' in this column. Enter 342 in the first cell and then drag to the bottom of the page to have it repeated in each cell.
8. The date format needs to be fixed to add leading zeros when necessary. Select the date column then right click and choose format cells.
9. On the following window select custom on the left. Then on the right side enter mm/dd/yyyy. Press ok and all of the dates should be adjusted.
10. Save the file. It is now ready to run in iNHdex