Equipment Costing - Rates (Standard)

Equipment Costing Control File - Charge/Reconciliation Tab

Pgm: EMCTRL – Equipment Costing Control File; standard Treeview path: Equipment Costing > Setup > Local Tables > Control – Charge/Reconciliation tab

The user can set up six levels of standard rates.  The level of hierarchy is shown in the Treeview menu.  The system will first look for a rate set up at the Job level. If no rate is found, the system will next look at Job/Class, Job Company/Class, Equipment, Home Location/Class, and Class, respectively. 

Rates by Class

Pgm: EMCLRATE – Equipment Class Rates; standard Treeview path: Equipment Costing > Setup > Local Tables > Rates > Class

Selection Criteria

Company

Enter/select company code. By default, the user's default company will be displayed. 

Class (Equipment)

Enter/select equipment class code.  The class name defaults from class code.

If rates are set up for the equipment class entered in this field, the rates will display in the next section.

Equipment class codes are defined in Local Tables (standard Treeview path: Equipment Costing > Setup > Local Tables > Equipment Classes).

[Copy to Job/Class] – Button

The [Copy To Job/Class] button allows the user to copy billing rates and/or charge rates to the controlling job or sub job. The Rate Type radio button is used to select the rates to be copied. By default, "Both" is selected, meaning both billing and charge rates are copied. If "Billing" is selected, then only billing rates are copied, and if "Charge" is selected, then only charge rates are copied.

By default, the 'Copy Rates To Controlling Jobs Only' box is checked. If unchecked, the rates are copied to both the controlling job and sub job.

NOTE: Rates must exist for the selected As Of Date field value. If rates already exist for the destination class on the selected date, the rates will not be modified/copied.

Rates By Equipment Class

Rate Type

Select rate type as either “Billing” rate or “Charge” out rate from the drop-down menu.  Charge-out rates are rates used to charge the job. Billing rates are rates used to bill the client.  Billing rates are equal to or higher than charge rates.

If billing rates are not added, the Job Billing module will not bill equipment rentals to the client.

Equipment Class

Enter/select equipment class code.  The class name defaults from class code.

Tran Code (Transaction)

Enter/select a transaction code. The transaction code list will only show the transactions codes which have been set up as revenue codes.

Start and End Dates for Charge and Billing Dates

Enter start and end dates for charge-out rates and billing rates. A charge will not be made for an expired date; the date will default as null if expired.

NOTE: Charge rates may be changed for the first of the month only. If changed for mid-month, the auto-charge will not calculate properly.

Rates (Hourly, Daily, Weekly or Monthly)

Enter the rates. If Auto Charge-out will be used, do not enter hourly rates as they will not be taken into consideration.  Daily rate, weekly rate and monthly rate are necessary for a smooth auto-charge calculation of rentals.  Hourly rates are used on manual rental charges.

WM (Weight Measure Code for Additional Rates)

Enter a WM code to be used with Additional Rate in the calculation of Material Sales production equipment charges.

Additional Rate

Enter additional rate if Material Sales production equipment charges will be used.

Rates by Home Location/Class

Pgm: EMCLASSLOCRATE – Location/Class Rates; standard Treeview path: Equipment Costing > Setup > Local Tables > Rates > Home Location/Class

Selection Criteria

Company

Enter/select company code. By default, the user's default company will be displayed. 

Rates By Location/Class

Rate Type

Select rate type as either “Billing” rate or “Charge” out rate from the drop-down menu.  Charge-out rates are rates used to charge the job. Billing rates are rates used to bill the client.  Billing rates are equal to or higher than charge rates.

If billing rates are not added, the Job Billing module will not bill equipment rentals to the client.

Home Location

Enter/select the equipment home location code. 

Equipment Class

Enter/select equipment class code.  The class name defaults from class code.

Tran Code (Transaction)

Enter/select a transaction code. The transaction code list will only show the transactions codes which have been set up as revenue codes.

Start and End Dates for Charge and Billing Dates

Enter start and end dates for charge-out rates and billing rates. A charge will not be made for an expired date; the date will default as null if expired.

NOTE: Charge rates may be changed for the first of the month only. If changed for mid-month, the auto-charge will not calculate properly.

Rates (Hourly, Daily, Weekly or Monthly)

Enter the rates. If Auto Charge-out will be used, do not enter hourly rates as they will not be taken into consideration.  Daily rate, weekly rate and monthly rate are necessary for a smooth auto-charge calculation of rentals.  Hourly rates are used on manual rental charges.

WM (Weight Measure Code for Additional Rates)

Enter a WM code to be used with Additional Rate in the calculation of Material Sales production equipment charges.

Additional Rate

Enter additional rate if Material Sales production equipment charges will be used.

Rates by Equipment

Pgm: EMEQRATE – Equipment Rate Maintenance; standard Treeview path: Equipment Costing > Setup > Local Tables > Rates > Equipment

Selection Criteria

Company

Enter/select company code. By default, the user's default company will be displayed. 

Rates by Equipment

Rate Type

Select rate type as either “Billing” rate or “Charge” out rate from the drop-down menu.  Charge-out rates are rates used to charge the job. Billing rates are rates used to bill the client.  Billing rates are equal to or higher than charge rates.

If billing rates are not added, the Job Billing module will not bill equipment rentals to the client.

Equipment Code

Enter/select equipment code. The equipment name defaults from equipment code.  Any rate entered against a piece of equipment will override the rate set up in Class Rates.

Tran Code (Transaction)

Enter/select the transaction code.  The transaction code list will only show the transaction codes set up as revenue codes.

Start and End Dates for Charge and Billing Rates

Enter start and end dates for charge out and bill rates. A charge or billing will not be made for an expired date. The date will default as null if expired.

NOTE: Charge rates may be changed for the first of the month only. If changed for mid-month, the auto-charge will not calculate properly.

Rates (Hourly, Daily, Weekly or Monthly)

Enter the charge-out rates. When using Auto Charge-Out, note that hourly rates are not taken into consideration.

WM (Weight Measure Code for Additional Rates)

Enter a WM code to be used with Additional Rate in the calculation of Material Sales production equipment charges.

Additional Rate

Enter additional rate if Material Sales production equipment charges will be used.

Rates by Job Company/Class

Pgm: EMCLASSCOMPRATE – Equipment Class/Company Rate Maintenance; standard Treeview path: Equipment Costing > Setup > Local Tables > Rates > Job Company/Class

This screen shows the equipment rates by class for all jobs within the charged company.

Selection Criteria

Company

Enter/select company code. By default, the user's default company will be displayed. 

Rates by Equipment Class/Company

Rate Type

Select rate type as either “Billing” rate or “Charge” out rate from the drop-down menu. Charge-out rates are rates used to charge the job. Billing rates are rates used to bill the client.  Billing rates are equal to or higher than charge rates.

If billing rates are not added, the Job Billing module will not bill equipment rentals to the client.

Equipment Class

Enter/select the equipment class code. The class name defaults from class code.

Charge Company

Enter/select charge company code. The rates will be the equipment rates by class for all jobs within the charged company.

Tran Code (Transaction)

Enter/select the transaction code.  The transaction code list will only show the transaction codes set up as revenue codes.

Start and End Dates for Charge and Billing Rates

Enter start and end dates for charge out and bill rates. A charge or billing will not be made for an expired date. The date will default as null if expired.

NOTE: Charge rates may be changed for the first of the month only. If changed for mid-month, the auto-charge will not calculate properly.

Rates (Hourly, Daily, Weekly or Monthly)

Enter the charge-out rates. When using Auto Charge-Out, note that hourly rates are not taken into consideration.

WM (Weight Measure Code for Additional Rates)

Enter a WM code to be used with Additional Rate in the calculation of Material Sales production equipment charges.

Additional Rate

Enter additional rate if Material Sales production equipment charges will be used.

Rates by Job/Class

Pgm: EMCLASSJOBRATE – Rates by Class/Job; standard Treeview path: Equipment Costing > Setup > Local Tables > Rates > Job/Class

Selection Criteria

Company

Enter/select company. This is the company that owns the equipment.

Job Company

Enter/select job company.

Job Code

Enter/select job.

[Copy Job/Class Rate] – Button

Pop-up window launched from [Copy Job/Class Rate] button on the Rates by Class/Job screen

