GL20.2 query

marty

We do not use financials but have the GL set up just enough to send payroll information to our ERP. One of our process levels is re-activating an old posting account on many accounting units, and I'm trying to find a query to see if the posting account is already set to Yes - Exists without having to look into each one individually. I am struggling to find a way through Add-Ins to query GL20.2. Can anyone help?

unknown

The table is GLMASTER in the IF system code. Limit the query by the GL Account number. This table doesn't store every Acct Unit and GL Account - it only has those that a) exist or b) exist and are inactive. In other words, if GL20.2 shows "No" then it won't be in this table. You can also run a GL222 out of Lawson.