Versions Compared

Old Version 1

changes.mady.by.user Fiona Hardy

Saved on

compared with

New Version 2

changes.mady.by.user Fiona Hardy

Saved on

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


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


Expand
titleGroup 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) 



Filter by label (Content by label)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@a45
showSpacefalse
sortmodified
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