I've only started messing with Micros recently so be kind when you reply to my question(s)!
On the system I'm testing with there is a custom report called "Revenue Center".
I've got Crystal Reports installed (this is a Micros rev. 2.6) and when I open this report and go to log on the server it starts with the user name of Micros. Since I don't know the password for this user (is this a standard user and a password I should know?). I change the user to custom/custom and log on.
So I started by looking at "Show SQL Query" where I find the following:
{call micros.sp_R_cons_rvc_ttls}
I open up Sybase Central and I find that procedure (actually listed 7 times for 7 different "Creators" but they basically all call the Micros creator procedure).
This is quite a detailed procedure and I see from the documentation that this procedure "Consolidates totals for a range
of business days and returns a result set." which makes sense because this is what is used to record daily sales.
The report breaks down the discounts used but when I search the procedure I don't see any reference to the dsvc_def table which holds the discount information. The report has a section that lists all the discounts and amounts and as an example one of the discount names is sp_R_cons_rvc_ttls.ttl_name_15. How would I know that the discounts start with 15? Is that buried somewhere in that procedure that I didn't see?
I added some new discounts (using the POS Configurator) and I can see them in the dsvc_def table but they didn't show up on the report but some other discounts with 0 totals do.
Looks like I'm missing something once again!
On the system I'm testing with there is a custom report called "Revenue Center".
I've got Crystal Reports installed (this is a Micros rev. 2.6) and when I open this report and go to log on the server it starts with the user name of Micros. Since I don't know the password for this user (is this a standard user and a password I should know?). I change the user to custom/custom and log on.
So I started by looking at "Show SQL Query" where I find the following:
{call micros.sp_R_cons_rvc_ttls}
I open up Sybase Central and I find that procedure (actually listed 7 times for 7 different "Creators" but they basically all call the Micros creator procedure).
This is quite a detailed procedure and I see from the documentation that this procedure "Consolidates totals for a range
of business days and returns a result set." which makes sense because this is what is used to record daily sales.
The report breaks down the discounts used but when I search the procedure I don't see any reference to the dsvc_def table which holds the discount information. The report has a section that lists all the discounts and amounts and as an example one of the discount names is sp_R_cons_rvc_ttls.ttl_name_15. How would I know that the discounts start with 15? Is that buried somewhere in that procedure that I didn't see?
I added some new discounts (using the POS Configurator) and I can see them in the dsvc_def table but they didn't show up on the report but some other discounts with 0 totals do.
Looks like I'm missing something once again!