Yearly rollover hangs

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

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

Related articles