cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Montly Sales Analysis Report ,Total by customer

Former Member

on ‎09-11-2014 1:11 PM

0 Kudos

Hi,

I need help on a query that a customer needs for a sales analysis report.

It should also contain:

Parameters from date X to Y and Warehouse  Z

Columns should be as follows

#Item No.Item DescriptionCustomer CodeCustomer NameCityAnnual TotalApril  (2014) - QuantityApril  (2014) - Sales AmountApril  (2014) - Gross ProfitApril  (2014) - Gross Profit %May  (2014) - QuantityMay  (2014) - Sales AmountMay  (2014) - Gross ProfitMay  (2014) - Gross Profit %June  (2014) - QuantityJune  (2014) - Sales AmountJune  (2014) - Gross ProfitJune  (2014) - Gross Profit %July  (2014) - QuantityJuly  (2014) - Sales AmountJuly  (2014) - Gross ProfitJuly  (2014) - Gross Profit %August  (2014) - QuantityAugust  (2014) - Sales AmountAugust  (2014) - Gross ProfitAugust  (2014) - Gross Profit %September  (2014) - QuantitySeptember  (2014) - Sales AmountSeptember  (2014) - Gross ProfitSeptember  (2014) - Gross Profit %

This report we can take from  sap business one sales analysis report but customer asking city column.that why

Please send me query ASAP.

Regards,

Rajeev.

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

kothandaraman_nagarajan
Active Contributor
‎09-12-2014 1:00 AM
0 Kudos

Hi,

Did you check B1 standard sales analysis report under sales reports?

Thanks & Regards,

Nagarajan

Show replies
Show replies
Former Member
‎09-12-2014 5:15 AM
0 Kudos

Hi Nagarajan,

Yes i checked standard report in sap business one,

But customer asking city column to that report ,

If possible send me a query basic on Itemise sales analysis report ,total by customer.

Needed columns :

#Item No.Item DescriptionCustomer CodeCustomer NameCityAnnual TotalApril  (2014) - QuantityApril  (2014) - Sales AmountApril  (2014) - Gross ProfitApril  (2014) - Gross Profit %May  (2014) - QuantityMay  (2014) - Sales AmountMay  (2014) - Gross ProfitMay  (2014) - Gross Profit %June  (2014) - QuantityJune  (2014) - Sales AmountJune  (2014) - Gross ProfitJune  (2014) - Gross Profit %July  (2014) - QuantityJuly  (2014) - Sales AmountJuly  (2014) - Gross ProfitJuly  (2014) - Gross Profit %August  (2014) - QuantityAugust  (2014) - Sales AmountAugust  (2014) - Gross ProfitAugust  (2014) - Gross Profit %September  (2014) - QuantitySeptember  (2014) - Sales

Please help me ASAP,

Regards,

Rajeev.

kothandaraman_nagarajan
Active Contributor
‎09-15-2014 8:22 AM
0 Kudos

Hi,

Yes possible to get those information. But need to spend some time to create a such query. Let me try and update once ready.

Thanks & Regards,

Nagarajan


Former Member
‎09-16-2014 5:27 AM
0 Kudos

Hi Nagarajan,

Ok thank you lot,

Please update ASAP.

Regards,

Rajeev

Former Member
‎09-11-2014 1:54 PM
0 Kudos

Hi,

try below query

SELECT T1.[ItemCode], T1.[Dscription],sum(T1.[Quantity]) Quantiry,  T0.[CardCode], T0.[CardName],T1.[WhsCode],  max(T3.[City])City FROM OINV T0  INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OCRD T2 ON T0.CardCode = T2.CardCode INNER JOIN CRD1 T3 ON T2.CardCode = T3.CardCode WHERE T0.[DocDate] between [%0] and [%1] and  T1.[WhsCode] =[%2] GROUP BY T1.[ItemCode], T1.[Dscription],T0.[CardCode], T0.[CardName], T1.[WhsCode]

regards,

Raviraj

Show replies
Show replies
Former Member
‎09-11-2014 2:11 PM
0 Kudos

Dear Raviraj,

I need coloums like follows:

#Item No.Item DescriptionCustomer CodeCustomer NameCityAnnual TotalApril  (2014) - QuantityApril  (2014) - Sales AmountApril  (2014) - Gross ProfitApril  (2014) - Gross Profit %May  (2014) - QuantityMay  (2014) - Sales AmountMay  (2014) - Gross ProfitMay  (2014) - Gross Profit %June  (2014) - QuantityJune  (2014) - Sales AmountJune  (2014) - Gross ProfitJune  (2014) - Gross Profit %July  (2014) - QuantityJuly  (2014) - Sales AmountJuly  (2014) - Gross ProfitJuly  (2014) - Gross Profit %August  (2014) - QuantityAugust  (2014) - Sales AmountAugust  (2014) - Gross ProfitAugust  (2014) - Gross Profit %September  (2014) - QuantitySeptember  (2014) - Sales AmountSeptember  (2014) - Gross ProfitSeptember  (2014) - Gross Profit %

Please send me query ASAP.

Regards,

Rajeev

Ask a Question