Link to home
Start Free TrialLog in
Avatar of Dan
DanFlag for United States of America

asked on

Dynamics GP Inventory item status question

Hopefully this will be a really easy question.  We are in the process of rolling out Dynamics GP and I am writing scripts to update our eCommerce store with products and on hand quantities so that they will pull from GP and not our current inventory mangement software.  The problem is I don't know what any of the field names are.  Some of which I'm not even if they exist in the same form I'm used to.  For example our current system has an ISBN field but I don't know if that even exists in GP.  Perhaps there's a UPC field?  I am sure that there is a way to mark an item as active/obsolete/on hold etc.  Does anyone know what those fields might be and what table they're in?

Thanks
Avatar of lcohan
lcohan
Flag of Canada image

Here's where you find all you need from DEV point of view:

http://msdn.microsoft.com/en-us/dynamics/gp/default.aspx

and here's the "Microsoft Dynamics GP 10.0 Tools Documentation: Integration Manager" part:

http://www.microsoft.com/downloads/details.aspx?FamilyID=34657aaa-731d-4cd3-b837-a901848bf64d&displaylang=en


ASKER CERTIFIED SOLUTION
Avatar of Victoria Yudin
Victoria Yudin
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dan

ASKER

Icohan --

Thanks for the idea, but I had already tried the forums with no success.

Victoria --

Thanks for the information.  I suspected that about ISBN.  I am a bit surprised about Status.

I guess I'll try that.