web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Shyamraoo Profile Picture
    Shyamraoo 354 on at

    Hi,

    Same issue, have you figured out the problem.

    shyam

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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.  

  • Community Member Profile Picture
    Community Member on at

    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.

  • addision1 Profile Picture
    addision1 323 on at

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

  • Community Member Profile Picture
    Community Member on at

    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.

  • Prado Profile Picture
    Prado 10 on at

    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

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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans