Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-9958

Sales by Store report calculates Value Sold incorrectly

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Release Branch 13.07, Release Branch 14.12, Trunk, Release Branch 15.12, Release Branch 16.11
    • Fix Version/s: Release Branch 16.11
    • Component/s: order
    • Labels:
      None
    • Flags:
      Patch

      Description

      Sales by Store report calculate Value Sold without taking into account order item quantity. See the first screenshot. It was 2 orders for the same product priced at $10. One order had 1 of the product, second has 2 of the product. Sales by Store report display correct quantity sold 3 and incorrect value sold $20. I guess it should be $30.

      The Second screenshot illustrates result after the patch.

      Patch is tested with trunk and 16.11. This bug exists from the very beginning. Perhaps this is not too valuable report if the issue left unnoticed for so long time. But I have been asked about it twice recently and I think it's time to fix it.

        Attachments

        1. sales_by_store_before.png
          59 kB
          Oleg Andreyev
        2. sales_by_store_after.png
          60 kB
          Oleg Andreyev
        3. report.diff
          3 kB
          Oleg Andreyev

          Activity

            People

            • Assignee:
              jacques.le.roux Jacques Le Roux
              Reporter:
              redcat Oleg Andreyev
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: