Solution:

This knowledgebase article explains how to add fields to tables in Sage Pro ERP

Important
It is recommended that this be done by a Sage Certified Consultant or Business Partner. Create a full and verified backup before proceeding. This should first be attempted in a test installation and the results should be fully verified before implementing in a live system.

Follow the steps below:

1. Open System Manager.
2. Under the Maintain menu, point to Dictionary and click Tables.
3. Type the Table ID for the table to be modified.
4. Select “Field” from the list box.
5. Click Select.
6. Type the name of the new field into the Field Namefield.
7. Press Enter.
8. Click Add.
9. A message appears asking whether to copy the default values from an existing record, click  Field, Data Type or No.
10. If No is selected, the information for the new field must be added manually.
11. Save changes.
12. Update from Data Dictionary

Related Reading
For more information, refer to the “Data Dictionary” section in the System Manager documentation.

© Copyright Sage Software