Skip to main content

Custom Reports

Download Guide

The custom report creator allows the user to create fully customizable reports on both assets and contract. Reports can be customized by selecting which specific fields the user would like to include in the report while also allowing the user to implement constraints on which assets or contracts should be included in the reporter. Reports are created using individual fields to specify what you want included in the report and the way in which you view each field can be modified within the creator. Filters can also be placed on the reports as to specialize which assets the user wishes to display in the report. The constraints are unique for assets and contracts as are fields. The creator also allows the user to name, save, duplicate, generate, and download the report as an excel spreadsheet. 

Creating a Basic Report                                                                                                                                                                                                                                               

  1. From the Top NavBar, select Reporting.

  2. Once in the Reporting workspace, go the Custom Reports tab.

  3. Under the Standard Reports header, click Custom Report to build a new report.



  4. First, select the Data Source from which to pool your data by clicking Add Data Source.


  5. In the pop-up, choose the Data Source from the drop-down. This forms the basis of your report, as any other data added into the report stems from this initial data source.

    • Asset: Full set of asset records in system

    • Contract: Full set of payable and receivable contracts recorded in system

    • Invoice: Full set of payable and receivable invoices in system

  6. Click Add.


  7. Once you’ve selected the initial Data Source, specific fields related to your chosen data source will appear.


  8. To include a field in your report, select it from the left Available Fields section and drag and drop it to the right Report Columns section.

  9. You may continue to drag and drop available fields to your report columns as necessary. You may either scroll through the list of Available Fields or use the search function to locate the desired fields.

  10. If you want to add another Data Source, you may click Add Data Source again and select another option to display specific fields for that data source.

  11. Some fields may have additional options that will pop up when selected and moved to the Report Columns section.

  12. You may reorder the fields in the Report Columns section simply by dragging and dropping to desired order.

  13. Once a field is in the Report Columns section, it may be customized by changing the title, alignment, size, and even color of the column.


  14. You may further customize your report by specifying any grouping or sorting by clicking the gear icon in the Structure field, which will open the Grouping and Sorting pop-up.



  15. If you would like to freeze the first (or more) column(s), you may indicate that in the Freeze first field.


  16. Name your custom report at the top of the workspace.


  17. This is also where you can choose what to do next with your report.

    • The globe icon permits all users to view this custom report.

    • The save icon saves the custom report for it to be ran or edited at a later date.

    • The duplicate icon saves a new report.

    • The download icon will download the report to an Excel spreadsheet.

    • The paperclip icon allows you to import an excel template for the report.

Advanced Custom Report Functions

If you would like to further customize your report, Real Estate Manager offers the ability to add filters, manual calculations, and static columns.

Adding Filters to the Report

Fields simply add columns to the report, they do not implement any criteria that discriminate between which asset (or contracts for example) should be displayed in the report. This is done by adding filters. Filters serve the purpose of adding constraints to the report so that if you want to put only certain assets or contracts into the report, it is possible.

  1. Once you’ve selected a Data Source and chosen your desired fields, click the Add Filter button within the Data Source box.


  2. From the Filter drop-down, select the first row to filter on. The choices in the drop-down will include all fields you’ve selected from the chosen data source.


  3. Click Add.

  4. In the next pop-up, select the relevant values to filter for.


  5. Click Save. The filter will be added to the Data Source box and will be applied when generating the report.

Generate Custom Report with Cost Per Area for Contract Data Source

  1. Navigate to Reporting > Create New Report > Create New Custom Report to view the Custom Report Builder.

  2. Under Contract data source, update the Report Columns for the contract.

  3. Enable Include Cost Per Area in the filter section.

  4. Choose a standard unit (e.g., convert per Sq. M to per Sq. Ft) for conversion. It is optional.

  5. Click Confirm. A pop-up appears to select the report format.

  6. Select the report format and click Generate.

  7. In My Jobs, download the output to view:

    • Per Annum Cost

    • Cost Per Area (Original Unit) — e.g., per acre

    • Converted Cost Per Area — e.g., per square meter

  8. Reports display Cost Per Area in a two-column format:

    • A numeric value (e.g., 85.00)

    • A measurement unit (e.g., per Sq. Ft, per Sq. M)

  9. The system automatically recalculates values when unit conversion is applied. This logic applies to both individual and total costs for consistency.

Automated Email Delivery for Custom Reports

Real Estate Manager allows you to receive custom reports directly via email when they're completed, eliminating the need to manually check back for finished reports. You can choose between automatic email delivery with a simple one-click option or the traditional download process based on your preferences. Completed reports are always available for download from the system regardless of your chosen delivery method, providing flexible access to your generated reports.

To automate email delivery for custom reports, follow the below steps:

  1. Log into Real Estate Manager and navigate to the Custom Reports section.

  2. Locate the custom report you want to generate from the list.

  3. Click the Email link next to the report name (this bypasses the report editor screen for faster processing). The system automatically queues your report job with email delivery enabled.

  4. You'll receive an email notification with:

    • Appropriate subject line indicating the completed report.

    • The report file as an attachment.

    • Delivery to your registered email address.

  5. You can also download the report from the job results page in the system or use the standard download workflow.

Choosing Your Delivery Method

For Email Delivery: Click Emailnext to any built-in custom report - the report will be automatically sent to your email upon completion.

For Traditional Download: Click Export to use the existing download-only workflow - the report will be available for download from the job results page.

Good to Know

  • Your email address is automatically synchronized with your user profile and uses your registered email address only. You cannot configure email delivery to other users' addresses. If your email address changes, log back into the system to sync the update.

  • Email delivery is currently available for custom reports only; standard reports continue to use existing download workflows.

  • Email jobs are processed in the same queue as regular report jobs. Failed or incomplete jobs will not send emails. All successfully completed reports remain downloadable from the system, regardless of email delivery method.

Adding Additional Data Sources

Additional data sources may be added to the report, such as asset contracts. These can be added when you already have a data source selected, such as asset, added to the report. This is done by selecting the data source button again which will give you options to add additional data sources. The additional data source selected will feed off the already loaded data source, meaning that if you have initially selected asset as your data source, asset contracts (the newly selected data source) will be related to the previous source, hence in this case meaning that the contracts loaded into the reports will be related to the user’s assets. Both data sources will now appear at the top of the workspace. As with the original data source, new fields are available to add to the report and constraints/ filters can be applied to the new data source.

Manual Calculation

Manual calculations may be performed on certain fields and then added to the report. These calculations will be visible in the report as its own column.

  1. Click the calculator icon in the top right corner of the Report Columns section.

  2. In the pop-up, select which report column will be used by clicking Add column and choosing the field from the available choices in the drop-down.

  3. In the Formula field, enter the simple calculation that will be used to generate this column. The formula can include column values and the mathematical operators for multiplication, division, addition, and subtraction. Parenthesis are supported.

  4. For Aggregation, you may select to use the formula entered or a simple sum function.

  5. Click Confirm.

  6. You will see a new field called Manual Calculation. This name may be changed by clicking in the name field and editing as necessary.

  7. To make any changes to your formulas, click the gear icon to display the pop-up.

  8. Once the report is exported to Excel, the calculation will be performed and appear in its own column.

Managing Standard Report Types

To simplify reporting and ensure consistency, 7 pre-configured standard report templates are available. These templates include pre-selected fields that enable users to quickly analyze key areas such as assets, contracts, vendors, portfolio performance, and payments.

The following are the available standard report types:

  • Lease Accounting Significant Contract Report

  • Contract Renewal Option Report

  • Leased Asset Portfolio Report

  • Owned Asset Portfolio Report

  • Document Repository Report

  • Contract Clause Report

  • Payment Review Report

For detailed information about each report, refer to the Standard Report Types section.

How to Use Standard Reports

Access Standard Reports

  1. Log into Real Estate Manager and navigate to the Custom Reports section.

  2. Standard reports are listed under Custom Reports and labeled as Standard Report Type.

Customize a Standard Report (Optional)

  1. Click Edit next to the desired standard report.

  2. Review the pre-selected fields designed to analyze the portfolio.

  3. Add additional fields if needed

  4. Click Save. Once saved, the customized report appears under Saved Reports Type with a Global tag.

Generate and Share Reports

  1. Click Export to run the report based on the selected filters.

  2. Click Email to send the report directly via email.

  3. Click Delete to delete the saved report type.

    Note: Delete option is available only for the saved or customized report types. The standard report templates cannot be deleted.

Data Sources for Custom Reports

Data Source

Description

Parent Data Source: Asset

Asset location and Custom Fields for Assets

Asset Contract

Contract information, including Contract definitions and costs

Asset Contractors

Contractor roles and Certifications

Asset Costs

Costs defined on Contracts and Invoices

Asset File

Files uploaded for an Asset

Asset Invoices

Information on Asset Invoices

Asset Invoice Costs

Information in an Invoice Cost section

Asset Invoice Vendor

Information about Vendors on Invoices

Asset Valuations

Valuations added for the Asset

Parent Data Source: Contract

Contract information and Custom Fields

Contract Asset

Information about the Asset, including Custom Fields

Contract Clauses

Clauses attached to the Contract

Contract File

Files uploaded for a Contract

Contract Invoices

Invoices related to a Contract

Contract Invoice Costs

Cost information for Contract Invoices

Contract Invoices (row filter)

Invoices related to Contracts with row filters of filter by contract invoice costs and filter by contract invoices

Contract Leased Asset Details

Information from leased assets specific to Lease Accounting Significant contracts

Parent Data Source: Invoice

Invoice information and Custom Fields

Invoice Costs

Costs for an Invoice

Invoice Vendor

Vendor Information for an Invoice

Available Field Types

Icon

Name

Description


Multi-Line

Field consumes multiple lines on the report.


Text

Characters are text, including numeric.


Configurable

Field requires you to specify certain definitions or requirements.


Numeric

Numeric characters that can be used in calculations.


Checkbox

Field is binomial and data consists of one of two choices.


Monetary

Field is a monetary value.


Date

Field is a date.

Available Fields by Data Source

Data Source: Asset

Address (Full)

Currency Code

Marketing for Sublease (Y/N)

Address City

Current Index

Measurement Field Test

Address Country

Date Assignment/Sublet Requested

Method of Notice Comments

Address Country Code

Division

Multi-Tenant (Y/N)

Address Latitude

Electrical

Name

Address Line 1

Electrical – Comments

Notes

Address Line 2

Elevator – Warranty Expiration Date

Occupied (Y/N)

Address Longitude

Elevator Repairs

OPEX/CAMS Base Year

Address Postcode

Entity

OPEX/CAMS Comments

Address State

Exposure (N/E/S/W)

Ownership

Address State (Abbrv)

Exterior Doors

Parent Name

Approval Date

Exterior Doors – Comments

Parking Lot

Archive Date

Fire Alarm (Y/N)

Parking Lot – Comments

Area available for Sublease

Fire Sprinklers (Y/N)

Permission Required (Y/N)

Asset Files (List)

Floors in Building

Previous Index

Asset Files with Path (List)

Floors Occupied

Primary Use

Asset Owner

Force Majeure Clause Exists

Property Tax Comments

Asset Type

Force Majeure Comments

RE Comments

Asset User

Foundations

RE Status

Assignment/Sublet Lease Reference

Foundations – Comments

RE Strategy

Assignment/Sublet Primary Contact

FTE Capacity

Reference Number

Assignment/Sublet Project Manager

FTE Headcount

Rentable Area (Gross)

Assignment/Sublet Status

Full Name

Rentable Area UOM

Attached Contracts (List)

Gross-up (Y/N)

Request Made (Y/N)

Base Index

HVAC – Warranty Expiration Date

Return Date

Boiler – Warranty Expiration Date

HVAC Maintenance

Roof

Boiler Repairs

HVAC Maintenance – Comments

Roof – Comments

Building Area

HVAC Repairs

Roof – Warranty Expiration Date

Building Area UOM

HVAC Replacement

Roof Repairs

Business Unit

HVAC Replacement – Comments

Security Alarm (Y/N)

Child Assets – SQM (List)

Index Base Date

Security Guards (Y/N)

Co-Tenancy

Index Type

Status

Co-Tenancy – Comments

Indexed Adjustment Date

Subdivision

Co-Tenancy – Tenant List

Land Area

Tenant Default

Co-Tenancy Clause Exists

Landlord Default

Usable Area UOM

Common Areas

Lease Abstracted By

Usable Area (Net)

Common Areas – Comments

Lease Fully Abstracted (Y/N)

Year Build

Construction Type

Lease Last Update Date

Zoning

Currency

Lease Reference

Data Source: Asset Contract

Approval Date

Current – Selected Costs

Next Option – End

Assignment/Sublet Lease Reference

Current – Selected Costs – Total

Next Option – Exercise End

Assignment/Sublet Project Manager

Current – Selected Costs P.A.

Next Option – Exercise Start

Assignment/Sublet Status

Current – Selected Costs P.A. – Total

Next Option – Name

Audit Restriction Comments

Current Index

Next Option – Start

Base Index

Current Option Duration – Months

Next Option Duration – Months

Break Clause Summary

Current option Duration – Text

Next Option Duration – Text

Break Cluse – Expands

Current Review – All Costs P.A. – Total

Next Review – Costs (Expands)

Building Area

Current Review – Effective Date

Next Review – Date

Commencement – All Costs P.A. – Total

Current Review - Notes

Next Review – Notes

Commencement – Other Costs P.A. - Total

Current Review – Review Date

Next Review – State

Commencement – Selected Costs

Current Review – Type

Next Review – Type

Commencement – Selected Costs – Total

Current Term End

Notes

Commencement – Selected Costs P.A.

Current Term Start

OPEX/CAMS Base Amount

Commencement – Selected Costs P.A. – Total

Deadline to dispute/audit/settle

OPEX/CAMS Base Year

Commencement Costs – Summary

Description

OPEX/CAMS Comments

Contract Absolute Duration – Months

Gross-up (Y/N)

Options – Expands

Contract Absolute Duration – Text

Gross-up %

Other Party

Contract Absolute Expiry Date

Guarantees (Expands)

Percentage of area unoccupied by tenant

Contract Commencement Date

Historical Costs – Summary

Permission Required for Assignment/Sublet (Y/N)

Contract Current Duration – Months

HR Site ID

Previous Index

Contract Current Duration – Text

In Holdover

Pro Rata Share %-Bldg

Contract Direction

Index Base Date

Pro Rata Share %-Site

Contract Expiry Date

Index Type

Property Tax Comments

Contract Files (List)

Indexed Adjustment Comments

RE Comments

Contract Files with Path (List)

Indexed Adjustment Date

RE Status

Contract Liability

Is Archived

Reference Number

Contract Options Detail

Lease Abstracted By

Request for Assignment/Sublet Made (Y/N)

Contract Type

Lease Fully Abstracted (Y/N)

Restrictions on who can perform audit? (Y/N)

Contracting Party

Lease Last Update Date

Tax Base Amount

Contractor

Lease Reference

Tax Base Year

Currency

Lease Reviewed/Approved By

Total Liability (ex Tax)

Currency Code

Liability End

Total Liability (inc Tax)

Current – All Costs – Summary

Liability Start

Total Tax Liability

Current – Other Costs P.A. - Total

Measurement Field Test

Unoccupied Area

Data Source: Asset Contractors

Certifications - Expands

Fully Certified?

Contractor – Expands

Role Name

Data Source: Asset Costs

Category

Currency

Periodic Cost Total (Invoices)

Category is Gross?

Group

Periodic Costs (Contracted)

Cost Direction

Periodic Cost Total (Contracts)

