This file layout is used when uploading Asset Management tables that were created from a separate software.
Field | Length | Position | Type | Description |
---|---|---|---|---|
Existing ASCENDER Item # | 10 | 1-10 | Character | |
Quantity | 5 | 11-15 | Numeric | Zero-filled |
Description | 50 | 16-65 | Character | |
Campus | 3 | 66-68 | Character | Zero-filled |
Room | 8 | 69-76 | Character | |
Manufacturer | 20 | 77-96 | Character | |
Model | 20 | 97-116 | Character | |
Serial # | 30 | 117-146 | Character | |
Last Inventory Date * | 8 | 147-154 | Numeric | YYYYMMDD |
Cost | 11 | 155-165 | Numeric | 2 decimal positions; zero-filled |
Account Code | 20 | 166-185 | Character | Left-justified |
Method * | 2 | 186-187 | Character | |
Life * | 4 | 188-191 | Numeric | 2 decimal positions |
Bar Code | 10 | 192-201 | Character |
* see defaults
Notes:
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.
When you create the merge text file from the vendor’s software, please name it UPcccddd (where cccddd is the county-district number).
The record maximum is 201 characters. Any position (1-201) not used is recognized with a space.
Merge Process Defaults:
If the cost is not numeric, then it is set to zeros.
The Total Value = Number of Units x Unit Cost.
If the last inventory date is spaces, the system date is used.
A status code must exist on the Tables > Code Tables tab before it can be selected or used on the Asset Management Options page.
If the Life field is blank or not numeric in the text file, the estimated life is set to 10 and prints on the Inventory Upload Report.
If the inventory type changes (i.e., from I to C) during an update, a message is printed on the Inventory Upload Report.
The default depreciation method is SL.
The Unallocated field is set to N in the Book table.
The Percent field is set to 100% in the Depreciation Distribution table.
The Book Type field is set to GP - GAAP (Generally Accepted Accounting Principles) in the Book table.
If the account code in the text file is spaces, the account code entered in the Default Account Code for Capital Items field of the Merge Asset Management Text File page is used in the Transaction table.
If this is a new record in the Asset Management application, the default transaction type is O (original) in the Transaction table.