Retrieving all GL accounts from GP?

[sschantz]

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.

 

[bklenzman]

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).