Management Reporter Column Layouts For Previous Years

Microsoft Dynamics GPA client in the process of migrating from FRx to Management Reporter 2012 recently asked how to configure the Column Definition in Management Reporter so they could get the same information as they did from FRx.

When I looked into it I found that the Column Layout in FRx was not set up in a way that the Migration Wizard will translate across correctly, as the FRx Column Layout hasn't been configured in the recommended way.

The Column Layout was configured with columns for previous years as shown below with a Period Code of 1 To 13 and a Current Per/YTD of YTD;

FRx Column Layout For Previous Year

This does work okay in FRx but should really have had the Current Per/YTD set to YTD and only 13 in the Period Code row. This will bring through the YTD balance for the entire year; if only the net change was needed then setting the Current Per/YTD to CUR and entering 1:13 in the Period Code row would give these numbers.

For this particular client, we set the Period to 13 and left the Periods Covered as YTD;

FRx Column Layout For Previous Year

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.

Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

Your Name (required) -
Your Email (required) -

2 thoughts on “Management Reporter Column Layouts For Previous Years

Leave a Reply

Your email address will not be published. Required fields are marked *