Standard SOAP API to create Sales Order in MS Nav 2013 R2?

(0) Share

Report

Posted on by Community Member

Hello Experts,

We are trying to create a Sales Order in MS Nav (on premise 2013 R2) from Oracle Sales cloud.
Going through the link https://msdn.microsoft.com/en-us/library/dd355398(v=nav.71).aspx , gave an impression that the Standard Sales Order creation page in NAV can be exposed as a SOAP service.

Question 1: Is there any standard SOAP API available to create Sales Order OR we need to expose the SO creation page in NAV as a SOAP service?
Question 2: In case the business validation to create Sales Order fail (credit check and other such validations) will this SOAP service send back an acknowledgment back to show the user the status of the attempt?
Question 3: On the same lines, we want to create customers and items as well, is there any seeded SOAP service or need to create it, on similar lines?

Question 4: Is there any standard SOAP API to bulk upload items, customers, orders to-and-from MS NAV? Or is it some file based loader?

Any guidance to solve this will be deeply appreciated.

--
Sayantan

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

To my knowledge, there are no standard service for importing data you mentioned, those need to be developed. While developing, you can add an option to send back the acknowledgment info about the success of the import. You can refer to standard web services, available in NAV, by typing "Web Services" in the search filed of client interface:

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Here are the answers

A1) You need to create the Web Service and publish.

A2) Ideally, If you have Item Master & Customer Master available in NAV, there is no scenario which can fail the SO creation. If at all there are some scenarios, you can achieve the same via related Web Service Configuration

3) You need to create and publish the Web Service for creating Item & Customer Masters.

4) No Standard Services available for direct Integration.

Creating & Publishing Web Service is bit simple in NAV. Refer below link for step by step instructions.

msdn.microsoft.com/.../dd355316.aspx

msdn.microsoft.com/.../dd339004.aspx

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Vishal,

Your response is deeply appreciated!

We will try the steps mentioned by you, and will post here, if any further guidance is required.

Quick question - Since in this case, we will want to make an outbound WS call from a Cloud application to a on premise MS NAV ERP (which will find an incoming request), will it require any settings at MS NAV end? Like "opening up" of some ports?

Some folks told me that there could be such network related restrictions, are you aware of any such pointers?

thanks again!

--

Sayan

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Sayan,

There are no standard services out of the box for SOAP API integeration, the way web services work in NAV is you need to publish the related page as service and you can use the standard page operations like Read, Udpate, Delete. Whether it is a item, customer, sales order.. anything you just need to publish the related page.

For the business validation the NAV will throw an error and you need handle that error on your application side (.NET, Java or PHP) which is consuming the webservices.

To create customers or items you just need to publish the related customer list and item list page.

For bulk upload you can still use the web services or customize NAV to create some xmlports for you and then use them by webservices to import.

Related to the ports and networking issue, you need to make your NAV webservice is open to other server, so make sure no firewalls are blocking those ports and use the proper authentication to communicate, if you run into any issue let us know.

Was this reply helpful? Yes No