Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

When you generate a report in Microsoft Management Reporter 2012 for Dynamics AX 2012 there is no data in the last period


View products that this article applies to.

Symptoms

When you generate a report in Microsoft Management Reporter 2012 for a Microsoft Dynamics AX 2012 company, you do not receive data in the last period of the year on a YTD column.

↑ Back to the top


Cause

This occurs if the Create closing transactions during transfer option is enabled in Microsoft Dynamics AX 2012. When it is enabled, there is a "zeroing out" transaction created in the closing period at the end of the fiscal year. Management Reporter 2012 currently does not support this feature. Therefore, Management Reporter 2012 includes these closing transactions. These transactions cause the balance of the last period to zero out. This makes the last period display a zero balance at the financial detail level in a YTD column of the MR report.

↑ Back to the top


Resolution

This is resolved by applying Management Reporter 2012 RU5 (2.1.1037.15) or higher.

↑ Back to the top


More Information

If you cannot apply RU5 to resolve this, you can disable this feature in Microsoft Dynamics AX 2012 by following these steps:

Important Complete on test environment first and backup Microsoft Dynamics AX databases before you perform any steps.

1. Clear Create closing transactions during transfer option under General Ledger | Setup | General Ledger Parameters in the Fiscal Year Close section.

2. Rerun Opening Transactions Job for that year(s) under General Ledger | Periodic | Fiscal Year Close | Opening Transactions.

↑ Back to the top


Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2719586
Revision : 1
Created on : 1/7/2017
Published on : 8/6/2013
Exists online : False
Views : 403