When reviewing the database, there are invalid entries for certain look up fields such as cost center, account, manufacturer and other areas. It is not known who entered or how this data was entered into the lists as only certain people have access to the system administration module. Mainsaver provides ‘Add on the Fly’ permission to quickly enter new fields as data is entered. However if too many users have this permission, it could result in erroneous values stored in the lookup tables.
User is entering an incorrect value
If the user has ‘add on the fly permission’, they will be asked if they want to enter the new value into the reference table.
In System Administration, under Application Security, make sure than under the ‘General’ category that ‘Generic add on the fly’ is disabled for general users. This will prevent members of this user group from typing in new values to add on the fly fields. (Hint; be sure every user is a member of at least one user group).
- Add asset on the fly: If an unknown asset number is entered on a work order, the user will be allowed to enter a new asset.
- Add stock location on the fly: When adding parts, a new bin location can be entered on the part entry form.
- Add UOM conversion on the fly: In the parts master or receipt screens, if a part with a different issue and receive unit of measure is encountered, the user will be able to enter the conversion factor. For example, oil received in a drum but issued by the gallon would have a conversion factor of 55 gallons per drum or .018 drums per gallon.
- Parts Master Add on the fly: Only applies to Mainsaver Interconnect Module
Data will be much cleaner by preventing entry on incorrect values in the Mainsaver standard tables. If one of the incorrect values is used in assets or work orders it might take SQL commands to clean up the errors.