Best ways of integrating NAV with a Sales System

(0) Share

Report

Posted on by Community Member

I need to integrate a POS system with Dynamics NAV 2013. What is the best way ?

1. Using a NAV webservices

2. Direct SQL import to NAV intermediate tables?

They have around 1000 invoices per day and they need this integration to happen real time so that they can get generate finance report from NAV real time. What is the best way of doing this?

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

RE: Best ways of integrating NAV with a Sales System

I have used both the options with few of our clients. however as for my understanding best way is to use first option, that is using webservices.

Reasons

01. Once you use the webservices you can directly retrieve the errors if there is any error in the invoice.

02. You do not have to handle any transactions since NAV itself handle them for you.

03. You do not have to write any extra insert or update TSQL statements since NAV handle them with webservices.

04. Very easy to integrate, You just need to expose the sales order page as a webservice and then pass the values to the page.

05. You do not have to do much modification in NAV ( if you use intermediate tables in NAV then you have to run a report, or query to batch process the invoice, or else you need additional coding to make it real time.)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Best ways of integrating NAV with a Sales System

Thank you for the answer.

I developed a process only report and used a job queue to execute it in every 15 min and update sales header table and sales line table. Then post the entries. But it did not work very well.

I will try the webservice, is there any other way of doing this?

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report

RE: Best ways of integrating NAV with a Sales System

hi,

use a xmlport for sales header/sales line to import/export sales order data.

you can use that xmlport with webservices (best with your own published codeunit). to use that the pos system has to create xml docs with the according structure. then call the webservice with xml doc parameter. the webservice method gets the xml data; using the xmlport it's easy to create the sales order (with lines) and post it.

other option: export the xml message from the pos system and save that xmldocs as xml files to a shared folder. with a nas job you can fetch these xml files and import them using the xmlport.

follow: http://msdn.microsoft.com/en-us/library/hh165768(v=nav.71).aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Best ways of integrating NAV with a Sales System

Thank you for the help. I will check the proposed methods.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Best ways of integrating NAV with a Sales System

We have a link to a POS at one of our companies.

While it is easy to get SALES transactions to pass over, the trouble comes from all the other transaction types that flow through POS. We've found that we actually need a translation table to map the POS 'totalizer' codes to department/account GL coding; as well as a routine to update/change the translation table. With a 'simple' POS system integrating to the ledger, our current translation table has over 9,000 entries.

Was this reply helpful? Yes No