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

Inventory Adjustment Report shows name of people that do not work at Restaurant 03524

    Details

    • VTask #:
      VTASK0472066
    • Root cause - Reason:
      Code defect
    • Source Code ID(s):
    • Root Cause:
      Hide
      ClerkID stores different values in different circumstances: If an inventory adjustment is entered in MxC, ClerkID is the UserID of the user making the adjustment. If it comes from the POS, ClerkID is the ClerkID. The defect was that the code was always expecting that the ClerkID was the UserID.
      Show
      ClerkID stores different values in different circumstances: If an inventory adjustment is entered in MxC, ClerkID is the UserID of the user making the adjustment. If it comes from the POS, ClerkID is the ClerkID. The defect was that the code was always expecting that the ClerkID was the UserID.

      Description

      Description

      Inventory Adjustment Report shows name of people that do not work at Restaurant 03524

      Environment : PROD 
      Store : 03524

       

       Steps

      1. Navigate to https://inform.cfahome.com/mms_logon.aspx?bypass_sso=true

      2. Menu> Reports > Inventory Adjustment Report > Select Month September, or October > Select Generate Report 

        

      Results :

      Several users display who don't work at store 03524

      Scott, Bryce

      Biberstein, Carissa

      Kowalski, Hunter

       

      Expected : For the correct cashier to display in the Inventory Adjustment report

       

      Looking at qryMMSReportData_StockAdjustment

      I can see the following piece which may be causing this

      'ClerkID = tbUser.UserID'

        Attachments

        1. 03524.pdf
          870 kB
        2. ClerkID issues.xlsx
          122 kB
        3. screenshot-1.png
          screenshot-1.png
          165 kB
        4. stockadjustment.PNG
          stockadjustment.PNG
          21 kB

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                PagerDuty

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