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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Micros 3700 manager dashboard not updating sales/discounts 1
- Thread starter Karliio
- Start date
-
1
- #2
Hi,
You havent set up the autosequences to post the totals!!
Read the Help file and it tells you:
Step
Procedure
1 Open the POS Configurator and select Reporting | Schedule Classes.
2 Add (or update) a scheduling class to satisfy each of the following criteria:
Sales Totals Posting
Schedule Date Type — Daily
Repeat Period — 1-minute intervals
Labor Totals Posting
Schedule Date Type — Daily
Repeat Period — 15-minute intervals
3 Click to save. Close the form and select Autosequences.
4 Create two autosequence records programmed as follows:
Dashboard Sales — From the Schedule Class drop-down list, link to the Sales Totals Posting class, described in Step 2.
Dashboard Labor — From the Schedule Class drop-down list, link to the Labor Totals Posting class, described in Step 2.
5 Click to save. Close the form and select Autosequence Steps.
6 From the Select an Autosequence drop-down list, select Dashboard Sales (defined Step 4)
7 Go to the Stored Proc tab and add the following steps to this autosequence:
124 Time Period Sales
130 System Sales and Tracking
115 Employee Sales
157 Load Dashboard Totals Information
8 Click to save.
9 From the Select an Autosequence drop-down list, select Dashboard Labor (defined Step 4)
10 Go to the Stored Proc tab and add the following steps to this autosequence:
133 Time Card Totals
142 Post Time Period Labor Totals
132 Job Code Totals
11 Click to save.
Summary
The following table summarizes the selections required to configure totals posting for the Dashboard:
Totals
Frequency
Kitchen/Speed of Service Panel
POS Configurator | Kitchen | Posting
Post Interval = 1 minute
Labor Panel Autosequence Steps | Stored Proc
133 -- Time Card Totals
142 -- Post Time Period Totals
132 -- Job Code Totals
Every 15 minutes
Sales / Employee Panels
Autosequence Steps | Stored Proc
124 -- Time Period Sales
130 -- System Sales and Tracking
115 -- Employee Sales
157 -- Load Dashboard Totals Information
Every 1 minute
You havent set up the autosequences to post the totals!!
Read the Help file and it tells you:
Step
Procedure
1 Open the POS Configurator and select Reporting | Schedule Classes.
2 Add (or update) a scheduling class to satisfy each of the following criteria:
Sales Totals Posting
Schedule Date Type — Daily
Repeat Period — 1-minute intervals
Labor Totals Posting
Schedule Date Type — Daily
Repeat Period — 15-minute intervals
3 Click to save. Close the form and select Autosequences.
4 Create two autosequence records programmed as follows:
Dashboard Sales — From the Schedule Class drop-down list, link to the Sales Totals Posting class, described in Step 2.
Dashboard Labor — From the Schedule Class drop-down list, link to the Labor Totals Posting class, described in Step 2.
5 Click to save. Close the form and select Autosequence Steps.
6 From the Select an Autosequence drop-down list, select Dashboard Sales (defined Step 4)
7 Go to the Stored Proc tab and add the following steps to this autosequence:
124 Time Period Sales
130 System Sales and Tracking
115 Employee Sales
157 Load Dashboard Totals Information
8 Click to save.
9 From the Select an Autosequence drop-down list, select Dashboard Labor (defined Step 4)
10 Go to the Stored Proc tab and add the following steps to this autosequence:
133 Time Card Totals
142 Post Time Period Labor Totals
132 Job Code Totals
11 Click to save.
Summary
The following table summarizes the selections required to configure totals posting for the Dashboard:
Totals
Frequency
Kitchen/Speed of Service Panel
POS Configurator | Kitchen | Posting
Post Interval = 1 minute
Labor Panel Autosequence Steps | Stored Proc
133 -- Time Card Totals
142 -- Post Time Period Totals
132 -- Job Code Totals
Every 15 minutes
Sales / Employee Panels
Autosequence Steps | Stored Proc
124 -- Time Period Sales
130 -- System Sales and Tracking
115 -- Employee Sales
157 -- Load Dashboard Totals Information
Every 1 minute
- Thread starter
- #3
Hello,
Thanks for Replying
It seems that the autosequences are already existing (#14) however it looks like at midnight it stops working.
(we run a night club)
I took a look at the Scheduled Classes but there is nothing that references to midnight,
You can see here:
#1 is scheduled at 4-am
#2 start: 6:45AM END: 6:48
#3 Days In week - 6AM
#4 thru #10 is at 7:30 AM
#12 Days In week Start: 6:15AM END: 6:30AM
I opened the Autosequence Steps and did a search for "dash" and found two things. #10407 & #40011
In #10407 (POST DASHBOARD TOTALS)
There are several steps (all skip steps false)
and the type is 'Stored Procedure'
#5 - 117 Post Employee Job Code Totals
#6 - 118 Post Serving Period Totals
#7 - 119 Post Serving Period Sales & Tracking
#8 - 120 Post Family Group Sales
#9 - 121 Post Major Group Sales
#10 - 122 Post Menu Item Group Sales
#11 - 123 Post menu Item Sales
#12 - 124 Post Time Period Sales
#13 - 125 Post RVC Time Prd Sales & Tracking
and it also posts:
126 to 133
137 to 140
131,132,133,
137 to 140,
142,150,157,116
** On Stored Procedure 151 Post Sales Export this is entered: Parameter: Business Date parameter
Source: Numeric
#40011 (Dashboard Display Sales)
There are only two steps:
#1 - Stored Procedure: 157 Load Dashboard Totals Information
#2 - [Ranges]
Date Range Source: Inherit
Shift Range Source: Inherit
RVC Range Source: Inherit
Date Range Selection: (Empty)
Thanks for Replying
It seems that the autosequences are already existing (#14) however it looks like at midnight it stops working.
(we run a night club)
I took a look at the Scheduled Classes but there is nothing that references to midnight,
You can see here:
#1 is scheduled at 4-am
#2 start: 6:45AM END: 6:48
#3 Days In week - 6AM
#4 thru #10 is at 7:30 AM
#12 Days In week Start: 6:15AM END: 6:30AM
I opened the Autosequence Steps and did a search for "dash" and found two things. #10407 & #40011
In #10407 (POST DASHBOARD TOTALS)
There are several steps (all skip steps false)
and the type is 'Stored Procedure'
#5 - 117 Post Employee Job Code Totals
#6 - 118 Post Serving Period Totals
#7 - 119 Post Serving Period Sales & Tracking
#8 - 120 Post Family Group Sales
#9 - 121 Post Major Group Sales
#10 - 122 Post Menu Item Group Sales
#11 - 123 Post menu Item Sales
#12 - 124 Post Time Period Sales
#13 - 125 Post RVC Time Prd Sales & Tracking
and it also posts:
126 to 133
137 to 140
131,132,133,
137 to 140,
142,150,157,116
** On Stored Procedure 151 Post Sales Export this is entered: Parameter: Business Date parameter
Source: Numeric
#40011 (Dashboard Display Sales)
There are only two steps:
#1 - Stored Procedure: 157 Load Dashboard Totals Information
#2 - [Ranges]
Date Range Source: Inherit
Shift Range Source: Inherit
RVC Range Source: Inherit
Date Range Selection: (Empty)
Hi,
Really you should look at the help file. Search DASHBOARD
You will see that you create a schedule to start say 4 am and make it repeat every 1 minute.
Create the autosequence for sales-Post Dashboard Sales and then add the following ASeq Steps (Stored Procedures):
124 Time Period Sales
130 System Sales & tracking
115 Employee Sales
157 Load Dashboard Totals Information
Make sure you reload the database after modifying or adding Auosequences (SchedulerStatus.exe will show your the status and values are loaded from DB at bootup \ reloading DB)
Really you should look at the help file. Search DASHBOARD
You will see that you create a schedule to start say 4 am and make it repeat every 1 minute.
Create the autosequence for sales-Post Dashboard Sales and then add the following ASeq Steps (Stored Procedures):
124 Time Period Sales
130 System Sales & tracking
115 Employee Sales
157 Load Dashboard Totals Information
Make sure you reload the database after modifying or adding Auosequences (SchedulerStatus.exe will show your the status and values are loaded from DB at bootup \ reloading DB)
- Thread starter
- #5
What autosequence runs @ midnight? I have done this at a lot of sites & no problems. Read the log & see what was happening when it froze.
Honestly, go to the Help screen, enter Dashboard, it is probably the only part of Help that is easy to understand
Honestly, go to the Help screen, enter Dashboard, it is probably the only part of Help that is easy to understand
- Thread starter
- #7
- Status