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).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.