Skip to Content
avatar image
Former Member

SAP B1 QUERY FOR SALES PER MONTH CUSTOMER AND ITEM

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 20, 2017 at 05:01 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 19, 2017 at 08:30 AM

    Hi,

    You can try with the SAP B1 standard report Sales Analysis

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded