web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Map Text to Account - ...
Small and medium business | Business Central, N...
Answered

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

(1) ShareShare
ReportReport
Posted on by John Nogaj 52

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!

I have the same question (0)
  • Marco Mels Profile Picture
    Marco Mels on at

    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.

  • John Nogaj Profile Picture
    John Nogaj 52 on at

    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.

  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at

    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.  

  • SW_Dynavics Profile Picture
    SW_Dynavics 7 on at

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

  • Bjoern Waninger Profile Picture
    Bjoern Waninger 4 on at
    Hello,
    i am having the same problem and not sure, if there is any reason, why the bank account can´t be filled?
     
    The table relation in table 1251 is setup correctly, but it does not work
     
    In case i add the same field again in an tableextension, the lookup to the "Bank Account" table works fine.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,577

#2
YUN ZHU Profile Picture

YUN ZHU 888 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans