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

One user not generating an inventory count export upon applying a spot count

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2022R2
    • Fix Version/s: CFA 2022R4
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0487492
    • Root cause - Reason:
      Code defect
    • Root Cause:
      added stock count export logic to the auto submit order process

      Description

      Description

      Description

      When user 'evrick.hall1' does a correct on hand within an order to create a spot count a inventory count export is not generated

      Environment : PROD 
      Store : 01873

       

      Results :

      When user 'evrick.hall1' preforms a spot count the inventory count export is not generated

      Expected : When user 'evrick.hall1' performs a spot count that a inventory count export is generated

       

      --Running the following query I can see that whenever user 'evrick.hall1' performs a spot count the inventory export is not generated however when users 'christopher.meeks1' and 'brad.graham1' perform a spot count the export is generated

       

      Select A.TransactionStockCountLocationID,A.EntityID,A.ApplyDate,A.Status,A.StockCountType,A.ClerkName,A.ReferenceNumber,B.Status,B.Longkey,B.StoreNumber,B.CompleteTime,B.StringKey ,b.BusinessDay,B.StartDate,B.EndDate
      from tbTransactionStockCountLocation A with (nolock) left Join tbExportQueueMessage B with (nolock) ON A.TransactionStockCountLocationID = B.Longkey and A.EntityID = B.EntityID
      where A.EntityID = 1022 and A.Applydate > '2021-12-01' and A.Status = 'applied' and A.StockCountType <> 'Spot Check'
      --and B.EntityID = 1022 and B.BusinessDay >= '2022-04-01' and B.EventID = 8 and B.StringKey in ('Spot','Custom1')
      Order by ApplyDate Desc

       

      What is preventing user 'evrick.hall1' from generating a inventory count export when the user performs a spot count? 
       

        Attachments

          Issue Links

            Activity

              People

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