How to import data from navision and then export to it to update stock and sales transaction

Business Central/NAV User Forum
1

Hi

I am totally new to navision.

My customer has the following: Microsoft Dynamics NAV 2009 SP1 V W16.0 running on windows Server 2008 and using database sql server 2008. They don’t have a Developer License.

He also has a tailor made VC# Pos application running separately. He wants me to daily import the Itemlist ( itemcode, ItemDesc, ItemPrice, Stock) from the Sql Server to the POS application.

And at the end of the day he wants me to retrieve the sales transaction from the POS application as a text/xml file and then export it Navision for the update of its sales and item ledger including stock etc

What are the tables which we need to query to get the itemlist for the above request?

What are the methods to update data to Navision?

Please advise

Best Regards

Mahen

2

Welcome to DUG!!

You need to look at the table No 27 Item and Sales Price table for exporting the data.

You need to write a report or data port and extract the data in required file.

3

Thx Amol

How about import data to Navison?

4

You can use data port for import as well as export the data.

5

Hi Amol,

As the customer does not have Navision Developer license, can he still use the dataport?

Thx

6

Yes You can use design dataport using customer license.