Fairmas Exports

Modified on: Wed, 11 Sep, 2024 at 8:33 AM

Applies to:          Stayntouch PMS          

Fairmas Exports


There are two custom exports that can be configured for Fairmas and emailed to Fairmas daily to include the data they require. These reports can be configured from Reports > Schedule a Report/Export > Custom Exports > +NEW EXPORT > Stays. The following reports should be scheduled:
  • Fairmas Actual
  • Fairmas Forecast


FAIRMAS ACTUAL

  • Select Fields: The following fields must be selected:
    • DATE
    • HOTEL CODE
    • RESERVATION STATUS
    • ROOM TYPE
    • BLOCK COUNT
    • SOLD
    • ROOM REVENUE
    • ADDON REVENUE
    • FNB REVENUE
    • OTHER REVENUE
    • TAX REVENUE
    • FEE REVENUE
    • TOTAL REVENUE
    • ARRIVAL ROOM COUNT
    • DEPARTURE ROOM COUNT
    • RATE CODE
    • ADULTS
    • CHILDREN
    • HOTEL NAME
    • MARKET CODE
    • TRAVEL AGENT
  • Set Filters: The following filters must be selected:
    • FIELD NAME: Date
    • DURATION: Last 30 days
  • Frequency: The export should be configured for the following frequency:
    • REPEATS: Daily
    • REPEATS EVERY: 1 Day
    • STARTS ON: Select the current date.
    • STARTS AT: Select the desired time.
    • ENDS ON: NEVER
  • Delivery:
    • DELIVERY METHOD: Email Export Delivery Type
    • ADD RECIPIENT: Should be delivered to Fairmas.
  • EXPORT NAME: FAIRMAS_ACTUAL
  • OUTPUT FORMAT: CSV
  • Choose INCLUDE CSV HEADER.
  • SAVE EXPORT



FAIRMAS FORECAST

  • Select Fields: The following fields must be selected:
    • DATE
    • HOTEL CODE
    • RESERVATION STATUS
    • ROOM TYPE
    • BLOCK COUNT
    • SOLD
    • ROOM REVENUE
    • ADDON REVENUE
    • FNB REVENUE
    • OTHER REVENUE
    • TAX REVENUE
    • FEE REVENUE
    • TOTAL REVENUE
    • ARRIVAL ROOM COUNT
    • DEPARTURE ROOM COUNT
    • RATE CODE
    • ADULTS
    • CHILDREN
    • HOTEL NAME
    • MARKET CODE
    • TRAVEL AGENT
  • Set Filters: The following filters must be selected:
    • FIELD NAME: Date
    • DURATION: Current + 12 Months
  • Frequency: The export should be configured for the following frequency:
    • REPEATS: Daily
    • REPEATS EVERY: 1 Day
    • STARTS ON: Select the current date.
    • STARTS AT: Select the desired time.
    • ENDS ON: NEVER
  • Delivery:
    • DELIVERY METHOD: Email Export Delivery Type
    • ADD RECIPIENT: Should be delivered to Fairmas.
  • EXPORT NAME: FAIRMAS_FORECAST
  • OUTPUT FORMAT: CSV
  • Choose INCLUDE CSV HEADER.
  • SAVE EXPORT



Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.