Add a new field to invoice in sage x3

To add a new field to an invoice in Sage X3, you'll need to follow these steps:

Prerequisites:

  1. You have a basic understanding of Sage X3 and its navigation.
  2. You have the necessary permissions to modify the system (e.g., System Administrator or Developer role).

Step 1: Identify the Invoice Table

In Sage X3, navigate to the "Tables" menu and search for "INVOICE". This will take you to the "INVOICE" table.

Step 2: Create a New Field

Click on the "Fields" button on the top-right corner of the screen. This will open the "Fields" window.

  1. Click on the "New" button to create a new field.
  2. Enter a name for the new field (e.g., "New Field 1").
  3. Choose the data type for the new field (e.g., Character, Numeric, Date, etc.).
  4. Set the length or precision for the new field (if applicable).
  5. Click "OK" to create the new field.

Step 3: Add the New Field to the Invoice Table

  1. Go back to the "INVOICE" table.
  2. Click on the "Fields" button again.
  3. In the "Fields" window, select the new field you created (e.g., "New Field 1").
  4. Click the "Add" button to add the new field to the "INVOICE" table.

Step 4: Configure the New Field

  1. In the "INVOICE" table, click on the "Edit" button next to the new field (e.g., "New Field 1").
  2. Configure the field settings as needed (e.g., default value, validation rules, etc.).
  3. Click "OK" to save the changes.

Step 5: Test the New Field

  1. Create a new invoice or edit an existing one.
  2. Verify that the new field is displayed and can be populated with data.

Additional Tips:

By following these steps, you should be able to add a new field to an invoice in Sage X3. If you encounter any issues or have further questions, feel free to ask!