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
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.
Thank you for the help. I will check the proposed methods.
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
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?
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.)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (