local_phone(877) 456-7632 local_post_officeinfo@msxgroup.com
Message Boards
Sign up Latest Topics

  Author   Comment  

Posts: 117
Reply with quote  #1 

Management Reporter displays zero balances for Period 13 Year-to-Date (YTD) columns for Microsoft Dynamics AX 2009 and AX 2012.

If the "Create closing transactions during transfer" option is enabled in AX2009, there is a transaction created in the Closing period at the end of the fiscal year that zero's out the balance for all accounts. Management Reporter includes these closing transactions when pulling YTD balances. These transactions cause the balance of the last period to display as zero and causes the last period to display a zero balance in a YTD column of the MR report.

There is a solution.

The Column Restriction XAD in an FD column will exclude any adjusting entries. If you need the adjusting entries, ADJ can be used in the Column Restriction for the FD column.

Noah C. Moseley
MSX Group Senior Consultant and Certified Instructor

Email me if you need help installing, implementing or just need training on Microsoft Forecaster, Management Reporter or FRx. Plus, Prospero for Financial Reporting and Budgeting is now available. See our introductory video at http://msxgroup.com/prospero_video_introduction

Management Reporter | Prospero | Forecaster | FRx
Training | Consulting Services | Software Support
Previous Topic | Next Topic

Quick Navigation:

Easily create a Forum Website with Website Toolbox.