/
Open New Fiscal Year- error refactoring Accounts

Open New Fiscal Year- error refactoring Accounts



Description of Issue
  • After closing successfully in Train, an error generated in Live while running the Open New Fiscal Year program: Munis (glopenyr).  Error refactoring Accounts: 6372... The MERGE statement conflicted with the FOREIGN KEY constraint FK_AccountSubAmounts Accounts.  



Context

Open New Fiscal Year



Cause

Possible causes:

  • Other users were not off Munis.

  • Other programs were open while closing.

  • A transaction with an issue was posted in Live after Train had been refreshed.  



Resolution
  • Check with General Ledger Support if this error happens in Live to determine if a restore is needed.

  • If the error happens in Train or Test, refresh from Live and try closing again.

  • Before closing in Live after restore:

  1. Have Train or Test refreshed from Live.

  2. Close in Train or Test.  

  3. If closing in Train or Test is successful, have IT save a backup of Live right before closing in Live.

  4. Have IT lock users out of Munis and confirm all other users are off Munis.

  5. Re-run closing programs and only have the one closing program you are running open.

  6. After closing, check General Ledger Settings and run reports.  Confirm results are as expected before letting users back on Munis.



Additional Information












Related content

Open New Fiscal Year- Fatal errors were encountered during processing
Open New Fiscal Year- Fatal errors were encountered during processing
More like this
Error - Access denied due to GL End of Year process following Year End Close
Error - Access denied due to GL End of Year process following Year End Close
More like this
Journal out of balance error - Close Current Fiscal Year cannot be output posted
Journal out of balance error - Close Current Fiscal Year cannot be output posted
More like this
Unable to post in Close Current Fiscal Year Unknown error on parameter update
Unable to post in Close Current Fiscal Year Unknown error on parameter update
More like this
Close Current Fiscal Year - error Selecting account for journal post, status
Close Current Fiscal Year - error Selecting account for journal post, status
More like this
Fund Attribute Not Found
Fund Attribute Not Found
More like this