75
I am new to GP, I need help with updating existing Sales Item using Web Services , I am able to create an Item using CreateSalesItem() but when I use the same for update it gives an error "Item Number already exists and the UpdateIfExists flag is set to not allow updates" and I did not find any UpdateSalesItem() method.Please Help.
*This post is locked for comments
I used direct Store procedure "taUpdateCreateItemRcd" to Create and Update Items, For now I am updating Item number, Item Description Class Code,Unit of Measure, User Categories , Cost,weight... but technical we could update all the values that a procedure lets us I guess. I was also able to use Web services to Add Item vendors ,Pricing.
Kiran,
Great Job!!! Did you use eConnect to update Item Master? You don't need to do anything after Item is updated.
Just curious to know which field you have updated?
Thanks
Sandip
I don't see anything in Policy for UpdateIfExist. But eConnect will be only one solution right now I am thinking.
Thanks
Sandip
Thank You Sandip, I have to look into eConnect . The error message, Web services is throwing when Item exist, looks like it is from underlying store procedure because Web services is setting UpdateifExists param value to default which is 0 (not to update), is there any way ( may be using Policy and behavior) or any way where we can change the default values?
Kiran,
Didn't find UpdateSalesItem(). Don't know why Webservices don't have web method for updating Items.
Why don't you use eConnect and wrapped that one into Custom Web Services? Even Microsoft Dynamics GP Web Services use eConnect behind seen.
msdn.microsoft.com/.../ff624038.aspx
Thanks
sandip
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,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (