Retained earnings account issues when upgrading from 6.5.13 to 7.00.xxx

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

Problem

Where a database has more than one General Ledger posting account set as a Retained Earnings account, upgrading from 6.5.13 to 7.00.xxx can create issues with the Current Year Open values for one or both of these accounts.

Solution

Ensure that there is only one General Ledger account setup as Retained Earnings i.e. where the field Classification = 'Retained Earnings'

To check this, do the following

  1. Load General Ledger Maintenance form

  2. Set the filter in the ribbon to Retained Earnings

  3. Load the search window and only 1 ledger account should be displayed

  4. Where multiple accounts are displayed, change the field Classification for the incorrect accounts from Retained Earnings to Normal

  5. Where the upgrade has already happened repeat steps 1 to 4

  6. Run the stored procedures usp_Jiwa_GL_Repost and usp_Jiwa_GL_UpdateParents to correct the underlying data

 

Advanced SQL programming skills are required