/
Unexpected error - Month End Manager

Unexpected error - Month End Manager



Description of Issue
  • When loading Month End Manager program, current year returns Unexpected error

  • System Log, Program Id : GetMonthEndData

    • EXEC

              [dbo].[usp_GL_MonthEnd_ReportCounts]

              @year = XXXX,

              @period = XX

    • Conversion failed when converting the varchar value XXXX to data type int.



Context

Month End Manager



Cause

Journals in proof with data defined in Reference 3 field



Resolution

Work ticket MUN-420779 is open with development to address the issue

Clearing Reference 3 on the journal that is causing the error will allow Month End Manager to load. 



Additional Information
  • This has been seen with GEN and GNI journals.

  • Clearing the Reference 3 on the proof journal resolves the unexpected error, but if you try to repopulate the field and save, the error returns. 

  • If there are a lot of journals in proof, clearing Ref3 for just the journal(s) with a special character, like a comma, may resolve it.











Related content

Accounting Entries year and period show 0 when entering journal on last day of month
Accounting Entries year and period show 0 when entering journal on last day of month
More like this
Month end manager - closing months for year-end close
Month end manager - closing months for year-end close
More like this
Error in YTD Budget Report when running for Carry forward or Current Year Only and including journal detail
Error in YTD Budget Report when running for Carry forward or Current Year Only and including journal detail
More like this
Execute insert tmpje failed - string or binary data would be truncated error when running Historical Actuals Comparison Report
Execute insert tmpje failed - string or binary data would be truncated error when running Historical Actuals Comparison Report
More like this
Entering a Journal the year end period are displaying as 0
Entering a Journal the year end period are displaying as 0
More like this
Budget Completion Journal - Monthly Budgeting - Invalid GL effective date
Budget Completion Journal - Monthly Budgeting - Invalid GL effective date
More like this