Book Creator
Add this page to your book

Book Creator
Remove this page from your book

This is an old revision of the document!

Enter Records in Asset Management

Click here to generate a PDF of this guide.

This guide covers the following three options for adding items to Asset Management:

Manually enter the information on the Inventory Maintenance tabs.
Retrieve asset information from Finance.
Merge data from an inventory text file.

This guide assumes you are familiar with the basic features of the ASCENDER Business system and have reviewed the ASCENDER Business Overview guide.

Enter Records Manually

Create an inventory record.

Asset Management > Maintenance > Inventory Maintenance > Inventory Records

❏ Add an item.

Add	Click to add an item.
Item Nbr	If Automatic Item Numbering is not selected on the Asset Management Options page, type an item number. The field can be a maximum of ten digits.

Note: If Automatic Item Numbering is selected on the Asset Management Options page, the Item Nbr field is set to AUTO, and the Status and Gain Code fields default to the selection on the Asset Management Options table.

The following fields are required, all other fields are optional. Review the Help page for additional information about the optional fields.

Inventory Type	Click to select an inventory type (C for Capital Assets or I for Inventory Assets). The field is required for depreciation calculations.
Acquired Date	Type the date in the MMDDYYYY format. If retrieved from Finance, the Check Date field from the Check Posting page is used. The field is required as it is used for inventory validation to maintain accurate depreciation calculations.
Number of Units	Type a quantity. The field is required for depreciation calculations and can be a maximum of 11 digits. When the Number of Units and Unit Cost fields are entered, the Total Cost field is calculated. Anytime the Number of Units field is changed, the Total Cost field is recalculated based on the unit cost.
Unit Cost	Type the cost of an individual unit. The field is required for depreciation calculations and can be a maximum of 11 digits. If this is a multiple unit record, the cost field can be calculated using the formula Total Cost/Number of Units = Unit Cost.
Total Cost	Type a value for the cost of an item or group of items (the cost can include sales price, shipping, and handling). Note: If the field is imported from the Finance save file, it is retrieved from the Expense Amount field in the Finance transaction file
Disposal Date	Type the date the asset was disposed of through sale or salvage. If unknown, type all zeros. The field is required for depreciation calculations.

Notes:

• Unable to Save until the Transaction and Book Records are created.

• The vendor number is displayed and is retrieved from the first available transaction record with vendor information. Vendor information will be added to the Inventory Record from the Transaction Records tab.

• A capital asset (C type record) can only be changed to an inventory asset (I type record) after the depreciation record has been deleted.

Enter a transaction record.

Asset Management > Maintenance > Inventory Maintenance > Transaction Records

Enter a new transaction when:

An item is first acquired.
Existing transaction amounts change. If an amount is incorrect, enter a new transaction for the difference in the amount, position or negative amounts can be added.
Amounts need to be entered multiple times for different account codes.
Additional purchases or improvements are made to an asset.

Note: A warning message displays if no record exists for capital items.

Transaction types:

O = Original	New transactions Affects depreciation cost The book record defaults to depreciation cost if this is a new amount. If a book record is already created, change it to reflect the changes made to the Transaction Amounts. There can only be one original transaction. After an original transaction is saved, the field is disabled and cannot be modified.
M = Maintenance	Used when upgrading items (e.g., new lockers, painted hallways) that will not change the depreciation of the item.
C = Capitalized	Used when upgrading items (e.g., remodeling) or making changes to the original amount. Affects depreciation cost. The book record is not affected and must be manually changed.

Define the depreciation distribution.
Asset Management > Maintenance > Inventory Maintenance > Depreciation Distribution Records

Define how depreciation is distributed by the LEA.
- Used for capital assets only (inventory type = C).
- Each account code is a separate record.
- There should be a distribution record for each year that the depreciation is calculated.
- Record is added during end-of-year processing after the initial records have been entered.
- Required account number elements are function and fiscal year.

Define how depreciation should be calculated.

Asset Management > Maintenance > Inventory Maintenance > Book Records

The following fields are required for depreciation calculations, all other fields are optional. Review the Help page for additional information about the optional fields.

Property Class	Click to select the property class description. The field is required for depreciation calculations.
Date In Service	Type the date that the record was entered into the system in the MMDDYYYY format. If entering a new record, this field is populated from the Acquired Date field on the Inventory Records tab, or you can override with a different date. The field is required and is used for inventory validation to maintain accurate depreciation calculations.
Deprec Method	Click to select a valid depreciation method code. There are only two depreciation methods available: • Straight Line (SL) - SL depreciation only. Uses the two conventions available, Full Month (FM) and Half Year (HY). • No Depreciation (ND) - Used for land or other assets that do not lose value. • If left blank, the field is populated from the property class record. CAUTION: If the depreciation method for an inventory item is changed from Straight Line (SL) to No Depreciation (ND), the following message is displayed, “Warning: When saved, any depreciation history is deleted. Do you wish to continue with this change?” Click Yes to change the depreciation method and delete the depreciation history. Since all depreciation history records for this inventory item are deleted with this change, it is strongly recommended that the user create a system backup before saving this change. Click No to disregard the change. The depreciation method is not changed, and the depreciation history is not deleted. The field is required for depreciation calculations.
Recovery Period	Type the number of years required to fully depreciate the item. The field is required for depreciation calculations. If assets are to be depreciated using partial years, the months should be converted to a decimal value (e.g., 3 months = .25, 6 months = .50, and 9 months = .75). If left blank, the number is populated from the property class record.
Deprec Cost	Type the depreciable cost of the item. If adding a new record, the field is populated from the Total Cost field on the Inventory Records tab. A negative depreciation cost can be entered. If the salvage value is not zero, the depreciation cost is negative, and the salvage value is greater than the depreciation cost, a warning is issued, and the user can save the record. When a transaction record is added, the Deprec Cost field is updated with the new amount.
Adjusted Basis	This amount is calculated as follows: Adjusted Basis = Depreciable Cost - Salvage Value. When a transaction record is added, the Adjusted Basis field is updated with the new amount.
Convention	Click to select a valid convention. The field is required for depreciation calculations. If left blank, it is populated from the property class record. • Full Month (FM) – Calculate depreciation after the first full month. • Half Year (HY) – Calculate depreciation as half or full year for the first year, depending on the acquisition date.

Enter manufacturer information.

Asset Management > Maintenance > Inventory Maintenance > Manufacturer Information

Maintain information about the make, model, and warranty information for an asset. This information is not mandatory for depreciation; however, it is useful in retrieving information for the manufacturer.

Note: Before you can retrieve records created from Finance, be sure that the Asset Management cross-reference table is set up in Finance.

Retrieve Records From Finance

Extract records from Finance.

Finance > Utilities > Extract to Asset Management

This utility is used to extract records from the Check Transactions file with an object/subobject code that matches an item in the Asset Management Cross-Reference table. Individual items from the file can then be retrieved into the Asset Management application. The extract file is only available in text format, even though the CSV icon is displayed.
Import records to Asset Management.
Asset Management > Maintenance > Inventory Maintenance > Transaction Records

The transaction record information is added to the Inventory Records tab.
❏ Click Import to begin the import process.

Click Choose File to select the file that you created from Finance.

Click Submit to import the selected file. A list of assets that can be moved from Finance is displayed.

Select the asset to extract from Finance.

Enter the Date Acquired to Save As and click OK. The item is now displayed on the Transaction Records tab.

❏ Click Save to save the item. Repeat this process to continue importing the additional asset items as only one record can be imported at a time.

Merge From Inventory Text File

Merge an Asset Management text file.

Asset Management > Utilities > Merge Asset Management Text File

This utility is used to upload Asset Management tables that were created using another type of software. All records being merged must have an item number or bar code. The item number or bar code becomes the item number for the Asset Management application inventory record. If no item number or bar code exists, the record is not added or updated in the Asset Management application.

Note: When you create the merge text file from the vendor’s software, please name it UPcccddd (where cccddd is the county-district number).

Merge Asset Management Text File Layout

Business

Sidebar

Table of Contents

Enter Records in Asset Management

Enter Records Manually

Retrieve Records From Finance

Merge From Inventory Text File

Americans with Disabilities Act (ADA) and Web Accessibility

Business

User Tools

Site Tools

Sidebar

Table of Contents

Enter Records in Asset Management

Enter Records Manually

Retrieve Records From Finance

Merge From Inventory Text File

Page Tools

Americans with Disabilities Act (ADA) and Web Accessibility