Map Text to Account - Payment Reconciliation Journals - Bank Accounts unable to be mapped

(0) Share

Report

Posted on by John Nogaj

Hi All,

When using the Map Text to Account feature in a Payment Reconciliation Journal, the balance source types of G/L Account, Vendor, and Customer all work as expected. For the G/L Balance source type, the software prompts you to have at least one debit or credit account filled out. For the Customer and Vendor Balance source types, the software prompts you to have a balance source number filled out.

Below shows everything working correctly for choosing a Customer balance source type.

For the Bank Account balance source type, it looks like there may be a bug? The software prompts you to enter a credit or debit account as the balancing source instead of the actual bank account to balance against. Manually entering the bank account number in the debit or credit fields throws an error that it can't find that in the G/L (as expected) and the Balance source number field on the far right is blank, and unable to be manually entered. See below:

Any ideas on how to solve this issue? This seems like a bug, but it could be some sort of intended function that I am missing.

Thanks!

All responses (4)

Answers (1)

SW_Dynavics 7 on at

Like (1)

Report

RE: Map Text to Account - Payment Reconciliation Journals - Bank Accounts unable to be mapped

Does anyone have an update as to how we map sweeps to other banks using Payment Reconciliations, or will this stay incomplete
Verified answer

Marco Mels on at

Like (0)

Report

RE: Map Text to Account - Payment Reconciliation Journals - Bank Accounts unable to be mapped

Hello again,

Now I understood your question. When you use a bank account, then that field cannot be used as per our docs:

Bal. Source No.

Specifies the balancing account to post amounts on payments or incoming documents that have this text to account mapping. The Bank Account option in the Bal. Source Type cannot be used in payment

For the debit and credit field, it must be G/L accounts that have direct posting enabled. We do not recommend this to enable this feature for bank accounts as that will make the reconciliation troublesome.

Thank you.
John Nogaj 36 on at

Like (0)

Report

RE: Map Text to Account - Payment Reconciliation Journals - Bank Accounts unable to be mapped

Hi Marco, thanks for the response. I am able to fill in a G/L account in the debit and credit fields, and I can even look up the G/L account that is associated with the Bank Account Posting Group, but the Balance source number field is unable to be edited or filled out for the Bank Account Balance Source Type.

If we just added the G/L account that the Bank Account Posting Group points to, then when matching the transaction and posting there would not be any bank account ledger entries posted, just entries posted to the G/L account.

It's strange that the Customer and Vendor Balance Source Types work exactly as expected, they allow you to put a Balance Source Number which is either the customer or vendor number, but the Bank Account Balance Source Type does not allow you to put a Bank Account in the Balance Source No. field.
Marco Mels on at

Like (0)

Report

RE: Map Text to Account - Payment Reconciliation Journals - Bank Accounts unable to be mapped

Hello,

You need to add the bank account number that you can find in the chart of accounts for debit and credit. E.g. in CRONUS company this in the range of 1001 - 1013, etc.

Hope it helps.