Uploading initial asset entries

Activity overview

Glossary

Basics of using a typical web page

This page allows you to upload the initial asset entries into the system. You can specify a range or numbers specifying the assets or the tags to retrieve the balance entries from the external source in which the data is available. You can view the asset details before uploading it. The data available in the external source must be in the specified format and must be complete in all respects.

The “Upload Initial Entry” page appears.

Finance Book

Use the drop-down list box to select the code identifying the finance book in which you want to update the initial asset entries. All the finance books that have been deployed in the login organization unit will be available for selection in the ascending order.

Asset No. From

The starting number in the range of asset numbers that you want to retrieve (Alphanumeric, 18). You can enter the asset number in full or specify it partially using the “*” character. The system retrieves all the asset numbers that are similar to the value entered here.

To

The ending number in the range of asset numbers that you want to retrieve (Alphanumeric, 18).  You can enter the asset number in full or specify it partially using the “*” character. The system retrieves all the asset numbers that are similar to the value entered here.

Tag No. From

The starting number in the range of tag numbers that you want to retrieve (Alphanumeric, 20). You can enter the tag number in full or specify it partially using the “*” character. The system retrieves all the asset numbers that have tag numbers similar to the value entered here.

To

The ending number in the range of tag numbers that you want to retrieve (Alphanumeric, 20). You can enter the tag number in full or specify it partially using the “*” character. The system retrieves all the asset numbers that have tag numbers similar to the value entered here.

Note: The system retrieves the data from an external source like an MS-Excel sheet or a database.

The system displays the following in the “Asset Information” multiline based on the search criteria entered:

Legacy Asset No.

The unique legacy asset number.

Asset No.

The unique number identifying the asset.

Asset Description

A textual description of the asset.

Tag No.

The unique number identifying the tag.

Tag Description

A textual description of the tag.

Depreciation Category

The depreciation category that has been set for the asset.

Asset Cost

The standard cost of the asset.

Status

The status of the asset. It could be “Active”, “Retired” or “Fresh”.

 
  • Active – indicates that the asset has been capitalized.

 
  • Retired – indicates that the asset is no longer in use.

 
  • Fresh – indicates that the asset is yet to be capitalized.

Asset Class Code

The code identifying the class to which the assets belong.

Asset Group Code

The code identifying the group to which the assets belong.

Asset Location Code

The code identifying the location in which the asset is located.

Cost Center

The cost center of the asset.

Analysis #

The code identifying the analysis number of the asset.

Sub Analysis #

The subanalysis code identifying the analysis number of the asset.

Inventory Cycle

The time period frequency in which the assets must be verified. It could be “Yearly”, “Half-yearly”, “Quarterly”, “Monthly” and “Not required”.

 
  • Yearly – indicates that the assets must be verified once in a financial year.

 
  • Half yearly – indicates that the assets must be verified twice in a financial year.

 
  • Quarterly – indicates that the asset must be verified every quarter of the financial year.

 
  • Monthly – indicates that the asset must be verified every month of the financial year.

 
  • Not required – indicates that there is no need for the assets to be verified.

In Service Date

The date on which the asset has been put to effective use.

Capitalization Date

The date on which the asset was capitalized.

Bar Code No.

A unique number identifying the bar code.

Serial No.

The serial number of the asset.

Warranty No.

The warranty number of the asset.

Model

The model of the asset.

Manufacturer

The name of the manufacturer of the asset.

Custodian

The employee in whose custody the asset is present

Business Use %

The percentage of use the asset is made.

Salvage Value

The salvage value of the asset.

Retirement Type

The method of retirement opted for the asset. It could be “Sale” or “Write-off”.

 
  • Sale – indicates that the value of the asset can be got back by selling it.

 
  • Write-off – indicates that the value of the asset can be written off from the books of account.

Retirement Date

The date on which the asset was retired.

Sale Value

The sale value of the asset.

The system updates the asset details in the “Asset Capitalization” business component.

To proceed, carry out the following