Skip to Content
avatar image
Former Member

Daily and Monthly sales query

Dear experts,

I am new in using SQL queries. I would like to get a query that will give me;

1. Daily and Monthly sales,

2. Month to Date,

3. Projected v Actual sales by item group and branch

I will appreciate any kind of help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 21, 2017 at 02:23 PM

    Hi,

    Have you tried with standard sales analysis report from SAP B1?

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Nagaraja,

      Yes I have but it could not give me the desired results. I am trying to extract data for use in designing Crystal Dashboard with;

      1. Daily and Monthly sales,

      2. Month to Date,

      3. Projected v Actual sales by item group and branch

      as my KPIs

  • Jun 22, 2017 at 08:04 AM

    Try this query for daily sales,

    SELECT T0.[DocNum], T0.[DocDate], T0.[CardName], T0.[DocTotal] FROM OINV T0 WHERE datediff(day, T0.[DocDate],getdate()) = 0

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded