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

Error "Duplicate Banking Records for selected period

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: CFA 2021R6
    • Fix Version/s: CFA 2022R2
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0480383
    • Root cause - Reason:
      Code defect
    • Source Code ID(s):
    • Root Cause:
      Duplicate check in code executes too far prior to the insert of new banking records.

      Description

      Description

      Error "Duplicate Banking Records for selected period" present on the "Finalize Day" tab.

      Environment : PROD 
      Store : Random Stores, 03521

       

      I have not been able to duplicate in a Non Prod environment

       

       

      Fix
      select* from tbbanking with (nolock)
      where entityid=4177 order by createdate desc

      Begin tran delete from tbbanking
      where bankingid=4930257

      The duplicate banking record that I deleted was for the business day of '2021-12-18 00:00:00.000'.  

       

       

        Attachments

        1. Capture.JPG
          53 kB
          Robert Johnson
        2. InFORM error Dec 18_deposit_part 2.PNG
          17 kB
          Robert Johnson

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

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