BrianFord
asked on
Dynamics GP Web Service
I've spent hours trying to find how to create a new (or update an existing) inventory item in GP 10 using Web-Services.
Does anyone know if GP 10 web services even supports this?
If so any sample VB code would be greatly appreciated.
Thanks
Does anyone know if GP 10 web services even supports this?
If so any sample VB code would be greatly appreciated.
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
If you don't absolutely need the web services architecture, i.e. your integrations run on your internal network only, I would personally recommend eConnect instead of web services for GP 10. It's faster and more complete, and doesn't require the overhead of IIS and the very heavy web services architecture.
With GP 2010, they have changed the architecture of both eConnect and web services to both use WCF, and have improved web services features, so for 2010 it might be an option, but as you have already found, web services still has some glaring functionality gaps.
Your desire to use an API is good--it makes life much easier, even if it is a relatively simple import. Occasionally you have to do a direct table import for certain items, but if you can use an API, it's much easier to manage in the long run.
Thanks,
Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
If you don't absolutely need the web services architecture, i.e. your integrations run on your internal network only, I would personally recommend eConnect instead of web services for GP 10. It's faster and more complete, and doesn't require the overhead of IIS and the very heavy web services architecture.
With GP 2010, they have changed the architecture of both eConnect and web services to both use WCF, and have improved web services features, so for 2010 it might be an option, but as you have already found, web services still has some glaring functionality gaps.
Your desire to use an API is good--it makes life much easier, even if it is a relatively simple import. Occasionally you have to do a direct table import for certain items, but if you can use an API, it's much easier to manage in the long run.
Thanks,
Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
ASKER
Agreed
Is it safe to say that eConnect does support create inventory items?
What I'm trying to acheive is a single interface for us to maintain item numbers/desriptions etc.. in both GP and CRM, keeping these is sync.
I already have a web form (Intranet only) that deals with tne CRM side and just need to get the GP side done now.
Is it safe to say that eConnect does support create inventory items?
What I'm trying to acheive is a single interface for us to maintain item numbers/desriptions etc.. in both GP and CRM, keeping these is sync.
I already have a web form (Intranet only) that deals with tne CRM side and just need to get the GP side done now.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
Good catch from Abulmalek.
I saw the CreateSalesItem method, but when I glanced at it, for some reason I thought it was to add items to a sales transaction.
But it does appear to be for creating an inventory item--just an unfortunate name choice.
Thanks,
Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
Good catch from Abulmalek.
I saw the CreateSalesItem method, but when I glanced at it, for some reason I thought it was to add items to a sales transaction.
But it does appear to be for creating an inventory item--just an unfortunate name choice.
Thanks,
Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
ASKER
Thanks for both your help, looks like this method should work for me.
ASKER
I could always use the last resort of inserting with SQL but not knowing what tables other than the inventory master that need updating that could also take some time. I'd much rather use an API so as not to have to worry about missing something.