Layouts

Account Sequence

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

Aged Transactions

Shows transactions for Customers for the current and three previous periods.

Aged Transactions Days

Reports the period transactions based on days aged for a specified number of days, to match days based statements. Defaults to 7 days.

Aged Transactions Due Date

Reports for customers matching the selected Statement Aging Unit and Count and ages transactions factoring in Invoice Due Date and any Hold amounts.

Aged Transactions Monthly

Reports the period transactions based on calendar months aging to match calendar month statements.

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.

Commission Report

Based on the commission amounts entered in Invoices (through IN). There are two available report types,

• Paid Invoices - shows commission for fully paid Invoices in the Period (part-paid Invoices are not included, although Invoices part paid in a prior period, then fully paid in the Period are included).
• Withheld - shows commission for Invoices outstanding for payment (includes the full commission amount for Invoices that have been part-paid).

Exchange Variation

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

Receipts Due

List of invoices due from customers on or before a specified date. You can Filter & Sort on payment due terms or other criteria. The report shows the transaction amount, discount, unallocated amount, hold amount and amount due for each transaction, grouped by customer. For customers on Period Terms date due is treated as the start date for the period following the transaction period to match period based aging.

Revaluation Rates

Produces a report of revaluation rates by currency over a range of periods.

Transaction Links

This report shows the links associated with AR 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 within the periods they were entered. This report can be selected for a period as a monthly transaction summary report for audit. A second band is available that shows the Sales Group analysis breakdown for Invoices and Credits. Transaction Types originate as follows:

Unallocated Transactions

Produces a report of unallocated transactions.

Untransferred Transactions

Produces a report of untransferred transactions.