Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / IMPORTING BANK STATEMENTS
Microsoft Dynamics NAV (Archived)

IMPORTING BANK STATEMENTS

(0) ShareShare
ReportReport
Posted on by Community Member

Is it possible to manually import bank statements from CSV, TXT etc files?  When the bank account has the databank conv I get the error "the expected data was not received from the webserver". When I make it Sepa, the error is "A Call to system.xml.xmldocument.load failed with this message: Data at the root level is invalid. Line 1, position 1".   I tried making an exchange definition and then the import says "the request body is not set". So obviously I have something set wrong.  Not sure what i'm doing anyway : P

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: IMPORTING BANK STATEMENTS

    Have been having the same issue and looking for a solution, thanks!

  • Prado Profile Picture
    Prado 10 on at
    RE: IMPORTING BANK STATEMENTS

    Hi Theodore,

    I have tried importing a bank statement CSV file, with more than 300 records. But when i import the file only 10 records are inserted in the bank reconciliation page. Could you help me out for such an issue.

     

  • Community Member Profile Picture
    Community Member on at
    RE: IMPORTING BANK STATEMENTS

    I change the M in M/d/yyyy to an uppercase and it worked.  It stopped importing everything as January.  That is the dumbest thing I have seen all day.  Thanks for the info.

  • addision1 Profile Picture
    addision1 323 on at
    RE: IMPORTING BANK STATEMENTS

    I have been struggling with this for a few months now. This works!!! Thank you!

  • Community Member Profile Picture
    Community Member on at
    RE: IMPORTING BANK STATEMENTS

    TBRANDEWIE

    I have had this problem before of the date filling as January. Go to Column definitions for Data Exchange Definition. Make sure Data Format has an uppercase M.


    To explain, in my CSV file, date is formatted as 7/21/16... if I use data format of M/d/yy then the date will fill in correctly. If I use a data format of m/d/yy then the date will fill in wrong (January). Another example, if in my CSV file the date is shown as 21/7/16 (different culture) and I use data format of d/M/yy then date will fill in correctly. If I set data format as d/m/yy then it will fill in as January.

    I have tested all of this.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: IMPORTING BANK STATEMENTS

    blogs.msdn.com/.../import-a-sample-file-for-bank-reconciliation-in-dynamics-nav-2015-w1.aspx

    i followed these instructions and did it this way.  However, when I import the bank statement, it always makes the date january, no matter the month i'm importing (playing catch up).  So, i just go through the dates and change it to the right month.  But other than that it worked.  

  • Shyamraoo Profile Picture
    Shyamraoo 354 on at
    RE: IMPORTING BANK STATEMENTS

    Hi,

    Same issue, have you figured out the problem.

    shyam

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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
EH-09052238-0 Profile Picture

EH-09052238-0 1

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 1

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans