Adding of field in another table

Business Central/NAV Developers Forum
1

How to add the field in the table in Business Central i.e. I want to add field of Bank Account in the table of Sales Header.

2

Extend the sales header page tabele and the field you wanted. Then add the field in the page also may be sales quotes, sales order where you wanna see it.

3

To add a field to the Sales Header table in Business Central:

  1. Go to the Search bar and type “Table” and select “Table” from the dropdown menu.
  2. In the Table List, locate and select the “Sales Header” table.
  3. Click on the “Design” button at the top of the window.
  4. In the Table Designer window, locate the last row and add a new row.
  5. In the “ID” field of the new row, enter a unique ID for the field. This ID will be used to reference the field in other parts of the system.
  6. In the “Name” field of the new row, enter a name for the new field, such as “Bank Account”.
  7. In the “DataType” field, select the appropriate data type for the field, such as “Code”.
  8. If required, set any additional properties for the field, such as “Max. Length” or “OptionString”.
  9. Save the changes to the table.

After adding the field, you may also need to update any related pages or reports to include the new field.