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.



Related articles





Related issues

DEV-7624: Period End Date for NEXT YEAR Period 12 is incorrect where there are only 2 unrolled years in GL Setup formPassed Testing