How do I print an aged debtor or creditor list?

From Catalyst
Jump to: navigation, search

Summary

This article explains how to print a aged debtors list from the Sales Ledger or an aged creditors list from the Purchase Ledger.

More Information

Printing an Aged Debtors List

Go to " Sales Ledger Aged Debtors Listing".

To print a current debt list for all debtors, click [Print].

  • Alternatively to print a debt list for a range of accounts or to choose one account:
  • Enter the first account to print in the "From Account" field and the "Last Account" to print in the To Account field (bear in mind any accounts falling between these codes will be included in the range).
    • To search for an account press <Ctrl+F1>.
    • You also have the option to specify a particular "Group" of accounts.
  • Click [Print] to print the debt list.

The debts shown will be as at today's date.

Detailed Debt List

To list the invoices which make up the customer balances you may produce a detailed debt list. Please be aware this may result in a large number of pages so you may prefer to press <Alt+P> and enter your PDF printer first.

  • At "Breakdown" specify which periods you wish to see the detail for e.g. 'Periods 1 -4' would give a detailed breakdown of all debts starting at those which fall into the Current period whereas 'Period 4 only' would be the oldest debts only.

At Financial Month End

You have the option to print a debtors listing as at the end of the current financial period, which is useful for checking the Sales Control account at the month end.

  • Just before you print the debt list:
  • Select the [Calculational] tab.
  • Set "Ignore Documents Beyond Current Accounting Period" to 'Y' for yes.
If your Debtors Print is missing a date at the top of the page this setting has not been set and will include current months transactions.
  • Click [Print] to print the debt list. The heading on the print out will read 'Aged Debt List At DD/MM/CCYYY'.

Printing an Aged Creditors List

Go to " Purchase Ledger Aged Creditors Listing".

To print a current credit list for all creditors, click [Print]

  • Alternatively to print a creditor list for a range of accounts or to choose one account:
  • Enter the first account to print in the "From Account" field and the "Last Account" to print in the To Account field (bear in mind any accounts falling between these codes will be included in the range).
    • To search for an account press <Ctrl+F1>.
    • You also have the option to specify a particular "Group" of accounts.
  • Click [Print] to print the creditors list.

The creditors shown will be as at today's date.

Detailed Creditors List

To list the invoices which make up the supplier balances you may produce a detailed creditors list. Please be aware this may result in a large number of pages so you may prefer to press <Alt+P> and enter your PDF printer first.

  • At "Breakdown" specify which periods you wish to see the detail for e.g. 'Periods 1 -4' would give a detailed breakdown of all items starting at those which fall into the Current period whereas 'Period 4 only' would be the oldest items only.

At Financial Month End

You have the option to print a creditors listing as at the end of the current financial period, which is useful for checking the Purchase Control account at the month end.

  • Just before you print the creditors list:
  • Select the [Calculational] tab.
  • Set "Ignore Documents Beyond Current Accounting Period" to 'Y' for yes.
If your Creditors Print is missing a date at the top of the page this setting has not been set and will include current months transactions.
  • Click [Print] to print the creditors list. The heading on the print out will read 'Aged Creditors List At DD/MM/CCYYY'.

See also


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
debtors, creditors, print aged debt list, print creditor list, at a date, date, print creditor list at a date, print aged list at a date