Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

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

Posted on by 36

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.
pastedimage1677776512912v1.png

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:

pastedimage1677776878281v2.png

pastedimage1677777009551v3.png
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!

  • SW_Dynavics Profile Picture
    SW_Dynavics 7 on at
    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 Profile Picture
    Marco Mels on at
    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 Profile Picture
    John Nogaj 36 on at
    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 Profile Picture
    Marco Mels on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans