Optional Field Manager
|
Available for $795 + $200 per year, Optional Field Manager performs operations on Sage 300 optional fields: Delete Old Optional Fields, Add Optional Field Values, Rename Optional Fields
and Update Optional Field Counts.
|
|
Watch:
Optional Field Manager
|
Read:
A Comprehensive Guide to Sage 300 Optional Fields.
|
|
*New* When logging into a SQL Server instance, a checkbox allows users to remember SQL Server passwords.
The remembered passwords are encrypted.
Picture.
|
*New* Supports Sage 300 2022.
|
*New* Adds the ability to rename optional fields.
|
|
|
|
Delete Old Optional Fields. Delete fields that are no longer required from a Sage 300 database.
A selected optional field will be completely deleted from all tables with an option to remove the optional field definition
from common services. Rows are deleted and counts are updated appropriately.
|
|
|
Add Optional Field Values. When a optional field is added in Sage 300, table rows are not populated with an initial
or default value. If the optional field is required, some operations cannot be performed until a value is present.
This add operation provides such a value for all rows in a table or tables without affecting existing values.
This operation is available for master file and setup tables, not for transaction tables.
|
|
|
Rename Optional Fields. Change the name or description of an optional field in all tables.
|
|
|
Update Optional Field Counts. Repairs a database inconsistency (integrity error) that can occur when one of the optional field counts doesn't match
the number of actual records containing the optional field.
|
|
|
Features and Benefits
|
• | Supports all optional field types: Text, Amount, Number, Integer, Yes/No Date and Time. |
|
• | Operates in seconds. |
|
|
|
Platform Requirements
|
• | Sage 300 2012 to 2022: A single executable program works with these platforms. |
• | .NET Framework 4.6.2 or higher is required. |
• |
Detailed Platform Requirements |
|