Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
unidentified user
cchong
Posts: 1
Registered: 02-08-2012
0

Error #22 Invalid compound statement

[ Edited ]

So im getting this error and cant seem to find a solution. from what ive looked up there a resolution id of 527386 but i cant find what that is. mas was running fine all morning but after lunch, error. ive reinstalled with no avail. i can log into another pc and itll work. whats weird is that i had another user log into mas from my machine and it worked for her, just not for me and only on my computer. 

 

im running version 4.4. on XP.

 

any thoughts?

thanks.

Switcher
BigLouie
Posts: 2,689
Registered: 10-28-2008
0

Re: Error #22 Invalid compound statement

[ Edited ]

Welcome to the Sage Community. Could you please detail a bit more what exactly you were doing when this error message occurred.

 

Here is the resolution but you might need your reseller to assist. From reading this, someone did something.

 

Note: Following the steps below will result in the loss of the screen customization for the affected user. Use caution when working with Data File Display and Maintenance. Always make a backup first. If necessary, seek the assistance of a qualified Sage Software business partner or a Sage Software Customer Support analyst.

 

This issue occurs if an invalid record exists in the SY_GridDefinition.m4t file; screens that have been modified are affected. Follow the steps below to delete the record causing the error. 

Use the Panel Settings to Reset All Grids. Perform the following:

  1. Open the task that generated the message (but do not click the Lines tab).
  2. Right click in a blank space on the panel.
  3. Select Panel Settings, Reset Panel, and Reset All Grids. Click OK.
  4. Close the task.

If Reset Grids is inaccessible, manually delete the records from the SY_GridDefinition.m4t:

  1. Have all users exit Sage MAS 90 or 200.
  2. In Windows Explorer, browse to the ...\Mas90\MAS_System\ folder.
  3. Create a backup of the SY_GridDefinition.m4t file.
  4. In Sage MAS 90 or 200, expand Modules, Library Master, and Utilities. Double-click Data File Display and Maintenance.
  5. Browse to the MAS_System folder, and open the SY_Company.m4t file.
  6. Click the Key Scan button, and note the key for the affected company.
  7. Open the SY_User.m4t file in the MAS_System folder.
  8. Click the Key Scan button, and note the key for the user that is receiving the error.
  9. Open the SY_GridDefinition.m4t file in the MAS_System folder.
  10. Click on key scan to find a key that starts with PO_PURCHASEORDER.GD_LINES.
  11. Use the keys found in previous steps to locate and select the record for that user with the following key combination: FormID:GridName:CompanyCode:UserKey:WorkstationName:Level:smileyfrustrated:eq e.g. PO_PURCHASEORDER.GD_LINES.ABC0000000003MachineName.A000.
  12. Click the Delete button to delete the A000 through A041 records for this user.
  13. If the error occurs on multiple tabs or for multiple users, repeat the above steps for additional records as needed.
Big Louie No MBA but BMOC
--------------------------------------------------------------------------
You have enemies? Good. That means you've stood up for something in your life.