50
Hi,
I am getting problem while creating a sales order in nav 2017 using webservice.
Can anyone suggest me how to create a sales order in nav 2017.
And also explain how to use Ship_to field.
I am getting the following exceptions while creating sales order.
Exception:
1) DataAccessProperty "Editable" for Ship-to Name is invalid!
2) Property "Editable" for Ship-to Code is invalid!'
*This post is locked for comments
ShippingOption gets set to "Alternate Shipping Address" automatically if the Ship_to_Code is populated. I am not even surfacing the ShippingOption field in the NAV page that I created for web services, but it's populated in UI.
We are using Scribe because we are on a tight implementation schedule, and don't have time to implement integration from scratch.
Did you change the init method to change shipping option to alternative address in the sales order page? and another question why do you use scribe for web service?
i think you have to mark your post as "suggested answer" for people to be able to "verify" it.
You are welcome.
If you managed to resolve your issue, please mark all helpful answers as Verified - this would indicate to similar forum members that your issue has been solved.
That was exactly the issue. The ShippingOption is meant to be used in UI, not in web services, that's why it did not work. So, I created a new page for Sales Order for usage with WS, and voila, all is good now. THANKS!
I ended up doing changing ship to to alternative address at the init stage and updating it through a published codeunit function as below,
UpdateShipAddress(InSONo : Text[30];InShipName : Text[30];InShipAddress1 : Text[30];InShipAddress2 : Text[30];InShipCity : Text[30];InShipCounty : Text[30];InShipPostcode : Text[30])
Order.SETFILTER("No.",InSONo);
Order.FINDFIRST;
Order."Ship-to Code" := '';
Order."Ship-to Name" :=InShipName;
Order."Ship-to Address" :=InShipAddress1;
Order."Ship-to Address 2" :=InShipAddress2;
Order."Ship-to City" :=InShipCity;
Order."Ship-to County" :=InShipCounty;
Order."Ship-to Post Code" :=InShipPostcode;
Order.MODIFY;
Hi,
I suggest you to create a new page based on the Sales Order page but without the "special" fields ShipToOptions and BillToOptions.
Instead of these ones, add Ship-to Code and Bill-to Customer No.
I did this and everything is OK.
Let me know if I helped.
Any update on this?
I need to be able to use one of the existing Shipping Addresses as the Ship-To on the Sales Order. I have tried setting ShippingOption to either "Custom Address" (gives not editable field error) or to "Alternate Shipping Address" (gives "loopback error" in Web Services, because NAV generates a Shipping address pop-up at that stage, which WS cannot process).
I am using SCRIBE for web services.
I still could not understand how to change ship to, so i cant help on that. Im still looking for how to do it in a proper way. as soon as i find anything i will update. I have created a fully functioning pos system using above link and have extended it to do many things.
You need to follow below link to create sales order through web service
blogs.msdn.microsoft.com/.../extending-page-web-services-and-creating-a-sales-order-again
It works and im using this method to create orders via a vb.net program
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,375
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
