The ordering Macro can be used for helping to determine the amount of stock to order to cover a two month period.
Identifying suppliers to order from
1. In RSA go to Manage > File > Export and Select PLU by Department - enter in Craft Beer as the department
2. Export this to Dropbox\Beer Cartel\Ordering\Stock Ordering Macro\MONTH\DATE
3. Open the Ordering Macro in Excel (not via Google Sheets) located in Dropbox\Beer Cartel\Ordering\Stock Ordering Macro and attached below
4. Click Enable Editing
5. On the upload page click the Data tab in the menu bar and click Refresh All. Find the folder where you just saved the export file at 2.
6. Select All Files rather than Text Files, find the PLUbyDept file and click Import
7. On the Order tab sort by SOH (Smallest to Largest) and enter in 0 for all cells that currently have 0 stock listed.
8. Then sort on the Order Cases column (Smallest to Largest) - scroll down to those cells highlighted in red. The number listed in these is the recommended stock to order.
9. Make a note of individual suppliers that need to be ordered from.
Looking at an individual supplier
1. In RSA go to Manage > File > Export and Select PLU by Supplier - enter in the supplier identified in earlier process e.g. Phoenix
2. Export this to Dropbox\Beer Cartel\Ordering\Stock Ordering Macro\MONTH\DATE - label this with the supplier name.
3. Open the Ordering Macro in Excel (not via Google Sheets) located in Dropbox\Beer Cartel\Ordering\Stock Ordering Macro and attached below
4. Click Enable Editing
5. On the upload page click the Data tab in the menu bar and click Refresh All. Find the folder where you just saved the export file at 2.
6. Select All Files rather than Text Files, find the supplier file and click Import
7. On the Order tab sort by SOH (Smallest to Largest) and enter in 0 for all cells that currently have 0 stock listed.
8. Then sort on the Long Desc column (A to Z) - this will allow you to determine all stock to be order from that supplier in alphabetical format.