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

Multiple UPT items with no Depletion from sales

    Details

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

      Description

      Description

       Missing Depletion from Sales for UPT items

      Environment : PROD 
      Store : multiple Stores, example 01656

       

       

       

      Expected : For Depletion from Sales to display for UPT items

       

      Select tsc.ApplyDate, BusinessDay, * from tbTransactionStockCount tsc With ( nolock)
      Join tbTransactionStockCountLocation tscl with ( nolock) on (tscl.TransactionStockCountLocationID = tsc.TransactionStockCountLocationID)
      Where tsc.EntityID = 910
      AND tsc.ItemID = 2027
      AND tsc.ApplyDate >= '2021-03-01'
      --AND tscl.AutoGenerated = 1
      Order by StockCountDate

      — Store 01656 Adjustment amount and Adjust Qty columns do not have data 

      Select tsc.ApplyDate, BusinessDay, * from tbTransactionStockCount tsc With ( nolock)
      Join tbTransactionStockCountLocation tscl with ( nolock) on (tscl.TransactionStockCountLocationID = tsc.TransactionStockCountLocationID)
      Where tsc.EntityID = 911
      AND tsc.ItemID = 2027
      AND tsc.ApplyDate >= '2022-03-01'
      --AND tscl.AutoGenerated = 1
      Order by StockCountDate

      — Store 01657 Adjustment amount and Adjust Qty columns have data 

       

       

       

      At store 01657 we can see that item Ketchup Dip has depletion from sales in item activity but at store 01656 there are no depletion from sales 

        Attachments

        1. screenshot-2.png
          screenshot-2.png
          3 kB
        2. screenshot-1.png
          screenshot-1.png
          3 kB
        3. 01657.PNG
          01657.PNG
          83 kB
        4. 01656.PNG
          01656.PNG
          80 kB

          Issue Links

            Activity

              People

              • Assignee:
                Robert.Johnson Robert Johnson (Inactive)
                Reporter:
                Robert.Johnson Robert Johnson (Inactive)
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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