...
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
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...