Mass Update Rate Plan(s)

MoversSuite Administration > Accounting and Financial Services > Rate Plan

Mass Update Rate Plan(s) is an interactive screen used to set new rates across one or more Rate Plan Setup records to users with appropriate security settings. Mass Update Rate Plan(s) is found within Rate Plan Setup > the Mass Record Selection Options menu, which is the dropdown indicated in the image Figure 49. Click Mass Update Rate Plan(s) for this functionality.

Figure 49: Mass Record Selection Options menu

Note: Any rate that is tied to a Rate Matrix cannot be updated through the Mass Update Rate Plan(s) screen.

As an overview, the Mass Update Rate Plan(s) process works as follows:

1.    Within the “Filter and Load Rates by…” section, filter by Rate Plan(s), Item Code(s), and/or Effective Dates (No. 1 in Figure 50).

2.    Rate plans(s) that result from the filter will list in the “grid” (No. 3 in Figure 50).

3.    Update any rate within the list manually or select rate plans to apply to updated rates using tools within “Update Rates for Selected Records” (No. 2 in Figure 50).

4.    Review and edit any rates in the list as needed.

5.    Save changes.

Figure 50: Mass Update Rate Plan(s) with section indicators noted.

There are two sets of instructions in this topic:

•    How to use Mass Update Rate Plan(s): Manually set rates

•    How to use Mass Update Rate Plan(s): General Instructions (which utilize the “Update Rates for Selected Rates...” section)

How to use Mass Update Rate Plan(s): Manually set rates

The most common use for this function is to use the Mass Update Rate Plan(s) screen to find all the Rate Plans by item code(s), and then mass update all the rates. This ensures that no Rate Plan with the needed item code(s) is overlooked. Once the list of rate plans is generated and shows in the Grid, each rate can be manually updated and then saved.

To use the “Update Rates for Selected Rates...” section, see “How to use Mass Update Rate Plan(s): General Instructions.”

1.    Create an initial list of one or more rate plans.

2.    Manually update rates.

3.    Save the edits.

STEP 1: Create a list of rate plans. 

Setup Area: Filter and Load Rates by…. section

To find all rates that have certain item codes, use the Item Codes dropdown to select as many item codes as needed. Click OK.

Figure 51: Choose one or more Items Code and click OK.

Click Load Rates. Rate plan(s) that list will have one or more of the item codes selected within their rate plan.

Figure 52: Click Load Rates to apply filters set in the section.

STEP 2: Update one or more rates.

Setup Area: the “Grid”

From the Grid, existing rates will list under Rate, OT Rate, and/or DT Rate columns. Enter new rate(s) within any of the “New” Rate columns. Make any changes as needed. You can navigate to other rate cells by using arrow keys. For example, if you just entered a New Rate in cell and wish to jump to the next cell below it, you can press the down arrow button on your keyboard.

Nothing is saved until Save Changes it clicked and the warning message that appears is confirmed.

In the image below, rates were added to four Rate Plans under New Rate. As new rates are entered, the red pencil icon  will appear on the line items that line item have been edited. Also, at the bottom are two indicators:  “Unsaved” which indicates 4 edits are unsaved and “Total Rows” which notes the number of rows in the list.

Figure 53: Red pencil icon shows on rates that have been edited or entered. Unsaved reflects the total number of items that have the red pencil icon.

STEP 3: Save the changes.

Setup Area: Save Changes button at the bottom of Mass Update Rate Plan(s) screen.

Edits are only saved once the Save Changes button is clicked and Yes is clicked on the “Confirm Save?” screen.

Figure 54: Confirm Save? screen appears after Save Changes button is clicked.

Choosing No on the “Confirm Save?” screen will return you to the Grid and the red pencil icon will still be shown on the lines of rates that have unsaved edits. The icons will remain until a new search is performed, the items are saved, or the screen is closed.

To exit from the Mass Update Rate Plan(s) screen without saving any edits, click the X in the upper right corner of the Mass Update Rate Plan(s) screen.

To continue changing rates in the Grid, just enter different rates, change the filters or the updates. Any of these will cause a prompt that will result in lost changes as explained in the “Confirm Save?” screen.

Each change made to a Rate Plan is tracked within the Admin Tool > Tools > View History Log or Admin History. 

How to use Mass Update Rate Plan(s): General Instructions

These instructions detail how to update rates using the Update Rates for Selected Records…:

1.    Create an initial list of one or more rate plans.

2.    Select from the list the rate plans that are to get the updated rates.

3.    Set the details of the updates to be applied to the selected rates from the list (or “grid.”)

4.    Review the changes.

5.    Choose to save - or exit without making any changes.

