Micros 3700 - Database help - list of all guest checks

[serendipitytech]

I'm preparing for a sales tax audit, and I'm trying to get a list of all the guest checks for certain days. I don't know what table they would be in. I had to reset the database, so I'm working from a restored database backup from before I reset it.

I'm trying to find in Sybase Central, what table can I look at that will list all the guest checks. I look at some of the tables, and all it seems to have is the most current month, where would the history be from last year?

 

[pmegan]

Micros only holds check specific detail for 14 days. To keep it longer than that you'll need to get MyMicros or a third party reporting tool like Avero. You can also add on transaction analyzer and set a long retention time but I wouldn't recommend it. Transaction level detail takes up a lot of space and your database will get bloated.

That said, your posted sales, employee and tax totals should be held for at least a year. You should have consolidated system, rvc and tax reports already in your system. Most are set up to hold a little over a year's worth of totals, so you'll probably be able to go back to about the first week of May 2011. You can run

select min(business_date) from micros.dly_sys_ttl

to get the oldest date with totals.