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 / Microsoft Dynamics AX (Archived) / Account number for tra...
Microsoft Dynamics AX (Archived)

Account number for transaction type Bank statement does not exist - when posting bank statement

(0) ShareShare
ReportReport
Posted on by Kasiborek 55

Hi,

I have a small bank rec with matched transactions. I am trying to post the Bank Statement now.

After many successful bank recs postings suddenly system throws an error ''Account number for transaction type Bank statement does not exist.''  

It all worked before and I have not changed anything in my config. Type of transaction 'bank statement'...? That's new and I never

had that in my Types of Transactions before. Not much online. Help needed and appreciated.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Have you tried setting up an account number in the GL auto posting accounts form?

    Best regards,

    Ludwig

  • Kasiborek Profile Picture
    Kasiborek 55 on at

    Hi Ludwig thanks for coming back to me so promptly!

    It looks more complicated than that. When I open bank statement and click on the transaction which is missing the main account distribution, look down on line details, Financial tab.

    Bank Transaction type is not automatically populated (it does exist in the dropdown and General Tab does pick it up) like on other lines which are picking up the main account.

    I got so far for now

  • Martin Dráb Profile Picture
    Martin Dráb 237,803 Most Valuable Professional on at

    Hi Kasiborek, please don't prefix tags with # and do separate words in tags with spaces (e.g. use advance bank reconciliation instead of #advancebankreconciliation).

  • Kasiborek Profile Picture
    Kasiborek 55 on at

    Thanks Martin.

  • Verified answer
    Kasiborek Profile Picture
    Kasiborek 55 on at

    Hi Ludwig,

    I found the missing link.

    Open: Bank Statement >on one of the transactions LINE DETAILS in the Financial Tab >Bank> the Bank Transaction Type field was not picking up the transaction type.

    In the General Tab the  Bank Transaction type was just fine. So it was a matter of our developers adjusting the code for the system to pick it up.

    We do have this part of D365 customised so the answer to this issue may not be helpful for many. But it is worth mentioning: CHECK THE LINE DETAILS in the bank statement lines, if everything else seems to be correct.

  • Szabolcs Torok Profile Picture
    Szabolcs Torok 5 on at

    Hi Kasiborek,

    I found your post very useful as I'm currently testing Advanced bank reconciliation with BAI2 bank statement format and bumped into the same issue, statement import does not pull the bank transaction type from the bank statement file even though Transaction code mapping is properly configured. Any idea if this is an existing product bug in D365FinOps or I might be missing something? I can select the transaction type manually on the statement lines but this way automatic transaction posting of the various bank charges will not work.

    Thanks for any help, much appreciated.

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 > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans