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.
I don't see anything in Policy for UpdateIfExist. But eConnect will be only one solution right now I am thinking.
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.
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?
I was able to successfully create a new item using aUpdateCreateItemRcd , I like to know is there any other tables that needs to be inserted or updated data before this item can be used?
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?
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.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics