Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error "Account nu...
Finance | Project Operations, Human Resources, ...
Suggested answer

Error "Account number for transaction type Bank does not exist"

(0) ShareShare
ReportReport
Posted on by nopainnogain 375

Reproduce steps:

1. Go to Cash and bank management>Bankl accounts, then create a new bank account (Test123) then link to a certain main account, for example: 123456

2. Go to Accounts Payable>Payments>Vendor payment journal, then create a new Vendor payment journal, go to Lines, choose Offset account type as Bank, Offset account as Test123 then Validate

3. Error received: "Account number for transaction type Bank does not exist.

4. Go to General Ledger>Ledger setup>Ledger, choose the account structure and I am able to see that the main account 123456 exists in this Balance Sheet account structure. 

5. Deleted 123456 from account structure then retry Step 2, still received error as in step 3

6. Go to General Ledger>Chart of accounts>Accounts>Main accounts. Then create a new main account 123457, using same set-up for main account 123456 (Main account category), then repeat from Step 1. No error was found in step 3.

Do you have any ideas how the error happened. Obviously the main account does exist in the account structure.

TIA

L

  • Bell.D Profile Picture
    Bell.D 107 on at
    RE: Error "Account number for transaction type Bank does not exist"

    Hi Saurabh, What do you mean by mapped to ledger setup?

  • Bell.D Profile Picture
    Bell.D 107 on at
    RE: Error "Account number for transaction type Bank does not exist"

    Hi Ludwig, 

    I am facing the same issue but it is a general journal for me with bank to bank transfer which is giving the same error. The main accounts for both the banks are setup. The only thing I noticed was the bank transaction type was one of the banks used is not setup under method of payments - vendors form. 

    Could this be the reason? The accounting structure has both the main accounts involved.

    Let me know,

    Thanks bella

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Error "Account number for transaction type Bank does not exist"

    Hi L,

    Can you show a screenshot how the accounts are setup in the account structure(s)?

  • nopainnogain Profile Picture
    nopainnogain 375 on at
    RE: Error "Account number for transaction type Bank does not exist"

    Hello Thomas,

    Thank you for your reply. I checked within the set up. all look the same and those with errors were created by someone else not me, hence, I am still struggling with what could possibly be the reason.

    Any insights?

    Regards,

    L

  • Thomas Tian Profile Picture
    Thomas Tian on at
    RE: Error "Account number for transaction type Bank does not exist"

    Hi TIA，

    I suggest you compare the account without error and account with error. find the difference between them. then we should be find the root cause.

  • nopainnogain Profile Picture
    nopainnogain 375 on at
    RE: Error "Account number for transaction type Bank does not exist"

    By the way, I found several other main accounts with the same issue, so I guess there must be some kind of set-up that caused the error

  • nopainnogain Profile Picture
    nopainnogain 375 on at
    RE: Error "Account number for transaction type Bank does not exist"

    Sorry Andre for not mentioning,

    Yes it was in draft mode, then I activated and waited until it was changed to active before going back to create a new Vendor payment journal.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Error "Account number for transaction type Bank does not exist"

    Hi L Dinh,

    When you had seen the main account 123456 in the account structure, did you also check that account structure was activated including this value? You didn't mention this in your first question.

  • nopainnogain Profile Picture
    nopainnogain 375 on at
    RE: Error "Account number for transaction type Bank does not exist"

    Hello Rahul,

    If you saw my initial question at step 4, I did mention that the main account does exist in account structure.

    Thank you

  • Rahul Mohta Profile Picture
    Rahul Mohta 21,014 on at
    RE: Error "Account number for transaction type Bank does not exist"

    consider review of accounting structure and ensure the control bank account in included and suggest

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans