Posting to a General Ledger year that has been rolled
The General Ledger year has been rolled and a journal needs to be posted to that closed year.
Step-by-step guide
SQL skills are required
A good understanding of SQL Management Studio is required to complete this task
Critical: Make sure there is only ONE Retained Earnings account i.e. one ledger account where Classification = Retained Earnings
It is strongly recommended that these steps be done in a test copy of the database to make sure you get the result expected.
The following is an example of posting a journal to 30/06/2021 where this is Last Year in the database - i.e. the Current Year starts 01/07/2021
run off a Trial Balance for the full year for Current Year - this is your starting point
create a journal as a Pending journal with the correct dates for 2021 with the relevant journal lines and save
SQL Management Studio and update the status of this Pending journal to Normal
update GL_Sets set SetType = '0' where setno = '102687’
run the standard stored procedures to update the General Ledger movement records and parent accounts
GO
usp_Jiwa_GL_repost
GO
usp_Jiwa_GL_UpdateParents
run off a Trial Balance for the full year for Current Year to ensure the values have been updated as expected