With the release of GP 2013 R2, you can reverse the End Year closing of historical years so that you can open fiscal years. In this post, this new feature will be illustrated in terms of the major and minor considerations.
Through the following scenario, the year (2014) is to be closed and the Year End closing report is generated as shown below.
The following journal entry is generated when closing the year JE No. 3451
Reverse Historical Year
GO To Microsoft Dynamics GP > Tools > Routines > Financial > Year End Closing
The following considerations are essentials when “reversing” the closing:
- You should reverse the most recent historical year first
- As usually, no users should be logged in Dynamics GP.
- The closing journal entry (In our example above, JE No. 3451 ) will be deleted not voided.
- Historical Analytical Accounting details will be deleted from the history tables, and moved to open tables
- Account summary balances will be recalculated (history and open) will be recalculated
Helping Note !
Back up is a must before reversing the historical year. Additionally, you should reconcile all open year. You get warning messages to do so.
Just before reversing the year
Just after reversing the year
Technical perspective :
Reverse historical year is performed through a new stored procedure added in GP 2013 R2 named [GLReverseHistYear] in the company database. While checking this stored procedure, the following tables are primarily affected by this process:
- GL20000 | Year to date transaction open
- GL10110 | Account Current Summary Master
- GL10111 | Account Summary History
- GL30000 | Account transaction history
- MC30001 | Multicurrency Account summary history
- MC00201 | Multicurrency Account summary open
- AAG40000 | GL distribution header
- AAG40001 | GL distribution
- AAG40002 | GL History assignment
- AAG40003 | GL History code
- AAG30000 | GL Header
- AAG30001 | GL Distribution
- AAG30002 | GL Assign
- AAG30003 | GL Code
Mahmoud M. AlSaadi