Equipment Maintenance - Cost

Program/Screen: RAEQPM/RAEQPM25

Description:

Use this screen to enter cost and depreciation information for the piece of equipment.

 

If the equipment is linked, a banner appears at the top of the screen, and the total amounts of all linked assets are displayed.

 

Click a link to advance to that section of the topic.

 

 

Navigation

Access this screen by pressing F2=Cost while on the Equipment Maintenance screen.  Enter costs and depreciation information associated with the equipment and review revenue and rental amounts.  Press Enter to return to the Equipment Maintenance main screen.

 

Unique Equipment Maintenance Screens

Equipment Maintenance - Launch

Equipment Maintenance

Cost

Tax/AMT

Insurance

Vehicle Registration

Cycle Count History

Equipment Tracking

G/L Revenue Distribution Inquiry

Cost History Inquiry

Equipment Loan Maintenance

Create an Equipment Loan

 

Fields

Equipment number

Displays the unique number of the equipment you are adding or updating.

 

Alternate equipment number

Enter an alternate unique number for the equipment (perhaps from a legacy software system).  You can use this number to retrieve this piece of equipment during transaction entry.

 

Category/Class/Sub

Displays the codes for the category, class, and sub-class to which this piece of equipment belongs.  Categories and classes are set up in Category/Class Maintenance.

 

Currency

Displays the code for the currency in which all monetary amounts are entered or displayed on this screen.

 

Fully invoiced

Indicate if this equipment has been fully invoiced for capitalization purposes.

 

An asset's monthly depreciation amount is estimated and calculated as an accrual until it is verified that its initial cost has been completely entered by setting this Fully Invoiced flag to Y, or by setting the Invoiced flag on the Enter/Edit Invoice - G/L Distribution screen to Y.  This ensures that when freight or other adjustments for the asset are entered in Accounts Payable Invoice Entry during the first part of the asset's life, they are calculated as accruals and reversed accordingly.

 

Once all costs for the asset have been entered, set at least one of the "Invoiced" flags to Y, and the system brings the asset's depreciation up to date according to the true and final cost when the asset is next depreciated.

 

ClosedMore information...

When depreciation is run live, the system will update the depreciation buckets in the equipment master file (EQPMASFL) for all assets that have this Fully invoiced flag set to Y.  It will also create a reversing batch for the assets that do not have this flag set to Y, but will not update the depreciation buckets.  The calculation for this accrual is cumulative from the date in rental since it is a reversal, and each month’s expense will be the net of the prior month’s LTD reversal and the current month’s LTD accrual.

 

The first month that assets become fully invoiced, and depreciation is run live, depreciation will be calculated based on the current acquisition cost.  The depreciation buckets in the equipment master file are updated with the appropriate MTD, YTD and LTD amounts and a non-reversing journal entry is made for the assets’ LTD depreciation.  The second and later months calculate and record normal monthly depreciation.

 

NOTE:  Control record RAEDP3 setting Flag uninvoiced method, should be set to Y to create depreciation accrual for uninvoiced or not fully invoiced assets that qualify for depreciation (type R, O).

 

Acquisition cost

The cost to acquire this piece of equipment.  If you are using the Purchasing application, and you entered and received a purchase order for this equipment, and you have the Allow to update EMCOST field set to Y in control record RARCP3, the receipt cost automatically populates this field.

 

If additional cost for the equipment is entered during A/P invoice entry, and the Update equipment cost field and the Replace equipment cost field are set to Y in control record IP230P, this acquisition cost is updated to include the additional cost.

 

If Allow to update EMCOST is set to N, this acquisition cost must be populated either via A/P invoice entry or by making a G/L journal entry.  In this scenario, set Update equipment cost in control record IP230P to Y, and in that same control record, set Replace equipment cost to N.

 

Original cost

The original cost for the equipment, which may or may not be the same as the acquisition cost.

 

If you are using the Purchasing application, and the Record Original Cost Eqp field is set to Y in control record RARCP6, the receipt cost of the equipment populates this field.

 

Salvage value

Enter the value of the equipment after it has been fully depreciated.

 

Payoff amount

Displays the amount needed to pay off the remaining balance on the note for the equipment.

 

Sales tax paid

Enter or accept the amount of sales tax that was paid when this equipment was acquired.  If you are using the Purchasing application, and you entered and received a purchase order for this equipment, the amount automatically populates this field.

 

Note

   Optional: Enter a user-defined reference note in this field.

 

A/P reference

   This field displays the invoice number the equipment was purchased on.

 

Depreciation life

Enter the life of the equipment (in months) for depreciation purposes.  The equipment will be fully depreciated at the end of this time.

 

