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

Opening change fund previous day closing balance is incorrect

    Details

    • Type: Customer Defect
    • Status: Done (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: CFA 2021R6
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • VTask #:
      VTASK0480764
    • Root cause - Reason:
      Bad data

      Description

      Description

      In the opening change fund for 12/20 the previous day closing balance shows $0 but it should show $5000 

      Environment : PROD
      Store : 04513

       

       Running the following query I identified and deleted all records after 12/18

      select* from tbBankingFloatCount with (nolock)
      where entityid=5441 order by floatdate desc

      Running the following query I identified and deleted the workflow for 12/20

      select* from tbworkflowtemplateinstance with (nolock)
      where entityid=5441 order by businessday desc

      I then ran the following query to attempt to correct the opening change fund for 12/20

       

      Results : The previous day closing balance still displays as $0

      Expected : For the previous day closing balance to display $5000

        Attachments

        1. closing.PNG
          closing.PNG
          65 kB
        2. opening.PNG
          opening.PNG
          62 kB

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:

                  PagerDuty

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