/
Trial Balance period end date for Next Year period 12 is incorrect where there are only 2 unrolled years in GL Setup form
Trial Balance period end date for Next Year period 12 is incorrect where there are only 2 unrolled years in GL Setup form
- Beth Blok (Unlicensed)
- Julie Hanlon
Owned by Beth Blok (Unlicensed)
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
, multiple selections available,
Related content
GLMGT235 - Profit and Loss with Actuals, Budgets and Variances can error 'Database Vendor Code: 8114...'
GLMGT235 - Profit and Loss with Actuals, Budgets and Variances can error 'Database Vendor Code: 8114...'
More like this
DB GL Reconciliation Report can give variance between Current Year Open + Current Year Movement and Next Year Open - 702.00 and 7.02.01
DB GL Reconciliation Report can give variance between Current Year Open + Current Year Movement and Next Year Open - 702.00 and 7.02.01
More like this
Period lock incorrectly reported when posting into the last month of the financial year 7.00.149
Period lock incorrectly reported when posting into the last month of the financial year 7.00.149
More like this
General Ledger posting to incorrect periods in 7.00.149
General Ledger posting to incorrect periods in 7.00.149
More like this
GLMGT200 - Profit and Loss this year comparative always reports the full year figures 7.00.175
GLMGT200 - Profit and Loss this year comparative always reports the full year figures 7.00.175
More like this
Posting to a General Ledger year that has been rolled
Posting to a General Ledger year that has been rolled
More like this