October 31, 2016

Financial reporting in Dynamics 365 for Operations

We know that, Management Reporter is labeled as a Financial reporting in the current version of Dynamics AX (Dynamics 365 for operations).

Financial Reporting Wiki link will provide you information on below topics.
  1. Accessing financial reporting
  2.  Duties, Privileges and Roles
  3. Default reports
  4. How to Opening financial reports
  5. Creating and modifying financial reports
>>Blogged By  Ravi Theja Madisetty<<

February 28, 2016

Management Reporter Integration failed with error “The REFERENCES permission was denied on the object 'DATAAREA', database ‘XXX_XXX_XXX’, schema 'dbo'.Rolling back transaction “ in AX2012R3


Solution : As per the error, the account which we used to run MR services has no ‘References ’ permission on DATAAREA table, on transaction database. To over come this error we have to provide required rights as per the below screen.


Connect to SQL Server --> Open SQL Managament Studio --> Expand ‘database’ --> Expand ‘Security’ --> Select ‘MR Service account’ --> Click on ‘Securables’ --> Select ‘DATAATEA’ and ‘Reference’ Tick Mark on ‘Grant ’ --> Click ‘Ok’.

Now goto Management ‘Configuration console’ stop and Start Integration, it will finish without any errors.

"Yours Ravi Theja Madisetty"

February 2, 2016

Unable to preview the report, install the Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2013














When I tried to preview AX report in Visual studio 2013, received above error.

My environment details are:
Operating System: Windows server2012R2
Application: MSD AX2012R3CU10
SQL Edition: SQL2014SP1 Developer Edition
Visual Studio: VS2013 Professional with Update 4

As per the TechNet / blogs, In SQL 2014, Business intelligence feature is removed. Previous versions of SQL 2014 (ex: SQL2012SP1) Business intelligence feature is available with name ‘SQL Server Data Tools’ and it comes with SQL media file.
To resolve Reports preview issue we have to download and Install Business intelligence tools in your host alone.


---------------------------- Same post I re blogged on my other blog--------------------------
                                       "Yours Ravi Theja Madisetty"

February 1, 2016

Forecast Model Cube error in DB synchronization during initialization checklist (AX2012R3CU10)











Note : This error I received during fresh installation of AX2012R3CU10.

Enabling ‘Forecast’ key from Initialization checklist is resolved my issue.

Execution Path : Initialization checklist àActivate application functionality à Configure application functionality à Expand Project 1 à Checkmark ‘Forecast’ and click ‘Ok’.










---------------------------- Same post I re blogged on my other blog--------------------------
                                       "Yours Ravi Theja Madisetty"

January 28, 2016

How to Extend the Windows Server 2012 evaluation period

If you are using Evaluation version of windows server 2012 and Windows server 2012 R2 on your servers, it will expire in 180 days. If you want to extend more 180 days evaluation license, use MS-DOS command “slmgr.vbs /rearm”.

Steps : Click on Start button and

–> Type ‘CMD’
–> Open ‘Command Prompt’ Run as administrator
–> Type command “slmgr.vbs /rearm” and Press Enter
–> Reboot server
                                  ****Same post I re blogged on my other website ****
                                                "Yours Ravi Theja Madisetty"