Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / B2B - information into...
Microsoft Dynamics NAV (Archived)

B2B - information into NAV 2013

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Our company currently does not have an e-commerce website, nor do we necessarily want one, as we are a B2B business and only sell to approved Dealers that have terms. Moving forward we are looking at the possibility of working with those Dealers and having them submit their orders to us in an Excel format with the goal to be able to take those files and have that information imported back into NAV in a Sales Order format (similar to what I currently do with Budgets) ultimately with the goal of eliminating the data entry.

First of all is this something that is even possible and if so has anyone done this?

*This post is locked for comments

  • Suggested answer
    Saurabh Shah Profile Picture
    Saurabh Shah 4,560 on at
    RE: B2B - information into NAV 2013

    Hi,

    I would recommend to use the XML port since the sales orders are not only one table but it contains header and details table (any others as per localisations).

    Since this excel sheet is getting filled up by the customers it will be confusing if give them a separate sheet or workbook for header and line items.

    We can do a XML code and create one line excel sheet where customer can fillup the data . the developer can also do some code in XML to get the default values automatically while creating the sales order and it will be very easy.

    We have done this work for many of our customers and it is working perfectly.

    You only need to consult your development partner for Dynamics NAV and asked them to do this.

    Regards,

    Saurabh Shah

  • TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: B2B - information into NAV 2013

    Did you found a answer for your query?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: B2B - information into NAV 2013

    Hello Norm:

    If you ever change your mind about eCommerce I recommend you to visit i95Dev. I strongly believe that eCommerce can do wonders for B2B companies like yours. We have worked with a number of B2B customers and they all are very happy with their decision of implementing eCommerce.

    We have recently worked with a B2B distribution company and you might want to read about them here.

    Regards,

    Vishnu

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: B2B - information into NAV 2013

    You can easily import data from Excel files. There are few ways to do that. Simplest way is to use RapidStart which is inbuilt function in the Dynamics NAV. Follow below links for more info on rapid start :

    https://www.youtube.com/watch?v=AuRQGitHfJw

    https://msdn.microsoft.com/en-us/dynamics/nav/dn848428.aspx

    Else you can use XML ports to import data, or if you want to automate the Excel data import process, that also possible in Dynamics NAV.  Both the last options would need  a help from a Microsoft Dynamics Partner with a Developer license.

  • Alex A Profile Picture
    Alex A 2,348 on at
    RE: B2B - information into NAV 2013

    There is RapidStart, which will allow importing data from an excel worksheet. Also, from an excel worksheet you can actually copy the rows and then paste them into the 'Lines' area of a sales order. To get this to work the columns have to be in a certain order (also Type, No., & Quantity may need to be the first columns - you'll have to test it - but this method does work.)

  • Rashed Profile Picture
    Rashed 3,765 on at
    RE: B2B - information into NAV 2013

    Yes, importing data from excel and creating any record in NAV is possible.  A lot of my clients use it for creating Items, and sales orders.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans