Great Plains Integration

[katiebruno]

Has anyone out there integrated AbleCommerce with Great Plains or have a suggested strategy? I have a client with a very large inventory with all sales information in Great Plains and they would like to have real time sales numbers for both the warehouse and the webstore integrated so that they can share the same inventory.

[AbleMods]

I haven't heard of anything yet for Great Plains. Does GP have an SDK or API interface?

I haven't worked with GP for many years...didn't realize it was still around.

[katiebruno]

Yes it does.

http://msdn.microsoft.com/en-us/library/ms994230.aspx

My question to the client is what version of Great Plains are they running. If they are in the .NET version, I am willing to go for it. If they are still using the legacy Dexterity version, forget it.

[AbleMods]

That's why I haven't seen it in a while, Microsoft bought it

Even if it's in .Net, you're still going to hit the server-side execution wall. Since AC7 is server-side code, GP will have to be on the web server as well or you'll have to expose the SQL db to the internet. Neither makes me feel real warm and fuzzy.

Otherwise, downloading the db to a local SQL install will be your only practical option although it's not very efficient. If Able gets some docs out on the data client API, things can get a whole lot simpler.

I'm writing a one-way Quickbooks interface right now...been going round-and-round on this for weeks now.

Welcome to the downside of server-side code execution