Statistics and Manual
Adjustments to Statistics
Added 10/09/02 -
Article ID#: K000110
Reports have zero or incorrect Totals
This problem usually results from a hardware failure that corrupted data.
It may not be possible to regenerate the data in all circumstancs.
Statistical records are generated when the
day is closed in RDP. Two types of records are created for each
reservation that is currently in-house when the day is
- A record is added to Statfile.dat.
This file contains the reservation's statistical detail.
Reports such as the 375-Rev by Market Code Detail and the 377-Rev by
State Detail read the Statfile.dat.
- A record is also added to either
TotalsXX.dat or OtotalXX.dat. Reports such as the 374-Rev by
Market Code Totals and the 376-Rev by State Totals read the Totals
If you have the Statistical detail, then
Statistical totals can be recreated.
If you are missing the Statistical detail, this information cannot be
regenerated. It is possible, however, to make adjusting entries to
the Statistical totals.
Procedure if detail exists.
- Menu 99, option 902 Rebuild Stats.
- Enter Month in the format of YYMM.
For example, September 2002 would be entered as
- Re-run report.
Note: Option 902-Rebuild has very limited capabilities. It does not add
statistical records to file 63(STATFILE.DAT). It only reads existing
records in file 63 and adds the totals from these records into the
TotalsYY and OtotalsYY files. New statistical records are only added
to file 63 when the day is closed. As a result it is critical to
make sure that no errors are generated each night when the date is
changed to the new day with RDP900. Use option 908 to view the
system log file to check to see if RDP902 is starting and ending
correctly each day during the day closing procedure.
Procedure if detail is missing.
Manually determine the room revenue
- Go to menu 3 (Night Audit), reports,
and choose 370. If there are transactions to explode, you can
choose option 1 (continue and new transactions will not appear.)
- Enter date that the detail is missing.
- Choose option 3 (General Ledger
Account), then A, <enter> twice, P to print report.
- Note the room revenue gl account and
the figure in the today column.
Make adjusting entry to statistical
- Go to menu 98 (System Manager), 184,
- <Enter> for year, enter MC in
the statistical category.
- <F3> and choose your most common
- Enter the month, i.e. 10 for October.
- Enter the day you wish to adjust.
- Enter the room revenue total from step
- Enter a description
- In the following statistical
categories, <F3> and choose your most common value.
This procedure above will create 1
adjustment to each of the selected statistical categories. For
example, if your room revenue from the 370 was $5000 then you will have
just made a $5000 entry to 1 market code, 1 source of business, 1 room
type, and 1 state. We realize not all $5000 came from just 1
market code, but the combinations are endless.