Skip to Content

Creating Report of SAP Business One

Good Day Experts,

How can I get Sale report total in a Month and per customer, Example.


C.Code     Item1     Item2     Item3

Cus1     20kg     10kg     30kg

Cus2     20kg     10kg     30kg



Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 21, 2015 at 03:43 AM

    Hi,

    Check this link

    Dynamic Pivot Query

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2015 at 03:24 AM

    How many items do u have?

    If it is not too many, u can use CTE to get sum result, and then pivot the result to achieve this.

    Frank

    Add comment
    10|10000 characters needed characters exceeded