Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Critical
    • Resolution: Closed/Resolved by Caller
    • Affects Version/s: CFA 2022R2
    • Fix Version/s: None
    • Component/s: Inventory
    • Labels:
      None
    • VTask #:
      VTASK0485924

      Description

      Description

      The issue began impacting this restaurant sometime between 4/10 and 4/17 ( incorrect UPT values for non-recipe items) 

      Impacted restaurants have reported stock outs of these critical inventory items so we'd like to have it resolved as soon as possible to prevent future stock outs.

      CFA reported this issue for multiple stores (01882, 02955)

      The following screenshot is showing what CFA expecting to see as the UPT Factor (Orange Column) and what is currently available in as the UPT Factor in MXC (Yellow Column)

      Ex ItemID 2115 & EntityID = 1027

      In MXC UPT = 0.0485

      According to our research the UPT is coming from UPTQty column in tbEntityItem table

      UPT Factor = ( Inventory Usage / Net Sales ) * 1000

      Inventory Usage = Opening On Hand + Receivings (Truck Orders) + Transfers In - Transfers Out - Closing On Hand

      Environment : PROD 
      Store : (01882, 02955)

       

       Steps

      1- Open the Item Maintenance Page in MXC and select item 'Sauce, Chick-fil-A Cup'

      2- From Right side select Usage Per Thousand 

      Results :

      UPT = 0.0485

       

      Expected : 

      UPT ~ 0.1140

       

        Attachments

        1. image-2022-05-20-12-23-47-523.png
          155 kB
          Wesam El-Gendy
        2. image-2022-05-20-12-21-09-967.png
          18 kB
          Wesam El-Gendy

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                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.