Downloads |Customization |Services |Videos |Partners |About |Contact
TaiRox Software |Partners |About |Contact |Downloads
Communications |Videos |Customization |Services
User Guide(s)
Product Distribution File
Release Notes
Platform Requirements
Application Suite
Automate G/L Consolidation
Download Rates
Productivity Tools
SOX Check Approval
SOX Second Sight
SOX User Management
TaiRox Collections
TaiRox CRM and Collections
Data Management Suite
Copy Company
Fast Clear History
Fast Data Integrity
Fast Database Management
Optional Field Manager
Web Store Integration
Free Diagnostic Software
Install Check
Optional Field Manager
Available for $995 + $250 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. PDF BrochureVideo *This price is effective May 1, 2024.
Read: A Comprehensive Guide to Sage 300 Optional Fields.
*New* Support is added for Sage 300 2024.
*New* Support is added for Sage 300 2023.2 and 2023.3.
*New* When logging into a SQL Server instance, a checkbox allows users to remember SQL Server passwords. The remembered passwords are encrypted. Picture.
optional-field-manager-menu.png optional-field-manager-menu.png
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.
optional-field-manager-delete.png optional-field-manager-delete.png
Add Optional Field Values. When an 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 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.
optional-field-manager-add-values.png optional-field-manager-add-values.png
Rename Optional Fields. Change the name or description of an optional field in all tables.
optional-field-manager-rename.png optional-field-manager-rename.png
Update Optional Field Counts. Repairs a database inconsistency (integrity error) that can occur when one of the optional field counts does not match the number of actual records containing the optional field.
optional-field-manager-update-counts.png optional-field-manager-update-counts.png
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 2024: A single executable program works with these platforms.
• .NET Framework 4.6.2 or higher is required.
•  Detailed Platform Requirements