previous

Active Contracts Report (REP_FITCONTRACT.REP with REP_FITCONTRACT.FMX)

The Active Contracts Report is a listing of all active FIT contracts as selected on the report form. This report can be created with specific FIT Contracts, or can be filtered by contract type, owner, status, discount level, or date range. This report is only available in S&C or SFA when the application function FIT Contracts is set to Y.

When this report is run for an SFA Resort, the report data will pull from the Main Contract

  1. The Project Room Nights and Revenue will be a summary of all the Hotels and:
  2. The Notes will pull from the Main Contract.

3. When run for a specific Resort, the report data will pull from that Hotel’s tab and:

  1. The projected Room Nights and Revenue will be based on the selected Hotel.
  2. The Notes will pull from the selected Hotel.

Selection Criteria

Property. Available when either the OPP_MHT2 or OPS_MHT2 license is active. Choose the property for which the report should be printed.

Contract Date Range From/To. Use the From/To Contract Date range feature to filter this report for contracts between certain dates.

Status Change Date Range From/To. Use the From/To Status Change Date range feature to filter this report for contracts that have changed to a certain status in a pre-defined date range.

Account IDs. Use this option to search for active contracts of specific accounts. When selected, the Account Search screen displays, allowing you to select one or more account for which to print this report. Bear in mind that accounts having a contract associated with them will display an indicator lamp stating Contract at the bottom of the account search screen; this greatly helps to speed along the process of only adding accounts with contracts to this report.

Contract Type. Use this option to search for active contracts by contract type, i.e. Global Corporate Contract or Local Corporate Contract, etc.

Contract Owner. Use this option to select a Contract Owner for which this report should return active contracts.

Contract Status. Use this option to select specific contract statuses to filter this report by. For example to return only active contracts with a DEF (Definite) status, you would select DEF from this field's LOV.

FIT Contract IDs. Select this option to return specific FIT Contracts for this report. Take note that even though an FIT Contract ID has been selected, that contract may not display if the contract does not meet other search filters used on this report. For instance, if you select three specific contract IDs and also a contract status or a date range that does not match the selected contract, that contract will NOT print on this report.

Discount Level. Use this option to filter FIT Contracts by a specified discount level.

Report Data

The data on this report prints by row for each FIT Contract in the listing. The first row contains the Account Name followed by the following contract details: Primary Address, Account Owner, Contract Owner, Primary Phone, Contact, Contract Name, FIT Contract Type, Property, From/To Date Range, Projected Room Nights, Projected F&B Revenue, Projected Room Revenue, Projected Other Revenue, Projected total Revenue, Global Discount and any Notes that may have been added to the FIT Contract. This report can be printed as a listing of specific FIT Contracts, using the FIT Contract IDs filter, or can be ordered by contract type, contract owner, contract status, discount level, or a date range.

Note: This report has been formatted to open in data delimited format (e.g., via Excel) containing all columns and no surplus formatting labels.