How can I edit information or clear range in Micros Res 3700?

[Random92]

Hi,

I'm a moderate level programmer. For my business we have been using Micros 3700 for a few years. When creating reports, I can only go back a certain time, however, the reports show the full financial totals from beginning to end. How can this figure be changed to display totals for a given range? Can I chop off a range of dates from the database and have all numbers making sense?

also along with clearing a certain range of previous time data in the database, can I change values in the database? How complicated is the database? Thank you so much

 

[safinramil]

HI, did you mean this

http://prntscr.com/ebj1mn

?

 

[Random92]

Thanks!

However, clearing a range doesn't affect the Grand total figure in reports. For our business, previous data from before the range we have cleared as far as sales data is from another owner. So from our range onwards, I would like to have the grand total only reflect that range.

How can we change the Grand total figure? Modify it in database?? Thanks

 

[Moregelen]

In Reporting, you will find a section called Historical Totals. This is where you set how much data to maintain. Because this is a locally running SQL server on a system with limited resources, Micros is configured to purge data based on these settings. Typically, full transaction information is only stored for two weeks, and the top level summary information you can see is stored for 365 days or more. You can adjust this, but keep in mind that your database will start inflating (and slowing down) pretty quickly. I would suggest that instead you start a process to offload the data somewhere else if you can manage, that way you don't potentially impact the system running the restaurant.