Periodic Costs (Invoiced)

Data Source: Asset Valuations

Valuations

Data Source: Asset Invoice Costs

Apportionment Splits

Cost Category

Tax Amount

Asset

Cost Category Ledger Code

Tax Jurisdiction

Asset Address

Incurred End Date

Tax Rate Multiplier

Asset Description

Incurred Start Date

Tax Rate Name

Base Amount

Label

Total Amount

Data Source: Asset Invoice Vendor

Contact Short Name

LA Roles

Phone 1

Currencies

Mobile

Phone 2

Email

Name

Fax

Notes

Data Source: Asset Invoices

AP Export Status

Invoice Recurrence Frequency

Payment Batch File Name

Cost Categories

Invoice Recurrence Pattern

Payment Batch Last Action Date

Currency

Invoice Type

Payment Batch Last Action Performed By User

Description

Is Multi Asset

Payment Batch Last Action Performed By Username

Invoice Date

Linked Contract

Payment Batch Last Action Type

Invoice Direction

Notes

Total Base (ex Tax)

Invoice Group

Payee Code

Total Tax (ex Tax)

Invoice Number

Payment Batch Description

Vendor

Approval Date

Current – Other Costs P.A. - Total

Liability Start

Archive Date

Current – Selected Costs

Measurement Field Test

Assignment/Sublet Lease Reference

Current – Selected Costs – Total

Next Option – End

Assignment/Sublet Project Manager

Current – Selected Costs P.A.

Next Option – Exercise End

Assignment/Sublet Status

Current – Selected Costs P.A. – Total

Next Option – Exercise Start

Audit Restriction Comments

Current Index

Next Option – Name

Available for Use Date

Current Option Duration – Months

Next Option – Start

Base Index

Current option Duration – Text

Next Option Duration – Months

Break Clause Summary

Current Review – All Costs P.A. – Total

Next Option Duration – Text

Break Clause – Expands

Current Review – Effective Date

Next Review – Costs (Expands)

Data Source: Asset Costs

Category

Currency

Periodic Cost Total (Invoices)

Category is Gross?

Group

Periodic Costs (Contracted)

Cost Direction

Periodic Cost Total (Contracts)

Periodic Costs (Invoiced)

Data Source: Asset Valuations

Valuations

Data Source: Asset Invoice Costs

Apportionment Splits

Cost Category

Tax Amount

Asset

Cost Category Ledger Code

Tax Jurisdiction

Asset Address

Incurred End Date

Tax Rate Multiplier

Asset Description

Incurred Start Date

Tax Rate Name

Base Amount

Label

Total Amount

Data Source: Asset Invoice Vendor

Contact Short Name

LA Roles

Phone 1

Currencies

Mobile

Phone 2

Email

Name

Fax

Notes

Data Source: Asset Invoices

AP Export Status

Invoice Recurrence Frequency

Payment Batch File Name

Cost Categories

Invoice Recurrence Pattern

Payment Batch Last Action Date

Currency

Invoice Type

Payment Batch Last Action Performed By User

Description

Is Multi Asset

Payment Batch Last Action Performed By Username

Invoice Date

Linked Contract

Payment Batch Last Action Type

Invoice Direction

Notes

Total Base (ex Tax)

Invoice Group

Payee Code

Total Tax (ex Tax)

Invoice Number

Payment Batch Description

Vendor

Approval Date

Current – Other Costs P.A. - Total

Liability Start

Archive Date

Current – Selected Costs

Measurement Field Test

Assignment/Sublet Lease Reference

Current – Selected Costs – Total

Next Option – End

Assignment/Sublet Project Manager

Current – Selected Costs P.A.

Next Option – Exercise End

Assignment/Sublet Status

Current – Selected Costs P.A. – Total

Next Option – Exercise Start

Audit Restriction Comments

Current Index

Next Option – Name

Available for Use Date

Current Option Duration – Months

Next Option – Start

Base Index

Current option Duration – Text

Next Option Duration – Months

Break Clause Summary

