Microsoft Dynamics AX (Archived)

List of outstanding cheques

(0) Share

Report

Posted on by Community Member

I need help with this item. I am a developer and do not know much about Ax functional.

How do I get a list of outstanding cheques (those that have not cleared the bank)?

I appreciate any help I can get.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jimmy, Have you checked the following form in the cash and bank management module?

Ludwig

Was this reply helpful? Yes No
Minoru Ohya 300 on at

Like (1)

Report

And you can check transactions in Bank accounts.

Thanks,

Minoru

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

you need to define "what is an outstanding cheque in case of Vendor"

e.g. in case of Accounts receivable, an outstading cheque may refer to Post dated cheque, for which we are still not sure if those will be cleared by bank or not.

For case or AR, there is only a list of cheque, and there is no concept of post-dated. you paid by a payment journal it turn to Piad, you cancel a payment it goes to Void.

So, what does mea n by "outstanding cheque of Vendor"

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

Thank you for your reply.

Yes I have seen this form, it lists all checks. Outstanding checks and otherwise. My problem is to filter which among these checks are outstanding.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

You can filter the grid by pressing 'Ctrl+G' and then you can set filter on each column. i.e. write: 20000.. on the topmost row of the amount column, and you'll get all checks with amount greater than 20,000. the two dots after 20000 means 'more or equal', and if you put it before the desired number it means 'less or equal'. You can also use > or < or other signs there.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jimmy,

I believe the issue is - as Sohaib writes - not how to filter on cheques but the definition of what you understand as an "outstanding" cheque. AX differentiates between the following cheque stati that you can filter on.

Yet, none of them says "outstanding".

What might help you is possibly also the setup of customer / vendor methods of payments. If you are in the cash and bank management module, you can open them by selecting one of your bank accounts and selecting the respective button in the setup tab. Once doing that you can identify that AX allows you setting up "bridging posting" and "postdated check clearing posting" that might help you identifying what you understand as "outstanding cheques". Please also have a look at the following TechNet site that might give you some additional insights. https://technet.microsoft.com/en-us/library/aa618565.aspx

All the best,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Since I am working with Accounts Payable, I think it would be safe to say that Outstanding cheques are those that the company has issued to the vendor and have not cleared the bank. Is there a way to filter that data? Also a friend suggested that Outstanding cheques are those that have not been reconciled - Im not sure what that means either.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The closest definition of outstanding checks (Accounts Payable) that I can come up with is that these are checks issued to vendors that have not yet been cashed or presented to the bank for payment, or cleared the bank.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jimmy, one possible solution would be setting up a check method of payment and using a bridging account for posting all checks until they are cleared. This gives you at least the total amount of your outstanding checks. Ludwig

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

hi Ludwig,

This makes sense, I think. Although I am still hoping there is another solution and that when the bank receives the payment it is stored away somewhere. (Obviously I have no accounting/finance know;ledge.).

Thanks!

Was this reply helpful? Yes No