Trial Balance period end date for Next Year period 12 is incorrect where there are only 2 unrolled years in GL Setup form

Problem

Where there are only 2 unrolled years in the General Ledger > Configuration > Setup form, running the GLMGT300 - Trial Balance for NEXT YEAR period 12, displays are incorrect date at the top of the report. (Usually 13 Mar 1905).

Solution

SQL skills are required

A working knowledge of SQL Studio Management is required to complete this task

Download and apply the attached script to the database to correct the report.

Trial Balance period end date for Next Year period 12 is incorrect where there are only 2 unrolled years in GL Setup form

Problem

Solution

Related articles