Dynamics Community Forum Thread Details

Unit Accounts with YTD

Greetings,

Using GP 2013 and Management Reporter 2013 (Version 2.1.9001.11). I have been developing an Income Statement report using Performance Metrics (Unit Accounts). The report is correctly reporting the unit accounts for the selected periods.

In my Row Definition, the Column Restrictions are: B, D, F, H, J, L, N, P, R

In my Column Definition, the columns are:

B	D	F	H	J	L	N	P	R
FD	FD	FD	FD	FD	FD	FD	FD	CALC
Actual	Actual	Actual	Actual	Actual	Actual	Actual	Actual
BASE	BASE	BASE	BASE	BASE	BASE	BASE	BASE
BASE	BASE	BASE	BASE	BASE	BASE	BASE	BASE
PERIODIC	PERIODIC	PERIODIC	PERIODIC	PERIODIC	PERIODIC	PERIODIC	PERIODIC
								B+D+F+H+J+L+N+P

I wanted to add a YTD for the Unit Accounts so I made the following change.

In my Row Definition, the Column Restrictions are: B, D, F, H, J, L, N, P, R, S

In my Column Definition, the columns are:

B	D	F	H	J	L	N	P	R	S
FD	FD	FD	FD	FD	FD	FD	FD	CALC	FD
Actual	Actual	Actual	Actual	Actual	Actual	Actual	Actual		Actual
BASE	BASE	BASE	BASE	BASE	BASE	BASE	BASE		BASE
BASE	BASE	BASE	BASE	BASE	BASE	BASE	BASE		BASE
PERIODIC	PERIODIC	PERIODIC	PERIODIC	PERIODIC	PERIODIC	PERIODIC	PERIODIC		YTD
								B+D+F+H+J+L+N+P