Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

How to upload bank statement.

Posted on by Microsoft Employee

I have created a new bank account and posted few transactions. Now I want to reconcile new bank by uploading a bank statement. Bank statement is in the .csv format and I want to know how to setup the field mapping and other related steps on uploading a bank statement. 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to upload bank statement.

    I want to create a exchange, to do that i need to have a .xsd file and file i created using visual studio is not working.

  • mmv Profile Picture
    mmv 11,465 on at
    RE: How to upload bank statement.

    Hi,

    I haven't used it.

    I have searched a few, and this is what I got:-

    The generic version of Microsoft Dynamics NAV does not support local bank or payroll file formats out-of-the-box. Microsoft Dynamics NAV therefore includes a data exchange framework that makes it easy to enable users to import or export bank or payroll files.

    Best Regards,

    MMV

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to upload bank statement.

    I created a xml file and then convert it to a .XSD file. but when I try to upload it to XML Schema it says "Provided file does not contain valid SEPA schema"

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to upload bank statement.

    Yes I have checked. Have you used these?

  • mmv Profile Picture
    mmv 11,465 on at
    RE: How to upload bank statement.

    Hi,

    Have you checked :-

    msdn.microsoft.com/.../dn414606(v=nav.80).aspx

    msdn.microsoft.com/.../dn789566(v=nav.80).aspx

    Best Regards,

    MMV

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to upload bank statement.

    Below link says to upload SEPA XML schema file. How do i create it? 

    https://msdn.microsoft.com/en-us/library/dn757280(v=nav.80).aspx

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to upload bank statement.

    Link for youtube is broken and other link is for 2013 version.  :(

  • mmv Profile Picture
    mmv 11,465 on at
    RE: How to upload bank statement.

    Hi,

    Have you checked this:-

    www.youtube.com/watch ... 419A3B59C8

    blogs.msdn.com/.../how-to-enable-import-export-of-bank-or-payroll-files-using-the-data-exchange-framework.aspx

    Best Regards,

    MMV

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans