The Run-a-Restaurant Query Tool generates custom queries and reports. In this post we go through the ach period.
The Query Tool can be found in the main menu of Run-a-Restaurant.
Start by creating a new report and adding the following columns:
- stock_items > title
- periods > end_date
- stock_items > count_qty
- units_count > symbol
- close_counts > close_count
Add a “Query Condition”, select the “stock_items > title” field and enter the name of the Stock Item.
Note: if you have multiple Sites you should add a condition to specify the Site.
To run the report, click on the “Update Result” button.
When you’re happy with your report, enter a title and description and click the “Save” button.
Easily turn your report into a useful chart by clicking the “Export to Excel” button and creating your chart in Excel.