sql – Great Plains query to get GL codes

sql – Great Plains query to get GL codes

The GP back end is not the most stright forward to query as every company is in a unique database.

select      ACTINDX
    ,       ACTNUMBR_1
    ,       ACTNUMBR_2 
    ,       ACTNUMBR_3
    ,       ACTNUMBR_4 
    ,       ACTNUMBR_5
    ,       ACTALIAS
    ,       MNACSGMT
    ,       ACCTTYPE 
    ,       ACTDESCR
from GL00100

The above code will give you the GL account listing in addition the the ACTINDX (OID). Id recommend starting with the following links as a starting resource for more complex queries:

http://www.gp-dynamics.com/dynamics-gp-tips-and-tricks.asp

http://victoriayudin.com/gp-tables/

sql – Great Plains query to get GL codes