-
Type: Customer Defect
-
Status: Done (View Workflow)
-
Priority: Major
-
Resolution: Closed/Resolved by Caller
-
Affects Version/s: CFA 2021R3
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
VTask #:VTASK0460883
Description
The daily sales report pulls Cash Over data from tbTransactionCashDeposit. Cashover in tbTransactionCashDeposit is not accurate due to CFAMX-15388
Environment : PROD
Store : All Stores, example 02418
Steps
1. Navigate to https://inform.cfahome.com/mms_logon.aspx?bypass_sso=true
2. Menu > Reports > Daily Sales > Select Store 02418 > Business day 6/12
3. Workflow > change the date to 6/12 > select cashier Layla Gallegos - Shift 1
Results :
Cashier Over/Short details under Cashier details in cashier settlement for Layla Gallegos - Shift 1 does not match the Cash Over or Cash Short columns in daily sales report
Expected : For the Cashier Over/Short data in cashier settlement to match Cash Over or Cash Short columns in daily sales report
This is a widespread issue across the chain due to CFAMX-15388. Is there a way to clean up the incorrect data in tbTransactionCashDeposit?
select* from tbTransactionCashDeposit with (nolock)
where TransactionCashDepositID=95530695
select* from tbTransactionCashDeposit with (nolock)
where cashover <-20 and cashdepositdate > '2021-05-20 00:00:00.000'order by CashDepositDate desc
- is blocked by
-
CFAMX-11540 Production Defects
- Open