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

CFA Testing Partitioning - Inventory activity report data discrepancies

    Details

    • Type: Testing Defect
    • Status: Done (View Workflow)
    • Priority: Critical
    • Resolution: Completed
    • Affects Version/s: CFA 2021R1
    • Fix Version/s: CFA 2021R1
    • Component/s: Reports
    • Labels:
      None
    • SCRUM Team:
      Watchmen
    • Sprint:
      CFAMX 2021R1 Sprint 5

      Description

      CFA Testing Partitioning - Inventory activity report data discrepancies

      CFA Testing

      Restaurant: 02693 - George Washington FSU

      Inventory Activity Report

      Inventory Activity Report (IAR) data captured before partitioning doesn't match IAR after partitioning. Attached IAR before and after along with specific items (Chicken, Nuggets and Potato, Waffle Fries) analysis.

      It appears that 3 columns do not match: Purchase, Used and UsedCost. Please let me know if there are any additional questions.

      Before Partitioning:
      InventoryActivity-stacy.privalova 02693.pdf

      After Partitioning:
      InventoryActivity-stacy.privalova 02693 11122020.pdf

      Excel sheet used for data validation:
      Partitioning validation.xlsx

      Report run between:

      • Monthly Count 1/31/2020 10:15 PM
      • Monthly Count 2/29/2020 10:15 PM
      • These dates were selected to that no new data was introduced during the partitioning process

      Differences between Before and After:

      Purchases are different, this likely feeds in to other columns in the report

        Attachments

        1. BeforeAndAfter.png
          183 kB
          Will Englefield
        2. Count Selection.png
          28 kB
          Will Englefield
        3. InventoryActivity-stacy.privalova 02693.pdf
          260 kB
          Stacy Privalova
        4. InventoryActivity-stacy.privalova 02693 11122020.pdf
          241 kB
          Stacy Privalova
        5. Partitioning validation.xlsx
          115 kB
          Stacy Privalova

          Activity

            People

            • Assignee:
              stacy.privalova Stacy Privalova
              Reporter:
              stacy.privalova Stacy Privalova
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 2h
                2h
                Remaining:
                0h
                Logged:
                Time Not Required
                Not Specified

                  PagerDuty

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