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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Retrieving all GL accounts from GP?

Status
Not open for further replies.

sschantz

Programmer
Aug 10, 2001
9
CA
Hi,
I have begun to play with eConnect com interface to do integration with GP. I need to query GP for all the GL Accounts. I seem not be able to figure out how to do it with the XML interface. Is it possible or must I use store proc to do it?
Thank you.
 
The GL Master table is GL00100. Each segment is stored in a separate column. For example, the test company (TWO) uses ACTNUMBR_1, ACTNUMBR_2 and ACTNUMBR_3. You'll need to trim each to remove spaces and concatenate them. Also know that Great Plains does not use the account number, it uses the Account Index (ACTINDX).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top