Export Vendor Table

Navision Articles

Get our Free Newletter

Don't you have the time to be online here at DUG every day? So how do you follow what is going on in the Dynamics industry and community?
If you subscribe to the DUG Newsletter then you can relax! We will make sure that you don't miss the big news!

Check out our
Newsletter Subscription Center
page a complete list of our different newsletters.

Solution (Not Verified) This post has 0 verified solutions | 1 Reply | 2 Followers

Not Ranked
6 Posts
55 Points
Joined: Oct 30, 2008
Last Online:
Jul 22, 2009 19:20
Location: New York, United States
Mafio posted on Jul 2, 2009 17:00
How helpful was this post/question? Please rate here:

Version: Nav 5.0 / SQL Server 2008

I am new to the system (replaced the existing ERP person).

I would like to export the vendor information (name, address, email, etc etc), and I do not know how to do this.  I was told to use the dataport function located in the Object Designer menu.  I was able to locate the table ( I believe it is table 23). 

Does anyone know where I can get documentation or an instruction manual on how to do this.  I will most likely want to do this with the Customer table and Item Master Table.

Thanks in advance,

 

 

All Replies

Top 25 Contributor
Male
1,057 Posts
22,099 Points
Joined: Dec 6, 2005
Last Online:
Mar 21, 2010 20:37
Location: Riga, Latvia, EU
Moderator
Solution (Not Verified) Modris Ivans replied on Jul 2, 2009 17:18
How helpful was this comment/solution? Please rate here:
Suggested by David Singleton

As I understand, you work for the customer. 

Mafio:
where I can get documentation or an instruction manual

You have 2 options:

1. CustomerSource website https://mbs.microsoft.com/customersource/ - but that is in case you are on active Maintenance Plan.

2. On installation CD in /Docs directory is a bunch of .PDFs with clumsy names - Application Designer's Guide has a chapter about DataPorts.

But:

Mafio:
I was told to use the dataport function located in the Object Designer menu.

Get there, check, if your license allows to create a new dataport - (hint - Object number must be in range 50000-50099).
In case message pops up saying your license permits this action, you would not be able to solve problem yourself, although it is rather simple & straighforward task, if you need EXPORT.

Besides, I would highly recomend not to try IMPORTING something, while your knowledge of Navision is not good enough.

Modris Ivans
MCP-Dynamics NAV Application

Please specify in your posts
1.product and DB version;
2.locale, or use International Forums

"Verify Solution" to post that helped you solve your problem

Page 1 of 1 (2 items) | Get this RSS feed | Bookmark and Share