Skip to Content
0

Daily and Monthly sales query

Jun 21, 2017 at 02:11 PM

54

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Nagarajan K Jun 21, 2017 at 02:23 PM
0

Hi,

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

Regards,

Nagarajan

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Nagarajan K Jun 22, 2017 at 08:04 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded