Budget Completion Journal - Invalid GL effective date

Description of Issue

Receiving an error when attempting to Post the Budget Completion Journal.

Munis(bgcmpjnl)
Invalid GL Effective date. XXXX

Context
  • Budget Completion Journal
  • Budget Projections
  • Code Defect or Bug
  • Versions 2021.6 through 2021.11
Cause

Site loaded released code following 10/16/2023 and introduced MUN-422544 or the respective code for site version and it introduced this issue.

The work ticket purpose was to resolve posting issues with back to back BUC for sites with multiple projections.  There were instances of amounts not updating correctly across accounts

Resolution

Hold off closing in the Live database until issue has been confirmed resolved in secondary database first.

  1. Call Financial General Ledger Support and let them know what database error was received in
    • Support will diagnose the impact to your site and provide options to move forward.
  2. Work ticket MUN-472034 has been opened with development as a priority 1 critical to address this error
    • This has moved forward to Quality Assurance final testing and should soon be ready for Release Management to roll out code update through Tyler Deploy
  3. Once site is notified code fix available, load it in secondary database and test to ensure it is in fact corrected, if not log a new case with examples and reference old case
    • New cases are always needed for root cause analysis when code updates have been applied and issues continue
Additional Information