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