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

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'))

...

Image Added

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

...

Image Added

To group results by landlord or property

...

:

...

Image Added

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) 

...

Image AddedImage Added

Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@a45
sortmodified
showSpacefalse

...

reversetrue
typepage
cqllabel = "reporting-accounts" and type = "page" and space = "RW"
labelstrustaccts
Excerpt
hiddentrue

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