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

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).