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

« Previous Version 5 Current »

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

To 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 screen) 

  • No labels