Dimensions play a critical role in financial reporting and transaction classification within Business Central. While dimensions should be carefully planned and maintained, there are situations where changes become necessary due to organizational changes, reporting requirements, or posting mistakes. Because dimensions directly affect financial reporting, changes to dimension values and posted entries should be restricted to administrators or senior accounting users. Allowing too many users access to these functions can create unintended changes and reporting issues.

Editing existing dimension values

Organizations may need to update dimension values after they have been created. When viewing an existing dimension:

• Dimension codes can be changed to a new unique value.
• Dimension names can be updated as needed.
• Special characters should generally be avoided when creating or modifying dimension codes.

Changing a dimension code requires Business Central to update all related posted entries associated with that value. Depending on the number of transactions involved, this process may take time to complete. As a best practice:

• Make dimension code changes when few or no users are actively working in the system.
• Plan code changes carefully before implementation.
• Test changes in a non-production environment when possible.

Changing a dimension name is typically much faster because it does not require updates to posted transactions.

Understanding dimension corrections

Dimension corrections are used to fix mistakes in general ledger entries after transactions have already been posted. Common use cases include:

• Correcting mass-posting errors
• Reclassifying entries to a new dimension value
• Merging reporting categories
• Updating entries when reporting structures change

Dimension Corrections do not eliminate the original transaction. Instead, they ensure that financial reporting accurately reflects the intended dimension assignments.

Creating a dimension correction

To create a correction:

1. Open the Dimension Corrections page.
2. Select New.
3. Enter a meaningful description.

The description should clearly identify:

• Which dimension values are being changed
• What the values are being changed to
• The purpose of the correction

Corrections remain in Draft status until they are run. Once completed, further editing is not permitted.

Defining dimension changes

Within the correction, users specify:

• The dimension being changed
• The current value
• The replacement value

These settings determine how selected General Ledger entries will be updated during processing.

Selecting entries to correct

Business Central provides several methods for identifying affected entries.

Select manually

The Select Manually option allows users to choose specific general ledger entries one at a time. Benefits include:

• Maximum control
• Reduced risk of unintended updates
• Ideal for correcting individual transactions

This method is commonly used when correcting a small number of entries.

Add by filter

The Add by Filter option allows users to pull entries based on specified criteria. Common filters include:

• Posting Date
• Document Number
• Account Number
• Other General Ledger fields

Organizations should test filters on the General Ledger Entries page before running corrections to confirm that the correct records are selected.

Add by dimension

The Add by Dimension option allows users to identify entries based on dimension combinations. This is especially useful when:

• Combining multiple dimension values into one
• Correcting postings made to the wrong dimension
• Updating large groups of entries with similar dimension assignments

Multiple dimension filters can be used simultaneously to target very specific transaction groups.

Managing selected entries

Additional tools are available during the correction process.

Add related entries

This option automatically includes related general ledger entries connected to the selected transaction. It helps ensure all affected entries are updated consistently.

Remove entries

If incorrect records are selected, users can remove them before processing the correction. This helps prevent accidental updates to unrelated transactions.

Running a dimension correction

Once entries and dimension changes have been defined:

1. Review all selected entries.
2. Confirm the new dimension assignments.
3. Select Run.

For smaller corrections, the process can typically be run immediately. For larger corrections:

• Schedule processing during off-hours.
• Minimize impact on system performance.
• Reduce disruption to active users.

After completion, the corrected General Ledger entries display the updated dimension values.

Blocking dimensions from corrections

Certain dimensions may require stricter controls. Business Central includes a Dimensions Blocked for Correction setting that prevents specified dimensions from being modified through Dimension Corrections. This feature is useful when:

• Regulatory requirements exist
• Reporting structures must remain fixed
• Certain dimensions require tighter governance

Blocking a dimension reduces the risk of unintended changes to critical reporting data.

Best practices for dimension maintenance

To maintain accurate reporting:

• Limit dimension editing permissions to administrators and senior accounting users.
• Keep dimension structures as stable as possible.
• Use corrections only when necessary.
• Document all correction activities.
• Review selected entries carefully before running corrections.
• Schedule large changes during low-usage periods.
• Block highly controlled dimensions from correction when appropriate.

Key takeaway

Business Central provides flexible tools for maintaining dimensions and correcting posting errors without compromising financial reporting. By carefully managing dimension updates, using dimension corrections responsibly, and restricting access to qualified users, organizations can maintain accurate reporting while adapting to changing business requirements.