Customizing a transaction detail report
To generate a transaction detail report, you must create a customized 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 PERIODIC column and period balances in the YTD column. 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 Only or the Financial, Account & Transaction option in the Detail Level list of the report definition.
Note
By default, transaction detail accounts with a zero balance or no period activity are suppressed in reports. To show these transaction detail accounts, select the Display rows with no amounts check box on the Settings tab of the report definition.
Creating a multiple period transaction detail report
Transaction detail amounts can appear only in columns for which the Periods Covered cell is set to PERIODIC. If you want a report to cover more than one period, enter the period range in the Period cell of the PERIODIC column. For example, to run a report that covers the last three periods, enter a Period of BASE-2:BASE in the PERIODIC column.
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:BASE in the Period cell of the PERIODIC column, and then type BASE in the YTD column, as shown in the following table.
|
A |
B |
C |
|---|---|---|---|
Header 1 |
|
Activity |
Balance |
Column Type |
DESC |
FD |
FD |
Book Code/Attribute Category |
|
ACTUAL |
ACTUAL |
Fiscal Year |
|
BASE |
BASE |
Period |
|
1:BASE |
BASE |
Periods Covered |
|
PERIODIC |
YTD |
You can specify YTD columns for transaction detail reports, but no transactions appear in the YTD columns.
Creating a debit/credit report
To create a report that categorizes transactions by debit and credit, follow the procedures below.
Create two PERIODIC columns (one PERIODIC column for debits, and one PERIODIC column for credits).
Create one YTD column for the period totals.
Enter the debit code (DR) in the Column Restriction cell of one of the PERIODIC columns, and the credit code (CR) in the Column Restriction cell of the other PERIODIC column, 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 |
Fiscal 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 Period cell.
Note
The value in the Column Restrictions cell overrides any restriction that is assigned in the row definition.