The 13th Period and Reporting

The 13th Period and Reporting in Dynamics GP

This article explains how to setup a 13^th fiscal period in Great Plains and Management Reporter to record year-end adjustments and report on them. The 12^th and 13^th periods will have the same date (12/01/20XX) in the Fiscal Period Setup window. This provides the ability for you to record year-end adjustments. Here is an example of the period setup.

13PeriodReporting1

You will notice that Management Reporter only shows 12 periods in the drop-down when selecting the base period to run the report. This is because the last two periods of the fiscal year end on the same date. Management Reporter automatically combines these two periods and reports as the first of the two periods.

13PeriodReporting2

The workaround for this issue is to use Column Restrictions in the Column definition. The ADJ Column Restriction only reports adjustments to that period. The XAD Column Restrictions reports all the data except adjustments to that period. In the example below the 12^th and 13^th periods are separated by using the ADJ and XAD Column Restrictions. When running the report for the 12^th period you will see the adjustments broken into a separate column. When generating the report for any other period you will not see the Adjustments column.

Reporting When the Last Two Periods End on the Same Date

If the last two periods of your fiscal year end on the same date, the data of these two periods is combined and reported as the first of the two periods.

For example, you have set up period 12 and period 13 so that both periods end on 12/31. All data for these two periods is reported as period 12 data and period 14 data is recorded as adjustments to period 12.

If you want to separate the data for the two periods, you must use column restrictions when you create Column Definitions.