Business Central State Field Customizations
This blog talks about Business Central State field customizations via the lookup table. It offers a solution to restrict the users.
Introduction
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:
- Allow only specific users to update states.
- Admin user should only be able to edit the state values in the vlookup table.
- 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.
And now, after my change this is how the sales order screen looks like:
- State field, Country is disabled
- 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.
Now the user would see the 3 dots to open the table for State
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:https://learn.microsoft.com/en-us/dynamics365/business-central/ui-customizing-overview
Drop a Message
Email Us
Fill up your details
Get Custom Solutions, Recommendations,
Estimates.
What's next?
One of our Account Managers will contact you
shortly
Related Post
Business Central State Field
Business Central State Field
This blog talks about the issues that you face while using Business Central State fields as it does not restrict from entering any state.
Business Central Web Service APIs
Business Central Web Service APIs
This blog talks about Business Central Web Service APIs and its easy availability to various external systems and users.
Business Central- Top 8 Unique Features
Business Central- Top 8 Unique Features
This blog talks about Business Central Top 8 Unique Features and why migrating to this ERP system is a good idea.
Business Central Getting Started with discounted licensing and extended free trial
Business Central Getting Started with discounted licensing and extended free trial
This blog talks about Getting Started with Business Central and how you could be getting discounted licensing and extended free trial