SAP B1 QUERY FOR SALES PER MONTH CUSTOMER AND ITEM

[Former Member]

Hi Guys,

Can anyone help me on this I want to generate a query that can make sales per month like this

Customer Name ! Customer Group ! Item Code ! Item Name!Description ! UoM ! jan ! Feb ! march ! April ! May ! June ! July ! Aug ! Sep ! Oct ! Nov ! Dec

coming from your AR Invoice?

Is this posible?

[KennedyT21 · Accepted solution]

Hi ,

You can try the standard report in SAP B1.

There are multiple post available here in the same topic..

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

Rgds,

[former_member312729]

Hi,

You can try with the SAP B1 standard report Sales Analysis

Regards:

Balaji.S

[Former Member]

yes but my client doesn't want that report.