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
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.

Create two PERIODICcolumns (one PERIODICcolumn for debits, and one PERIODICcolumn for credits).
Create one YTDcolumn for the period totals.
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
The value in the Column Restrictionscell overrides any restriction that is assigned in the row definition.

Creating a multiple period transaction detail report

Creating a year-to-date transaction detail report

Creating a debit/credit report

See Also