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

Value in Monies To Be Deposited field is different than expected

    Details

    • 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

      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? 

        Attachments

        1. Deposits Page - 03212 on 2.12.png
          Deposits Page - 03212 on 2.12.png
          131 kB
        2. screenshot-1.png
          screenshot-1.png
          654 kB
        3. testing.PNG
          testing.PNG
          123 kB

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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