https://fixedasstets.blogspot.com/2018/07/error-0-subledger-journal-entry-does.html
When attempting to run Create Accounting - Assets, the following error occurs:
Error 0 - Subledger Journal Entry Does Not Balance In The Entered Currency Please Verify Entered Amount
Cause:
Reval Amortization journal line is missing from the Depreciation journal when Depreciation and Create Accounting are run after upgrade to R12.1.3
This causes the unbalanced journal as there is no contra-entry to the reval reserve posting generated.
The reval amortization side of the entry is not generated because there is a condition in the Journal Line Definition which looks for fa_book_controls.sorp_enabled_flag to be either Y or N (and not a null value).
In the customer case, this flag is null and hence no reval amortization journal line is generated.
In this case, for an asset book that was set up and has been running for a long time on R11i, when the book was defined, there was no such field as fa_book_controls.sorp_enabled_flag.
Then the 'SORP' solution (a UK Localization functionality) was released by Oracle Development and introduced fa_book_controls.sorp_enabled_flag.
For existing customers who do not use 'SORP' (ie. those outside of the UK), this flag remains null. On 11i this is not a problem, but on R12, the condition mentioned in the previous update relies on it being populated.
This was determined by review of the example problem asset traces uploaded to the SR which shows that the customer has fa_book_controls.sorp_enabled_flag = null.
When attempting to run Create Accounting - Assets, the following error occurs:
Error 0 - Subledger Journal Entry Does Not Balance In The Entered Currency Please Verify Entered Amount
Actual Revaluation Entry is:
ACCUMULATED DEP
|
135,320.60
|
||
REVALUATION
|
7,162.21
|
||
DEPRECIATION EXP
|
7,162.21
|
||
DEPRECIATION EXP
|
135,320.60
|
Cause:
Reval Amortization journal line is missing from the Depreciation journal when Depreciation and Create Accounting are run after upgrade to R12.1.3
This causes the unbalanced journal as there is no contra-entry to the reval reserve posting generated.
The reval amortization side of the entry is not generated because there is a condition in the Journal Line Definition which looks for fa_book_controls.sorp_enabled_flag to be either Y or N (and not a null value).
In the customer case, this flag is null and hence no reval amortization journal line is generated.
In this case, for an asset book that was set up and has been running for a long time on R11i, when the book was defined, there was no such field as fa_book_controls.sorp_enabled_flag.
Then the 'SORP' solution (a UK Localization functionality) was released by Oracle Development and introduced fa_book_controls.sorp_enabled_flag.
For existing customers who do not use 'SORP' (ie. those outside of the UK), this flag remains null. On 11i this is not a problem, but on R12, the condition mentioned in the previous update relies on it being populated.
This was determined by review of the example problem asset traces uploaded to the SR which shows that the customer has fa_book_controls.sorp_enabled_flag = null.
Solution
1. Navigate to the Book Controls form and query the asset book.
2. Move to the 'Accounting Rules' tab.
3. Find that the UK Local Authority Accounting option is unchecked.
4. Check this checkbox, then uncheck it again and save. The form is thus saved with a blank value.
5. Re-run Create Accounting - Assets which should now complete with no unbalanced journals.
2. Move to the 'Accounting Rules' tab.
3. Find that the UK Local Authority Accounting option is unchecked.
4. Check this checkbox, then uncheck it again and save. The form is thus saved with a blank value.
5. Re-run Create Accounting - Assets which should now complete with no unbalanced journals.
No comments:
Post a Comment