-
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
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.
- blocks
-
CFAMX-11540 Production Defects
- Open