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 issues

https://jiwa.atlassian.net/browse/DEV-7624