Payment Reconciliation Journal not Mapping the correct Text to relevant Sub-ledger Account

AntonyNgorora7

Hi All,

Please may you kindly assist,

The Payment Reconciliation Journal is not Mapping the correct Text to the relevant Account.

When the CSV file (Bank Statement is uploaded) the transactions are populated.

But only the G/L Accounts Map the text to the relevant account.

All Sub-ledger accounts, Vendor and Customer are not populated, but All the Accounts are defined on the Table 1251 (Text-to-Account Mapping table) .

Perhaps something is causing this in the background.

Please advise.

Regards
Antony

AntonyNgorora7

Hi - The answer to this was fairly simple. There were Open Bank Account Ledger Entries in the System that had not been Reconciled. So the System quickly mapped these entries that have similar transaction texts and transaction amounts to the new Entries brought in on the new Payment Reconciliation Journal.

The issue has been resolved.