To generate a transaction detail report, you must create a customised column definition specifically for that type of report.

When you set up the column definition for your transaction detail report, include at least one column for the financial data current period amounts ( PERIODIC) and at least one column for the financial data year-to-date amounts ( YTD). The transaction amounts appear in the PERIODICcolumn and period balances in the YTDcolumn. You can also include any transaction detail codes that are specific to your accounting system.

When you generate your transaction detail report, use either the Transaction Onlyor the Financial, Account & Transactionoption in the Detail Levellist of the report definition.

Note Note

By default, transaction detail accounts with a zero balance and no period activity are suppressed in reports. To show these transaction detail accounts, select the Display rows with no amountscheck box on the Settingstab of the report definition.

Creating a multiple period transaction detail report

Transaction detail amounts can appear only in columns for which the Periods Coveredcell is set to PERIODIC. If you want a report to cover more than one period, enter the period range in the Periodcell of the PERIODICcolumn. For example, to run a report that covers the last three periods, enter a Periodof BASE-2:BASEin the PERIODICcolumn.

You can use multiple book codes in a transaction detail report.

Creating a year-to-date transaction detail report

To run a transaction detail report for the entire year, type 1:BASEin the Periodcell of the PERIODICcolumn, and then type BASEin the YTDcolumn, as shown in the following table.

 

A

B

C

Header 1

 

Activity

Balance

Column Type

DESC

FD

FD

Book Code/Attribute Category

 

ACTUAL

ACTUAL

Accounting Year

 

BASE

BASE

Period

 

1:BASE

BASE

Periods Covered

 

PERIODIC

YTD

You can specify YTDcolumns for transaction detail reports, but no transactions appear in the YTDcolumns.

Creating a debit/credit report

To create a report that categorises transactions by debit and credit, follow the procedures below.

  1. Create two PERIODICcolumns (one PERIODICcolumn for debits, and one PERIODICcolumn for credits).

  2. Create one YTDcolumn for the period totals.

  3. Enter the debit code ( DR) in the Column Restrictioncell of one of the PERIODICcolumns, and the credit code ( CR) in the Column Restrictioncell of the other PERIODICcolumn, as shown in the following table.

 

A

B

C

D

E

Header 1

 

Beg Balance

Debits

Credits

YTD

Column Type

DESC

FD

FD

FD

FD

Book Code/Attribute Category

 

ACTUAL

ACTUAL

ACTUAL

ACTUAL

Accounting Year

 

BASE

BASE

BASE

BASE

Period

 

BASE

BASE

BASE

BASE

Periods Covered

 

PERIODIC/BB

PERIODIC

PERIODIC

YTD

...

 

 

 

 

 

Column Restrictions

 

 

DR

CR

 

As in other transaction reports, if you want to display details for multiple periods, enter a range (for example, 1:BASE) in the Periodcell.

Note Note

The value in the Column Restrictionscell overrides any restriction that is assigned in the row definition.

See Also