BeyondERP.Newsletter
Menu

Setup page · System administration

Custom fields

A setup page that lists every custom field in the system, table by table, and lets you manage them.

Used by
Information technology manager
Business process
Administer system features
Menu item
SysCustomFieldManageFields
Main table
SysCustomFieldDefinitionTmp
Setup steps
1 on this page
Show what matters for
PAGE GUIDEWhat the page does and how to use it8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page that lists every custom field in the system, table by table, and lets you manage them.
What you do hereUse this page to view, edit, delete and translate custom fields that were added from the user interface, and to show them on data entities.
ExampleFor example, BEAT adds a Picklist custom field Delivery zone with the values North, South and East to the customer page, then enables it on the customer data entity here so the zone is included when customers are exported or edited in Excel.
Custom fields page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Step by step, with screenshots

Set up Custom fields1 screen

Use this page to view, edit, delete and translate custom fields that were added from the user interface, and to show them on data entities.

  1. Screen 1

    Review the custom fields

    Go to System administration > Setup > Custom fields

    1. Select a table to list the custom fields added to it
    2. Select a field to review its name, type, label and help text
    3. Open the Entities section to see which data entities show the field
    4. Select Apply changes after editing or deleting a custom field
    Review the custom fields (zoomed on the outlined fields)
    Show the full screenReview the custom fields
    page title tab to open what to set or check

Steps from Microsoft

  1. Go to System administration > Setup > Custom fields and select the custom field.
  2. Expand the Entities section to see the related data entities.
  3. Select Edit.
  4. Select Enabled for each entity that should show the field.
  5. Select Apply changes.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Enabled (Entities)Shows the custom field on the selected data entity, for Office integration and data import and export.Microsoft Learn
TranslationsAdds or edits the label and help text of the field in other languages.Microsoft Learn
Apply changesSaves the edits made for the selected table.Microsoft Learn

Common errors and fixes

MessageWhat to do
A custom field is missing from an export or from the Excel add-inOn Custom fields, select the field, expand Entities, select Enabled for the data entity and select Apply changes. Microsoft Learn

Test checklist

  1. Create the custom field from Personalize this form and insert it on the page.
  2. On Custom fields, select the field, enable it on the needed entity and select Apply changes.
  3. Add a translation for the label and check it in a user with that language.
  4. Export the entity and check that the field and its values are included.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Custom fieldsAgree each field's name, data type and picklist values before creating it, and enable it only on the entities that need itAfter creation only the label, help text and text length can be edited; the field name and data type can't change and picklist values can't be removed. There's a limit of 20 custom fields per table.Should the requirement be met with a custom field or with an extension field?Deleting a custom field to fix a mistake. Deletion can't be undone and permanently deletes the field's data.Test: Custom field shows on its data entity

Feature management and licence

Licence or add-inOn this system the page opens for Information technology manager. Only users with special permissions can create custom fields. No Feature management feature needs to be turned on for this page.

Microsoft Learn

Solution architect

5Design impact

Can it be undoneOne-way: Warning: A deleted custom field and its data can't be restored, and the field name, data type and existing picklist values can't be changed after creation. Microsoft Learn
If you change it laterDeleting a custom field can't be undone and permanently deletes its data; the field name and data type can't be changed after creation. Microsoft Learn
Technical architect

6Technical

Menu itemSysCustomFieldManageFields Checked in Dynamics 365
FormSysCustomFieldManageFields Checked in Dynamics 365
TableSysCustomFieldDefinitionTmpShown as “Custom fields” in Record infoChecked in Dynamics 365
Who can open itPrivilegesManage all custom field definitions SysCustomFieldManageFieldsMaintainDutiesManage all custom field definitions SysCustomFieldManageFieldsMaintain
1 security roleInformation technology manager SysServerITManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can open this page.Checked in Dynamics 365
Actions on the pageOptions: Page options, ShareChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=SysCustomFieldManageFields
Data migrationLoad order: Custom fields has no data entity in Data management, so it can't be loaded from a file or a configuration template. Microsoft recommends re-creating each custom field by hand in the target environment from this page's list for the table, selecting Apply changes, and then exporting the personalizations that show the fields and importing them in the target environment.Microsoft Learn
Everyone

8Sources