Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Importing bank statement

Posted on by 2,432

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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: Importing bank statement

    Hi Mohammad,

    I think the best you can do is debug to see what is going on. As you mention you are using a service, possibly you need to use the Visual Studio debugger. You can find some information about debugging here: msdn.microsoft.com/.../gg860898.aspx

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,432 on at
    RE: Importing bank statement

    Yes Andre, Please follow below navigation depicted in screenshot.

    22.png

    22.png

    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.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: Importing bank statement

    Hi Mohammad,

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

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,432 on at
    RE: Importing bank statement

    Hi Andre,

    There is no customization, it is standard code.

    It is csv format and also supported by Ax

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,432 on at
    RE: Importing bank statement

    yes please...,

    Regards,

    Raziq.Ali

  • Suggested answer
    Divya Lakshmi Profile Picture
    Divya Lakshmi 745 on at
    RE: Importing bank statement

    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

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Importing bank statement

    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

  • Suggested answer
    Divya Lakshmi Profile Picture
    Divya Lakshmi 745 on at
    RE: Importing bank statement

    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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,240 Super User 2024 Season 2 on at
    RE: Importing bank statement

    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?

  • Mohammad Raziq Ali Profile Picture
    Mohammad Raziq Ali 2,432 on at
    RE: Importing bank statement

    It is csv file format.

    file has already posted bank statement.

    Thanks,

    Raziq.Ali

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans