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 of Usage
• 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 Capitalize, Depreciable, and Non-Depreciable.

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.

If you specify that a record is Capitalize, the system will disable the fields in the G/L Book Info tab and the Other Books Info subtask.

This column displays the Lease Type options. There is no system calculation associated with selecting these options. The following possible display options are available for this column:

• Straight Line: It is defaulted when the Depr/Lease Status is Depreciable and Depr/Lease Based On is Lease Pds.
• Operating Lease: It is accessible when the Depr/Lease Status is Capitalize and Depr/Lease Based On is Lease Pds.
• Finance Lease: It is accessible when the Depr/Lease Status is Capitalize and Depr/Lease Based On is Lease Pds.

This field will be inaccessible and blank when the Depr/Lease Status is Depreciable wherein the Depr/Lease Based On is Years or Units of Usage, and for Non-Depreciable.

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/Lease Status column is Non-Depreciable. This check box is disabled for Capitalize leases.

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. The Accum Depr Account Code field is enabled but not required for Capitalize leases. 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. The Depr Exp Acct Alloc Code field is enabled but not required for Capitalize leases. 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/Lease Based On column is Years. The column is not available for user entry if the value in the Depr/Lease Based On column is Units of Usage 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/Lease Based On column is Years. The column is not available for user entry if the value in the Depr/Lease Based On column is Units of Usage 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/Lease Based On column is Years or Units of Usage. The column is not available for user entry if the value in the Depr/Lease 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:

• Example 1

  In this example, the system subtracts the salvage value before calculating depreciation. This is the most common methodology for computing depreciation when there is salvage value assigned to an asset.

  Asset Master Record

  G/L Book Total Cost	= $ 10,000
  G/L Book Salvage Percent	= 10 %
  G/L Book Salvage Value	= $ 1,000
  G/L Book Depr Method Code	= SL5
  G/L Book Amt to Depreciate	= $ 9,000

  Depr Method: SL5 (Straight Line Method over 5 years)

  Total % to Depreciate = 100%

  Subtract Salvage Value Before Calculation= Checked for depreciation method "SL5."

  Year	%		Amt to Depreciate		Annual Depreciation
  1	20%	x	9,000	=	1,800
  2	20%	x	9,000	=	1,800
  3	20%	x	9,000	=	1,800
  4	20%	x	9,000	=	1,800
  5	20%	x	9,000	=	1,800
  					9,000

  For this example, the system subtracted the salvage value from the asset's total cost to determine the amount to depreciate ($10,000 - $1,000 = $9,000). Note that the residual amount is spread uniformly across all years of useful life ($200 per year for 5 years).

  To determine annual depreciation, the system multiplies the amount to depreciate by the depreciation percentage for the appropriate year of life.

• Example 2

  In this example, the system does not subtract the salvage value before calculating depreciation.

  Asset Master Record:

  G/L Book Total Cost	= $ 10,000
  G/L Book Salvage Percent	= 10 %
  G/L Book Salvage Value	= $ 1,000
  G/L Book Depr Method Code	= SL5
  G/L Book Amt to Depreciate	= $ 10,000

  Depr Method: SL5 (Straight-Line Method over 5 years)

  Total % to Depreciate = 100%

  Subtract Salvage Value Before Calculation = Clear (unchecked) for depreciation method "SL5."

  Year	%		Amt to Depreciate		Annual Depreciation
  1	20%	x	10,000	=	2,000
  2	20%	x	10,000	=	2,000
  3	20%	x	10,000	=	2,000
  4	20%	x	10,000	=	2,000
  5	20%	x	10,000	=	2,000
  					10,000

  For this example, the system ignored the salvage value from the asset's total cost in determining the amount to depreciate (10,000 - 0 = 10,000). To determine annual depreciation, the system multiplies the amount to depreciate by the depreciation percentage for the appropriate year of life.

• Example 3

  This example illustrates the only method available that recognizes the residual (salvage) amount in the last year of useful life. Note that only 90% of the asset was set up for depreciation when the depreciation method was defined.

  Asset Master Record:

  G/L Book Total Cost	= $ 10,000
  G/L Book Salvage Percent	= 10 %
  G/L Book Salvage Value	= $ 1,000
  G/L Book Depr Method Code	= SL5
  G/L Book Amt to Depreciate	= $ 9,000

  Depr Method: SL5 (Straight-Line Method over 5 years)

  Total % to Depreciate = 90%

  Subtract Salvage Value Before Calculation = Clear (unchecked) for depreciation method "SL5."

  Year	%		Amt to Depreciate		Annual Depreciation
  1	20%	x	10,000	=	2,000
  2	20%	x	10,000	=	2,000
  3	20%	x	10,000	=	2,000
  4	20%	x	10,000	=	2,000
  5	10%	x	10,000	=	1,000
  					9,000

You can edit this column or enter a value only if the Depr/Lease Based On column is Units of Usage. The column is not available if the value in the Depr/Lease 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/Lease Based On column is Units of Usage. The column is not available if the value in the Depr/Lease 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/Lease Based On column is Units of Usage. The column is not available if the value in the Depr/Lease 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/Lease Based On column is Lease Pds and Lease Type is Straight Line. The column is not available if the value in the Depr/Lease Based On column is Years or Units of Usage and Depr/Lease Status is Capitalize.

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/Lease Based On column is Lease Pds and Lease Type is Straight Line. The column is not available if the value in the Depr/Lease Based On column is Years or Units of Usage and Depr/Lease Status is Capitalize.

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. This column is disabled when the Depr/Lease Status is Capitalize.

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:

• Example 1

  In this example, the system subtracts the salvage value before calculating depreciation. This is the most common methodology for computing depreciation when there is salvage value assigned to an asset.

  Asset Master Record

  Total Cost	= $ 10,000
  Salvage Percent	= 10 %
  Salvage Value	= $ 1,000
  Depr Method Code	= SL5
  Amt to Depreciate	= $ 9,000

  Depr Method: SL5 (Straight-Line Method over 5 years)

  Total % to Depreciate = 100%

  Subtract Salvage Value Before Calculation = Checked for depreciation method "SL5."

  Year	%		Amt to Depreciate		Annual Depreciation
  1	20%	x	9,000	=	1,800
  2	20%	x	9,000	=	1,800
  3	20%	x	9,000	=	1,800
  4	20%	x	9,000	=	1,800
  5	20%	x	9,000	=	1,800
  					9,000

  For this example, the system subtracted the salvage value from the asset's total cost to determine the amount to depreciate (10,000 - 1,000 = 9,000). Note that the residual amount is spread uniformly across all years of useful life ($200 per year for 5 years).

• Example 2

  In this example, the system does not subtract the salvage value before calculating depreciation.

  Asset Master Record

  Total Cost	= $ 10,000
  Salvage Percent	= 10 %
  Salvage Value	= $ 1,000
  Depr Method Code	= SL5
  Amt to Depreciate	= $ 10,000

  Depr Method: SL5 (Straight-Line Method over 5 years)

  Total % to Depreciate = 100%

  Subtract Salvage Value Before Calculation = Clear (unchecked) for depreciation method "SL5."

  Year	%		Amt to Depreciate		Annual Depreciation
  1	20%	x	10,000	=	2,000
  2	20%	x	10,000	=	2,000
  3	20%	x	10,000	=	2,000
  4	20%	x	10,000	=	2,000
  5	20%	x	10,000	=	2,000
  					10,000

  For this example, the system ignored the salvage value from the asset's total cost when determining the amount to depreciate (10,000 - 0 = 10,000). To determine annual depreciation, the system multiplies the amount to depreciate by the depreciation percentage for the appropriate year of life.

• Example 3

  This example illustrates the only method available that recognizes the residual (salvage) amount in the last year of useful life. Note that only 90% of the asset was set up for depreciation when the depreciation method was defined.

  Asset Master Record

  Total Cost	= $ 10,000
  Salvage Percent	= 10 %
  Salvage Value	= $ 1,000
  Depr Method Code	= SL5
  Amt to Depreciate	= $ 9,000

  Depr Method: SL5 (Straight-Line Method over 5 years)

  Total % to Depreciate = 90%

  Subtract Salvage Value Before Calculation = Unchecked for depreciation method "SL5."

  Year	%		Amt to Depreciate		Annual Depreciation
  1	20%	x	10,000	=	2,000
  2	20%	x	10,000	=	2,000
  3	20%	x	10,000	=	2,000
  4	20%	x	10,000	=	2,000
  5	10%	x	10,000	=	1,000
  					9,000

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.