- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Error #22 Invalid compound statement
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-08-2012 12:46 PM - last edited on 02-08-2012 12:49 PM
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.
Re: Error #22 Invalid compound statement
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
02-08-2012 01:31 PM - last edited on 02-08-2012 01:34 PM
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:
- Open the task that generated the message (but do not click the Lines tab).
- Right click in a blank space on the panel.
- Select Panel Settings, Reset Panel, and Reset All Grids. Click OK.
- Close the task.
If Reset Grids is inaccessible, manually delete the records from the SY_GridDefinition.m4t:
- Have all users exit Sage MAS 90 or 200.
- In Windows Explorer, browse to the ...\Mas90\MAS_System\ folder.
- Create a backup of the SY_GridDefinition.m4t file.
- In Sage MAS 90 or 200, expand Modules, Library Master, and Utilities. Double-click Data File Display and Maintenance.
- Browse to the MAS_System folder, and open the SY_Company.m4t file.
- Click the Key Scan button, and note the key for the affected company.
- Open the SY_User.m4t file in the MAS_System folder.
- Click the Key Scan button, and note the key for the user that is receiving the error.
- Open the SY_GridDefinition.m4t file in the MAS_System folder.
- Click on key scan to find a key that starts with PO_PURCHASEORDER.GD_LINES.
- 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:WorkstationNam
e:Level
eq e.g. PO_PURCHASEORDER.GD_LINES.ABC0000000003MachineName.A000. - Click the Delete button to delete the A000 through A041 records for this user.
- If the error occurs on multiple tabs or for multiple users, repeat the above steps for additional records as needed.
--------------------------------------------------------------------------
You have enemies? Good. That means you've stood up for something in your life.


