-
Type:
Customer Defect
-
Status: Done (View Workflow)
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: CFA 2022R2
-
Fix Version/s: CFA 2022R3
-
Component/s: None
-
Labels:None
-
VTask #:VTASK0486696
-
Root cause - Reason:Functionality new
-
Root Cause:the user is able to select other cashier immediately while the other one is in progress..
Description
on 2/12 there was a negative value in the Monies To Be Deposited field
Environment : PROD
Store : Multiple Stores, example store 03212
Running the following query I see two cashiers with Financial groups not found
select * from tbAuditCashDeposit acd with (nolock)
join tbAudit a with(nolock) on acd.AuditID = a.AuditID
where TransactionCashDepositID in (108169248,108179617,108180218,108180439,108180574,108185021,108198714,108200906,108201010,108201011,108201298,108202231,108202477,108202969,108203462,108203986,108209925,108209929)
order by EventEntityLocalDateTime asc
I have corrected the data using the following queries
select * from tbTransactionCashDeposit nolock where EntityID = 3156 and CashDepositDate = '2022-02-12'
--commit
Begin tran update tbtransactioncashdeposit
set cashdeposit=33
where transactioncashdepositid=108202231
--was 28
Begin tran update tbtransactioncashdeposit
set cashdeposit=182
where transactioncashdepositid=108203462
--was 162
What caused the two Cash Deposit Update failed on 2/12, also how was the store able to finalize with a negative value in Monies to be Deposited?
- is blocked by
-
CFAMX-11540 Production Defects
-
- Open
-