Bank statement per date

(0) Share

Report

Posted on by Community Member

In Cash and bank management - does anybody know how to get the bank statement for ALL accounts PER date - I know how to check each individual bank account but not how to get the whole overview for a specific date...

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Crispin John Augustine 37,081 on at

Like (0)

Report
Copy link

Link copied!

Cash and bank management > Reports > Statistics > Payment summary by date. technet.microsoft.com/.../aa592027.aspx;MSPPError=-2147217396

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you very much for your answer. However, doing that not only shows the balance for each account - it also shows all the postings for the date for each account. I just need the a "list view" for all accounts with one line for each account stating the balance at date

Was this reply helpful? Yes No
Crispin John Augustine 37,081 on at

Like (0)

Report
Copy link

Link copied!

That's probably not available ready made.

It may be possible to filter this from one of the lines forms in AX, but it's easier if you make a new query/view for this, which should be quite simple..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Ohh .. I see. How to do that?

Was this reply helpful? Yes No
Crispin John Augustine 37,081 on at

Like (0)

Report
Copy link

Link copied!

To start with, duplicate the query BankPaymentByDate and Play with the Group by, and field Aggregation. You will eventually Figure it out..

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report
Copy link

Link copied!

no standard report do that , you need to customize new report

Was this reply helpful? Yes No