Rate Tables

Form ID: (PM206000)

You use this form to specify rates for different sequences of rate tables. For details on using rates, see Billing Rules: General Information and Project Billing Preparation: General Information. For details on configuring rate tables, see Billing Rates: General Information.

Note: Do not confuse the term rate as it applies to rate tables with other rates in MYOB Acumatica, such as employee hourly rates or equipment run rates. In the context of rate tables, a rate (denoted as @Rate) is a number that you can use in allocation rules as a multiplier, addend, or constant.

Form Toolbar

The form toolbar includes only standard buttons. For the list of standard buttons, see Form Toolbar and More Menu.

Selection Area

In this area, you can select a rate table, its sequence, and the applicable price class, so that you can specify particular rates on the Rate tab.

Element Description
Rate Table The rate table, which is initially created on the Rate Tables (PM204200) form and is configured on the current form.
Rate Type The rate type for which you want to view (and possibly change) rates. The rate types, which are defined on the Rate Types (PM204100) form, are associated with particular steps of the billing or allocation rules.
Sequence The sequence of the rate table for which you want to view (and possibly change) rates. Sequences are created on the Rate Lookup Rules (PM205000) form.
Rate Code The rate code for which you want to define rates. You can create a new rate code by typing its identifier in this box; an alphanumeric string of up to 10 characters can be used.

By using multiple rate codes with one sequence, you can specify for this sequence as many different rates (for different sets of particular factors defined by the sequence) as there are rate codes—instead of creating a long list of similar sequences. For instance, suppose that you want to use different rates for three projects. You can create three sequences with the Project check box selected and specify a rate for each sequence under one rate code. Alternatively, you can use only one sequence and three rate codes (created on the fly) to define three different rates for these three projects.
Description The description of the rate code.

Rate Tab

On the Rate tab, you can specify the specific rates to be used to calculate amounts to be billed, as well as the date ranges they are effective. You can specify multiple date ranges for a single rate.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Column Description
Start Date The start date of the range when the rate is valid.
End Date The end date of the range when the rate is valid.
Rate The value of the rate for the selected sequence, rate code, and price class. When you run allocations, this value is assigned to the @Rate variable, which you can use in formulas to calculate the allocation amount, quantity, and other values. The value can be used as a multiplier, a constant, or an addend.

Projects Tab

You can use the Projects tab to specify the projects for which the particular rate value is applied. This tab appears only if the sequence includes the project as a type of factors; the types of factors are specified on the Rate Lookup Rules (PM205000) form.

Note: The rate application condition is defined as follows: Conditions on particular projects, particular items, particular employees, or particular account groups are joined by OR operators, while conditions on different types of factors are joined by AND operators. For instance, a special rate is valid for tasks 1, 2, and 3 of Project 1 and Project 2 if employees JOHN or JACK are involved. The resulting condition is expressed as follows.
((Project=Project1) OR (Project=Project2))AND  
((Employee=JOHN) OR (Employee=JACK))AND
((Task=Task1) OR (Task=Task2)OR(Task=Task3))

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Column Description
Project The project for which you want to apply the rate specified on the Rate tab.
Description The description of the project, as specified in the project settings.

Tasks Tab

On this tab, you can specify one or more tasks for which the particular rate value is applied. This tab appears only if the sequence includes the task as a rate factor; rate factors are specified on the Rate Lookup Rules (PM205000) form.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Column Description
Project Task The task for which you want to apply the rate specified on the Rate tab.

Account Groups Tab

By using the Account Groups tab, you specify the account groups for which the particular rate value is applied. This tab appears only if the sequence includes the account group as a rate factor; rate factors are specified on the Rate Lookup Rules (PM205000) form.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Column Description
Account Group The account group for which you want to apply the rate specified on the Rate tab.
Description The description of the account group, as specified in the account group settings.

Inventory Tab

You can use the Inventory tab to specify the inventory items for which the particular rate value is applied. This tab appears only if the sequence includes the inventory item as a rate factor; rate factors are specified on the Rate Lookup Rules (PM205000) form.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Column Description
Inventory ID The inventory item for which you want to apply the rate specified on the Rate tab.
Description The description of the inventory item, as specified in the inventory item settings.

Employee Tab

You can use the Employee tab to specify the employees for which the particular rate value is applied. This tab appears only if the sequence includes the employee as a rate factor; rate factors are specified by using the Rate Lookup Rules (PM205000) form.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Column Description
Employee ID The employee for which you want to apply the rate specified on the Rate tab.
Employee Name The name of the employee, as specified in the employee account.