Debtors Inquiry

The Debtors Inquiry report combines the use of a Reference Link, Summary Links and a Detail Report to extract debtor account details, account aged balances and an uncleared transaction listing.

This is a practical example of how different types of data extraction can be used in the same worksheet to present complementary view of information.

The Auto Format feature is used to format the Detail Report, which lists the transactions.

These fields are included on the Detail Report:
  • Transaction Date
  • Accounting Period
  • Transaction Reference
  • Description
  • Journal Number
  • Journal Line Number
  • Base Amount
Note: Double-click these cells to open the extraction definition screen:
  • F15: Detail Report
  • G4: Reference Link
  • L6 to L10: Summary Links

This table shows the filters used on the Detail Report:

Filter Value Field Reference
Table Ledger
Account Code 64008 $C$8
Accounting Period All
Transaction Date 01/01/1970 - 12/09/2005 01/01/1970 -$C$9