|
Optional Field Manager
|
|
Available for $595 + $150 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 Fields Counts. All operations preserve or correct data integrity issues.
|
|
Read:
A Comprehensive Guide to Sage 300 Optional Fields.
|
|
|
Watch:
6:26 Optional Field Manager: Support for Optional Fields in Sage 300
|
|
|
*New*
Support has been added for Sage 300 2022.
|
|
*New*
The ability to rename optional fields has been added.
|
|
*New*
Support has been added for Sage 300 2021 and Azure.
|
|
*New* Performs operations on optional fields for Sage 300 multiple contacts.
|
|
|
|
|
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 fields 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. |
|
