Create Accounting Exception - The subledger journal must be balanced in the ledger currency.
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,
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).