Details

    • Type: Customer Defect
    • Status: Need More Info (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2023R1
    • Fix Version/s: None
    • Component/s: Inventory
    • Labels:
      None
    • VTask #:
      VTASK0509910

      Description

      CFA reported that store 03313 has been experiencing perpetual on hand issues with DRSNG, APPLE CIDER VINAIGRETTE (101338) for some time now.

      The operator routinely has to correct his on hand quantities during the ordering process (InFORM's on hand qty is always higher than what the restaurant has) and CFA team can't make any sense of it.

      If he corrects his on hand and enters a count of 1.0 cases, the next day his on hand will be >1.0 cases, with no inbound inventory transaction and inventory depletion from sales. Their UPT value for this item is 0.0057 which means their on hands should be depleting by 0.17-0.20 cases per day yet somehow their on hands are increasing each day.

      I noticed that in the activity report the closing Inventory is always > from expected  

      It match what we have in tbItemQty

      Select fOnHand_qty/180,* from tbItemQty with ( nolock )where ItemID = 2399 and EntityID = 3178

       

      1st question where this is getting calculated?

      Is it taking into consideration the physical count the operator does?

      select * from tbTransactionStockCount with (Nolock) where EntityID = 3178 and ItemID = 2399 order by ApplyDate desc

      For the spot counts (system) it is always > what the operator counted.

       

        

       

      Are you able to dig into this and let us know what may be causing this?

        Attachments

        1. image-2023-02-17-17-37-04-105.png
          105 kB
          Wesam El-Gendy
        2. image-2023-02-17-17-41-00-985.png
          37 kB
          Wesam El-Gendy
        3. image-2023-02-17-17-44-52-339.png
          397 kB
          Wesam El-Gendy
        4. image-2023-02-21-18-50-09-429.png
          456 kB
          Caner Saritac
        5. image-2023-02-21-18-50-57-591.png
          263 kB
          Caner Saritac

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:

                  PagerDuty

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