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

Researching impact of system outage on 5/15 - CFA reported some stores with discrepancy in Credit amount

    Details

    • Type: Customer Defect
    • Status: Ready for Developer (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2022R2
    • Fix Version/s: None
    • Component/s: POS
    • Labels:
      None
    • VTask #:
      VTASK0516417

      Description

      Some stores reported a discrepancy when they tried to finalize the day 05/15 after the Outage occurred on 05/15.

      Example:  01808

      According to my investigation, I am using store 01808, the Issue is with Cashier Ross, Susan, in the file you sent I see the Gross Sales = 41972.81 while in the INFORM finalize page it is 40396.78.
       
      41972.81 - 40396.78 = 1576.03
       
      When I checked the transactions for this cashier coming from the TLD it is = 1576.03
        

       

      Select SUM(Sales_Incl_GST_EXCL) from tbTransactionSummary with ( nolock ) where EntityID = 989 and BusinessDay = '2023-05-15' and ClerkIDName = 'Ross, Susan'

       

      In the tbTransactionCashDeposit we don't see the amount came for this cashier in the LiteSum file (Attached). 

      Select * from tbTransactionCashDeposit with ( nolock ) where EntityID = 989 and CashDepositDate = '2023-05-15' and ClerkName = 'Ross, Susan' order by RegisterSales Desc
      
      Select * from tbTransactionCashCount with ( nolock ) where EntityID = 989 and BusinessDay = '2023-05-15' and ClerkName = 'Ross, Susan'
      
      Select * from tbMxshift with ( nolock ) where EntityID = 989 and BusinessDay = '2023-05-15' and ClerkName = 'Ross, Susan'

       

      The day 05/15 for store 01808 is already finalized, CFA is requesting at this point:

      1- Find all cashiers with a discrepancy between the LiteSum and TLD for the business day of 05/15.

      2- to find the reason or the error/notification for why this cashier didn't get updated in INFORM.

       

       

        Attachments

        1. 01808 - 5-15 - Daily Financial.pdf
          62 kB
          Wesam El-Gendy
        2. image-2023-05-18-15-39-55-445.png
          19 kB
          Wesam El-Gendy
        3. image-2023-05-18-15-42-03-536.png
          29 kB
          Wesam El-Gendy
        4. MERGED-LiteSumToThirdParty_Closed_2023-05-15.xml
          623 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:

                  PagerDuty

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