Solved

Dynamics GP Web Service

Posted on 2011-03-22
7
1,205 Views
Last Modified: 2013-12-11
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
0
Comment
Question by:BrianFord
  • 3
  • 3
7 Comments
 
LVL 18

Assisted Solution

by:Steve Endow
Steve Endow earned 250 total points
ID: 35194626
Hi,

To my surprise, I don't see any GP web services method to create an inventory item.  Baffling.

I also checked the GP 2010 web service reference, and I don't see it there either.

I don't understand why it is not included, since eConnect has had it for years.

I personally just stick with eConnect, since very few environments specifically require a web services interface, so I've never realized that it was missing from web services.

If you don't have it already, I strongly recommend getting a copy of the GP web services reference help file (.chm).  It lists all of the available methods, and includes all of the field values.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional
0
 

Author Comment

by:BrianFord
ID: 35194655
I've never used eConnect, guess I'll nned to get familiar with:)

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.
0
 
LVL 18

Expert Comment

by:Steve Endow
ID: 35194745
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
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:BrianFord
ID: 35194763
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.
0
 
LVL 10

Accepted Solution

by:
Abdulmalek_Hamsho earned 250 total points
ID: 35197562
CreateSalesItem to create Inventory Item.
0
 
LVL 18

Expert Comment

by:Steve Endow
ID: 35198982
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
0
 

Author Closing Comment

by:BrianFord
ID: 35200664
Thanks for both your help, looks like this method should work for me.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
Getting data out of MAS90 doesn’t have to be tedious or time consuming.  With any version of Excel using the included Microsoft Query function, you can access just about any data set or combination of data sets stored in your MAS90 MAS200 Software. …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question