Objective:

We have a Business Central Online that has an empty record in the currency table, which is causing all kinds of problems. No one knows how it got there: By Code, by Rapid Start Configuration Package, ...?

To Ensure data integrity within Microsoft Dynamics 365 Business Central by preventing the creation of critical setup records with empty codes, such as currencies and payment terms, and making them easier to manage and correct.

Key Features:

• Validation Gatekeeper: Implement stricter validation rules in the platform that prevent the creation of setup entries with empty codes across all data entry points, including backend processes like code execution and Rapid Start Configuration Packages.

• Cleanup Tool: Introduce a user interface tool that allows administrators to easily identify and correct invalid records. This tool would list all setup entries with empty or invalid codes and provide options to either correct or delete them directly through the UI.

• Automated Correction Suggestions: When invalid setup entries are detected, the system could suggest valid alternatives or corrections, streamlining the cleanup process for administrators.

Benefits:

This extension reduces support and enhances system stability and reliability by preventing problematic record creation and offering robust tools to manage and correct existing setup entries, thereby addressing critical data integrity issues within Business Central.