Yearly rollover hangs

Owned by Beth Blok (Unlicensed)
Last updated: Jul 10, 2017
1 min read

Problem

Running a yearly roll-over hangs the application and the process does not complete.  Applies to 7.00157 and 7.00.149 only.

Solution

 

SQL skills are required

Sound SQL skills are required to complete this task.

 

The issue is caused by a posting account linking back to itself.  Here is a script to identify and then correct the data.   The General Ledger Roll Over will then execute as expected.  Trial Balances balances before and after the roll over.

--identify incorrect linkings

select * from GL_Ledger where AccountNo = ParentAccNo

-- correct incorrect linkings

update GL_Ledger set ParentAccNo = '' where AccountNo = ParentAccNo