Daily and Monthly sales query

[Former Member]

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

[kothandaraman_nagarajan]

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

[kothandaraman_nagarajan]

Hi,

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

Regards,

Nagarajan

[former_member467290]

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