XCR Print Control code example

The following tables are examples of, respectively, a column definition that uses the XCR(eXtended Character Recognition) code, the corresponding row definition with credit signs reversed, and the resulting report.

In the following excerpt from a column definition, the XCRcode in the column definition reverses the sign of the calculation.

	A	B	C	D	E
Column Type	DESC	FD	FD	CALC	CALC
Book Code/Attribute		ACTUAL	ACTUAL
Accounting Year		BASE	BASE
Period		BASE	BASE
Periods Covered		YTD	PERIODIC
Formula				C:B	D/B.B
Column Width	30	14	AutoFit	14	14
Extra Spaces Before Column
Print Control				XCR	XCR

In the following excerpt from a row definition, the Ccodes in the Normal Balancecolumn tell Management Reporter to reverse the amount signs that are in the XCRcolumns.

Description	Format Code	Related Formulas...	Normal Balance	Print Control	Column	Link to Financial Dimensions
Net Revenue			C			(4100:4259)
COGS						(450?:4509)
Gross Profit	TOT	100:160	C
Gross Margin %	CAL	@220/@100"10.0%"	C		B:D
Operating Expenses	DES
Salaries and Wages						5177+(5077)+(5477)
Office Expense						52??
Advertising Expense						53??
Total Operating Expense	TOT	340:489
Net Income from Operations	TOT	220:520	C	CS

The following example shows the results of using the XCRcode to change the print control and using the Ccode to reverse the amount signs in the XCRcolumns.

Income Statement
For the Three Months Ending March 31, 2007

	Actual	Budget	$ Variance	% Variance
			(Unfavourable)	(Unfavourable)

Net Revenue	$2,136,207	$1,034,335	$1,101,872	51.58%

COGS	1,444,056	644,131	(799,925)	(55.39%)
Gross Profit	692,151	390,204	301,947	43.62%
Gross Margin %	32.4%	37.7%	(5.3%)

Operating Expenses
Salaries and Wages	399,824	270,851	(128,973)	(32.26%)
Office Expense	52,455	36,814	(15,641)	(29.82%)
Advertising Expense	48,135	39,687	(8,448)	(17.55%)
Total Operating Expenses	500,414	347,352	(153,062)	(30.59%)
Net Income from Operation	$191,737	$42,852	$148,885	77.65%

See Also