Management Report

(1) Share

Report

Posted on by CU28091606-0

I am preparing month wise TB and I Need Difference b/w each month as percentage. Following way I prepared the column definition and in Report I am not getting the correct percentage especially when we have "0' Amount in one of the month. could you Please let me know is there any other way to prepare it. In Row Definition I Just copy all Chart of account.

		JANUARY	JANUARY	JANUARY	FEB	FEB	FEB		JAN-FEB-%
DATE	VOUCHER	DR	CR	CB	DR	CR	CB

ATTR	ATTR	FD	FD	CALC	FD	FD	CALC	CALC	CALC
Transaction Date	Voucher	Actual	Actual		Actual	Actual
		BASE	BASE		BASE	BASE
		1	1		2	2
		PERIODIC	PERIODIC		PERIODIC	PERIODIC
				E+F			(H+I)	(J-G)	(K/G)*100
AutoFit	AutoFit	AutoFit	AutoFit	AutoFit	AutoFit	AutoFit	AutoFit	AutoFit	AutoFit


		NP	NP		NP	NP		NP
		DR	CR		DR	CR

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (1)

CU28091606-0 25 on at

Like (0)

Report

Management Report

Dear I have updated same as mentioned above but the percentage is gone wrong when January is Zero and February having Transaction. How could correct this

Verified answer

Burley

18 on at

Like (1)

Report

Management Report

I don't think the columns with column restriction for debit and credit are needed or doing the calculation of net change since the debit and credit are NP (non-printing) anyway. Remove the column restriction with Periods Covered as Periodic, and it shows the month's net amount. Then do the calculation for the difference and then another calculation for the % change. For the % change, there needs to be a format/currency override so that it shows as a percentage rather than multiply by 100.

	F	G	H	I
	September	October	September to October difference	% Change

Column Type	FD	FD	CALC	CALC
Book Code	Actual	Actual
Fiscal year	BASE	BASE
Period	9	10
Periods Covered	PERIODIC	PERIODIC
Formula			G-F	H/F
Column Width	AutoFit	AutoFit	AutoFit	AutoFit

Format/Currency Override				###0.00%;(###0.00%)