GL Opening Balance Incorrect Due to Misclassified Accounts Wrongly Corrected
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle General Ledger - Version 11.5.9 to 12.1.3 [Release 11.5.9 to 12.1]
Information in this document applies to any platform.
Executable:GLACTANL - Account Analysis - (132 Char)
Executable:GLACTANL2 - Account Analysis - (180 Char)
Executable:GLACTANP - Account Analysis - Payables Detail(132 Char)
Executable:GLACTANP.RDF - Account Analysis with Payables Detail
Executable:GLACTANP180 - Account Analysis - Payables Detail(180 Char)
Form:GLXIQACC.FMB - Account Inquiry
You have a misclassified account that has been corrected using <Note.1050920.6> or <Note.872162.1> but mistakes were made so there are still incorrect bought forward amounts . You now have a correctly classified code combination but the amount bought forward into the new year is still wrong.
While creating the journal in Adjustment period to move the balance off the account combination, the double entry was created back to the same account combination.
10.200.1000 50 dr
Created a journal with a line to credit each of the above account combinations.
The double entry should have been debited to a holding account 10.100.9000 for £200 but it was put to one of the error accounts instead account combination 10.300.1000
The journal was saved and posted. The account combination type was changed using sql as per the misclassified note. The journal was then reversed and posted.
As a result account combination 10.300.1000 now has a YTD balance in the new year of £200 which you need to remove.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms