Dimension Correction in Business Central

 

Dimension Correction in Business Central

Breaking of Default feature of dimension correction module. We have a provision to update the dimension for the posted transaction in Business Central. This feature provides you with the feasibility of the correctness of the system reporting with analysis by dimensions.

Steps to Change the Dimensions

1.      Open the General Ledger Entries page.

2.      Select the entries that require dimension correction.

3.      Click on the Correct Dimension action.

4.      A  Draft Dimension Correction page will be opened.

5.      In the General tab, You can find the option to update the Analysis view required – Enable.

6.      Status will show as Draft.

7.      In the subpage you can find the Dimension Correction details

8.      In this tab you can define any dimensional changes if required.

9.      Select the Dimension code and the old value will be updated automatically.

10.  A new value will be selected there (it can be either new or blank).

Once you have filled in all the required pieces of information. Click on the validate dimension changes, If you find any validation errors that will be shown. If no errors click on the Run Command. It will schedule a job to update the dimensions for the selected entries.

All the corrections for dimension will have track change log entries.


Limitation

This Correction will be effective only in General ledger and analysis view entries.

Changing the dimension will help in reporting data taken from the chart of accounts and General ledger entries.

Improvements required

Dimension correction is required in all the sub-ledgers and documents to be corrected. Current features are not updated in the transaction document headers and sub-ledgers.

Customization

[IntegrationEvent(false, false)]

    local procedure OnAfterVerifyIfDimensionCanBeChanged(var DimCorrectionChange: Record "Dim Correction Change")

    begin

    end;

By calling this event from Dimension correction management we can get the list of entries which require correction in dimension and from there we can set a navigation to all the related entries using Document No. and Posting date to correct all the relevant transaction data for the dimension update to get the ledger and sub-ledger matched automatically.

Comments

Post a Comment

Popular posts from this blog

Multi Approval Configurator - Business central customized solution for approval management

Image
  Multi Approval Configurator Business Requirement Approval must be provided for the Sales document, Purchase document, Service document, and customer Approval based on the Department, Business Type, Order type, and values. Each Department, Order type, and value will have different approval hierarchies. These approval parameters vary across the business units. To handle delegation of the approvers on the vacation/holidays time. Based on the leave calendar. Delegation can be done to different users each time, which needs to be recorded. Technical Design We have customized the workflow with a configurator, allowing users to define multiple combinations of document types. i.e. Department code is dimension 1, Order type is master data, and Values are calculated from the document. Each line of combination will have a set of workflow user groups. We will configure a standard workflow template and define a blank workflow group in the approval setup. We can define a workfl...
Read more

Telemetry Analysis Hidden facts - Business Central

Telemetry Telemetry is a tool that helps an organization to track their current business central performance, usability, and Monitoring.  Monitoring telemetry lets you look at the activities and general health of your environments/apps, so you can diagnose problems and analyze operations that affect performance. Requirements  To enable the telemetry we would require Azure Application insight with an Azure subscription.  Adding the Azure application insight details to the business central admin center.  To analyse the visuals we need to connect to a Power BI.  Setup Telemetry Azure Application Insights Resource: Login into  Portal.Azure.com Select -> Azure Application Insight  Create a New Resource  Generate an API key for the Resource.  Copy the Azure application Insight ID details  Copy the  Connection String from the Insight Business Central Admin C enter : 1.  ...
Read more