An email was just sent to confirm your subscription. Please find the email now and click 'Confirm Follow' to start subscribing.
You have already subscribed to this site. Please check your inbox.
You can manage your preferences at subscribe.wordpress.com
If you are as ecstatic as I am to find out that Microsoft released the ability to Correct Dimensions on G/L Entries, then you probably can’t wait to find out if it’s really everything you thought it would be. If you haven’t had time to check into it yourself, don’t worry; I did some legwork for you by testing the functionality in a preview environment. Read on to see what I found.
You probably want to know first and foremost what additional setup is required on your part—I will tell you that there really is not much. The only setup is related to disallowing users to change values in dimension sets for specific dimension codes. You can select dimensions that cannot be corrected in Dimension Correction Settings. Selecting here will block users from adding/changing/removing dimension values for this dimension code.
Microsoft also mentions in the release notes that “Administrators can specify that corrections must respect closed accounting period.” I couldn’t find anything new in the system to control this, so it’s possible that control yet to be added. I talk more about this point at the end of this article.
Keep in mind that Permissions may also affect users’ access to this new feature.
Now for the good part! How does the feature work? Is it easy? Will users change values by accident? I have all those answers for you right here.
There are a few different places in the system you can activate the dimension correction feature. I will illustrate its use through General Ledger Entries and the new options available in the Action Bar. Let me walk you through the steps.
As you work through the different steps to Validate and Run, you can see the different correction statuses for each line in History of Dimension Corrections page. The different statuses are based on how far along you are in the process and include Draft, Validated, In Process and Completed. If you want a list of all dimension corrections made in the system instead of changes only for a selected line, navigate to the Dimension Corrections page where you can see all changes along with a status. This provides a detailed audit trail for the corrections.
At the time I tested, changing a dimension value on a ledger entry did NOT change the dimension on a posted document (if that is where the ledger entry originated).
If you need to revert a dimension change, the steps are very similar to the original dimension change process. You first need to select Validate Undo Dimension Correction and then select Undo. Both of these actions will bring up the prompt to either schedule the task or run it immediately.
I think Microsoft successfully delivered on this feature overall, but there are a few missing pieces for me. Here are the pros and cons as I see it.
I am excited to start using this feature, even with the opportunities for improvement I noted. I hope you’re as excited as I was to discover this new enhancement, and even more excited to use it to save countless hours with corrections and reporting!
Goodbye dimension reclassification entries!