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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How to create a new bank statement

(0) ShareShare
ReportReport
Posted on by 460

Hi All,

I'm writing to need your support on how to create a new bank statement.
Although some bank accounts have been set up, I can't select any bank account in the list of Bank account when I click 'New' Bank statement in the Bank statement form. It was supposed that some bank accounts could be listed in this form to create a new bank statemet of a bank.
Are there some parameters need to set up?

Thanks

6765.pastedimage1658252404003v1.png

1033.pastedimage1658252593825v2.png

I have the same question (0)
  • Verified answer
    BillurSamdancioglu Profile Picture
    18,548 Most Valuable Professional on at
    RE: How to create a new bank statement

    Perfect! 

  • Jacky Qian Profile Picture
    460 on at
    RE: How to create a new bank statement

    Hi BillurSamdancioglu.

    As your suggestion, I solved the warning messages. So now I can see the statement lines which were created by hand in the bank statement before.

    Thanks for your support.

    pastedimage1658329099361v1.png

  • Jacky Qian Profile Picture
    460 on at
    RE: How to create a new bank statement

    Hi,

    Let me try to solve these warning messages. If I have another problems, I'll report it in here.

    Thank you.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    18,548 Most Valuable Professional on at
    RE: How to create a new bank statement

    Hi,

    During validation system checks couple of things like, if opening and ending balances are correct or line qty field is the same as the lines entered. So you have to solve the warning messages.

    Even if it is automated and have the same issues as manually created ones, you will still have this arning messages.

  • Jacky Qian Profile Picture
    460 on at
    RE: How to create a new bank statement

    Hi, Yes, I can click "Validate" the statement which was created by hand. As a result, I got some validating warning messages. Is this the reason?

  • Verified answer
    BillurSamdancioglu Profile Picture
    18,548 Most Valuable Professional on at
    RE: How to create a new bank statement

    Hi, Can you please "Validate" the statement. There is a button in the header.

  • Suggested answer
    Jacky Qian Profile Picture
    460 on at
    RE: How to create a new bank statement

    Hi BillurSamdanioglu,

    Thanks for your reply. I opened the advanced reconciliation and created a bank statement with two statement lines by hand, just like below illustration.

    pastedimage1658303570942v3.png

    But when I open the worksheet in Bank reconciliation, the two lines are not appeared in the list of statement transactions. It was supposed that two lines are appeared in that list? Could you tell me how to resolve it?

    pastedimage1658304352370v1.png

    Best Regards

  • Verified answer
    Prem Kumar Bachu Profile Picture
    3,418 on at
    RE: How to create a new bank statement

    Hi Jacky,

    Bank statements are used in advanced bank reconciliation. You need to enable bank account for "advanced bank reconciliation" in the bank account master in order to import or create bank statement. If advance bank reconciliation option is turned off, that bank account will be treated as manual bank reconciliation account.

    pastedimage1658257335310v1.png

  • Verified answer
    BillurSamdancioglu Profile Picture
    18,548 Most Valuable Professional on at
    RE: How to create a new bank statement

    Have you selected the bank accounts as advanced reconciliation? Be careful! Once you select,  there is no return. So do your testing in test environments.

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…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 814 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 798 Super User 2025 Season 2

#3
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 622

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans