Make sure you back up the database before doing this. It's pretty labor intensive and will bog down the system so don't do it while the system is in use. Last, depending on your sales volume and the pc's speed, this can take some time, so give yourself at least an hour to get it done.
Create a purging autosequence
Open the configurator and go to Reports / Autosequences.
Add an autosquence and call it Purge Historicals.
Close the form and click the Autosequence Steps button.
Find Purge Historicals in the dropdown and click it.
Click the blue plus sign to add a step. Assign Stored Procedure as the Type. Click the Stored Procedure tab and select "101 Purge Historical Totals".
Save and close
Change the purge settings
Now go to the Reports tab, Historical Totals button, Classes tab.
Set the Number Of Days History to 17 (assuming you're doing this on 12/17) for all the classes that have a value in this field. Make sure you write down the original setting so you can change them back when you're done.
On the configurator's main screen go to the System Tab, Restaurant button, Business Settings tab.
Change the Save Batch Records Number of Days to 17.
Again, make sure you write down the original setting.
Purge the data
Open Autosequences and Reports
Go to the Autosequences tab and run the Purge Historicals autosequence.
Run a system detail for Nov. 30 and see if there are still totals. If there are run the autosequence again.
You'll probably have to run this a bunch of time. I know that older 3700 systems were set to only purge 10 days at a time, mainly because pc's back in the day couldn't handle much more than that without freezing for extended periods.
Run a system detail for Nov. 30 and see if there are still totals. If there are run the autosequence again.
If you're comfortable with SQL you can run the following script instead of creating and running the autosequence. It will purge out up to 50 days and then return the oldest date with totals left in the system. Run it a few times if you have to. It also seems to purge a bit faster than going through an autosequence.
Code:
call micros.sp_PurgeHistory();
call micros.sp_PurgeHistory();
call micros.sp_PurgeHistory();
call micros.sp_PurgeHistory();
call micros.sp_PurgeHistory();
select min(business_date) from micros.dly_sys_ttl;
Either way, don't worry about over-purging. Micros will only purge data up the cutoff set in the Historical Totals Class, and will always retain 14 days of check history.
Change everything back
Once you're done, set the Number Of Days History in the Historical Totals Classes and the Save Batch Records in the Business Settings back to what they were when you started. Also, if you created a stored procedure go back to the setup for it and check the Hide On Run Screen box.
