Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »


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

This page outlines how to run a report which allows you to list any landlords with vacant properties (i.e. where there's no arranging or current tenancy) and there is an outstanding landlord works order


From main menu, click Rentals/Lettings, select Reporting and Analysis and click Query Transactions: 

1. Complete the required criteria

Select/enter the following:

  • Unallocated: £/$ 0.01 to £/$ 0.00

  • Ledger: Landlord

  • Category: Landlord Works Order

  • Extra: copy and paste the text below

    nomTran.lldCode NOT IN (SELECT lldCode FROM prp p INNER JOIN ten t ON prpCode = p.code AND t.synchdel = 0 WHERE p.synchdel = 0 AND t.status IN ('TC','TA'))


2. Run the report

  • Click Report

    The report will show all outstanding landlord works orders/supplier invoices for properties where there is no Arranging or Current Tenancy


 Group results by landlord or property...

3. Save the criteria 

The report criteria can be saved as a Predefined Report for future use

  • From the screen shown in step 1, click Save 

  • Enter a Report Name 

  • In Available to choose which offices will get access to this saved report

  • Click Accept

    The report can then be selected from the Predefined Reports drop-down menu (bottom left of the screen) 


  • No labels