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

Dear Michael

Thank you for your information, i also try to make the quick report, but have no idea of the technical name of the following items, do you familiar with them? REVENUE, COST, MARGIN

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 Michael

now I got it, I will play around in the system, thank you for your in time help.

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

Looking forward to lear from you!
CU
Michael

Dear Sherry,

The revenue should be in your General Ledger. What is it that makes you want to go elsewhere?

Sincerely

Jonas