Layouts

Account Sequence

Sorts and groups transactions by creditor. Select a range of Creditor codes and also select period, current year, all periods or a range of periods. A Filter & Sort can be added to both the Creditor band and to the Transactions band within each creditor. The report shows an opening balance, transactions for the selected period, a running account balance and the outstanding (that is, unallocated) amount of the transaction. Only accounts with an opening balance or transactions in the periods selected are shown.

Aged Transactions

Displays AP Aged Transactions by Creditors. You can select a range of Creditor Codes and / or Creditor Group, and Currency and Period.

Allocated Transactions

Reports transactions allocated for a period or range of periods. Defaults to reporting payments and credits only with transactions allocated against them in the Allocation band.

Allocation Sequence

Shows allocations for a period range, regardless of the period of the Transaction in the allocation.

Exchange Variation

Reports exchange variation by transaction. Select period, current year, all periods or a range of periods. The report lists all transactions with exchange variations, with detail of the variations.

Exchange Variation Sequence

Print a list of exchange variations. Select period, current year, all periods or a range of periods. The report lists exchange variations in the period order they were generated. You can Filter & Sort the report. This report can be selected for a period as a monthly exchange variation report for audit.

Payment Due

List of invoices due to creditors on or before a specified date. You can specify the payment priority to report on, and Filter & Sort on payment method, balance or other criteria. The report shows the transaction amount, discount, unallocated amount, approval amount, hold amount and amount due for each transaction, grouped by creditor.

• Payment Due, the footer of the Payment Due report excludes creditors for whom the total due is negative (that is, a credit balance).
• Total Amount Due, is the sum of all the totals due per creditor, including negative total amounts.

Payment Due Transactions

List of invoices (and credits) due to creditors on or before a specified date. You can specify the payment priority to report on, and Filter & Sort on payment method, balance or other criteria. The report shows the transaction amount, discount, unallocated amount, approval amount and approval Invoice for each transaction.

Revaluation Rates

Displays currency valuation information. You can select the currency and / or time period to display.

Transaction Links

This report shows the links associated with transactions for a range of periods.

Transaction Sequence

Print a list of transactions. Select period, current year, all periods or a range of periods. The report lists transactions in the period order they were entered. You can Filter & Sort the report. This report can be selected for a period as a monthly transaction summary report for audit. The Transaction types originate as follows:

A second band is available showing the expense analysis for Invoices and Credits.

Unallocated Transactions

Produces a report of unallocated transactions. Optionally, select payments and credits only, that is, the transactions normally allocated, unless there are outstanding credits or pre-payments.

Untransferred Transactions

Produces a report of transactions not yet transferred to GL.