The [Copy Job/Class Rate] button becomes enabled when the fields for Company, Job Company and Job Code on the Rates by Class/Job main screen are populated.  Clicking this button opens a pop-up window that allows the user to copy all the Job/Class Rate records from one Job Company/Job Code to another Job Company/Job Code.  If there are already rates set up in the “To” Company/Job, the records will be added to the existing set of records.

The equipment company will remain the same.  The system prevents the user from changing the equipment company to ensure the validity of rate types, class and transaction codes.

Rates by Class/Job

Rate Type

Select rate type as either “Billing” rate or “Charge” out rate from the drop-down menu. Charge-out rates are rates used to charge the job. Billing rates are rates used to bill the client.  Billing rates are equal to or higher than charge rates.

If billing rates are not added, the Job Billing module will not bill equipment rentals to the client.

Equipment Class

Select/enter the equipment class code.  The class name defaults from class code.

Tran Code (Transaction)

Enter/select the transaction code.  The transaction code list will only show the transaction codes set up as revenue codes.

Start and End Dates for Charge and Billing Rates

Enter start and end dates for charge out and bill rates. A charge or billing will not be made for an expired date. The date will default as null if expired.

NOTE: Charge rates may be changed for the first of the month only. If changed for mid-month, the auto-charge will not calculate properly.

Charge Cap %

Enter the charge cap %.  This is used to calculate the maximum charge-out amount (percentage of equipment value). If there is a charge cap defined at the job level, it will take precedence.

For more information on defining charge caps, please refer to Equipment Costing - Maximum Charge Cap % .

Rates (Hourly, Daily, Weekly or Monthly)

Enter the charge-out rates. When using Auto Charge-Out, note that hourly rates are not taken into consideration.

WM (Weight Measure Code for Additional Rates)

Enter a WM code to be used with Additional Rate in the calculation of Material Sales production equipment charges.

Additional Rate

Enter additional rate if Material Sales production equipment charges will be used.

Rates by Job

Screenshot of Equipment Job Rate Maintenance

Pgm: EMEQJBRT – Equipment Job Rate Maintenance; standard Treeview path: Equipment Costing > Setup > Local Tables > Rates > Job

Selection Criteria

Company

Enter/select company. This is the company that owns the equipment.

Co / Job (Job Company and Job Code)

Enter/select job company and job code.

[Query Data] − Button

Press this button to filter the Rates by Job/Equipment section according to the selected criteria. If changes are made to the selection criteria, this button must be clicked to refresh the display.

Rates by Job/Equipment

Rate Type

Select rate type as either “Billing” rate or “Charge” out rate from the drop-down menu. Charge-out rates are rates used to charge the job. Billing rates are rates used to bill the client.  Billing rates are equal to or higher than charge rates.

If billing rates are not added, the Job Billing module will not bill equipment rentals to the client.

Equipment Code

Enter/select the equipment.  The equipment name will default from the equipment code.

Tran Code (Transaction)

Enter/select the transaction code.  The transaction code list will only show the transaction codes set up as revenue codes.

Start and End Dates for Charge and Billing

Enter start and end dates for both charge rates and billing rates. A charge will not be made for an expired date. The date will default as null if expired.

NOTE: Charge rates may be changed for the first of the month only. If changed for mid-month, the auto-charge will not calculate properly.

Rates (Hourly, Daily, Weekly or Monthly)

Enter rates for charge and/or billing. Hourly rates will not be taken into consideration for auto charge-out.

WM (Weight Measure Code for Additional Rates)

Enter a WM code to be used with Additional Rate in the calculation of Material Sales production equipment charges.

Job Maximum Amount (Maximum Charge Out Amount)

If a figure has not defaulted into this field, it may be entered now. Maximum charge out rules are as follows:

  • A defaulted figure has come from the Enter Equipment screen (standard Treeview path: Equipment Costing > Setup > Enter Equipment). It has been calculated as the equipment value X %. If no figure has defaulted one may be entered, although it is not mandatory.

  • Exceeding the cap will result in the transactions not being posted.

  • Time Entry will flag the amount as needing a “Cap Reduction”. The edit list will print an exception report. The user will have to return to the Time Entry program and manually correct any cap amount.

  • Auto Charge will cap the amount. The reduced amount will be posted and flagged.

For more information on defining charge caps, please refer to Equipment Costing - Maximum Charge Cap % .

Additional Rates

Enter additional rates if Material Sales production equipment charges will be used.