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

          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.