Use this program to update open reservations and/or open RAs with rates from a newer version of the rate product than the one that was used for the original transaction.

For example, some operations have corporate rates that are re-negotiated annually or more frequently. Once negotiated, reservations that were entered in the system prior to the negotiations being finalized should have their rates changed to the new rates. Likewise, it may be that RAs that are currently open should also be updated with the newly negotiated rates.

Prior to running this program create a new version of the rate with a new effective date. Then use this program to update open reservations and RAs with the new rates.

To access the Update Res/Rental Rates program, type RTCHNG (RET) at any menu "OPTION:" field or the appropriate line number on the Rental Rates menu. The screen will then display:

OPTION: __ UPDATE RES/RENTAL RATES

1 Rate set
2 Product
3 Date
4 Time
5 CDPID# ALL
6 Bill to# ALL
7 IT# ALL
8 Start Res Create Date EARLIEST
9 Start res P-U Date 01-14-10
10 RA Open Date 01-15-10
11 Include Vouchers Y

Read cnt Write cnt
Res Counts

RA Counts




1SAVE 2 3ERASE 4 5BACKUP 6 7HELP 8

Enter data as follows:


 These first two fields (along with fields 5 through 11) are used to select the transactions to be updated.

1. RATE SET

Enter a one or two character alphanumeric code for the Rate Set for the rate that was edited.

EXAMPLE: Type C (RET)

2. PRODUCT

Enter up to 12 alphanumeric characters to indicate the the Rate Product that was edited.

EXAMPLE: Type CORPA (RET)

In this case, all open Reservations and Open RAs that currently have the Rate Product CORPA in Rate Set C will be checked to see if the prices should be updated. Transactions that should have used C/CORPA but did not because of a set-up error with that rate product will NOT be looked at.

3. DATE

Using the selected date format, enter the effective date for the new version of the Rate Product in Field 2.

EXAMPLE: Type 010110 (RET)

4. TIME

Using the selected time format, enter the effective time for the rate product that was edited.

EXAMPLE: Type 0000 (RET)

The next seven fields allow the user to limit the extent of this update.
5. CDPID#

Enter:

A single CDPID number to apply the changes to only those open Reservations and RAs with the CDPID number.

or

Press (RET) to apply the change to all open RAs and Reservations regardless of the CDPID number.

EXAMPLE: Type: 123456 (RET)
6. BILL TO#

Enter:

A single bill-to number to apply the changes to only those open Reservations and RAs with the bill-to number.

or

Press (RET) to apply the change to all open RAs and Reservations regardless of the bill-to number.

EXAMPLE: Press (RET)

7. IT#

Enter:

A single IT number to apply the changes to only those open Reservations and RAs with vouchers with the IT number.

or

Press (RET) to apply the change to all open RAs and Reservations regardless of the voucher IT number.

EXAMPLE: Press (RET)
8. START RES CREATE DATE
 Enter a starting reservation create date or press (RET) to default to "EARLIEST". If a date is entered, reservations created as of that date or later will be eligible for this update.

EXAMPLE: Press (RET)
9. START RES P-U DATE
 Enter a starting reservation pick up date or press (RET) to default to the current day. If a pick up date is entered, reservations with that pick up date or a later day will be eligible for this update.

EXAMPLE: Press (RET)
10. RA OPEN DATE
 Enter a starting RA Open date. If the RA opened after the date entered, the RA will be eligible for this update.

NOTE: Accepting the default date of tomorrow causes open RAs to be excluded from this update.
11. INCLUDE VOUCHERS
 Indicate if the rates on vouchers should be included in the update. Enter:

Y = On eligible records, update the net rate on the voucher.
N = On eligible records, do not update the net rate on the voucher.

EXAMPLE: Type Y (RET)


Records are updated as follows:

If the transaction qualifies for an update (that is, the rate, dates, CDPID, Bill-to #, IT# etc. match) and there is a more recent version of the rate:
The effective date/time on the reservation or RA rate will be changed to the effective date/time entered in Fields 3 and 4.
The rate amounts will be re-written using the current rates referred to by the Rate set, product, effective date/time in Fields 1-4.
If vouchers are included, the net rates for the voucher will be re-written.