web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Using GP web services ...
Microsoft Dynamics GP (Archived)

Using GP web services to update Sales Items

(0) ShareShare
ReportReport
Posted on by Kiran_GP 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 have the same question (0)
  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    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

  • Kiran_GP Profile Picture
    Kiran_GP 75 on at

    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?

  • Verified answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    I don't see anything in Policy for UpdateIfExist. But eConnect will be only one solution right now I am thinking.

    Thanks

    Sandip

  • Kiran_GP Profile Picture
    Kiran_GP 75 on at

    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?

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    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

  • Kiran_GP Profile Picture
    Kiran_GP 75 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans