to select, a valid property type for this record. Valid property types are set up on the Manage Property Types screen.Use this screen to perform global data changes on all user-editable fields on the Manage Asset Template Information screen other than user-defined fields. You can also use this screen to perform manual edits to non user-definable fields on a template-by-template basis.
You can globally (or non-globally) change template data for user-defined fields by using the Manage Template User-Defined Global Changes screen.
You can also edit user-defined fields in individual template records on the Manage Asset Template Information screen. Your decision to make changes in the global screens is a matter of personal preference and will depend on the number of records to be changed and the efficiency with which the changes can be made.
Regardless of the screen(s) in which you choose to make changes, you can capture change data, store it in history, and make it available to view and print. If you use this functionality, the system can capture the template/revision record identifier, the name of each changed field, the old data from before the change, the new data after the change, information on the user who performed the change, and the date and time of the change.
Each check box that you select in the Asset/Template Field/Column Names subtask of the Configure Asset/Template Change Settings screen signifies that you want to capture data for that field for an Asset Template record each time you make a change to that data, regardless of the screen in which the change was made.
Once the change details have been captured, you can view change data stored in the Template Audit Log via the View Template Change History screen. You can print change data stored in the Template Audit Log via the Print Asset/Template Change History Report screen.
Almost all fields on the Manage Asset Template Information screen are available as selection criteria, so you can define a very specific subset of Asset Template records.
Once you have selected the Asset Template records to be changed, enter the desired changes. The system will change the appropriate fields in this table window (and thus also your Asset Template records) and will also write the change details to an audit table, Template Change Audit Log (FA_TMPLT_AUDIT_LOG).
You can also use this screen to perform manual edits for desired fields/columns on a template-by-template basis so that change details will be written to the audit table (FA_TMPLT_AUDIT_LOG). The audit table stores the following change data:
template/revision number
the data field that was changed
the old data and the new data
the date and time of change
and the user ID
You can view template change data from that table by using the View Template Change History screen. You can print template change data from that table using the Print Asset/Template Change History Report screen.
Some columns in this table window are non-editable. The same situation also exists in the Asset Template record itself, in which there are corresponding non-editable fields. Non-editable columns are displayed because they may be useful when you are selecting the data to be changed. The data rules for each column regarding validations and your ability to edit are identical to those for each corresponding field in an Asset Template record.
You cannot use this screen to add new Asset Template records or delete Asset Template records.
On this screen, unlike maintenance table windows throughout Costpoint, the line functions in the menu bar (New Record, Copy Record, Delete Record, and Undelete Record) are disabled.
The "normal" Asset Template data rules and validations are used; note that changes to a column on this screen may also require data entry in another column on this screen. For example, a template has been assigned a non-depreciable status. Although you can change the Depr Status column from Non-Depreciable to Depreciable on this screen, you must also enter data in the Depr Method Code, Accum Depr Acct Code, and Depr Exp Acct Alloc Code columns before you can save the change to the Depr Status column.
Asset Template records must already be in place before you can perform global changes on this screen.
This column displays the required template number assigned to each of your selected records when they were first saved on the Manage Asset Template Information screen. You cannot edit this column or make entries in it. Please refer to the documentation for the Template No field on the Manage Asset Template Information screen for additional information.
This column displays the optional revision number, as applicable, that was assigned to each of your selected records when they were first saved on the Manage Asset Template Information screen. You cannot edit this column or make entries in it. Please refer to the documentation for the Rev No field on the Manage Asset Template Information screen for additional information.
The system displays the system-required record status assigned to each of your selected records when they were first saved on the Manage Asset Template Information screen. The options available for this column are Active or Inactive.
A record must be Active to be eligible for depreciation calculations.
If you specify that a record is Inactive, the system will skip over the record for depreciation calculations and for reports that do not specify the inclusion of inactive records. Rendering an Asset Master record "Inactive" provides an alternative to deleting it, because you can retain the record for audit purposes and still exclude it from reports when you are reconciling your Asset Master record account totals to your General Ledger balances.
This non-editable column displays the ID of the user who originally added the Asset Template record.
This non-editable column displays the date and time that the Asset Template record was originally added.
This column displays the optional short description entered for each of your selected records, as applicable.
You can add new data or edit existing data in this column. To "delete" data, replace it with blanks.
This column displays the optional long description entered for each of your selected records, as applicable.
You can add new data, edit existing data, or delete existing data in this column. To "delete" data, replace it with blanks.
This column displays the optional additional description entered for each of your selected records, as applicable.
You can add new data or edit existing data in this optional column. To "delete" data, replace it with blanks.
This column displays the property type entered for each of your selected records. You can edit this value.
Enter, or click to select, a valid property type for this record. Valid property types are set up on the Manage Property Types screen.
This column displays the required classification code entered for each of your selected records. You can edit this value.
Enter, or click to select, a valid classification code for this record. Valid classification codes are set up on the Manage Classification Codes screen.
This column displays the optional subclass code entered for each of your selected records, as applicable. You can edit data in this column.
Enter, or click to select, a valid subclass code for this record. To "delete" data, replace it with blanks. Valid subclass codes are set up on the Manage Subclass Codes screen.
If the record is depreciable (Depr Status = Depreciable), this column displays the required basis for depreciation that you assigned to each of your selected records on the Manage Asset Template Information screen. The available options are:
Years
Units
Lease Pds
For any optional books (2 to 10) used, the system uses the Years base method in its computations. Units (of Usage) and Lease Pds base methods are not available for non-G/L books.
A record must be depreciable to be eligible for depreciation calculations. If the record is non-depreciable, you cannot access this column for the record.
Because each of the three base methods (Years, Units, Lease Pds) for depreciable assets uses some specific terminology and concepts that are not mutually shared, this column ensures that you have access to fields/columns appropriate to the selected methodology. Access based on methodology includes both columns on this screen and fields in the G/L Book Info tab of the Manage Asset Template Information screen.
For a depreciable Asset Template record for which you have selected a Years depreciation basis methodology, the columns available for use in the G/L Book Info tab are appropriate to the methodology. Columns not appropriate to the selected methodology for the record, such as G/L Book Lease Start Date, G/L Book Units of Useful Life, and so on, are not available for use.
For a depreciable Asset Template record for which you have selected a Units of Usage depreciation basis methodology, the columns available for use in the G/L Book Info tab are appropriate to the methodology. Columns not appropriate to the selected methodology for the record, such as G/L Book Lease Start Date, G/L Book Depr Method, and so on, are not available for use.
For a depreciable Asset Template record for which you have selected a Lease Pds depreciation basis methodology, the columns available for use in the G/L Book Info tab are appropriate to the methodology. Columns not appropriate to the selected methodology for the record, such as G/L Book Useful Life, G/L Book Depr Method, and so on, are not available for use.
This column displays the required depreciation status assigned to each of your selected records on the Manage Asset Template Information screen.
The options available for this column are Depreciable or Non-Depreciable.
A record must be depreciable to be eligible for depreciation calculations.
If you specify that a record is depreciable, additional data will be required by the system, including a valid depreciation method and codes for valid G/L depreciation expense and accumulated depreciation account combinations.
If you specify that a record is non-depreciable, you cannot access the data fields related to the G/L Book Info tab and Other Books Info subtask of the Manage Asset Template Information screen.
This column displays the status of this check box (on the Manage Asset Template Information screen) for each of your selected records.
This check box is available only if the Depr Status column is Non-Depreciable.
If you select this check box for a non-depreciable asset, a future Asset Master disposal entry for this record can be posted to the General Ledger. In the case of non-depreciable assets (for example, land), the G/L entry on disposal can consist only of debits and credits, as appropriate, to the Cost and Gain/Loss on Sale of Fixed Assets accounts, because there is no accumulated depreciation associated with a non-depreciable asset.
You cannot select this check box for depreciable assets, because disposal entries for depreciable assets with the Selected for Posting option selected on the Manage Disposal Transactions screen are posted to the General Ledger.
This column displays the optional vendor ID that you assigned to each of your selected records, as applicable. You can edit this column. You can also enter, or click to select, a vendor ID. To "delete" data, replace it with blanks.
If your entry in this column matches an established vendor already set up on the Manage Vendors table in Costpoint Accounts Payable, the associated vendor name will display in the Vendor Name column on this screen, where it can be edited.
You can enter a vendor ID that has not been previously set up on the Manage Vendors screen in Costpoint Accounts Payable. In this event, note that the vendor ID in this column will only be in effect for the Asset Template record and will not be written back to the Manage Vendors table.
This column displays the optional vendor name that you assigned to each of your selected records, as applicable. You can edit this column.
You can also enter, or click to select, a vendor name. To "delete" data, replace it with blanks.
If your entry in this column matches an established vendor already set up on the Manage Vendors screen in Costpoint Accounts Payable, the associated vendor ID will display in the Vendor ID column on this screen, where it can be edited.
You can enter a vendor name that has not been previously been linked with and set up with a vendor ID on the Manage Vendors screen in Costpoint Accounts Payable. In this event, the vendor name in this column will only be in effect for the Asset Template record and will not be written back to the Manage Vendors table.
This column displays the optional manufacturer ID that you assigned to each of your selected records, as applicable. You can edit this column.
You can also enter, or click to select, a manufacturer ID. To "delete" data, replace it with blanks.
If your entry in this column matches an established manufacturer already set up on the Manage Manufacturers screen in Costpoint Product Definition, the manufacturer name will display in the Manufacturer Name column on this screen, where it can be edited.
You can enter a manufacturer ID that has not been previously set up in the Manufacturers table in Costpoint Product Definition. In this event, note that if you enter a manufacturer ID for the Asset Template record that has not been previously assigned to an alternate part in Costpoint Product Definition, the manufacturer ID will be in effect only for the Asset Template record and will not be written back to the Manufacturers table.
This column displays the optional manufacturer name that you assigned to each of your selected records, as applicable. You can edit this column.
You can also enter, or click to select, a manufacturer name. To "delete" data, replace it with blanks.
If your entry in this column matches an established manufacturer already set up on the Manage Manufacturers screen in Costpoint Product Definition, the manufacturer ID will display in the Manufacturer column on this screen, where it can be edited.
You can enter a manufacturer name that has not been previously set up in the Manufacturer table in Costpoint Product Definition. In this event, the manufacturer name in this column will only be in effect for the Asset Template record and will not be written back to the Manufacturer table.
This column displays the optional model number that you assigned to each of your selected records, as applicable. You can edit this column or enter a model number. To "delete" data, replace it with blanks.
This column displays the system-required condition code assigned to this record.
The options available for this column are New or Used.
You can edit this required column as desired. The condition code is a data element designed to help sort your records for inquiries and reports and is not used as a selection parameter in any system process or report.
This column displays the optional location group amount that you assigned to each of your selected records, as applicable. You can edit this column. You can also enter, or click to select, a valid location group for this record.
If you assign a location group in this column, you cannot edit data in the City, State/Province, Postal Code, Country, or County columns on this screen. In this circumstance, you can return to the Manage Location Groups screen to make appropriate edits, as needed, or you can delete the location group in this column and enter or edit specific location information for the record on a column-by-column basis. To "delete" data, replace it with blanks.
This column displays the location group description assigned to the location group when it was first saved on the Manage Location Groups screen.
You cannot edit this column or make entries in it. To edit the location group description, you must do so on the Manage Location Groups screen.
This column displays the city data that you assigned to each of your selected records, as applicable. Data displayed in this column may have been set up as a default on the Manage Location Groups screen.
You can edit this column only if you did not use a location group. If data displays because you used a location group that contains city data, you will not be able to edit this column. In this circumstance, you can return to the Manage Location Groups screen to make appropriate edits to the city data, as needed, or you can delete the data in the Location Group column and enter or edit specific city data for the record.
Alternately, if you do not use location groups and you enter a postal code in the Postal Code column that has previously been set up on the Manage Postal Codes screen (in Costpoint Administration), the city name associated with the postal code displays in this column as a default city. In this circumstance, you can overwrite the displayed city data as desired and enter non-validated city data.
This column displays the state/province data that you assigned to each of your selected records, as applicable. Data displayed in this column may have been set up as a default on the Manage Location Groups screen.
You can edit this column. You can also enter, or click to select, a state/province only if you did not use a location group. If data displays because you entered a location group that contains state/province data, you will not be able to edit this column. In this circumstance, you can return to the Manage Location Groups screen to make appropriate edits to the state/province data, as needed, or you can delete data in the Location Group column and enter or edit specific state/province data for the record.
Alternately, if you do not use location groups and you enter a postal code in the Postal Code column that has previously been set up on the Manage Postal Codes screen in Costpoint Administration, the state/province name associated with the postal code displays in this column and cannot be edited.
You can enter only valid state/province data from the Manage States and Provinces screen in Costpoint Administration in this column. If you enter state/province data, you must also enter valid data in the Country column.
This column displays the country data that you assigned to each of your selected records, as applicable. Data displayed in this column may have been set up as a default on the Manage Location Groups screen.
You can edit this column. You can also enter, or click to select, a country only if you did not use a location group. If data displays because you entered a location group that contains country data, you will not be able to edit this column. In this circumstance, you can return to the Manage Location Groups screen to make appropriate edits to the state/province and country data, as needed, or you can delete data in the Location Group column and enter or edit specific state/province and country data for the record.
You can enter only valid country data from the Manage Countries screen in Costpoint Administration in this column.
Alternately, if you do not use location groups and you enter a postal code in the Postal Code column that has previously been set up on the Manage Postal Codes screen (in Costpoint Administration), the country associated with the postal code displays in this column and cannot be edited.
This column displays the postal code data that you assigned to each of your selected records, as applicable. Data displayed in this column may have been set up as a default on the Manage Location Groups screen.
You can edit this column. You can also enter, or click to select, a postal code only if you did not use a location group. If data displays because you entered a location group that contains postal code data, you will not be able to edit data in this column. In this circumstance, you can return to the Manage Location Groups screen to make appropriate edits to the state/province, country, and postal code data, as needed, or you can delete data in the Location Group column and enter or edit specific state/province, country, and postal code data for the record.
If you use Lookup to review the postal codes or if you enter a postal code in this column that has previously been set up on the Manage Postal Codes screen (in Costpoint Administration), the city, state/province, and/or country data associated with the postal code displays in the appropriate columns. Entries in this column, when permitted, will overwrite existing data in the City, State/Province, and Country columns. (In this circumstance, you can overwrite data only in the City column.)
This column displays the optional county data that you assigned to each of your selected records, as applicable. Data displayed in this column may have been set up as a default on the Manage Location Groups screen.
You can edit this column or enter a county only if you did not use a location group. If data displays in this column because you entered a location group that contains county data, you will not be able to edit this column. In this circumstance, you can return to the Manage Location Groups screen to make appropriate edits to the county data, as needed, or you can delete data in the Location Group column and enter or edit specific county data for the record.
If you designated a label for Location 1 in the Location Labels for Asset Master group box on the Manage Asset Master Field Labels screen, your label description for Location 1 displays at this column. You are not required to establish a label for this column. If you did not set up a label for Location 1 on the Manage Asset Master Field Labels screen, Location 1 displays at this column.
This column displays the optional Location 1 data that you assigned to each of your selected records, as applicable. Data displayed in this column may have been set up as a default on the Manage Location Groups screen.
Enter, or click to select, a valid Location 1 code. This column is always editable, even if you have specified a Location 1 code associated with a location group. The Location 1 code entered in this column is validated against Location 1 codes set up on the Manage Location 1 Codes screen.
This column displays the Location 1 description assigned to the location code when it was saved on the Manage Location 1 Codes screen. You cannot edit this column or make entries in it. To edit the description for the Location 1 code, you must use the Manage Location 1 Codes screen.
If you designated a label for Location 2 in the Location Labels for Asset Master group box of the Manage Asset Master Field Labels screen, your label description for Location 2 displays at this column. You not required to establish a label for this column. If you did not set up a label for Location 2 on the Manage Asset Master Field Labels screen, Location 2 displays at this column.
This column displays the optional Location 2 data that you assigned to each of your selected records, as applicable. Data displayed in this column may have been set up as a default on the Manage Location Groups screen.
Enter, or click to select, a valid Location 2 code. This column is always editable, even if you have specified a Location 2 code associated with a location group. The Location 2 code entered in this column is validated against Location 2 codes set up on the Manage Location 2 Codes screen.
This column displays the Location 2 description assigned to the location code when it was saved on the Manage Location 2 Codes screen. You cannot edit this column or make entries in it. To edit the description for the Location 2 code, you must use the Manage Location 2 Codes screen.
If you designated a label for Location 3 in the Location Labels for Asset Master group box of the Manage Asset Master Field Labels screen, your label description for Location 3 displays at this column. Note that you are not required to establish a label for this column. If you did not set up a label for Location 3 on the Manage Asset Master Field Labels screen, Location 3 displays at this column.
This column displays the optional Location 3 data that you assigned to each of your selected records, as applicable. Data displayed in this column may have been set up as a default on the Manage Location Groups screen.
Enter, or click to select, a valid Location 3 code. This column is always editable, even if you have specified a Location 3 code associated with a location group. The Location 3 code entered in this column is validated against Location 3 codes set up on the Manage Location 3 Codes screen.
This column displays the Location 3 description assigned to the location code when it was saved on the Manage Location 3 Codes screen. You cannot edit this column or make entries in it. To edit the description for the Location 3 code, you must use the Manage Location 3 Codes screen.
This column displays the required asset account "ownership" data assigned to each of your selected records.
You can edit the displayed data by entering a valid asset account in this required column to specify the account "ownership" for this record. Enter, or click to select, an asset account.
The system will validate that the account is a detail account and that it is active. If the account fails one of these validations, you will need to either make corrections to the account or enter a different account number. (Additional validations regarding the Account/Organization/Project/Reference 1/Reference 2 data, as applicable, will also be performed before the record can be saved. The system will validate that the account is valid for the organization and, if project-required, valid for the project.)
This column displays the required asset organization "ownership" data assigned to each of your selected records.
You can edit the displayed data when you enter, or click to select, a valid asset organization in this required column to specify the organization "ownership" for this record.
When you save this screen, the system will validate that the organization is active. If the organization fails this validation, you will need to either make corrections to the organization or enter a different organization. (Additional validations regarding the Account/Organization/ Project/Reference 1/Reference 2 data, as applicable, will also be performed before the record can be saved. The system will validate that the organization is valid for use with the account. If the organization is restricted to specific projects, the system will also validate the organization-project relationship.)
This column displays the optional asset project "ownership" data assigned to each of your selected records, as applicable.
You can edit the displayed data when you enter, or click to select, a valid asset project in this column to specify the project "ownership" for this record. To "delete" data, replace it with blanks.
The system will validate that the project level is valid and active. If the project fails this validation, you will need to either make corrections to the project or enter a different project. (Additional validations regarding the Account/Organization/ Project/ Reference 1/Reference 2 data, as applicable, may also be performed before the record can be saved. An example of this would be checking that the account-organization combination linked with the project is valid.)
If you designated a different label for Reference 1 on the Configure General Ledger Settings screen in Costpoint General Ledger, your label displays at this column. If you did not set up a different label for Reference 1, Asset Ref 1 displays at this column.
This column displays the optional asset Reference 1 "ownership" data assigned to each of your selected records, as applicable.
You can edit the displayed data when you enter, or click to select, a valid asset Reference 1 number in this column to specify the Reference 1 "ownership" for this record. To "delete" data, replace it with blanks.
When you save this screen, the system will validate the Reference 1 number. If a Reference 1 number fails this validation, you will need to either make corrections to the Reference 1 number or enter a different Reference 1 number.
If you designated a different label for Reference 2 on the Configure General Ledger Settings screen in Costpoint General Ledger, your label displays at this column. If you did not set up a different label for Reference 2, Asset Ref 2 displays at this column.
This column displays the optional asset Reference 2 "ownership" data assigned to each of your selected records, as applicable.
You can edit the displayed data when you enter, or click to select, a valid asset Reference 2 number in this column to specify the Reference 2 "ownership" for this record. To "delete" data, replace it with blanks.
The system will validate the Reference 2 number. If a Reference 2 number fails this validation, you will need to either make corrections to the Reference 2 number or enter a different Reference 2 number.
Asset account combination denotes "ownership" and can include balance sheet combinations, expense account combinations (to track items not capitalized), and/or project combinations for property that should be identified with a contract.
A valid asset account combination is required on this screen for both depreciable and non-depreciable property. At the minimum, a system-validated Account and Organization must be assigned as the "owner."
Although account combinations for depreciation expense and accumulated depreciation are not necessary for non-depreciable records, asset account combination data is required for ALL records for the purpose of segregating groups of assets. You can use asset account combination data as selection criteria by which you can choose specialized segments from your database records when performing online queries, running standard reports, or designing custom reports using Impromptu.
The accumulated depreciation account code specifies the General Ledger account, organization, project, reference 1, and reference 2 numbers to which accumulated depreciation will be posted from the Asset Master record. You set up accumulated depreciation account codes during initialization in the Manage Accumulated Depreciation Account Codes screen.
This column is not available for non-depreciable assets, but required for depreciable assets. This column displays the accumulated depreciation account code entered for this record, if applicable. You can edit this column when you enter, or click to select, a valid accumulated depreciation account code for this record. Because postings to the G/L are made to the account(s)/organization(s)/project(s) represented by the code, use caution if you edit this column.
The depreciation expense account allocation code specifies one or more General Ledger account, organization, project, reference 1 and reference 2 numbers, as applicable, to which depreciation expense will be posted from the Asset Master record. You set up depreciation expense account allocation codes during initialization on the Manage Depreciation Expense Acct Allocation Codes screen.
This column is not available for non-depreciable assets, but required for depreciable assets. This column displays the depreciation expense account allocation code assigned to each of your selected records, as applicable. You can edit the column when you enter, or click to select, a valid depreciation expense account allocation code for this record. Because postings to the G/L are made to the account(s)/organization (s)/project(s) represented by the code, use caution if you make edits to this column.
For depreciable assets, this column displays the status of this check box assigned to this record when the template was saved on the Manage Asset Template Information screen
Select this check box if you want the Asset Master record to be included in system calculations of depreciation. (You can always overwrite the automatic system calculation of depreciation in an Asset Master record.)
Clear this check box if you want to disable the automatic system calculation of depreciation. If you do this, you will need to manually enter the amount of depreciation in an Asset Master record if you want to post depreciation for this record.
For depreciable assets, this column is available for user entry or edits only if the value in the Depr Based On column is Years. The column is not available for user entry if the value in the Depr Based On column is Units or Lease Pds.
This column displays the required depreciation method code assigned to this depreciable record when the template was saved on the Manage Asset Template Information screen.
Enter, or click to select, a valid depreciation method code for this record. You can edit the data in this required column. Valid depreciation method codes are set up during initialization on the Manage Depreciation Methods screen.
For depreciable assets, this column is available for user entry or edits only if the value in the Depr Based On column is Years. The column is not available for user entry if the value in the Depr Based On column is Units or Lease Pds.
This column displays the optional useful life assigned to this record, as applicable, when the template was saved on the Manage Asset Template Information screen.
You can edit this column when you enter the useful life for this record. The system does not validate the data in this column. To "delete" data, replace it with blanks.
This column is available for user entry or edits only if the value in the Depr Based On column is Years or Units. The column is not available for user entry if the value in the Depr Based On column is Lease Pds.
This column displays the optional G/L book salvage percent assigned to this template record, as applicable, when it was last saved on the Manage Asset Template Information screen.
Enter the salvage value percentage rate to be used in the calculation of salvage and depreciable value in this column, if applicable. To "delete" data, replace it with blanks.
The G/L Book Salvage Percent column and the G/L Book Salvage Value columns are reciprocal in that the entry in one column calculates and displays corresponding data in the other column in an Asset Master record. If you enter a salvage value percentage in this column, the system computes and displays the equivalent salvage value in the G/L Book Salvage Value column once the template data is imported to an Asset Master record
In an Asset Master record, system-computed data from the G/L Book Salvage Value column is subtracted from the G/L Book Total Cost column and the result is displayed in the G/L Book Amt to Depreciate column, which in turn affects the amount of depreciation calculated by the system. In a simplified example, if an asset's cost is $10,000 and its salvage value is 5%, the amount to depreciate is $9,500, and the system will not permit depreciation in excess of $9,500 for this asset. Do not enter a value in the G/L Book Salvage Percent column on this screen for salvage unless this is the point at which you want the system to stop depreciation.
Because system calculations use this data to determine how depreciation computations will take place for each record, use caution when adding or editing the percentage in this column.
Refer to the following examples, each of which illustrates a different way in which the system handles salvage value relative to the computation of depreciation based on years:
You can edit this column or enter a value only if the Depr Based On column is Units. The column is not available if the value in the Depr Based On column is Years or Lease Pds.
The system displays the optional estimated units of useful life assigned to this record, as applicable, when the template was saved on the Manage Asset Template Information screen
This column is similar to the Total Cost column in the G/L Book Info tab, in that it defines the maximum number of units beyond which the system should not calculate depreciation. If the G/L Book Auto Calculate check box is selected, this field is required.
You can edit the value that displays in this column when you enter the estimated units of useful life (such as hours or miles). To "delete" the data, replace it with zeroes.
You can edit this column or enter a value only if the Depr Based On column is Units. The column is not available if the value in the Depr Based On column is Years or Lease Pds.
This column displays the optional estimated units of useful life assigned to this record, as applicable, when the template was saved on the Manage Asset Template Information screen.
You can edit the value that displays in this column when you enter the type of unit for this asset, such as hours, miles, and so on. The value in this column is for data purposes only and is not used in system calculations. To "delete" the data, replace it with blanks.
You can edit this column or enter a value only if the Depr Based On column is Units. The column is not available if the value in the Depr Based On column is Years or Lease Pds.
This column displays the optional standard depreciation rate per unit of usage assigned to this record, as applicable, when the template was saved on the Manage Asset Template Information screen.
You can edit the value that displays in this column. To "delete" the data, replace it with zeroes.
You can edit this column or enter a value only if the Depr Based On column is Lease Pds. The column is not available if the value in the Depr Based On column is Years or Units.
This column displays the check box selection, as applicable, when the template was saved on the Manage Asset Template Information screen.
Select this check box to indicate that this record is a capitalized lease. This check box is for data purposes only and is not used in system calculations.
You can edit this column or enter a value only if the value in the Depr Based On column is Lease Pds. The column is not available if the value in the Depr Based On column is Years or Units.
This column displays the optional lease start date, as applicable, when the template was saved on the Manage Asset Template Information screen.
The value in this column is for data purposes only and is not used in system calculations. (When calculating amortization, the system checks only the date from the G/L Book Depr Start Date column.) The date in this column can be an historical, current, or future date.
You can enter or edit the lease start date for this record in date format in this optional column. To "delete" the data, replace it with blanks.
You can edit this column or enter a value only if the value in the Depr Based On column is Lease Pds. The column is not available if the value in the Depr Based On column is Years or Units.
This column displays the optional lease end date, as applicable, when the template was saved on the Manage Asset Template Information screen.
The value in this column is for data purposes only and is not used in system calculations. (When calculating amortization, the system checks only the date from the G/L Book Depr Start Date column.) The date in this column can be an historical, current, or future date.
You can enter or edit the lease start date for this record in date format in this optional column. To "delete" the data, replace it with blanks.
Unlike the G/L Book, for which depreciation can be based on years, units of usage, or lease periods, depreciation for other books can be based only on years. This column displays the optional depreciation method code assigned to this template record for this book, if applicable, when the template was saved on the Manage Asset Template Information screen.
Enter, or click to select, a depreciation method code for this record. Valid depreciation method codes are set up during initialization on the Manage Depreciation Methods screen.
This column displays the optional useful life assigned to this record for this book, if applicable, when the template was saved on the Manage Asset Template Information screen.
You can edit this column or enter the useful life for this record. The system does not validate the data in this column.
For depreciable assets, this column displays the status of this check box assigned to this record when the template was saved on the Manage Asset Template Information screen
Select this check box to include the book for this Asset Master record in system calculations of depreciation. (You can always overwrite the automatic system calculation of depreciation in an Asset Master record.)
Clear this check box if you want to disable the automatic system calculation of depreciation for this book. In this circumstance, you will need to manually enter the amount of depreciation in an Asset Master record if you want to post depreciation for this record.
This optional column displays the optional salvage percent assigned to this record, as applicable, when the template was last saved on the Manage Asset Template Information screen.
Enter the salvage value percentage rate to be used in the calculation of salvage and depreciable value for this book. To "delete" the data, replace it with zeroes.
The Book 2 (or your label) Salvage Percent column and the Book 2 (or your label) Salvage Value columns are reciprocal because entry in one column calculates and displays the data in the other column in an Asset Master record. If you enter a salvage value percentage in this column, the system computes and displays the equivalent salvage value in the Book 2 (or your label) Salvage Value column once the template data is imported to an Asset Master record.
In an Asset Master record, system-computed data from the Book 2 (or your label) Salvage Value column is subtracted from the Book 2 (or your label) Total Cost column and the result is displayed in the Book 2 (or your label) Amt to Depreciate column, which in turn affects the amount of depreciation calculated by the system. In a simplified example, if an asset's cost is $10,000 and its salvage value is 5%, the amount to depreciate is $9,500 and the system will not permit depreciation in excess of $9,500 for this asset. Do not enter a value in the Book 2 (or your label) Salvage Percent or Book 2 (or your label) Salvage Value columns for salvage unless this is the point at which you want the system to stop depreciation.
Because system calculations use this data to determine how depreciation computations should take place for each record (as well as the amount to depreciate), use caution if you change this column for property records once they have begun depreciating in the system.
Refer to the following specific examples, each of which illustrates a different way in which the system handles salvage value relative to the computation of depreciation based on years:
Please refer to the documentation for the Book 2 (or your label) Depr Method Code column.
Please refer to the documentation for the Book 2 (or your label) Useful Life column.
Please refer to the documentation for the Book 2 (or your label) Auto Calculate column.
Please refer to the documentation for the Book 2 (or your label) Salvage Percent column.
This column displays the optional national stock number entered for this record, if applicable, when the template was last saved on the Manage Asset Template Information screen.
The system does not validate the data in this column. You can edit this column or enter a value. To "delete" the data, replace it with blanks.
This column displays the optional year-built data entered for this record, if applicable, when the template was last saved on the Manage Asset Template Information screen.
The system does not validate the data in this column. You can edit this column or enter a value of up to four numeric characters in year format (for example, 2001). To "delete" the data, replace it with blanks.
This column displays the optional employee data entered for this record, as applicable, when the template was last saved on the Manage Asset Master Information screen.
The system does not validate the data in this column. You can edit this column or enter, or click to select, a valid employee ID. To "delete" the data, replace it with blanks.
This column displays the optional data assigned to this record, if applicable, when the template was last saved on the Manage Asset Template Information screen.
The system uses the "government" label only as a matter of convenience and organization. Because these field names are user-defined, you can use these data fields to hold data for any asset type, including company-owned property and other "non-government" property. To edit the column name, you must do so on the Manage Asset Master Field Labels screen.
The system does not validate the data in this column. You can edit this column or enter a value. To "delete" the data, replace it with blanks.
Please refer to the documentation for the Governmentt1 (or your label) column.
This column displays the optional notes entered for this record, if applicable, when the template was last saved on the Manage Asset Template Information screen.
The system does not validate the data in this column. You can edit this column. To "delete" the data, replace it with blanks.