FAH Accounted Amounts Columns Required On Subledger Journal Creation Spreadsheet to avoid "Journal is not balanced at ledger currency level. Enable Suspense accounting". (Doc ID 2931233.1)

Last updated on FEBRUARY 27, 2023

Applies to:

Goal

On : 11.13.22.10.0 version, Integration

Accounted Amounts columns required on Subledger Journal Creation Spreadshee

Entering the multi-currency journals via ADFdi in Subledger Journals, wherein there are no Accounted Debit nor Accounted Credit columns and the spreadsheet is calculating the amounts based on Entered Amounts along with Conversion rate.

While loading the multi-currency journal, system is throwing error saying "Journal is not balanced at ledger currency level. Enable Suspense accounting".

*Accounting Class[..] Currency **Entered Debit **Entered Credit Conversion Date[..] Conversion Rate Type Conversion Rate
CXXXX DEBIT EUR 1.00 12/28/22 User 3.9111 > Accounted equivalent is 3.9111
CXXXX CREDIT AED 3.91 > Accounted equivalent is 3.91
============== =====================================================================================================================
Difference between DR and CR accounted = 0.0011

requirement is to have accounted fields so that direct amounts can be punched and the unbalance of entered amounts can be parked to Entered Currency Balancing combination.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.