Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-20989

Understated purchase quantities in Inventory Activity Report

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2022R2
    • Fix Version/s: CFA 2021R5
    • Component/s: Reports
    • Labels:
      None
    • VTask #:
      VTASK0492346, VTASK0492345, VTASK0492344
    • Root cause - Reason:
      Code defect
    • Root Cause:
      Hide
      when getting the entity item DSB last business day record we should look for tbEntityItemDailyStockBalance table only. so removing transaction stock count location join because including this join was causing DSB not to be calculated for days for an item. and also we are only looking for only active items..
      Show
      when getting the entity item DSB last business day record we should look for tbEntityItemDailyStockBalance table only. so removing transaction stock count location join because including this join was causing DSB not to be calculated for days for an item. and also we are only looking for only active items..

      Description

      Description

      CFA reports everyday 1 or more tickets where the IAR report has less purchases than expected.

      to fix this issue we have to set the dates for Daily Stock Balance to the previous month to recalculate and get the updated quantity in the IAR report

      Example Store: 04371 - Blue Ash FSU

      CFA reported the issue where items purchase quantities are not correct (Ex, Waffle Fries)

      Then we run the following and run the Daily Stock Balance task in server manager

      When we run the report again the number are corrected as shown below 

      Environment : PROD
      Store : Example 04371
       Steps
      1. Open the IAR page in MXC
      2. Start Count : Monthly 4/30 and End Count : Monthly 5/31
      3. Generate Report

      Results ;  Purchase Qty less than expected

      We would like to know why this issue is occurring almost everyday.

      Next time this issue will occur I will update this ticket with the info needed and will not fix the issue immediately until you look at the ticket.  

       

        Attachments

        1. image-2022-06-10-14-40-46-963.png
          52 kB
          Wesam El-Gendy
        2. image-2022-06-10-14-43-14-034.png
          228 kB
          Wesam El-Gendy
        3. image-2022-06-10-14-45-49-305.png
          126 kB
          Wesam El-Gendy
        4. image-2022-06-13-16-31-24-456.png
          1.25 MB
          Wesam El-Gendy
        5. image-2022-06-13-16-33-33-398.png
          1.25 MB
          Wesam El-Gendy
        6. image-2022-06-21-10-58-17-899.png
          275 kB
          Wesam El-Gendy
        7. image-2022-06-21-11-51-05-201.png
          72 kB
          Wesam El-Gendy
        8. image-2022-06-30-12-14-26-767.png
          68 kB
          Wesam El-Gendy
        9. image-2022-06-30-12-16-14-029.png
          94 kB
          Wesam El-Gendy
        10. image-2022-06-30-12-18-32-817.png
          113 kB
          Wesam El-Gendy
        11. Mx.Inventory.Data_orig.dll
          547 kB
          Caner Saritac
        12. Mx.Inventory.Data.dll
          547 kB
          Caner Saritac
        13. screenshot-1.png
          25 kB
          Caner Saritac
        14. screenshot-2.png
          573 kB
          Caner Saritac
        15. screenshot-3.png
          45 kB
          Caner Saritac
        16. screenshot-4.png
          57 kB
          Caner Saritac

          Issue Links

            Activity

              People

              • Assignee:
                wesam.el-gendy Wesam El-Gendy
                Reporter:
                wesam.el-gendy Wesam El-Gendy
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.