Some Micro-English Examples:
RMSRESV WITH ARRIVAL >= &ENTER 1ST ARRIVAL DATE& AND ARRIVAL <= &ENTER LAST ARRIVAL DATE& BY ZIP.CODE INTO LABELS.FIL
This sentence will set up a group of labels that will print from the Reservation Reports Print Labels or envelopes option using the [Last Resv] button that is available within that report option. The group that prints out depends on what arrival dates are used for the parameters.
RMSRESV WITH ARRIVAL >= &ENTER 1ST ARRIVAL DATE& AND ARRIVAL <= &ENTER LAST ARRIVAL DATE& BY ZIP.CODE PRINT RESERVATION.NUMBER NAME
This sentence will print a list of reservation numbers and names of guest arriving within the dates you enter. It is helpful to run this report prior to running the above report for labels to see the list prior to printing the labels.
RMSOWNER BY A0 BUILD TEXT FILE OWNRMAIL.TXT OWNERS.NAME ADDRESS.LINE.1 ADDRESS.LINE.2 ADDRESS.LINE.3
This sentence will give you a quote comma delimited ASCII file named OWNERMAIL.TXT containing nothing more than the owner’s name and address. Address line 2 will only have information if there is any. Address line 3 has the city, state and zip information. This type of ASCII file is suitable for importing into other programs as needed.
RMSMAIL WITH (INQUIRY.DATE >= &ENTER 1ST DATE OF INQUIRY & AND INQUIRY.DATE <= &ENTER LAST DATE OF INQUIRY &) OR (DATE.RESERVED >= &ENTER 1ST DATE OF RESERVATION & AND DATE.RESERVED <= &ENTER LAST DATE OF RESERVATION &) AND ZIP.CODE >= &ENTER FIRST ZIP CODE & AND ZIP.CODE <= &ENTER LAST ZIP CODE & BY ZIP.CODE INTO LABELS.FIL
This report allows you to print labels from your mail file based on the date of inquiry or the date of reservation and a range of zip codes. The labels are always sorted by zip code. This process of printing labels is always a two step process. First run the select report to select which entries to print and then run the label print report with in RMS, using the "Last" button immediately after running this select sentence. See more details on this report.
RMSMAIL BUILD TEXT FILE MAIL.TXT NAME ADDRESS.LINE.1 ADDRESS.LINE.2 CITY STATE ZIP.CODE
This sentence will create a text file called mail.txt in the RMS directory or folder. All the names and addresses from the mail file are included. It would be suitable to import using excel. Some marketing companies request mail lists in excel or as a text file.
RMSMAIL BUILD TEXT FILE MAIL.TXT NAME ADDRESS.LINE.1 ADDRESS.LINE.2 CITY STATE ZIP.CODE E.MAIL
This sentence is exactly the same as the previous sentence except it also includes e-mail addresses.
RMSRESV WITH ARRIVAL >= &Enter first arrival date : & AND ARRIVAL <= &Enter last arrival date : & BY ARRIVAL UNIT.NUMBER PRINT ARRIVAL UNIT.NUMBER RESERVATION.NUMBER STATUS.CODE PRIMARY.NAME
This sentence will select the reservation file reporting on only the reservations that arrive between the entered dates inclusive. The report will be sorted in sequence of arrival first and within arrival by unit number. The arrival date, unit number, reservation number, status code and primary name will be printed on the report.
RMSGLTRN WITH DATE = "020199" AND GL.ACCOUNT.NUMBER = 100 BY AMOUNT DISPLAY DATE GL.ACCOUNT.NUMBER DESCRIPTION AMOUNT
This sentence will select the general ledger transaction file reporting only on transactions that are dated 02/01/99 and whose general ledger account is 100. The report will be sorted in sequence of amount. The report will display to the screen the date, general ledger account number, description and the amount.
RMSRSVA USING RMSRESV.DCT WITH (UNIT.NUMBER = 1000 OR UNIT.NUMBER = 2000) AND ARRIVAL >= '010199' AND ARRIVAL <= '013199' BY UNIT.NUMBER ARRIVAL PRINT UNIT.NUMBER ARRIVAL RESERVATION.NUMBER TOTAL OWNERS.GROSS.INCOME
This sentence will select the reservation archive file by using the reservation dictionary file for all records containing the unit number 1000 or unit number 2000 and they must have arrived in January 1999. The report will be sorted in sequence of unit number and then within unit number by arrival date. The report will print the unit number, arrival date, and reservation number and total the owner gross income.
RMSRESV BY UNIT.NUMBER BREAK PAGE UNIT.NUMBER PRINT UNIT.NUMBER TOTAL OWNERS.GROSS.INCOME TOTAL COMMISSION
This report will select all reservations in the current reservation file. The report will be sorted in sequence of unit number. Each time the unit number changes totals for the owner gross income and the commission amount will be printed and the printer will advance to the top of a new page. This will produce each unit on a new page. The report will print the owner’s gross income, the commission amount and the totals for these amounts.
RMSRESV WITH BALANCE.OWED > "0.00" AND ARRIVAL >= &ENTER FIRST ARRIVAL DATE: &AND ARRIVAL <= &ENTER LAST ARRIVAL DATE: & DISPLAY RESERVATION.NUMBER UNIT.NUMBER NAME BALANCE.OWED BALANCE.DUE.DATE BEGINNING.AMT.DUE HOME.PHONE
This report will display information from the current reservation file. You will be prompted for a beginning arrival date and a last arrival date of the reservations you are inquiring about. The reservation number, unit number, name of the guest, the amount they owe, the date it’s due and the beginning amount they owed before any payment, and their home phone number will be displayed. Because there are so many different dictionary items used the report will use a paragraph form. Try this same report substituting print for the word display. If you remove the beginning amount due dictionary item, the report will be in the columnar form.
Try modifying the sample sentences using the clause information from How to Create a Custom Report . With a little practice, you will find that the Report Generator in your Resort Management System is a powerful tool for your business!