Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Rapidstart Services Importation of excel file

Posted on by 75

We have a client who needs their Purchase Invoices imported in NAV coming from their 3rd party system provider who processes their purchases. We need to have a Vendor subsidiary ledger so we decided to have it imported through the Purchase Invoice in NAV. But as we try to import the Purchase Header and lines through the excel import function in Rapidstart services, and though the data could be applied in the table, the Purch. Invoice Header does not have a total amount of the line amount found in the Purch. Invoice lines. So our questions are:

1. Is it possible to import the Purchase Inv. Header and Purch. Invoice line through Rapidstart Services?

2. Also, is it possible for us to directly import an excel file directly created from a third party system? We tried to import the said file (following the formatting of the excel file exported from NAV) but upon importation we encountered an error saying that "Excel does not contain xml mappings"

Can anyone give us any possible solution to solve our concernsr?

*This post is locked for comments

  • SSI Judith Profile Picture
    SSI Judith 75 on at
    RE: Rapidstart Services Importation of excel file

    Thanks for the help Mr. Roberto Stefanetti. Highly appreciate it.

  • Verified answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: Rapidstart Services Importation of excel file

    hi,

    you need an Excel file containing XML fileds mapping (generated from RapidStart and embedded in Excel file); if your source system overwrite the file, your structure is lost and you receive error message.

    (you can only fill the excel sheet created from Rapid Start and then import the excel sheet)

    some links:

    Set Up a Company With RapidStart Services for Microsoft Dynamics NAV

    msdn.microsoft.com/.../hh179428(v=nav.71).aspx

    Tips and Tricks: RapidStart Services

    msdn.microsoft.com/.../hh879494(v=nav.71).aspx

    Rapid Start Config

    www.google.it/url

    RapidStart Services: Configuration Worksheet

    www.mibuso.com/.../viewtopic.php

    ---------

    you can try these others solutions:

    NAV 2013 Universal XMLPort v5  

    mibuso.com/dlinfo.asp

    Excel Import Export Wizard - NAV 2013  

    mibuso.com/dlinfo.asp

    or Import external data using NAV Web Services Technology (with XMLPorts)

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans