how to mass download the service contract revenue?

Hi Sherry,

in this case I would always recommend a QR or a BI report.
Perhaps your colleages not only want to know the revenue of “all” SC but for a given month.

Compared with another month (last year).
Use filters, like SC-”items”, employees doing the service, etc.
Also they perhaps would like to see a “deviation analysis”?

So the question there is: When looking into quantity, price and product - mix.
What is the percentage of “influence” into a given deviation (e.g. two months in a row or given month compared to same month last year).

You see: tons of questions you may ask to get more insight in your data.

All the best to you and a nice last “pre” christmas week,

Michael

Hi Sherry,

hmmm, I did a QR for service contracts some years ago and will do a quick research into the old scripts.
What system you are on, cloud or on premise?
Are you familiar with the Debug - Console (in the on prem solution)?
To start it, you just Shift-Ctrl-D.
If you can start the debugger, and than do the “Analysis” the system will show you exactly what kind
of SQL it is performing.

Unfortunately my “main” customer don’t work with service contracts and so there a no data in their system. :-(

But you can see the ORACLE View SC_SERVICE_CONTRACT in the debug and the system info:
 

Did you ever used the “System Info”?

Looks like the following screenshot and also gives a lot of useful information about the structures below your masks.
 

Hope that helps a little bit.

All the best

Michael

Dear Sherry,
what do you got. I’ veeeerrrry curious! :-)

Looking forward to lear from you!
CU
Michael