Micros 3700 Sales Data

jjhowell · Dec 16, 2009

I'm trying to clear out all the sales data from a Micros 3700 environment. I can run reports on everything, but I'd like to remove all sales data starting at the end November 2009 so all I have left going forward is December 2009 and beyond.

Is there an easy way to purge all that data? I've looked through all the manuals and Micros support was no help. Thanks in advance!

pmegan · Dec 16, 2009

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.

jjhowell · Dec 16, 2009

Thanks so much. I'll give this a shot tonight.

jjhowell · Dec 17, 2009

Thanks! This seems to have worked.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Micros 3700 Sales Data

jjhowell

Technical User

pmegan

Programmer

jjhowell

Technical User

jjhowell

Technical User

Similar threads

Part and Inventory Search

Sponsor