Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2022 Release Wave 1 PlanDynamics 365 release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
2022 release wave 1 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
We are using Management Reporter 2012 CU12 on AX 2009. The closing transactions are added to the end of year totals, which makes using period 12 useless.
The problem should be fix starting with release 2.10.1037.15 or higher, according to this support entry: https://support.microsoft.com/en-us/kb/2719586
Well... its not... :(
From the tech note: "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."
Anybody is able to produce end of year documents that wont add the closing transactions?
You have quite an unfortunate scenario!
There are probably a few different ways.
I haven't tested any of these but they may be a suitable workaround:
1. Use ADJ and/or XAD Column restrictions in the Column layout
2. Use the 'Posting' Attribute filter in the Column layout to try and segregate out the zeroing out transactions that may be classified as 'Closing' or 'Year-end result'
Let us know how you go
Many thanks Anthony!
Your first suggestion nails it effectively.
I also checked the second option and I think it would as well, although it would require more manipulation than the first one. It does allow more flexibility however.
Business Applications communities