Business Central State Field Customizations


In this blog, we will talk about Business Central State Field Customizations. As mentioned in the last article, we are trying to control the value in the state field so that more validations can run on them..

We have created a lookup table which is updated based on the specific country in the configuration. The user can select the state based on a lookup table.

There are some more checks and balances we could add. For example:

  1. Allow only specific users to update states.
  2. Admin user should only be able to edit the state values in the vlookup table.
  3. Restrict editing state field on the UI and user should only be selecting the state from the lookup table. We can also make state field mandatory for specific countries, if needed.

We created custom roles and permissions and assigned the user profiles; whoever has the right role will be able to update the State lookup table.

Here, we update the value of the table from which state lookup table is valid. We specified the country as US, so the checks will run only for the US.

Here is a screenshot of- How I am able to add any state in the sales order field before my change.

Table Description automatically generated with medium confidence

And now, after my change this is how the sales order screen looks like:

  1. State field, Country is disabled
  2. It can be selected when clicking on the pop up of Zipcode.

To see the available option of state field click on the 3 dots.

Graphical user interface, chart Description automatically generated

Now the user would see the 3 dots to open the table for State

Graphical user interface, application Description automatically generated

Conclusion- Business Central State Field Customizations

With this change we are now able to restrict user to only select the state values from the available options. This would then prevent the user from randomly entering an incorrect value. Hence, giving lesser issues when trying to collate the data state wise for reporting, taxation or compliance purposes.

For more information:

Get In Touch If You Have A Business Query

Related Posts