Current Review – All Costs P.A. – Total

Next Option Duration – Text

Break Clause – Expands

Current Review – Effective Date

Next Review – Costs (Expands)

Data Source: Contract

Building Area

Current Review – Type

Next Review – Date

Commencement – All Costs P.A. – Total

Current Term End

Next Review – Notes

Commencement – Other Costs P.A. - Total

Current Term Start

Next Review – State

Commencement – Selected Costs

Deadline to dispute/audit/settle

Next Review – Type

Commencement – Selected Costs – Total

Depreciation Start Date

Notes

Commencement – Selected Costs P.A.

Description

OPEX/CAMS Base Amount

Commencement – Selected Costs P.A. – Total

Effective Contract Termination Date

OPEX/CAMS Base Year

Commencement Costs – Summary

First Payment Date

OPEX/CAMS Comments

Contract Absolute Duration – Months

GL Code

Options – Expands

Contract Absolute Duration – Text

Gross-up (Y/N)

Other Party

Contract Absolute Expiry Date

Gross-up %

Percentage of area unoccupied by tenant

Current Review - Notes

Guarantees (Expands)

Permission Required for Assignment/Sublet (Y/N)

Contract Commencement Date

Historical Costs – Summary

Previous Index

Contract Current Duration – Months

HR Site ID

Pro Rata Share %-Bldg

Contract Current Duration – Text

In Holdover

Pro Rata Share %-Site

Contract Direction

Index Base Date

Property Tax Comments

Contract Expiry Date

Index Type

RE Comments

Contract Files (List)

Indexed Adjustment Comments

RE Status

Contract Files with Path (List)

Indexed Adjustment Date

Reference Number

Contract Liability

Is Archived

Request for Assignment/Sublet Made (Y/N)

Contract Options Detail

Is Contract Terminated

Restrictions on who can perform audit? (Y/N)

Contract Type

LARR Status

Tax Base Amount

Contracting Party

Lease Abstracted By

Tax Base Year

Contractor

Lease Accounting Contract Type

Total Liability (ex Tax)

Cost Center

Lease Fully Abstracted (Y/N)

Total Liability (inc Tax)

Currency

Lease Last Update Date

Total Tax Liability

Currency Code

Lease Reference

Unoccupied Area

Current – All Costs – Summary

Lease Reviewed/Approved By

Current Review – Review Date

Liability End

Data Source: Contract Asset

Address (Full)

Division

Measurement Field Test

Address City

Effective Contract Termination Date

Method of Notice Comments

Address Country

Electrical

Multi-Tenant (Y/N)

Address Country Code

Electrical – Comments

Name

Address Latitude

Elevator – Warranty Expiration Date

Notes

Address Line 1

Elevator Repairs

Occupied (Y/N)

Address Line 2

Entity

OPEX/CAMS Base Year

Address Longitude

Exposure (N/E/S/W)

OPEX/CAMS Comments

Address Postcode

Exterior Doors

Ownership

Address State

Exterior Doors – Comments

Parent Name

Address State (Abbrv)

Fire Alarm (Y/N)

Parking Lot

Approval Date

Fire Sprinklers (Y/N)

Parking Lot – Comments

Area available for Sublease

Floors in Building

Permission Required (Y/N)

Asset Files (List)

Floors Occupied

Previous Index

Asset Files with Path (List)

Force Majeure Clause Exists

Primary Use

Asset Type

Force Majeure Comments

Property Tax Comments

Assignment/Sublet Lease Reference

Foundations

RE Comments

Assignment/Sublet Primary Contact

Foundations – Comments

RE Status

Assignment/Sublet Project Manager

FTE Capacity

RE Strategy

Assignment/Sublet Status

FTE Headcount

Reference Number

Attached Contracts (List)

Full Name

Rentable Area (Gross)

Base Index

Gross-up (Y/N)

Rentable Area UOM

Boiler – Warranty Expiration Date

HVAC – Warranty Expiration Date

Request Made (Y/N)

Boiler Repairs

