Skip to Content
author's profile photo Former Member
Former Member

Sales Analysis report in XLR

SAP XLR Sales per Customer by Item report that published in the portal doesn't include document discount. This is a reason for the differences between XLR and B1 sales analysis report.

How can I calculate discount from the document in XLR when the report is run by invoice/credit memo lines.

Edited by: Philip Eller on May 16, 2008 8:56 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2008 at 04:47 AM

    Hi Olga,

    I have done this in the past by using calculations based on Doc Total less Tax, and comparing to sum of lines.

    It depends what data you need to report.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 02, 2008 at 01:58 PM

    I know the calculation that should be done, but how can I run it in XLR. When I use in row lines directly all the information from the header will be 0. How can I run SQL query or connect the tables in XLR?

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello,

      In XLR Composer> Sales tab, if you want to design a report group by document number, then choose the Document Number light dimension first,then "discount% per document", choose item/quantity/row total and so on for row level information. This will give you the result instead of 0.

      If you want to run the report group by items. The same way you can do but the only difference is choose the item Dimension first, then you can also drag document level ,Document number for example.

      Header and row levels table can be connected and use together if there is the relationship between them.

      Choose discount % per document and then use calculation to calculate the discount amount of a document.

      Hope this helps.

      Regards,

      Maggie An

      SAP Business One Forum Team

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.