1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > A/R Reports > Reports and then double-click Debtor Unalloc/Unmatched Report. ARR014 Debtor’ Unallocated/Unmatched Transaction panel appears.
2. Enter the selection criteria and click OK to produce the report.

Debtor balances by item hierarchy

This balance report shows a breakdown of the outstanding balance by title hierarchy/dissection. For each customer the breakdown is based on the titles on the invoices/credits.  Each title on each invoice/credit is allocated to its own dissection levels.  This information is then grouped and totalled.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > A/R Reports > Reports and then double-click Debtor Balance Report. ARR021 Debtor Balances by Item Hierarchy panel appears.
2. Enter the selection criteria and click OK to produce the report.

Over-limit exception report

The Over-limit exception report is used to look up customer’s outstanding balances and credit limits.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > A/R Reports > Reports and then double-click Debtor Overlimit Exception Report. ARR060 Overlimit Exception Report selection panel appears.
2. Enter the period and click OK to produce the report.

This report provides an edit listing of all payment and journal entries made per Batch number, including the allocations, that is, all the transactions taken up when allocating a payment.  This enables management to ensure the accuracy of the input data. The transactions will show original and allocated amounts in debtor’s currency.

The listing can be requested for all batches or a selected batch and can be run for batches created in previous months and for one user or a range of users.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > A/R Reports > Reports and then double-click Debtor Entry Edit List. ARR080 Accounts Receivable Edit List  panel appears.
2. Enter the Batch and User ID and click OK to produce the report.

Factored invoice status report

This report shows management the outstanding transactions as well as any payments that have been received.

It checks all transactions that have been paid since last generating the factoring process.  The relevant invoice and customer balances held on the factoring file are adjusted accordingly. The report can be run in either summary or detailed format.

1.  In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > Debtors Factoring > Reports and then double-click Debtor Factored General Report. ARR100 Factored Invoice Status Report  panel appears.
2. Enter the period and click OK to produce the report.

AR Paid factored invoice report

This report generates both a detailed and summary report showing factored invoices that have been paid, in customer sequence.

1.  In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > Debtors Factoring > Reports and then double-click Debtor Paid Factored Inv Report. ARR105 AR Paid Factored Invoice Report panel appears.
2. Click OK to produce the report.

 Debtors dissection report

This report provides the user with aged debtor’s details by dissection level, relevant to either the current or previous accounting period.

An optional selection facility is available to assist in determining the report range

1.  In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > AR Reports > Reports and then double-click Debtor Dissection Report. ARR120 Debtor Dissection Report panel appears.
2. Enter the selection criteria as required and click OK to produce the report.

Debtors with no payment received for period

To assist in the collection of overdue amounts this report has been designed that isolates debtors who have not made any payments during a specific month.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > AR Reports > Reports and then double-click Debtor No Payment Received Report. ARR130 Debtors with No Payment Received for Period panel appears.
2. Enter the period and click OK to produce the report.

Debtors that have not  made a payment

To assist in the collection of overdue accounts, the accounts receivable module provides a report which lists those customers that have not made a payment during an accounting period.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > AR Reports > Reports and then double-click Debtor No Payment Received Report. ARR150 Debtors That Have not Made a Payment panel appears.
2. Enter the selection criteria and click OK to produce the report.

Account analysis by transaction types

This report analyses outstanding debt into transaction types and selection is made to print in summary or detail level.

A control file determines the column headings and how to select the figures that will be included under each heading. The selection will be the – Document type (invoice, credit, journal) – actual payment type codes (journal types) – non allocated or allocated – negative or positive.

A work file is generated extracting data from file ARTR00P, ARTRA00P and stores the data in the newly created work file object.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > AR Reports > Reports and then double-click Debtor Report : Transaction Type. ARR180 Account Analysis by Transaction Type panel appears.
2. Enter the selection criteria and click OK to produce the report.

AR Analysis by payment/journal type

This report is used to analyse customer payments and/or journals.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > AR Reports > Reports and then double-click Debtor Pymt/Journal Type Report. ARR200 A/R Analysis by Payment/Journal Type panel appears.
2. Enter the selection criteria and click OK to produce the report.

AR Analysis by batch

This report is used to analyse customer payments by batch.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > AR Reports > Reports and then double-click Debtor Batch Analysis Report. ARR205 A/R Analysis by Batch panel appears.
2. Enter the selection criteria and click OK to produce the report.

Debtor movement analysis report

The Debtor movement analysis report prints the debtor movements in detail from the A/R Transaction Details file. The flexible selections allow the user to choose which column is to be printed on the report.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > AR Reports > Reports and then double-click Debtor Movement Analysis Report. ARR240 Debtor Movement Analysis Report panel appears.
2. Enter the selection criteria and click OK to produce the report.

 Debtor movement by reporting currency

This report prints the opening balance, movements, and closing balance by reporting currency for the selected period.  The flexible selections allow the user to select field sort sequences, sub-total levels, page break levels and ranges.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > AR Reports > Reports and then double-click Debtor Movement/Currency Report. ARR260 Debtor Movement by Reporting Currency panel appears.
2. Enter the selection criteria and click OK to produce the report.

Debtor risk reserve report

The Accounts Receivable system offers a facility to provide for doubtful debts.  For each outstanding account a provision amount is reserved, which is calculated based on a provision rate applicable to each outstanding transaction.  This information is contained in the Debtors risk reserve report, providing up-to-date and concise details at the time of print, either in trade or base currency.

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > AR Reports > Reports and then double-click Document Reprint. DSR200 Debtor Risk Reverse Report panel appears.
2. Enter the period and click OK to produce the report.

Draft masterfile report

This prints a draft masterfile list, supplying the user with detailed draft/letter of credit information. 

1. In the menu, expand Base Modules > Distribution > Debtors & Claims > Accounts Receivable > AR Reports > Reports and then double-click Debtor Draft Detail Report. DSR380 Draft Masterfile List panel appears.
2. Enter the selection criteria and click OK to produce the report.