Hi Chris,
I believe the field name you want for the Current Period activity is M. Thus what you should see in the cell is =ACCPAC("gldata.M",acct). If you are using Cell references for the account/dept, enter the cell as the parameter to replace 'acct' above. If the account/dept is hardcoded into the formula, enter the required account/department (eg "4000-1000").
There is also a function in Quik Link to print out a list of the fields available in a specific dictionary. From the Quik Link menu, choose Utilities, and Print Data Dictionaries. Pick GL Accounts (GLDATA) and click the Print button. This should allow you to have a printout of all the field names available, for easy reference.
Regards,
Softrak Support