Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

This guide has been reviewed against our global client base and classed as relevant to all regions

<Add intro here>

1. <add action heading here>

...

<add screenshot here>

2. <add action heading here>

...

<add screenshot here>

3. <add action heading here>

...

The Query Transactions function allows a supplier debt report can be generated, providing a view of the live balance of outstanding invoices which are yet to be paid

1. Accessing the report

From Lettings/Rentals on the main menu:

  • Select Reporting and Analysis

  • Click Query Transactions

Image Added

2. Enter criteria

To view a live balance of outstanding invoices which are yet to be paid, enter the following criteria:

  • Unallocated: enter an end figure (e.g. £1m)

  • Ledger: select Supplier

  • Click Report

Image Added

3. Viewing the report

The Unallocated column shows how much is outstanding on the invoice
This is inclusive of partially paid & fully unpaid invoices

Image Added

The report results are shown in a grid, which allows you to:

  • Click any column heading to sort in ascending/descending order

  • Click to the right of a column heading for filter options

  • Right-click and add further columns and/or export to Excel

Filter by label (Content by label)
showLabelsfalse
max8
sortmodified
showSpacefalse
reversetrue
cqllabel = "reporting-accounts"
Excerpt
hiddentrue

<Add very brief overview of what the guide is about here>The Query Transactions function allows a supplier debt report can be generated, providing a view of the live balance of outstanding invoices which are yet to be paid