Versions Compared

Key

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

...

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) 

Image RemovedImage RemovedImage 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

...