This utility can be used to copy rates from one service option to a range of service options based on the selections offered.

Copy Rates - Source Service Selection

In this example, new seasons rates for ‘Pass’ style accommodation is going to be copied from a ‘source’ service option, to those services that have the correct Database Analysis Code identifying them as the same pass type as the source option.

Copy Rates

1. Select menu Home > Product > Product Utilities > Rate Maintenance > Copy Rates.

   1. From Products click the Product Utilities menu to expand it:

      

   2. Select the Rate Maintenance menu to expand it:

      

   3. Select the Copy Rates option to filter selection and display results on screen:

      

2. On the Copy Rates screen the From Tab will open, enter a date range for Rates Based On and Based To, select required filter fields to narrow search results.

   

3. Select the To Tab, select required filter fields to narrow search for the rate to be copied to.

   

4. Check the completed screens.
5. View returned results either:
   1. Click on the Results Tab, or

      

   2. Select the Search button.

      

6. Click Save to keep the changes.

   

7. A further Copy Rates screen will show, fields can be selected controlling how the rate is to be modified. See Copy Rates Second Screen for field selections.
8. Click Save to keep the changes.

   

 

Location (Drop-down)

The Location Code of the option being copied from – the ‘source’ option.

Service (Drop-down)

The Service Code of the option being copied from – the ‘source’ option.

Supplier (Drop-down)

The Supplier Code of the option being copied from – the ‘source’ option.

Option (6 Chrs)

The Option Code of the option being copied from – the ‘source’ option.

Select Rates By

Based on/to (Date)

A From Date/To Date selection. The date ranges of the rates to be copied.

Cost Currency (Drop-down)

Rates with the selected Cost Currency. Leave blank to select all Cost Currencies.

Sell Currency (Drop-down)

Rates with the selected Sell Currency. Leave blank to select all Sell Currencies.

Rate Status (Multi Select List Box)

All or selected Rate Statuses.

Price Code (Multi Select List Box)

All or selected price codes.

---

Copy Rates - Select Options to Copy To

In this screen, the service options to be copied to can be selected based on:

• Location From/To
• Service Code – All or Selected
• Supplier From/To
• Option Code From/To
• Database Analysis Codes 1 - 6, all or selected

---

Copy Rates Second Screen Selection

The rates to be copied can be modified via the second selection screen, but no modification is required in this example.

 

Cost Currency (Radio Button/Drop-down)

Choices are to Retain Existing Currency or Change To. If change to is checked, the new cost currency can be selected from the drop down.

---

FIT Cost

Change By (Numeric 5.2)

This field refers to the FIT Cost Rate field in the Service Rates screen. A numeric value can be entered into this field

%

The two choices available from the drop-down indicate whether the value in the Change FIT Cost field is a percentage (%) or a currency amount (Flat Rate). The combination of these two fields will adjust the values of the FIT Cost column in the Service Rates screen.

Round To Nearest (Drop-down)

There are 6 choices available from the drop down. They are: No rounding, Nearest 0.10, Nearest 0.50, Nearest 1.00, Nearest 5.00 or Nearest 10.00. Rounding is on the basis of up to .5 round down; over .5 round up.

---

Groups Cost

Change By (numeric 5.2)

This field refers to the Group Cost Rate field in the Service Rates screen and can have a numeric value entered.

%

The two choices available from this drop-down, indicates whether the value in the Change Groups Cost field is a percentage (%) or a currency amount (Flat Rate). The combination of these two fields will adjust the values in the Group column in the Service Rates screen.

Round To Nearest (Drop-down)

There are 6 choices available from the drop down. They are: No rounding, Nearest 0.10, Nearest 0.50, Nearest 1.00, Nearest 5.00 or Nearest 10.00. Rounding is on the basis of up to .5 round down; over .5 round up.

Sell Currency (Radio Button/Drop-down)

Choices are to Retain Existing Currency or Change To. If "Change To" is checked, the new cost currency can be selected from the drop down.

---

FIT Sell

Change By (Numeric 5.2)

This field refers to the FIT sell rate and can have a numeric value entered.

%

This drop-down determines how the value in Change FIT Sell value will be applied:

%	The value will be applied as percentage to existing FIT Sell Rates.
MUP%	The value will be applied as a markup % to the FIT Costs
Flat Rate	The value will be applied as a flat rate (currency amount)

Round To Nearest (Drop-down)

There are 6 choices available from the drop down. They are: No rounding, Nearest 0.10, Nearest 0.50, Nearest 1.00, Nearest 5.00 or Nearest 10.00. Rounding is on the basis of up to .5 round down; over .5 round up.

---

Groups Sell

Change By (Numeric 5.2)

This field refers to the Group Sell rate and can have a numeric value entered.

%

This drop-down determines how the value in Change Groups Sell value will be applied:

%	The value will be applied as percentage to existing Group Sell Rates.
MUP%	The value will be applied as a markup % to the Group Costs
Flat Rate	The value will be applied as a flat rate (currency amount)

Round To Nearest (Drop-down)

There are 6 choices available from the drop down. They are: No rounding, Nearest 0.10, Nearest 0.50, Nearest 1.00, Nearest 5.00 or Nearest 10.00. Rounding is on the basis of up to .5 round down; over .5 round up.

Exchange Rate (Radio Button/Numeric)

If the buy and sell currencies in the service are different, then the exchange rate used to calculate the rate can be updated here (see Maintaining Exchange Rates).

Rate Status (Button/Drop-down)

If retain existing is selected no further selections are required for this field, the existing rate status of the price code/date range will be retained. However if 'change to' is selected there are 5 choices from the drop-down enabling the rate status to be changed to:

Closed	The Rate Status will be changed to Closed
Confirmed	The Rate Status will be changed to Confirmed
Manual	The Rate Status will be changed to Manual
Provisional	The Rate Status will be changed to Provisional
Terminal	The Rate Status will be changed to Terminal

---

Options

Set Apply Markup (Drop-down)

This choice can update the ‘Sell With Markup’ flag. The options are Retain Existing Value, Yes (will set the Sell With Markup Flag ‘On’), or No (will set the ‘Sell With Markup Flag ‘Off’)

Update Pax Breaks (Check box)

Checking this box ensures that all rates that are against any existing Pax Breaks are also updated.

Always Round Up (checkbox)

When checked, any rounding will always be up.

Attach Taxes (Radio Button)

This field gives the choice of either retaining any existing taxes that have already been attached, have no taxes attached (None) or Attach Taxes selected.

Taxes (Check box)

When the ‘Attach Selected’ radio button (in Attach Taxes above) is checked, the list of available taxes displays and the applicable tax(es) can be checked.