Transaction Listing Report

---

Use this option to print a list of general ledger account transactions within a specified period date range.

Header Details

• Report process date & time
• Page number
• Period date range specified in the parameters
• The In Currency option selected in the parameters ledger or account)
• The transaction analysis tree and codes (depends on the Subtotal by Transaction Analysis and Print Tran Analysis parameters)

Line Details

These details display for each general ledger account transaction, based on the parameters selected:

• Account number
• Account description
• Period
• Sub code
• Date
• Batch number
• Transaction type
• Transaction reference
• Transaction detail
• Transaction debit value
• Transaction credit value
• Quantity (if it is a quantity account)
• Narration

The output of the report will be grouped and sub-totalled using the Subtotal option selected in the parameters. You can sub total the report by period, subcode, or transaction analysis code. A subtotal displays for total debit and credit values, and a net movement value, and a period/subcode total (based on option). The grand total of transaction debit & credit values displays, and a closing balance.

If you select the option to print the report in Summary, sub-totals will not display, only the grand totals.

The option to Print in Detail works with the option to Print Details, which is assigned to each General Ledger account. If a General Ledger account has this option selected, then additional details always display for those accounts.

Company

The default value is the company you are logged into, but you can change it to view the report for a different company.

View Mode

This is applicable if you are using Advanced Security and enables you to restrict the output based on team security.

Sequence

You can select the account sequence on which to base the output. These are defined in GL Module Sequences.

Tree

You can filter the output of this report by Tree. If you select a tree, you can specify which branches to include. If you do not want to filter the output by tree, select the option None in the Tree field.

Currency

Select whether you want the report to print values in the ledger or account currency.

Print

Select whether you want the report to print summary or detailed information.

In Order

Select whether you want to print transactions in document date order or posting date order.

Print Zero Balance

Select this option to include accounts with a zero balance in the report.

Print Empty Accounts

Select this option to include accounts that have no transactions in the report.

Subtotal by Subcode

This option is enabled if Print in detail is selected and the option to Subtotal by Transaction Analysis is not selected. Select it to print sub-total values by subcode per account.

Subtotal by Period

Select this option to print a sub-total for each period in the selected date range for each account.

Print Tran Analysis

This option is enabled if Subtotal by Transaction Analysis is selected.

If you select this option, a transaction analysis section will appear at the top of the page, displaying both the tree and the branches selected. If you don't select this option, only the tree name will display.

Print New Page

This option is enabled if Print in Detail is selected and the option to Subtotal by Transaction Analysis is selected.

Select it to print a new page for each transaction analysis code per account. This is a useful feature to distribute the report to multiple people, each being responsible for reviewing account details for different analysis codes.

Print account on subsequent pages

This option is enabled if the Print New Page option is selected. Select it to print the general ledger account code, description and opening balance details on each new page. If you don't select this option, the details will only print on the first page for transaction detail for the account.

Print Balance details

This option is enabled to select if the option to Subtotal by Transaction Analysis is selected, and the Print in Summary option is selected. If selected, transaction code balance detailprint in addition to full account balance details.

Print full narration

Select this option to print the full narration for each transaction. This will output the full header and line narration for each transaction on the report. If you don't select this option, the first part of the narration will still print, but only as much as will fit into the Narration column on the report.

Subtotal by Transaction Analysis

This option is enabled if you are using the GL Transaction Analysis module. A Transaction analysis options button will appear when the option is selected, enabling you to select tree/branch combinations to include in the report.

Selected by AND/OR

These options are only available if the option to Subtotal by Transaction Analysis is selected.

Select AND to print transaction lines that include a combination of the selected transaction tree branches. Select OR to print transaction lines that include only the selected transaction tree branches.

---