Skip to Content
avatar image
Former Member

Need sql query which show month wise total sales, exp and Revenue in single report

Hi experts

I Need a query which shows Month Total Sales Inovice, Sales Credit note. Expense , Revenue for each branch,

we had define document number series to each branch,

for eg the report is like this i need

Month Total(AR Inovoice) Total (Cr Memo) Total (Expense) Total (Revenue)

January 2535220 3500 12500 650242

Feb 74545746 54210 54254 6445400

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 26, 2016 at 07:47 PM

    Hi Shams

    Check the below Thread it may help you

    https://archive.sap.com/discussions/thread/3880665

    With Regards

    Balaji Sampath

    Add comment
    10|10000 characters needed characters exceeded