I want to regularly import external orders into Navision

mr.mcgoo

I have a web application which allows our customers to place orders. This is saved in a SQL 2005 database. I want to transfer these orders into the latest Navision system at periodic intervals, say every 15 minutes.

Is there a built in mechanism for this? I'm not a Navision programmer but I'm pretty handy with all things SQL and VB.

At the moment we are thinking of getting our dealer to write something but I know it's going to be expensive!

DenSter

Whatever you do, do it with a Navision process. You would miss essential business logic if you write directly into Navision tables.

You can have a timer polling your table using ADO automation. You could also create a linked table in Navision. You could also write a MSMQ monitor and send the orders into it. The MSMQ monitor actually is my preference.

girish.joshi

This is another common request, and there are some complications that you should do some thinking about. The more you think about this before contacting your solution center, the less they will have to charge you.

1. Make sure you have some reliable way of reconciling the "Identifcation Values" (e.g Order ID, cust ID, etc) on the web, with what you're using in Navision. What will you do if the information doesn't match?

2. What will you do when information about the Order (shipment status, item update, etc) is update on the Web? How about when its updated in Navision? How will the two be kept in synch?

3. How wil you deal with Order cancellations? (this is really a special case of #2)


Denster is right in saying you should make sure it is Navision driven in order to capture the business logic.

All of his suggestions have ways of dealing with the above issues, but some handle things a little differently.