User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

business:merge_asset_management_text [2018/07/24 12:21] (current)
Line 1: Line 1:
 +======Merge Asset Management Text File Layout======
 +<WRAP round intro>
 +This file layout is used when uploading Asset Management tables that were created from a separate software.  ​
 +^Field ​ ^Length ^Position ^Type ^Description ^
 +|Existing TxEIS Item #​|10|1-10|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
 +<WRAP Box>
 +**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.
business/merge_asset_management_text.txt · Last modified: 2018/07/24 12:21 (external edit)

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.