Add, Add by Dimension, Add by Filter, Add Related Entries, Analysis Views, BC18, Business Central, Change, Combinations, Completed, Correction, Correction Setup, Delete, Dimension, Dimension Corrections, Draft, Dynamics 365, Functional Tips, G/L Entries, G/L Register, General Ledger Entries, History, How To, Information, Modify, Posted General Journal, Reversing, Run, Schedule, Select Manually, Tip & Tricks, Trace, Undo, Updating, Validate, What's New

How can we Correct Dimension in Microsoft Dynamics 365 Business Central?

You can do correction by reversing the journal or creating a credit memo for the document, which will be time consuming and can attract to even more errors.

Now you can correct dimensions for general ledger (G/L) entries to ensure your financial reports is providing you with accurate insights. For G/L entries, you can now

  • change the dimension values
  • add new dimensions
  • remove wrong ones

You can also trace a history of the corrections that you have done and can undo corrections in case you had made a mistake in the corrections itself.

Before you continue let me remind you:

Although the Dimension Correction feature only updates general ledger entries, still it can be helpful in many cases with creating accurate financial reports.

You must decide when to use the corrections because when you perform correction, it will result in differences between the dimensions in finance and sub-ledgers. The earlier you decide on what corrections to use, the less manual corrections you’ll need to do in the future.

I am using BC18 Demo database.

 How to run the Dimension Correction

General Ledger Entries. You can change the dimensions for single or multiple entries just by selecting the entries.

G/L Register. You can change the dimension per batch posting. By using “From Entry No.”, “To Entry No.” as a filter for General Ledger Entries.

Posted General Journal. You can use “Document No.” and “Posting Date” as filters for General Ledger Entries.

Search for Dimension Corrections Page.

Draft Dimension Correction Screen:

Depending upon from where you Launched the Dimension Correction, it may come with pre-filled or as blank screen.

You have several options to work with dimensions:

  • You can Add New Dimensions
  • You can Remove existing Dimensions
  • You can Change the existing Dimensions

For Selecting Entries to which above changes applies you have different options to work with.

  • Add related entries. This requires at least 1 G/L Entry already to be selected, and then it adds all other G/L Entries with the same “Transaction No”.
  • Select Manually. You can manually select in the G/L Entries by just choosing them.
  • Add by Filter. Here you have all freedom of choice, how to filter your G/L Entries for the dimension corrections.
  • Add by Dimension. This can be useful if you want to change the dimension value Sales to Admin for all G/L entries. So, you find all G/L Entries with the Dimension Sales.

You can omit/remove selected entries, or change selection criteria for your entries to be applied with changes.

Updating Dimension Values

Above we create a Dimension Correction, the Status is initially DRAFT, it means the G/L Entries Dimension is NOT yet updated.

Once you are done in the Dimension change to move forward you have two option to go thru:

  • Click the Validate dimension change then click RUN.
  • Click RUN.

Validate change

This will check if it’s possible to make the dimension changes you specified.

  • Check Dimension Correction Setup.
  • Check Dimension Combinations.

Once the validation run successfully you can see it in the Validation status.

You can choose to run the job immediately or schedule in case you are operating on larger data set.

Next you can now use the Run action button. This will Apply changes to the General Ledger Entry Dimensions.

How to trace the correction

General Ledger Entries. You can see all the dimension corrections that you’ve done for the selected entries.

Search the Dimension Corrections. You can see all the Dimension corrections that you’ve done even the ongoing dimension corrections will be listed here.

Undo a Correction


In the dimension correction page just click the UNDO. This will be executed as a Job. The user will have to choose, how he wants to apply changes: running the job immediately or schedule it.

It is recommended to run the schedule if you are working with larger data set, to avoid the table locking during posting of other transactions.

Once the Job execution completes, you will see the status change to UNDO COMPLETED.

How to Update the Analysis Views

From the Dimension Correction page, you can also update you’re Analysis Views by clicking the Update Analysis Views button. This will be executed as a Job. You will have to choose, how you want to apply changes: running the job immediately or schedule it.

It is recommended to run the schedule if you are working with larger dataset, to avoid the table locking during posting of other transactions.

Hope you enjoyed the information. Will come with more similar information in my next posts. Till then keep exploring, learning and sharing your knowledge with others.

Remain safe, take care of your loved ones, put your mask, maintain safe distance and don’t forget to get vaccinated.

BC18, Business Central, Copy Journal, Functional Tips, How To, Information, Posted General Journals, Tip & Tricks, Wave 2, What's New

Copy Journal function on Posted General Journals in Business Central

Working with large journals can be cumbersome to correct if you make mistakes.

Earlier we used to do customizations for our customers to get this done. But now this feature is available in the product.

Now with the Wave 2 release of Dynamics Business Central you can use the copy journal function on Posted General Journals.

User have ability to reverse the entries based on posted General Journals.

I am using Accountant Profile.

Search for General Journal Template, make sure you have check mark under Copy to Posted Jnl. Lines for template which you wish to use for this purpose.

Journals-> General Journal

Similarly, the Check mark on Batch which you will use for this purpose.

Search for Posted General Journal

You will find no entries as you can see in previous screenshot for Default Batch Copy to Posted General Journal check mark is clear and any entries posted using that batch is not available.

Now put the Check mark and post the entries.

Now re-open Posted General Journal after posting few entries.

Select the Lines you wish to reverse

Select Copy Selected Line to Journal

Fill the request page, Your Template & Batch to Use, if you wish to change the Posting Date & Document No. If you wish to change the Sign and then press OK.

Your Journal Lines will be created as per the information provided on request page:

Below is the Screenshot after posting the entries:

I have exported to Excel and hidden few columns to show the output.

Entries marked in red rectangle is the entries posted post above operation and options selected on request page.

So now you know how to use this feature, share with your customers and help to make their life easy. Hope you liked and enjoyed learning this feature.

See you in next post, till then keep exploring, learning and sharing with others.

Now we have YouTube channel too, you can find link on Menu, first ever Dynamics Navision & Business Central Channel in Hinglish. You will get videos of demonstration in Mixed Language English as well as in Hindi. This will help both those who are comfortable with English and also with Hindi. Don’t forget to Subscribe and post your suggestions to improve the channel.

Channel Link

https://www.youtube.com/channel/UCm1JWr26UO5GqXiOHWhVD4A