Sage 100

That's a great point Kevin – third party mods that add columns would need to be reinstalled if you took that route. Plus, any custom office changes would be gone  

 I have a utility that I have used in the past that was hard coded to read through the SY_GridDefinition and remove records for a specific user key and module. I have only used this twice; both times the same client when users were getting errors on the lines tab of purchase order receipt of goods entry. I could tell the errors were related to corrupted grid records. this client was also quite large with about 45 users and years of history.

 I could update that utility to prompt for:

• 10-digit User Key (optionally allow user to type in ALL for all users).
• Module Code: formatted as X/X (optionally allow user to type in ALL for all modules).

The utility would only remove records with a level "A" (user specific). So master developer and custom office records remain untouched.

Since I've never really used this except in 2 very specific circumstances, does anyone think this would be a safe and/or helpful utility?  I would test it internally, but it would anyone have a more complete test install for more thorough testing?

I welcome any thoughts.

That's a great point Kevin – third party mods that add columns would need to be reinstalled if you took that route. Plus, any custom office changes would be gone  

 I have a utility that I have used in the past that was hard coded to read through the SY_GridDefinition and remove records for a specific user key and module. I have only used this twice; both times the same client when users were getting errors on the lines tab of purchase order receipt of goods entry. I could tell the errors were related to corrupted grid records. this client was also quite large with about 45 users and years of history.

 I could update that utility to prompt for:

• 10-digit User Key (optionally allow user to type in ALL for all users).
• Module Code: formatted as X/X (optionally allow user to type in ALL for all modules).

The utility would only remove records with a level "A" (user specific). So master developer and custom office records remain untouched.

Since I've never really used this except in 2 very specific circumstances, does anyone think this would be a safe and/or helpful utility?  I would test it internally, but it would anyone have a more complete test install for more thorough testing?

I welcome any thoughts.

That's a great point Kevin – third party mods that add columns would need to be reinstalled if you took that route. Plus, any custom office changes would be gone  

 I have a utility that I have used in the past that was hard coded to read through the SY_GridDefinition and remove records for a specific user key and module. I have only used this twice; both times the same client when users were getting errors on the lines tab of purchase order receipt of goods entry. I could tell the errors were related to corrupted grid records. this client was also quite large with about 45 users and years of history.

 I could update that utility to prompt for:

• 10-digit User Key (optionally allow user to type in ALL for all users).
• Module Code: formatted as X/X (optionally allow user to type in ALL for all modules).

The utility would only remove records with a level "A" (user specific). So master developer and custom office records remain untouched.

Since I've never really used this except in 2 very specific circumstances, does anyone think this would be a safe and/or helpful utility?  I would test it internally, but it would anyone have a more complete test install for more thorough testing?

I welcome any thoughts.

That's a great point Kevin – third party mods that add columns would need to be reinstalled if you took that route. Plus, any custom office changes would be gone  

 I have a utility that I have used in the past that was hard coded to read through the SY_GridDefinition and remove records for a specific user key and module. I have only used this twice; both times the same client when users were getting errors on the lines tab of purchase order receipt of goods entry. I could tell the errors were related to corrupted grid records. this client was also quite large with about 45 users and years of history.

 I could update that utility to prompt for:

• 10-digit User Key (optionally allow user to type in ALL for all users).
• Module Code: formatted as X/X (optionally allow user to type in ALL for all modules).

The utility would only remove records with a level "A" (user specific). So master developer and custom office records remain untouched.

Since I've never really used this except in 2 very specific circumstances, does anyone think this would be a safe and/or helpful utility?  I would test it internally, but it would anyone have a more complete test install for more thorough testing?

I welcome any thoughts.

That's a great point Kevin – third party mods that add columns would need to be reinstalled if you took that route. Plus, any custom office changes would be gone  

 I have a utility that I have used in the past that was hard coded to read through the SY_GridDefinition and remove records for a specific user key and module. I have only used this twice; both times the same client when users were getting errors on the lines tab of purchase order receipt of goods entry. I could tell the errors were related to corrupted grid records. this client was also quite large with about 45 users and years of history.

 I could update that utility to prompt for:

• 10-digit User Key (optionally allow user to type in ALL for all users).
• Module Code: formatted as X/X (optionally allow user to type in ALL for all modules).

The utility would only remove records with a level "A" (user specific). So master developer and custom office records remain untouched.

Since I've never really used this except in 2 very specific circumstances, does anyone think this would be a safe and/or helpful utility?  I would test it internally, but it would anyone have a more complete test install for more thorough testing?

I welcome any thoughts.

That's a great point Kevin – third party mods that add columns would need to be reinstalled if you took that route. Plus, any custom office changes would be gone  

 I have a utility that I have used in the past that was hard coded to read through the SY_GridDefinition and remove records for a specific user key and module. I have only used this twice; both times the same client when users were getting errors on the lines tab of purchase order receipt of goods entry. I could tell the errors were related to corrupted grid records. this client was also quite large with about 45 users and years of history.

 I could update that utility to prompt for:

• 10-digit User Key (optionally allow user to type in ALL for all users).
• Module Code: formatted as X/X (optionally allow user to type in ALL for all modules).

The utility would only remove records with a level "A" (user specific). So master developer and custom office records remain untouched.

Since I've never really used this except in 2 very specific circumstances, does anyone think this would be a safe and/or helpful utility?  I would test it internally, but it would anyone have a more complete test install for more thorough testing?

I welcome any thoughts.