Micros menu item sold per employee per month 2

[blaatz]

Hello all,

We just got a new F&B Manager and he wants to run a contest to see which employee can sell the most deserts in one month. Could some please help me write the query or even point me in the right direction to the tables i will need? I am running Micros 3700.

Thanks in advance,
Brian

 

[jd11111]

what version are you on?

 

[blaatz]

Micros 3700 Version 4.0 Build 418 Service pack 14.

Is that what you are looking for?

Thanks!

 

[pmegan]

The easiest way would be to add the major, family or menu item group for desserts to employee tracking. Once that's done you can write a report to pull the employee names and sum up that tracking total.

 

[jd11111]

You could also use Transaction Analyzer and save a simple dessert report that you could run at any time. If you don't already have the mneu items in a separate family group, you would have to manually select each menu item. This might be easier than writing a report.

 

[blaatz]

JD11111: The transaction Analyzer almost works, it was not listing the names of the employees, so I would have to run it once for each employee, unless I am missing something.

Pmegan: Where do I add the item to employee tracking?

Thanks!

 

[blaatz]

JD11111: I figured it out, thank you very much for your help!

 

[pmegan]

Blaatz, make sure the totals in T/A go back far enough to get the reports you want. If I remember correctly Micros didn't introduce detail archiving until version 4.1 so your data may only go back 14 days. You'll have to run the report weekly and add the totals to get monthly summaries, (or put them in a spreadsheet and let it do the math).

Generally I don't use T/A much for totals because you have to weed through all the individual sales to get to the employee summary. With a crystal reports template you can suppress the details and just get the relevant info.

Even in 4.1 the archiving has it's drawbacks, mainly database size. Our restaurants all archive for 90 days and all of the databases are over 600M, with the 3 busiest stores creeping up on 1G.