Who is this guide for?

Accounts Users and Accounts Supervisors

A list of purchase ledger account (Supplier) balances – split aged across 0 , 30, 60, 90 days

FILTER OPTIONS

Branch.  Defaults to All – can select an individual branch from the drop down list

Department – Defaults to All – can select a Department from the drop down list.

Currency – Defaults to the Default currency –  Other live currencies can be selected from the drop down list.

Supplier No.  – Ticking this box brings up a list of suppliers to select if only one, or a group of suppliers are required.

Include Debit Balances.  Selecting this box allows the report to also list any suppliers who have a debit balance. This would allow the total of the report to equate to the figure for Trade Creditors on the trial balance.

As At  – Ticking this box allows the report to be produces for a historical date. Remember to put the / between the day, month and year.  i.e. 23/02/2007, or click on the box to the right. This will bring up the calendar to select a date from.

GROUPING OPTIONS

Order by    select from the drop down list  Account No.   or  Account Name

Grouping :  select from the drop down list  – No Grouping   or   Branch.

LIST OF COLUMNS PRODUCED.

PL code   / Supplier Description   /  Balance    /  Bill Date (the last bill)  0-30days /  31/60 days  / 61/90 days  /     91 + days  / Debit Balance  /  Ms Alloc

OTHER COMMENTS.

Under each column for number of days, the amounts shown should add up to the total balance.  If there is a discrepancy, it should be shown as Ms-Alloc = Yes.