Max bill percentage

Enter the percentage for the maximum billed amount per unit that calculates for the length of a rental contract.  This percentage is based on the equipment's replacement value, so for example, if a piece of equipment has a replacement value of $100,000, what is the percentage of that amount that you would want as the maximum amount you would bill a customer for renting it.

 

Book value

Enter the book value for the equipment.  The book value is the original value of the equipment used for accounting.

 

Replacement value

Enter the amount it would cost to replace this equipment.  This information is useful if the equipment is lost or damaged.

 

Fair market value

Enter the fair market value of the equipment by subtracting depreciation from the replacement value.

 

Example: You purchased a wet saw for $2,000 five years ago and it was recently damaged beyond repair.  The wet saw has a depreciation life of 10 years (120 months).  A similar wet saw today costs $2,500.  The destroyed wet saw had 50% (5 years) of its life remaining, so the fair market value equals $2,500 (replacement cost) times 50% (useful life remaining) or $1,250.

 

Interest

If applicable, this field displays the interest paid on the note for this equipment.

 

Sales tax collected

The amount of sales tax that has been collected from rental of this equipment.

 

Freight paid

Enter the freight charges that were paid when the equipment was delivered to you.

 

Back to top

Depreciation method

Enter the code that represents the method you want to use to depreciate this piece of equipment.

 

Depreciation amount (MTD)

Enter or accept the amount of depreciation on this equipment month-to-date.  If you run the monthly depreciation program in the General Ledger application, or you use the FAS interface, this amount is calculated and populated by the system.

 

Depreciation is calculated as follows:

 

[(Acquisition Cost - Salvage Value) - (Depreciation LTD)] / [(Depreciation Life in Months - Number of depreciated months {Date into Rental minus Current Depreciation Date})].

 

Depreciation amount (YTD)

Enter or accept the amount of depreciation on this equipment year-to-date.  If you run the monthly depreciation program in the General Ledger application, or you use the FAS interface, this amount is calculated and populated by the system.  You also need to run the Reset Depreciation at Year End program in G/L to ensure that the year-to-date figure is reset at the end of your accounting year.

 

Depreciation amount (LTD)

Enter or accept the amount of depreciation on this equipment life-to-date.  If you run the monthly depreciation program in the General Ledger application, or you use the FAS interface, this amount is calculated and populated by the system.

 

Revenue (YTD)

Displays the revenue generated by this equipment year-to-date (during the current year).

 

Revenue (LTD)

Displays the revenue generated by this equipment life-to-date (the entire time since it was put into rental inventory).

 

Revenue (LYR)

Displays the revenue generated by this equipment last year.

 

Number of days on rent (YTD)

Displays the number of days that this equipment has been out on rent year-to-date (during the current year).

 

Number of days on rent (LTD)

Displays the number of days that this equipment has been out on rent life-to-date (the entire time since it was put into rental inventory).

 

Number of days on rent (LYR)

Displays the number of days that this equipment was out on rent last year.

 

Maintenance-parts (YTD)

Displays the amount spent on parts for maintenance of this equipment during the current year.

 

Maintenance-parts (LTD)

Displays the amount spent on parts for maintenance of this equipment since it was put into rental inventory.

 

Maintenance-parts (LYR)

Displays the amount spent on parts for maintenance of this equipment last year.

 

Maintenance-labor (YTD)

Displays the amount spent on labor for maintenance of this equipment during the current year.

 

Maintenance-labor (LTD)

Displays the amount spent on labor for maintenance of this equipment since it was put into rental inventory.

 

Maintenance-labor (LYR)

Displays the amount spent on labor for maintenance of this equipment last year.

 

Assigned item number

If applicable, enter or accept the inventory item number assigned to this piece of equipment.

 

Stock class

Enter the code that groups this piece of equipment with other similar equipment for reporting and purchasing purposes.

 

Function Keys

Function Key

Description

F1

Help.  Place your cursor in a field and press F1 to access online help for that field.  Place your cursor outside of any field, and press F1 to access online help at the program level.

F3

Exit.  Exit the page or program.

F5

Refresh.  Refresh the screen and remove entered data.

F10

Tax/AMT.  Advance to the Equipment Maintenance - Tax/Alternative Minimum Tax screen.

F12

Cancel/Previous.  Exit the program or move back a screen.

F14 (Shift + F2)

Cost History.  Advance to the Equipment Cost History Inquiry screen.

 

Related Programs

Run Monthly Depreciation

Reset Depreciation at Year End

 

Special Topics

Equipment Costing quick guide

 

 

 

Back to top