STEP 1: Create a list of rate plans. 

Setup Area: Filter and Load Rates by….

Create a list of rate plans using any of the following options individually or in combination with other filters in this section:

•    Rate Plan:  Use this filter when you know the exact Rate Plan(s) you wish to view and/or update.

•    Item Codes: Use this filter to locate all Rate Plans that contain the Item Code(s) selected.

•    Effective Dates: Use this filter to locate Rate Plans by Effective Start Date or Effective End Date.

•    Only Display: Use this filter to view Active, Pending or Expired Rate Plans. By default, this is set to Active.

In the image below, within Filter and Load Rates by… “Local” was selected from the Rate Plans dropdown. When selecting from any dropdown within this section, OK must be clicked to confirm the selections.

Click Load Rates to create a list within the Grid of all the rate plans that meet the criteria set within this section.

Figure 55: Filtering using Rate Plans.

STEP 2: Select Rate Plans in the Grid. 

Setup Area: The Grid

The Grid is simply a list of rates that have met the filtering requirements set in Step 1. The Grid can be filtered and sorted, and the columns can be rearranged by clicking on any column header.

Select the Rate Plans that are to be updated by checking the selection box on the left. Only Rates that are checked will have updates made within Update Rates for Selected Records… applied to them. This step must be completed before Step 3 can be accomplished.

Figure 56: Indicated area shows the line items have been selected. These rates will have the "Update Rates for Selected Records..." changes made to them.

Note: Rates only update if there is a rate set already. Rates can be entered manually for item codes that do not currently have a rate.

STEP 3: Choose rate change criteria. 

Setup Area: Update Rates for Selected Records…

Choices made within this section will apply to all the rates selected within Step 2. Rates are not “officially” changed once Update is clicked. Clicking Update will simply update rates according to the selections made in this section. Of note, rates only update if there is a rate set already. Rates can be entered manually for item codes that do not currently have a rate.

Figure 57: Update Rates for Selected Records... section.

1.    Select a Change By option from the dropdown. The (+) options will increase rates by the amount entered.  The (-) options will decrease rates by the amount entered. 

2.    Enter an amount within Rate, OT Rate, and/or DT Rate. The number will increase or decrease the amount according to the option chosen within Change By.

3.    If used, enter a New Starting Date, which will become the Effective Date for this update.

4.    Click Update.

Within Figure 57, the rates selected within the Grid will be edited using Amount (+), they will have a New Starting Date of 6/1/2024, and the rates will be edited by increasing Rate by $5, OT Rate by $10, and DT Rate by $20.

Note: If a Recurring Billing record has rate based on an Effective Date, then the Effective Date on each Recurring Billing Item for each customer must have the Effective Date updated. Update the Effective Date using Edit Billing Item screen.

STEP 4: Review the changes. 

Setup Area: Update Rates for Selected Records…

Go through the edited rates and verify the rates are as desired. Rates were updated according to what was set within “Update Rates for Selected Records” and which line items were selected. In Figure 58, New Rates where applied and each updated rate was changed by +$5. As rates cannot be edited if there is not one already set, New OT Rate and New DT Rate are empty. New Starting Date is shown.

In Figure 58, notice line items that have edits are indicated with the red pencil   icon. Also, at the bottom are two indicators:  “Unsaved” which indicates 53 edits are unsaved and “Total Rows” which notes the number of rows in the list.

Rates can be manually entered into any line item at any time and can be entered to “override” what was updated using the Update Rates by Selected Records…. section. Feel free to change variables and rates. No changes are saved until Save Changes is clicked. Additionally, when Save Changes is clicked, the changes are only made to the rates checked(selected) in the grid. Unchecked rates will not be changed.

Figure 58: Updates were made within the New Rates column. The (+) column shows how the rates were changed. New Starting Dates shows rates were updated and start on day indicated.

STEP 5: Save the changes.

Edits are only saved once the Save Changes button is clicked and Yes is clicked on the “Confirm Save?” screen.

Figure 59: Confirm Save? screen

Choosing No on the “Confirm Save?” screen will return you to the Grid and the red pencil icon will still be shown on the lines of rates that have unsaved edits. The icons will remain until a new search is performed, the items are saved, or the screen is closed.

To exit from the Mass Update Rate Plan(s) screen without saving any edits, click the X in the upper right corner of the Mass Update Rate Plan(s) screen.

To continue changing rates in the Grid, just enter different rates, change the filters or the updates. Any of these will cause a prompt that will result in lost changes as explained in the “Confirm Save?” screen.

Each change made to a Rate Plan is tracked within the Admin Tool > Tools > View History Log or Admin History. 

Technical Field and Function Information

The following table describes the fields within this setup.