Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
integrating a vb.net app with Great Plains
- Thread starter kurzo
- Start date
There is a sdk on the installation disks. This will list some table name descriptions and links, etc.
There are no APIs to great plains. It is built on a 4GL system. It is not object based. Parts of the code are in stored procedures and some in dexterity script.
You have several options: Integration Manager/Integration Manager for Excel or a custom sql upload to the underlying tables. A basic G/L batch upload integration shouldn't be too hard for an experienced programmer to write. I'd recommend you start off by keying in the data you want and using sql profiler to see what data and where the system is pulling it from.
There are no APIs to great plains. It is built on a 4GL system. It is not object based. Parts of the code are in stored procedures and some in dexterity script.
You have several options: Integration Manager/Integration Manager for Excel or a custom sql upload to the underlying tables. A basic G/L batch upload integration shouldn't be too hard for an experienced programmer to write. I'd recommend you start off by keying in the data you want and using sql profiler to see what data and where the system is pulling it from.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question