Revenue Report

[Former Member]

Experts,

I am in dire need of some assistance on how to create a "Revenue" report for a specific year. Can anyone give me a hand in telling me how or where to start? The finance manager wants to be able to just enter a year and then see the revenue for it (with details).

Please, any help would be greatly appreciated

[Former Member · Accepted solution]

Check this first:

[Former Member · Accepted solution]

Gordon,

That is close, but is it possible to show the project number?

[Former Member · Accepted solution]

Yes. You just need to add T1.Project to the query.

[Former Member]

Hi,

The Sales Analysis report should be able to meet the need for this. What are missing from the report?

Thanks,

Gordon

[Former Member]

i need it in a sql query that we can run separate of sap... we have to add some items from sap add on "Project management" so getting it into sql allows us to do that.

I was hoping someone may have built a query for this already.....