Microsoft Dynamics AX (Archived)

Importing bank statement

(0) Share

Report

Posted on by Mohammad Raziq Ali

2,486

While I am importing the CSV (bank statement), in AX 2012 R3, it showing that

0 bank statements was imported from file path

1 bank statement was imported

Is there any set-up effecting this. please let me know.

Regards,

Raziq.Ali

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

Like (0)

Report

HI Mohammad,

Which file format and method are you using? Do you use an official bank statement or did you try to generate your own?

Was this reply helpful? Yes No
Mohammad Raziq Ali 2,486 on at

Like (0)

Report

It is csv file format.

file has already posted bank statement.

Thanks,

Raziq.Ali

Was this reply helpful? Yes No
André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

Like (1)

Report

Hi Mohammad,

Is this a format provided by a bank and also supported by AX or do you have a customization to import this bank statement file?

Was this reply helpful? Yes No
Suggested answer

Divya Lakshmi 745 on at

Like (0)

Report

Hi,

In ax 2012 , I wrote separate code to import bank statement,its working fine for my client specified scenario...My functional could not import bank statement through base.

So do u want my job that help to import bank statement.

Regards,

Divya Lakshmi.J

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Divya Lakshmi,

It would be great if you could share your separte code for all on this forum as many users will run into similar issues when trying to Import bank statements.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Divya Lakshmi 745 on at

Like (1)

Report

Hi,

Hope this helps!

I have published my code in my blog.

Below is the link.

community.dynamics.com/.../x-code-job-to-import-bank-statement-lines-in-ax2012

Correct me if I'm wrong anywhere.

Regards,

Divya Lakshmi.J

Was this reply helpful? Yes No
Mohammad Raziq Ali 2,486 on at

Like (0)

Report

yes please...,

Regards,

Raziq.Ali

Was this reply helpful? Yes No
Mohammad Raziq Ali 2,486 on at

Like (0)

Report

Hi Andre,

There is no customization, it is standard code.

It is csv format and also supported by Ax

Was this reply helpful? Yes No
André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

Like (0)

Report

Hi Mohammad,

Can you provide some more details like screenshots? Without more information it would be hard to help you now.

Was this reply helpful? Yes No
Mohammad Raziq Ali 2,486 on at

Like (0)

Report

Yes Andre, Please follow below navigation depicted in screenshot.

When I entered Bank Account, Statement format which is of CSV, linked BAI2 AIF service created by me.

When file path is specified and press OK.

it is giving infolog as '0' bank statements are imported and 1 file is imported.

file has 15 rows and none is imported.

Was this reply helpful? Yes No