You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Create Accounting Exception - The subledger journal must be balanced in the ledger currency.

Accepted answer
40
Views
2
Comments
edited Oct 21, 2020 10:09AM in Subledger Accounting & Accounting Hub 2 comments

Content

Hi,

My client created a custom subledger application, we import transactions using the downloaded template but received an error when importing transaction.

Error : "The subledger journal entry doesn't balance in the ledger currency. Details: The subledger journal must be balanced in the ledger currency."

Let say we have 1 transaction with multiple lines across different dates from the source system. For example,

Date Amount
4-May Dr 1
4-May Cr 1
4-May Dr 1
5-May Cr 1

I found in the upload template, the transaction date is one of the header level fields. Since the transaction date is header level, I split the 1 transaction into 2 headers to preserve the original date value. The 4/May will be the first header and 5/May will be the other header. But if we sum up the amount by date, they become unbalanced (4/May +1, 5/May -1).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!