Microsoft Dynamics AX (Archived)

Automated Bank Reconciliation

(0) Share

Report

Posted on by Vinoth Kumar

285

Hi,

Please any one let me know. How to generate automated bank reconciliation?

Specifically we are looking for bank statement information should be imported from electronic statement files using a flexible import process and it should do the comparison of entries(check details) made in AX. Now we are doing this manually tallying AX entry with bank statements. We need to do automation on this to reduce manual hours. Automated matching can be used to reconcile the majority of transactions with the minimum of effort. Please any one let me know the solution for this.

Thanks,

Vinoth Kumar

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Community Member on at

Like (0)

Report

to which country you want to do it for ... we need to customise to do it

Was this reply helpful? Yes No
Vinoth Kumar 285 on at

Like (0)

Report

We are looking the solution for Canada. If you a have any solution for this..Please let me know.

Thanks,

Vinoth

Was this reply helpful? Yes No
vsaito 5 on at

Like (0)

Report

Does anyone has a solution for Australia?

Was this reply helpful? Yes No
Rafael Mardones 20 on at

Like (0)

Report

Does anybody has one for Chile?

Thanks,

Rafael Mardones

Was this reply helpful? Yes No
user5555 7,437 on at

Like (0)

Report

Hi,

Please forward your post into the MS connect tool and refuse that it is declined or rejected as 'can be customized' by its customers. It is unacceptable for ERP system calling itself Global that such imports are not defacto standard. If there is a job opportunity to become product manager at AX I would definitely dive into this. There are too many short comings in AX while following this forum for a couple of months now. If it is either the partner, then it is AX itself lacking simply accessing functionality that is defacto standard in many ERP systems like King, Start, Exact, Davilex, etc. for only 200 USD you can have such basic software running on your desk. Not even 2 or more servers needed like for AX.

Anyhow,

I have had my clieop3 file fixed by my partner after encountering 5 severe bugs,...and even a supplier named adidas had been read by the code as the payment id (since adidas has an id also in it). I have never found such stupid code in my live and I would fire such developers on the fly.

First of all check if in the AOT there is a class named VendOutPaym...and then your country code. Like my is:

class VendOutPaym_NLClieOp03 extends VendOutPaym

The you need to do a lot of setups so that you can connect the payment file to the BANK, also check at your bank how to upload the file and how to download.

We now generate the payments for one week in advance and then upload the file (that is something which banks should automate, it is also a defacto process, quite boring to do). Then the day after or next week we download the files and import it in AX. The manual reconcillation under bank, I did once to check my year end balances, but we do not use it anymore. It can be automated as well, but if there is no guidance, the time is actually wasted to have it done.

J.

Was this reply helpful? Yes No

Community site session details

Automated Bank Reconciliation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Automated Bank Reconciliation

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates