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 for Dynamics AX 2009 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 for a Microsoft Dynamics AX 2009 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 2009. When it is enabled, there is a "zeroing out" transaction created in the closing period at the end of the fiscal year. Management Reporter currently does not support this feature.  Therefore MR 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 option is currently incompatible with Microsoft Management Reporter.

↑ Back to the top


Workaround

You can disable this feature in AX by following these steps:

Important: Complete on test environment first and backup AX databases before doing any steps:

1. Clear Create closing transactions during transfer option under General Ledger | Setup | Parameters | Ledger tab.

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 : 2599442
Revision : 1
Created on : 1/7/2017
Published on : 6/4/2012
Exists online : False
Views : 257