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: