views:

71

answers:

1

Hi,

I am tasked with creating an API that would allow 3rd party customers the ability to send orders into our Microsoft Dynamics NAV 5.0 SP1.

I want to be able to create a SalesOrder in Dynamics NAV not with the client but via an API so i can allow a seperate process to enter in orders automatically.

Any help is appreciated in leading me in the right direction.

A: 

Well, it depends on how complicated you want to make it. Do you need confirmation of the Sales Order creation in "real time"? If so, you'll need to use a Web Service and ensure that there is a network path from wherever customers will create orders (public internet, extranet) to your NAV Web Service - likely using a VPN tunnel, etc. es th Alternatively, if you can live with a batch type process then you can have your customers create SOs via a web-based form, etc. and then import these orders into NAV on a regular basis using Dataports or XMLPorts.

For example, you may have a form online that your customer can create an Order on that places the Order in a staging table in SQL or even an XML or CSV file. Then you can run a process on a regular basis that imports these Orders into NAV and creates the appropriate SalesOrders.

Presumably, you also need a way to expose your Item database to the Ordering interface so customers can select which Items to order (and therefore create SalesLines from).

Which type of scenario are you interested in?

Rob Burke
Thanks for answering Rob, I am interested in Real Time orders only. Confirmation would be an actual SalesOrderNumber from Navision. So form batch based processed would not fit the requirements. I was hoping there was a built in API for Navision where i can call a method like CreateOrder and it would trigger code inside Navision just as it does as if i was using the client. Note: the Item database is already exposed via our SQL database.
Paul Smith