HVAC Maintenance

Return Date

Building Area

HVAC Maintenance – Comments

Roof

Building Area UOM

HVAC Repairs

Roof – Comments

Business Unit

HVAC Replacement

Roof – Warranty Expiration Date

Child Assets – SQM (List)

HVAC Replacement – Comments

Roof Repairs

Co-Tenancy

Index Base Date

Security Alarm (Y/N)

Co-Tenancy – Comments

Index Type

Security Guards (Y/N)

Co-Tenancy – Tenant List

Indexed Adjustment Date

Status

Date Assignment/Sublet Requested

Is Contract Terminated

Subdivision

Co-Tenancy Clause Exists

Land Area

Tenant Default

Common Areas

Landlord Default

Usable Area UOM

Common Areas – Comments

Lease Abstracted By

Usable Area (Net)

Construction Type

Lease Fully Abstracted (Y/N)

Year Build

Currency

Lease Last Update Date

Zoning

Currency Code

Lease Reference

Current Index

Marketing for Sublease (Y/N)

Data Source: Contract Clauses

Amendment Clause Text

Interpretation

Reason

Amendment Date

Is Active

Receivable From Contact

Amount Payable

Latest Invoke Date

Recorded At Utc

Amount Receivable

Lease Page Number

Recorded By User

Area

Notes

Reminder Date

Category

Original Clause Text

Section

Clause

Outcome

Triggered On

Comments

Payable to Contact

Year

Documents

PDF Page Number

Earliest Invoke Date

Percentage

Data Source: Contract Invoice Costs

Apportionment Splits

Cost Category

Tax Amount

Asset

Cost Category Ledger Code

Tax Jurisdiction

Asset Address

Incurred End Date

Tax Rate Multiplier

Asset Description

Incurred Start Date

Tax Rate Name

Base Amount

Label

Total Amount

Data Source: Contract Invoices

AP Export Status

Invoice Number

Payment Batch Description

Contact Short Name

Invoice Recurrence Frequency

Payment Batch File Name

Cost Categories

Invoice Recurrence Pattern

Payment Batch Last Action Date

Currencies

Invoice Type

Payment Batch Last Action Performed By User

Currency

Is Multi Asset

Payment Batch Last Action Performed By Username

Description

LA Roles

Payment Batch Last Action Type

Email

Linked Contract

Phone1

Fax

Mobile

Phone2

Invoice Date

Name

Total Base (ex Tax)

Invoice Direction

Notes

Total Tax (ex Tax)

Invoice Group

Payee Code

Vendor

Data Source: Contract Option

End

Exercise Start

Start

Exercise End

Name

Term Notes

Data Source: Contract Leased Asset Details

Asset Owner

Business Unit

Entity

Asset User

Cost Center

Fair Market Value

Available For Use Start Date

Depreciation Start Date

GLCode

Data Source: Invoices

AP Export Status

Invoice Recurrence Frequency

Payment Batch Last Action Performed By User

Cost Categories

Invoice Recurrence Pattern

Payment Batch Last Action Performed By Username

Currency

Invoice Type

Payment Batch Last Action Type

Description

Is Multi Asset

Phone1

GL Code

Linked Contract

Phone2

Invoice Date

Notes

Total Base (ex Tax)

Invoice Direction

Payee Code

Total Tax (ex Tax)

Invoice Group

Payment Batch Description

Vendor

Invoice Number

Payment Batch File Name

Invoice Recurrence Frequency

Payment Batch Last Action Date

Data Source: Invoice Costs

Apportionment Splits

Cost Category

Tax Amount

Asset

Cost Category Ledger Code

Tax Jurisdiction

Asset Address

Incurred End Date

Tax Rate Multiplier

Asset Description

Incurred Start Date

Tax Rate Name

Base Amount

Label

Total Amount

Data Source: Invoice Vendor

Contact Short Name

LA Roles

Phone 1

Currencies

Mobile

Phone 2

Email

Name

Fax

Notes

Was this article helpful?

We're sorry to hear that.