Contents of the Manage Asset Master Global Changes Screen
Use the fields and options to configure the Manage Asset Master Global Changes screen.
Table Window
Field | Description | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Asset No |
This column displays the required asset number assigned to each of your selected records when they were first saved on the Manage Asset Master Information screen. Please refer to the documentation for the Asset No field on the Manage Asset Master Information screen for additional information. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Item No |
This column displays the required item number assigned to each of your selected records when they were first saved on the Manage Asset Master Information screen. Please refer to the documentation for the Item No field on the Manage Asset Master Information screen for additional information. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Template No |
This column displays the template number that was used, if applicable, for each of your selected records, to import data from the template into the Asset Master record. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Rev No |
This column displays the revision number associated with the template number that was used, if applicable, for each of your selected records, to import data from the template into the Asset Master record. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Short Description |
This column displays the optional short description entered for each of your selected records, as applicable. Data displayed in this column may have been entered/edited on the Desc Info tab on the Manage Asset Master Information or on the Manage Asset Description Information screen. You can achieve the equivalent of a data deletion by replacing the existing data with blanks. If the displayed short description originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. Although this column is not required, you may want to provide a meaningful asset description if this column is blank, because the data from this column will display in the Description field on many standard system reports. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Depreciation/Lease Status |
This column displays the required depreciation/lease status assigned to each of your selected records. Data displayed in this column may have been edited on the Manage Asset Master Information screen. The options available for this required column are Depreciable, Non-Depreciable, and Capitalize. 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 Master Information screen or the Manage Asset General Ledger Book Information and the Manage Asset Other Books Information screens. If you specify that a record is Capitalize, the system will disable the fields in Other Books Info subtask and some fields in G/L Book Info tab. Note: If you have assigned a
Non-Depreciable status to a record, you can optionally select the
Post Disposal to G/L check box to allow a future disposal entry for this record to be posted to the General Ledger. (In the case of non-depreciable assets (for example, land), the G/L entry on disposal can only consist 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 non-depreciable assets). The
Post Disposal to G/L check box will not be available if the depreciation status of the asset is
Depreciable because disposal entries for depreciable assets can always be posted to the General Ledger.
When you change the depreciation status (Depreciable to Non-Depreciable or Non-Depreciable to Depreciable), the system performs a validation that checks the Fixed Assets Disposal Edit table for an existing entry for this asset. You cannot change the Depreciation Status if a disposal entry exists on the Manage Disposal Transactions screens. To change the depreciation status in this circumstance, you must first delete the disposal transaction from the Manage Disposal Transactions screens. To preserve the audit trail, you cannot edit this column after a disposal is posted or manually entered. When you first manually add a historical record with a Disposal status, you can edit all eligible fields in the Asset Master record as needed before saving the record for the first time. If you access the saved "Disposal" record again, however, the Record Status, Depreciation/Lease Status, and Depr/Lease Based On columns on this screen are disabled. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Post Disposal to G/L |
This column displays the status of this check box for each of your selected records. Data displayed in this column may have been edited on the Manage Asset Master Information screen. This check box is available only if you have specified that the record is Non-Depreciable in the Depr Status column. If you select this check box for a non-depreciable asset, a future 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 on Selected for Posting status on the Manage Disposal Transactions screens are posted to the General Ledger. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Record Status |
The system displays the system-required record status assigned to each of your selected records. The value displayed in this column may have been edited on the Manage Asset Master Information screen or on the Manage Asset Description Information screen. The options available for this required column are Active, Inactive, or Disposal. 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 a record Inactive provides an alternative to deleting the record, because you can retain the record for audit purposes and exclude it from reports when you are reconciling your Asset Master record account totals to your General Ledger balances. When you save an inactive record, the system validates that both the current period depreciation and the amount posted values are equal to zero. If either amount does not equal zero, indicating that depreciation was entered or computed for the asset in the current period and/or that there is unposted depreciation, you will not be able to give the record "Inactive" status. Note that you cannot delete an Asset Master record for which a transaction has been posted to the General Ledger. In this circumstance, you can change the record status to Inactive to ensure that it will be retained for audit purposes and exclude it from reports when you are reconciling your asset account totals to your General Ledger balances. When a disposal for an Asset Master record is posted to the General Ledger, the system changes the status for this record to Disposal. A record with a Disposal status will be skipped for depreciation calculations and for reports that do not specify the inclusion of disposal records. (If a record has a Disposal status, the Disposal option will be selected in the Record Status drop-down list in the Manage Asset Master Information screen and the Record Status column on the Manage Asset Description Information screen will display Disposal.) Although it should rarely be necessary, you can set up a historical Asset Master record that has been disposed of with a Disposal status. (If you enter historical data on the Disp Info tab of the Maintain Asset Master Info screen and on the Manage Asset Disposal Information screen, you must also assign a Disposal status to the record in order to successfully save it). Note: When you first manually add a historical record with a
Disposal status, all fields in the Asset Master record can be edited as needed before saving the record for the first time. If the saved "Disposal" record is accessed again, however, the selection options in the
Record Status,
Depreciation/Lease Status, and
Depr/Lease Based On fields/columns are disabled. In addition, edits to fields in the Cost Info and Acct Info tabs and Other Books Info subtask of the Manage Asset Master Information screen and to columns on the Manage Asset Cost Information, Manage Asset Account Information, and Manage Other Books Information screens cannot be saved in this circumstance.
You can enter original data in the Other Books Info subtask of the Manage Asset Master Information and on the Manage Asset Other Books Information screen for an Asset Master record with a Disposal status only when no data has previously been entered and saved. If the Other Books Info subtask of the Manage Asset Master Information screen or the Manage Asset Other Books Information screen already contains saved data, this data cannot be edited if the status is changed to Disposal. If the Disposal Entry Type column displays MANUAL in the Disp Info tab of the Manage Asset Master Information screen or on the Manage Asset Disposal Information screen, you can change disposal data for an Asset Master record with a Disposal status. If the Disposal Entry Type column displays SYSTEM in the Disp Info tab of the Manage Asset Master Information screen or on the Manage Asset Disposal Information screen, you cannot change disposal data for an Asset Master record with a Disposal status. If you have designated a Disposal status and have also manually entered data by mistake in the Disp Info tab of the Manage Asset Master Information screen or on the Manage Asset Disposal Information screen, you can change the status back to Active if you first delete all manually entered data from the Disp Info tab of the Manage Asset Master Information screen or on the Manage Asset Disposal Information screen. Note: If an entry already exists on the Manage Disposal Transactions screens for this Asset Master record, you cannot change the status to
Disposal. In this circumstance, if you need to assign a
Disposal status to a record, first delete the entry from the Manage Disposal Transactions screen. To preserve the audit trail, you cannot edit this column after a disposal is posted.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Property Type |
This column displays the required property type entered for each of your selected records. Data displayed in this column may have been edited on the Manage Asset Master Information screen or on the Manage Asset Description Information screen. Enter, or click to select, a valid property type for this record. Valid property types are set up on the Manage Property Types screen. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Classification Code |
This column displays the required classification code entered for each of your selected records. Data displayed in this column may have been edited on the Manage Asset Master Information screen or on the Manage Asset Description Information screen. Enter, or click to select, a valid classification code for this record. Valid classification codes are set up on the Manage Classification Codes screen. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Subclass Code |
This column displays the optional subclass code entered for each of your selected records. Data displayed in this column may have been edited on the Manage Asset Master Information screen or on the Manage Asset Description Information screen. Enter, or click to select, a valid subclass code for this record. Valid subclass codes are set up on the Manage Subclass Codes screen. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Depr/Lease Based On |
If the record is depreciable (Depr/Lease Status is Depreciable), this column displays the required basis for depreciation that you assigned to each of your selected depreciable records. Data displayed in this column may have been edited on the Manage Asset Master Information screen. Select the depreciation methodology from the drop-down list. The available options are:
Note: You can choose the basis for depreciation methodology only for the G/L Book.
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 of Usage, Lease Pds) for depreciable assets uses some specific terminology and concepts that are not mutually shared, this column ensures that you have access to columns appropriate to the selected methodology when you enter the G/L Book Info tab of the Manage Asset Master Information screen.
Note: To preserve the audit trail, you cannot edit this column after a disposal is posted or manually entered. When you first manually add a historical record with a
Disposal status, all eligible fields in the Asset Master record can be edited as needed, before saving the record for the first time. If the saved Disposal record is accessed again, however, the
Record Status,
Depreciation/Lease Status, and
Depr/Lease Based On columns on this screen are disabled.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Lease Type |
The new Lease Type drop-down field options are for tracking purposes only. There is no system calculation associated with selecting these options. Operating Lease, Finance Lease, and Straight Line have been added in the list of options. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PO Date |
This column displays the purchase order date that you assigned to each of your selected records, as applicable. Data displayed in this column may have been entered or edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can add new data or edit existing data in this column. Enter, or click to select, the PO date. To delete data, replace it with blanks. If the displayed purchase order date originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PO No |
This column displays the purchase order number that you assigned to each of your selected records, as applicable. Data displayed in this column may have been entered/edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can add new data or edit existing data for the purchase order number in this column. To delete data, replace it with blanks. If the displayed purchase order number originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PO Line No |
This column displays the purchase order line number that you assigned to each of your selected records, as applicable. Data displayed in this column may have been entered/edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can add new data or edit existing data for the purchase order line number in this column. To delete data, replace it with blanks. If the displayed purchase order line number originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
PO Rel No |
This column displays the release number for a blanket purchase order that you assigned to each of your selected records, as applicable. Data for this column may have been entered/edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can add new data or edit existing data for the purchase order release number in this column. To delete data, replace it with blanks. If the displayed purchase order release number originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Receipt Date |
This column displays the receipt date that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can add new data or edit existing data in this column when you enter, or click to select, a receipt date. To delete data, replace it with blanks. If the displayed receipt date originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Receipt |
This column displays the receipt identifier that you assigned to each of your selected records, as applicable. Data for this column may have been entered/edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can add new data or edit existing data for the receipt identifier in this column. To delete data, replace it with blanks. If the displayed receipt identifier originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Packing Slip |
This column displays the packing slip number that you assigned to each of your selected records, as applicable. Data for this column may have been entered/edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can add new or edit existing data in this column to specify the packing slip identifier. To delete data, replace it with blanks. If the displayed packing slip originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Invoice Date |
This column displays the invoice date that you assigned to each of your selected records, as applicable. Data for this column may have been entered/edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can add new or edit existing data when you enter, or click to select, a date in this column. To delete data, replace it with blanks. If the displayed invoice date originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Invoice No |
This column displays the invoice number that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can enter new or edit existing data in this column for the invoice number. To delete data, replace it with blanks. If the displayed invoice number originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Voucher Date |
This column displays the voucher date that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can add new or edit existing data in this column when you enter, or click to select, a date. To delete data, replace it with blanks. If the displayed voucher date originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Voucher No |
This column displays the voucher number that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can enter new or edit existing data in this column to specify the voucher number. To delete data, replace it with blanks. If the displayed voucher number originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Acquisition Fiscal Year |
This column displays the acquisition fiscal year entered or defaulted in for this record. Data displayed in this column may have been edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. Assets manually entered into Manage Asset Master Information will have the Acquisition Fiscal Year, Period and Subperiod defaulted in from the Configure Posting Settings screen when you first enter the Purch Info tab of Manage Asset Master Info during asset entry. Data in this column should reflect the fiscal year that relates to the purchase (or acquisition) date for this property record, and not the current fiscal year. Although the system does not validate the fiscal year, many standard system reports use the fiscal year as one of the report selection parameters. In addition, the fiscal year is an important selection parameter when you are using Query or designing output (for example, using Impromptu). You can edit acquisition fiscal year data in this required column. If the displayed fiscal year originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Acquisition Period |
This column displays the acquisition accounting period entered or defaulted in for this record. Data displayed in this column may have been edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. Assets manually entered into Manage Asset Master Information will have the Acquisition Fiscal Year, Period and Subperiod defaulted in from the Configure Posting Settings screen when you first enter the Purch Info tab of Manage Asset Master Info during asset entry. Data in this column should reflect the accounting period that relates to the purchase (or acquisition) date for this property record, rather than the current accounting period. Although the system does not validate the accounting period, many standard system reports use the accounting period as one of the report selection parameters. In addition, the accounting period is an important selection parameter when you use Query or design output with Impromptu. You can edit acquisition accounting period data in this column. If the displayed accounting period originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Acquisition Subperiod |
This column displays the acquisition accounting subperiod entered or defaulted in for this record. Data displayed in this column may have been edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. Assets manually entered into Manage Asset Master Information will have the Acquisition Fiscal Year, Period, Subperiod defaulted in from the Configure Posting Settings screen when you first enter the Purch Info tab of Manage Asset Master Info during asset entry. Data in this column should reflect the accounting subperiod that relates to the purchase (or acquisition) date for this property record, rather than the current subperiod. Although the system does not validate the subperiod, many standard system reports use the subperiod as one of the report selection parameters. In addition, the subperiod is an important selection parameter when you use Query or design user-specific output with Impromptu. You can edit acquisition accounting subperiod data in this column. If the displayed subperiod originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Acquisition Date |
This column displays the acquisition date that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited or defaulted in on the Purch Info or Govt Info tab of the Manage Asset Master Information screen, on the Manage Asset Purchase Information screen, or on the Manage Asset Government Information screen. Assets manually entered into Manage Asset Master Information will have the current date defaulted in for the Acquisition Date when you first enter the Purch Info tab of Manage Asset Master Info during asset entry. The acquisition date displays in the Date field in the Purch Info tab and in the Acq Date field in the Govt Info tab of the Manage Asset Master Information screen. The date also displays in the corresponding columns of the Manage Asset Purchase Information and Manage Asset Government Information screens. If you have entered a date in the Date field of the Purch Info tab on the Manage Asset Master Information screen or in the Acq Date field on the Manage Asset Purchase Information screen, the data from that field displays in the Acq Date field of the Govt Info tab on the Manage Asset Master Information screen or on the Manage Asset Government Information screen, where it can also be edited. Conversely, edits to the date in the Acq Date field of the Govt Info tab on the Manage Asset Master Information screen or on the Manage Asset Government Information screen display in the Date field of the Purch Info tab on the Manage Asset Master Information screen or in the Acq Date field on the Manage Asset Purchase Information screen. You can add new or edit existing data in this column when you enter, or click to select, an acquisition date. To delete data, replace it with blanks. If the displayed acquisition date originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. Note: If you enter data in this column, you may want to develop some internal rules on its use, because there are four other optional date columns available on this screen:
PO Date,
Receipt Date,
Invoice Date, and
Voucher Date. For most users, a date entered in this column relates to the purchase of the property and is consistent with data in the
Acquisition Fiscal Year,
Acquisition Period, and
Acquisition Subperiod columns. There are also two additional date fields related to depreciation (Depr Start Date and
In-Service Date) in an Asset Master record for each book used.
This column is for data entry purposes only and is not used in system calculations for depreciation. The Depr Start Date field in the G/L Book Info tab (for Units of Usage and Years depreciation methodology) of the Manage Asset Master Information screen is the most important date field for depreciable assets, because the system uses this field when computing for depreciation. Although the system does not validate the acquisition date and there are no system rules regarding the date entered in this column, we recommend that you enter a date that relates to the acquisition of the property and is consistent with your entries in the Acquisition Fiscal Year, Acquisition Period, and Acquisition Subperiod columns. In addition, you may find that the acquisition date is an important selection parameter when you use Query or design output with Impromptu. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Vendor |
This column displays the vendor ID that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can enter,or click to select, the vendor ID in this column. To delete data, replace it with blanks. If the displayed vendor ID originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. If your entry in this column matches an established vendor already set up in the Maintain 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 be in effect only for the Asset Master record and will not be written back to the Maintain Vendors table. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Vendor Name |
This column displays the vendor name that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can enter, or click to select, the vendor name in this column. To delete data, replace it with blanks. If the displayed vendor name originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. 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 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 be in effect only for the Asset Master record and will not be written back to the Maintain Vendors table. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Manufacturer |
This column displays the manufacturer ID that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited in the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can enter, or click to select, the manufacturer ID in this column. To delete data, replace it with blanks. If the displayed manufacturer ID originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. If your entry in this column matches an established manufacturer already set up in the Manufacturers table 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 Master 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 Master record and will not be written back to the Manufacturers table. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Manufacturer Name |
This column displays the manufacturer name that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can edit, enter, or click to select, a manufacturer name in this column. To delete data, replace it with blanks. If the displayed manufacturer name originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. If your entry in this column matches an established manufacturer already set up in the Manufacturers table 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 be in effect only for the Asset Master record and will not be written back to the Manufacturer table. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Model Number |
This column displays the model number that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can enter or edit the model number in this column. To delete data, replace it with blanks. If the displayed model number originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. Also, if the model number was used in the creation or auto-generation of a UID value for the asset, changing the model number will create a disconnect between the UID value and the components of the UID. (The model number is used in UID value creation when the UID Type is UID2. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Serial Number |
This column displays the serial number that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. You can enter or edit the serial number in this column. To delete data, replace it with blanks. If the displayed serial number originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. Also, if the serial number was used in the creation or auto-generation of a UID value for the asset, changing the serial number will create a disconnect between the UID value and the components of the UID. (The serial number is used in UID value creation when the UID Type is either UID1 or UID2. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Condition |
This column displays the condition code assigned to this record. Data displayed in this column may have been edited on the Purch Info tab of the Manage Asset Master Information screen or on the Manage Asset Purchase Information screen. The options available for this required column are New or Used. You can edit this required column as desired. If the displayed condition code originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. 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. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Quantity |
This column displays the quantity data that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Cost Info tab of the Manage Asset Master Information screen or on the Manage Asset Cost Information screen. You can edit the value in this column or enter the quantity. To delete data, replace it with blanks. If the displayed quantity originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. This column serves only as a memo data column and is not used by the system for any calculations. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Unit Price |
This column displays the unit price amount that you assigned to each of your selected records, as applicable. The value in this column may have been entered or edited on the Cost Info tab of the Manage Asset Master Information screen or on the Manage Asset Cost Information screen. You can enter or edit the unit price amount in this column. To delete data, replace it with zeroes. If the displayed unit price amount originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. The system adds the value entered in this column to the value(s) entered in any other cost columns and displays the results in the G/L Book Total Cost column. Data from the G/L Book Total Cost column is used for depreciation calculations for the G/L Book. Note:
Unit Price, Sales Tax, Shipping/Handling, Transportation, and/or Other Costs associated with an Asset Master record are NOT system-required, because you may want to track property that has no cost basis. The system cannot, however, compute depreciation if the value in the G/L Book Total Cost column is equal to zero. When you first add and save an Asset Master record, the G/L Book Total Cost value for the G/L Book displays as the default total cost for all optional books used in the Other Books Info subtask of the Manage Asset Master Information screen and on the Manage Asset Other Books Information screen. You can always assign a different cost basis for each optional book (for purposes of stepped-up depreciation basis, and so on). When you manually change data on this screen for any cost element that affects the G/L Book total cost amount, including this column, you can update the total cost of the Other Book(s) whose cost matched the original cost. For details, see the documentation for the field, Update the Total Cost in All Other Books. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Sales Tax |
This column displays the sales tax amount that you assigned to each of your selected records, as applicable. The value in this column may have been entered or edited on the Cost Info tab of the Manage Asset Master Information screen or on the Manage Asset Cost Information screen. You can enter or edit the sales tax amount this column. To delete data, replace it with zeroes. If the displayed sales tax amount originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. The system adds the value entered in this column to the value(s) entered in any other cost columns, and displays the results in the G/L Book Total Cost column. Data from the G/L Book Total Cost column is used for depreciation calculations for the G/L Book. Note:
Unit Price,
Sales Tax,
Shipping/Handling,
Transportation, and/or
Other Costs associated with an Asset Master record are NOT system-required, because you may want to track property that has no cost basis. The system cannot, however, compute depreciation if the value in the
G/L Book Total Cost column is equal to zero.
When you first add and save an Asset Master record, the G/L Book Total Cost value for the G/L Book displays as the default total cost for all optional books used in the Other Books Info subtask of the Manage Asset Master Information screen and on the Manage Asset Other Books Information screen. You can always assign a different cost basis for each optional book (for purposes of stepped-up depreciation basis, and so on). When you manually change data on this screen for any cost element that affects the G/L Book total cost amount, including this column, you can update the total cost of the Other Book(s) whose cost matched the original cost. For details, see the documentation for the field, Update the Total Cost in All Other Books. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Shipping/Handling |
This column displays the shipping/handling amount that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Cost Info tab of the Manage Asset Master Information screen or on the Manage Asset Cost Information screen. You can enter or edit the shipping/handling amount in this column. To delete data, replace it with zeroes. If the displayed shipping/handling amount originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. The system adds the value entered in this column to the value(s) entered in any other cost columns, and displays the results in the G/L Book Total Cost column. Data from the G/L Book Total Cost column is used for depreciation calculations for the G/L Book. Note:
Unit Price, Sales Tax, Shipping/Handling, Transportation, and/or Other Costs associated with an Asset Master record are NOT system-required, because you may want to track property that has no cost basis. The system cannot, however, compute depreciation if the value in the G/L Book Total Cost column is equal to zero. When you first add and save an Asset Master record, the G/L Book Total Cost value for the G/L Book displays as the default total cost for all optional books used in the Other Books Info subtask of the Manage Asset Master Information screen and on the Manage Asset Other Books Information screen. You can always assign a different cost basis for each optional book (for purposes of stepped-up depreciation basis, and so on). When you manually change data on this screen for any cost element that affects the G/L Book total cost amount, including this column, you can update the total cost of the Other Book(s) whose cost matched the original cost. For details, see the documentation for the field, Update the Total Cost in All Other Books. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Transportation |
This column displays the transportation amount that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Cost Info tab of the Manage Asset Master Information screen or on the Manage Asset Cost Information screen. You can enter or edit the transportation amount in this column. To delete data, replace it with zeroes. If the displayed transportation amount originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. The system adds the value entered in this column to the value(s) entered in any other cost columns, and displays the results in the G/L Book Total Cost column. Data from the G/L Book Total Cost column is used for depreciation calculations for the G/L Book. Note:
Unit Price,
Sales Tax,
Shipping/Handling,
Transportation, and/or
Other Costs associated with an Asset Master record are NOT system-required, because you may want to track property that has no cost basis. The system cannot, however, compute depreciation if the value in the
G/L Book Total Cost column is equal to zero.
When you first add and save an Asset Master record, the G/L Book Total Cost value for the G/L Book displays as the default total cost for all optional books used in the Other Books Info subtask of the Manage Asset Master Information screen and on the Manage Asset Other Books Information screen. You can always assign a different cost basis for each optional book (for purposes of stepped-up depreciation basis, and so on.), if desired. When you manually change data on this screen for any cost element that affects the G/L Book total cost amount, including this column, you can update the total cost of the Other Book(s) whose cost matched the original cost. For details, see the documentation for the field, Update the Total Cost in All Other Books. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Other costs |
This column displays the other costs amount that you assigned to each of your selected records, as applicable. Data for this column may have been entered or edited on the Cost Info tab of the Manage Asset Master Information screen or on the Manage Asset Cost Information screen. You can enter or edit the other costs amount in this column. To delete data, replace it with zeroes. If the displayed other costs amount originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. The system adds the value entered in this column to the value(s) entered in any other cost columns, and displays the results in the G/L Book Total Cost column. Data from the G/L Book Total Cost column is used for depreciation calculations for the G/L Book. Note:
Unit Price, Sales Tax, Shipping/Handling, Transportation, and/or Other Costs associated with an Asset Master record are NOT system-required, because you may want to track property that has no cost basis. The system cannot, however, compute depreciation if the value in the G/L Book Total Cost column is equal to zero. When you first add and save an Asset Master record, the G/L Book Total Cost value for the G/L Book displays as the default total cost for all optional books used in the Other Books Info subtask of the Manage Asset Master Information screen and on the Manage Asset Other Books Information screen. You can always assign a different cost basis for each optional book, for purposes of stepped-up depreciation basis, and so on, if desired. When you manually change data on this screen for any cost element that affects the G/L Book total cost amount, including this column, you can update the total cost of the Other Book(s) whose cost matched the original cost. For details, see the documentation for the field, Update the Total Cost in All Other Books. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Total Cost |
This field is non-editable. The system automatically adds the values from each of the cost columns and displays the total in this column. If this column does not display the correct value, you can edit the applicable cost fields (Unit Price, Sales Tax, Shipping/Handling, Transportation, and/or Other Cost), as appropriate. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Update the Total Cost in All Other Books |
When you manually change data on this screen for any cost element that affects the G/L Book total cost amount, including the Unit Price, Sales Tax, Shipping/Handling, Transportation and Other Costs, you can update the total cost of the Other Book(s) whose cost matched the original cost. Select this check box to apply the resultant change in total cost to be effective for the G/L Book and in all optional other books for which the total cost matched the G/L Book before the change. This check box is disabled for Capitalize leases. If the cost in an optional book did not match the total cost in the G/L Book before the change, no change in the cost value will happen for that book when you save this screen. In this circumstance, if you want to make global changes to total cost amounts for optional books, you will need to manually change the appropriate Total Cost column for each applicable optional book. If you clear this check box, the resultant change in total cost will only be effective for the G/L Book. The value in the appropriate Total Cost column for each applicable optional book will be unchanged. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Location Group |
This column displays the location group code that you assigned to each of your selected records, as applicable. Data displayed in this column may have been edited on the Loc Info tab of the Manage Asset Master Information screen or on the Manage Asset Location Information screen. You can edit this column or 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 to enter or edit specific location information for the record on a column-by-column basis. To delete data, replace it with blanks. Note that the associated data in the City, State/Province, Postal Code, Country, or County columns will also be replaced with blanks. You can then re-run the Global Change utility on the individual City, State/Province, Postal Code, Country, or County columns, if needed. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
City |
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 edited on the Loc Info tab of the Manage Asset Master Information screen or on the Manage Asset Location Information screen, or set up as a default on the Manage Location Groups screen. You can edit this column or enter a city 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 data in the Location Group column to enable you to enter or edit specific city data for the record. If you "delete" the location group on this screen (by replacing data in the Location Group column with blanks), the associated data in the City, State/Province, Postal Code, Country, or County columns will also be replaced with blanks. You can then re-run the Global Change utility on the individual City, State/Province, Postal Code, Country, or County columns, if needed. 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 System Controls), 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. Note: This column is independent from the other location columns if you have not used a location group. If you have not used a location group, you can add data in this column without adding data in any other location-related data columns.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
State/Province |
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 edited on the Loc Info tab of the Manage Asset Master Information screen or on the Manage Asset Location Information screen, or set up as a default on the Manage Location Groups screen. You can edit this column, 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 to enable you to enter or edit specific state/province data for the record. If you "delete" the location group on this screen (by replacing data in the Location Group column with blanks), note that the associated data in the City, State/Province, Postal Code , Country, or County columns will also be replaced with blanks. You can then re-run the Global Change utility on the individual City, State/Province, Postal Code, Country, or County columns, if needed. 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 System Controls, 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 System Controls in this column. If you enter state/province data, you must also enter valid data in the Country column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Postal Code |
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 edited on the Loc Info tab of the Manage Asset Master Information screen or on the Manage Asset Location Information screen, or set up as a default on the Manage Location Groups screen. You can edit this column, enter, or click to select, a postal code 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 to enable you to 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 System Controls), 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.) If you "delete" the location group on this screen (by replacing data in the Location Group column with blanks), the associated data in the City, State/Province, Postal Code, Country, or County columns will also be replaced with blanks. You can then re-run the Global Change utility on the individual City, State/Province, Postal Code, Country, or County columns, if needed. Note: This column is independent from the other location columns if you have not used a location group. If you have not used a location group, you can add data in this column without adding data in any other location-related data columns.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Country |
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 edited on the Loc Info tab of the Manage Asset Master Information screen or on the Manage Asset Location Information screen, or set up as a default on the Manage Location Groups screen. You can edit this column, 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 to enable you to enter or edit specific state/province and country data for the record. If you "delete" the location group on this screen (by replacing data in the Location Group column with blanks), the associated data in the City, State/Province, Postal Code, Country, or County columns will also be replaced with blanks. You can then re-run the Global Change utility on the individual City, State/Province, Postal Code, Country, or County columns, if needed. Only valid country data from the Manage Countries screen in Costpoint System Controls can be entered 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 System Controls), the country associated with the postal code displays in this column and cannot be edited. Note: This column is independent from the other location data, with the exception of the
State/Province column. If you have not used a location group, you can add data in this column without adding data in any other location-related columns except for the
State/Province column. If you enter country data, you must also enter valid data in the
State/Province column.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
County |
This column displays the county data that you assigned to each of your selected records, as applicable. Data displayed in this column may have been edited on the Loc Info tab of the Manage Asset Master Information screen or on the Manage Asset Location Information screen, or 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 to enable you to enter or edit specific county data for the record. If you "delete" the location group on this screen (by replacing data in the Location Group column with blanks), the associated data in the City, State/Province, Postal Code, Country, or County columns will also be replaced with blanks. You can then re-run the Global Change utility on the individual City, State/Province, Postal Code, Country, or County columns, if needed. Note: Unlike the
City,
State/Province, and
Country columns, county data is not automatically linked with postal code information. This column is independent from the other location columns. If you have not used a location group, you can add data in this column without adding data in any other location-related data columns.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Location 1 (or your label) |
If you designated a label for Location 1 in the Location Labels for Asset Master group box of the Manage Asset Master Field Labels screen, your label description for Location 1 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 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 edited on the Loc Info tab of the Manage Asset Master Information screen or on the Manage Asset Location Information screen, or set up as a default on the Manage Location Groups screen. You can edit the data in this column, enter, or click to select, a location 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. If you "delete" the location group on this screen (by replacing data in the Location Group column with blanks), the associated data in this column will also be replaced with blanks. You can then re-run the Asset Master Global Changes utility on the individual City, State/Province, Postal Code, Country, County, Location 1, Location 2, and/or Location 3 columns, as needed. Note: This column is independent from the other location data. You can add data in this column without adding data in the
Location 2 and
Location 3 columns or in any other location-related data columns.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Location 2 (or your label) |
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 are 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 edited on the Loc Info tab of the Manage Asset Master Information screen or on the Manage Asset Location Information screen, or set up as a default on the Manage Location Groups screen. You can edit the data in this column, enter, or click to select, a location 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. If you "delete" the location group on this screen (by replacing data in the Location Group column with blanks), the associated data in this column will also be replaced with blanks. You can then re-run the Asset Master Global Changes utility on the individual City, State/Province, Postal Code, Country, County, Location 1, Location 2, and/or Location 3 columns, as needed. Note: This column is independent from the other location data. You can add data in this column without adding data in the
Location 1 and
Location 3 columns or in any other location-related data columns.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Location 3 (or your label) |
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. 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 Location 3 data that you assigned to each of your selected records, as applicable. Data displayed in this column may have been edited on the Loc Info tab of the Manage Asset Master Information screen or on the Manage Asset Location Information screen, or set up as a default on the Manage Location Groups screen. You can edit the data in this column, enter, or click to select, a location 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. If you "delete" the location group on this screen (by replacing data in the Location Group column with blanks), the associated data in this column will also be replaced with blanks. You can then re-run the Asset Master Global Changes utility on the individual City, State/Province, Postal Code, Country, County, Location 1, Location 2, and/or Location 3 columns, as needed. Note: This column is independent from the other location data. You can add data in this column without adding data in the
Location 1 and
Location 2 columns or in any other location-related data columns.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Asset Account |
This column displays the required asset account "ownership" data assigned to each of your selected records. Data displayed in this column may have been edited on the Acct Info tab of the Manage Asset Master Information screen or on the Manage Asset Account Information screen. You can edit the displayed data in this column when you enter, or click to select, a valid asset account to specify the account "ownership" for this record. If the displayed account data originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. Note: If you enter a project account abbreviation in the
Proj Acct Abbrev column, the system will populate this column with the account previously associated with the project account abbreviation.
To use this feature, you must have previously set up optional project account abbreviations codes on the Manage Project Account Groups screen in Costpoint Project Setup Controls. For additional information about this feature, please refer to the documentation for the Manage Project Account Groups screen and the related topic, Project Account Groups. When you save this screen, 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. (The system will perform additional validations regarding the Account/Organization/Project/Reference 1/Reference 2 data, as applicable, 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). |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Asset Organization |
This column displays the asset organization "ownership" data assigned to each of your selected records. Data displayed in this column may have been edited on the Acct Info tab of the Manage Asset Master Information screen or on the Manage Asset Account Information screen. You can edit the displayed data in this column when you enter, or click to select, a valid asset organization to specify the organization "ownership" for this record. If the displayed organization data originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. 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). |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Asset Project |
This column displays the optional asset project "ownership" data assigned to each of your selected records, as applicable. Data displayed in this column may have been edited on the Acct Info tab of the Manage Asset Master Information screen or on the Manage Asset Account Information screen. You can edit the displayed data in this column when you enter, or click to select, a valid asset project to specify the project "ownership" for this record. To delete data in this optional column, replace it with blanks. If the displayed project data originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. When you save this screen, 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 (such as checking that the account-organization combination linked with the project is valid) regarding the Account/Organization/ Project/ Reference 1/Reference 2 data, as applicable, may also be performed before the record can be saved). |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Proj Acct Abbrev |
This column is available if you have previously set up optional project account abbreviations codes on the Manage Project Account Groups screen in Costpoint Project Setup Controls. You can enter, or click to select, a project account abbreviation in this column. If you enter a project account abbreviation in this column, the system will populate the Asset Account column with the account previously associated with the project account abbreviation. For additional information on the setup and use of project account abbreviations, please refer to the documentation for the Manage Project Account Groups screen and the related topic, Project Account Groups. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Reference 1 (or your label) |
If you designate 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, the system-default label displays at this column. This column displays the optional asset Reference 1 "ownership" data assigned to each of your selected records, as applicable. Data displayed in this column may have been edited on the Acct Info tab of the Manage Asset Master Information screen or on the Manage Asset Account Information screen. You can edit the displayed data in this column, enter, or click to select, an asset Reference 1 number to specify the Reference 1 "ownership" for this record. To delete data in this column, replace it with blanks. If the displayed Reference 1 data originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. 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. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Reference 2 (or your label) |
If you designate 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, the system-default label displays at this column. This column displays the optional asset Reference 2 "ownership" data assigned to each of your selected records, as applicable. Data displayed in this column may have been edited on the Acct Info tab of the Manage Asset Master Information screen or on the Manage Asset Account Information screen. You can edit the displayed data in this column, enter, or click to select, an asset Reference 2 number to specify the Reference 2 "ownership" for this record. To delete data in this column, replace it with blanks. If the displayed Reference 2 data originated from autocreated data, however, you should make edits with caution to avoid compromising the integrity of the captured data. When you save this Asset Master record, 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. Note: The asset account combination specifies the General Ledger asset Account, Organization, Project, Reference 1, and Reference 2 numbers linked with the Asset Master record. The Account and Organization are always required. Project is needed when the account is project-required and must otherwise be blank Reference 1 and Reference 2 numbers are always optional. There are no special rules regarding the types of Account/Organization/Project/ Reference 1/Reference 2 combinations that can be used as an asset account.
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" of each Asset Master record. 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. Asset account combination data is frequently used 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 such as using Impromptu. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Depr Exp Acct Alloc Code |
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 for this Asset Master record. Depreciation expense account allocation codes are set up on the Manage Depreciation Expense Acct Allocation Codes screen. You must make an entry in this column for depreciable assets, and you will not be able to access this column for non-depreciable assets. This column is enabled but not required for Capitalize leases This column displays the system-validated depreciation expense account allocation code assigned to each of your selected depreciable records, as applicable. Data displayed in this column may have been edited on the Acct Info tab of the Manage Asset Master Information screen or on the Manage Asset Account Information screen. You can edit the data in this column, 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 edit this column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Accum Depr Acct Code |
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 for this Asset Master record. Accumulated depreciation account codes are set up on the Manage Accumulated Depreciation Account Codes screen. You must make an entry in this column for depreciable assets, and you will not be able to access this column for non-depreciable assets. This column is enabled but not required for Capitalize leases This column displays the system-validated accumulated depreciation account code entered for this record, if applicable. Data displayed in this column may have been edited on the Acct Info tab of the Manage Asset Master Information screen or on the Manage Asset Account Information screen. You can edit the data in this column, enter, or click to select, a code to specify 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. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Auto Calculate |
For depreciable assets, this column displays the status of this check box assigned to this record when the asset was saved on the Manage Asset Master Information screen. The value displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. Select this check box if you want this record to be included in system calculations for depreciation. If you select this check box, the system will compute depreciation for each period for eligible assets and will display the results in the Current Pd Depreciation field on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. You can always overwrite the automatic system calculation of depreciation. If this check box is selected, the system will also re-set the Current Pd Depreciation amount back to zero during the Fixed Assets period close process. Clear this check box if you want to disable the automatic system calculation of depreciation. In this circumstance, you will need to manually enter the amount of depreciation if you want to post depreciation for this record. Warning: If you disable automatic calculations for an Asset Master record when you clear this check box, the system safeguards that prevent depreciation in excess of cost no longer apply.
In general, if you need to make a one-time adjustment to current depreciation expense, you should manually override the system calculation in the G/L Book Current Pd Depreciation column rather than change the default for this check box. However, if you want to post a depreciation entry to the General Ledger as a recurring override to system calculations, you should clear this check box and enter the override amount in the G/L Book Current Pd Depreciation column. Note:
If you manually edit the system-computed G/L Book current period depreciation amount and then want to set it back to the system-calculated number, run the Compute Depreciation process again for that asset with this field selected. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Depr Method Code |
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 asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited in the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. You can edit the data in this column, enter, or click to select, a valid depreciation method code for this record. Valid depreciation method codes are set up on the Manage Depreciation Methods screen. Because depreciation calculations use the depreciation method code from this column, use caution if you change the depreciation method code for records once they have begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Depr Start Date |
This column displays the optional G/L book depreciation start date assigned to this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. You can edit, enter, or click to select, the depreciation start date for this record in this column. Even though data entry in this column is not required, this column is the most important date for depreciable assets, because the system uses this date to determine whether depreciation calculations should proceed. Depreciation calculations will not take place if this column is blank, or if this date is later than the end of the current accounting period. (The Fixed Assets "current" accounting period is specified on the Configure Posting Settings screen.) If you anticipate a depreciation start date delay due to installation or calibration requirements, for example, you can enter a future date in this column. In this circumstance, depreciation calculations will not begin until the future date coincides with your current accounting period. The date in this column must be on or before the end of the current accounting period for depreciation calculations to take place. You can enter or edit data in this column. For an existing Asset Master record, you should enter the historical date that depreciation began for this record and NOT the date that you began depreciating this record using Costpoint Fixed Assets. Because system calculations use this date to determine whether depreciation computations should take place for each record, use extreme caution if you change the depreciation start date for property records once they have begun depreciating in the system. If you enter a depreciation start date for 2/29 in a leap year, the system will display a message that informs you to use 2/28 for the Depr Start Date. The relationship between the data in this column and the values in the G/L Book Current Depr Year and G/L Book Days/Pds Remaining columns is also critical to the accurate calculation of depreciation for new records in which Depr Based On is Years. Note:
You can use the Compute/Update Depreciation Computation Data utility to assist you in verifying the relationship of the G/L Book Depr Start Date column to the G/L Book Current Depr Year and G/L Book Days/Pds Remaining columns. Using the value in the G/L Book Depr Start Date column, the system prints a report by asset/item number, by book, that includes a side-by-side comparison of both the current values displayed in the Asset Master record AND the values that the system would have computed for the G/L Book Current Depr Year and G/L Book Days/Pds Remaining columns. Although you can print this report for all selected records, you can also print the report for exceptions only, which makes discrepancies easier to identify. After the report has printed, you can select the option in this utility that applies the system-computed values to your Asset Master records. This process updates the existing data in the G/L Book Current Depr Year and G/L Book Days/Pds Remaining columns by replacing your data and writing the system-computed values to these columns. You should always carefully review and agree with the reported results on a record-by-record basis, using the Compute/Update Depreciation Computation Data utility, before performing the Update process. For additional information about this feature, please refer to the documentation for the Compute/Update Depreciation Computation Data utility. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Current Depr Year |
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, along with data in the G/L Book Days/Pds Remaining and G/L Book Depr Start Date column, plays an integral role in the system calculation of depreciation. The value in this column signifies which depreciation year of the asset's useful life is current. As a result of this data, the system can use the appropriate percentage for the current year of life from the depreciation method linked with this record. Years of useful life and percentages for each year are set up on the Manage Depreciation Methods screen. This column displays the optional G/L book current depreciation year assigned to this record, as applicable, when the asset was saved on the Manage Asset Master Information screen or when depreciation was computed. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. For a new Asset Master record, blanks normally display in this column as a default. You can leave this column blank because the system will insert 1 in this column for a new blank record the first time that depreciation is calculated for this asset. Alternately, you can manually enter the depreciation year, which should be 1 for a new record. If you enter a value in this column, however, to save the Asset Master record you must also enter a value in the G/L Book Days/Pds Remaining column. This column must be blank for the system to populate it with "1" the first time that depreciation is calculated for this record. If you have entered any number in this column or the G/L Book Days/Pds Remaining column, the system will not replace your entry during depreciation calculations. Although this column is not required, system calculations cannot take place if you have overwritten the system-populated value in this column with blanks. The reason for this is that the system cannot find the appropriate percentage to use from the Manage Depreciation Methods screen if the current depreciation year is not specified. Please refer to the related topic, Calculate Depreciation, for additional information on how to initialize this column. When initializing your historical records, you will need to enter the correct current depreciation year for each asset. If, for example, you have an asset for which you have defined a depreciation method with a useful life of five years (on the Manage Depreciation Methods screen), you should enter the current year of that life (for example, 1, 2, 3, 4, or 5). In this way, the proper depreciation percentage for the current depreciation year can be used during system calculations. Once this column is initialized for both new and historical records the system increases the value in this column when required during the appropriate Fixed Assets period close process. The current year increments during the closing process if there are additional years of useful life remaining for the record and the G/L Book Days/Pds Remaining column displays 1 (for assets using period-based depreciation), or if the number of days remaining is less than or equal to the number of days in the Fixed Assets period being closed (for assets using a Date of Purchase basis with depreciation calculated based on the number of days owned). At the same time, the value in the G/L Book Days/Pds Remaining column will also change. Note: Because manually entered data in the
G/L Book Current Depr Year and
G/L Book Days/Pds Remaining columns is especially prone to user error and misinterpretation, you can use the Compute/Update Depreciation Computation Data screen to assist you in verifying the relationship of these two data columns with the
G/L Book Depr Start Date column. This screen can be accessed from the Utilities menu. Please refer to the documentation for the Compute/Update Depreciation Computation Data screen.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Days/Pds Remaining |
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, along with the G/L Book Current Depr Year and G/L Book Depr Start Date columns, plays an integral role in the system calculation of depreciation. The value in this column indicates the number of days or periods (as appropriate to your setup on the Configure Fixed Assets Settings screen) remaining in the current depreciation year of the asset's useful life. (Years of useful life and percentages for each year are set up on the Manage Depreciation Methods screen.) The system displays the G/L book number of days/periods remaining assigned to this record, as applicable, when the asset was saved on the Manage Asset Master Information screen or when depreciation was first computed. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. For a new Asset Master record, blanks display in this column as a default. You can leave this column blank, if desired, because the system will insert the correct value in this column for a new blank record the first time that depreciation is calculated for this asset if the G/L Book Current Depr Year column is also blank. Alternately, you can manually enter the days or periods remaining in this column, if desired. If you enter a value in this column, however, you must also enter a value in the G/L Book Current Depr Year column, or you will not be able to save the Asset Master record. The value in this column will depend on the Date of Purchase or Fiscal Year basis assigned to the depreciation method for this asset.
This column must be blank for the system to populate it the first time that depreciation is calculated for this record. If you have entered any number in this column, the system will not replace your entry during depreciation calculations. Although this column is not required, system calculations cannot take place if you have overwritten the system-populated value in this column with blanks. The reason for this is that the system cannot depreciate correctly for the current period if the G/L Book Days/Pds Remaining column is not specified or is incorrect. Please refer to the related topic, Calculate Depreciation, for additional information on how to initialize this column. Once this column is initialized for both new and historical records, the system changes this value during the Fixed Assets period close process, as required. The current year increments during the closing process if there are additional years of useful life remaining for the record, and the G/L Book Days/Pds Remaining column displays 1 (for assets using period-based depreciation) or if the number of days remaining is less than or equal to the number of days in the Fixed Assets period being closed (for assets using a Date of Purchase basis with depreciation calculated based on the number of days owned). At the same time, when the value in the current year increases, the value in the G/L Book Days/Pds Remaining column will also change as appropriate for the basis used (Date of Purchase or Fiscal Year). For an existing Asset Master record, you can edit data that displays in this column. Because system calculations use this data to determine whether depreciation computations should take place for each record and the manner in which they should take place, use extreme caution if you change data in this column for property records once they have begun depreciating in the system. Note: Because manually entered data in the
G/L Book Current Depr Year and
G/L Book Days/Pds Remaining columns is especially prone to user error and misinterpretation, you can use the Compute/Update Depreciation Computation Data screen to assist you in verifying the relationship of these two data columns with the
G/L Book Depr Start Date column. You can access this screen from the Utilities menu. Please refer to the documentation for the Compute/Update Depreciation Computation Data screen.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Amt Taken Purchase YTD |
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 is active only for depreciation methods that use the Date of Purchase basis. (You must select a Date of Purchase or Fiscal Year basis on the Manage Depreciation Methods screen when you set up each depreciation method).
This column, along with data in the G/L Book Current Depr Year and the G/L Book Days/Pds Remaining columns, plays an integral role in the system calculation of depreciation for methods using the Date of Purchase basis. This column displays the G/L book amount taken purchase Year-To-Date assigned to this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. For a new Asset Master record, no data should display in this column, because there has been no historical purchase year activity. You should leave this column blank for a new record, because the system will increment (or possibly decrement) the value in this column by the cumulative amount of depreciation posted for the accounting period when you close the current Fixed Assets period. The value in this column will be different from the value in the G/L Book FYTD Depreciation column except when the date of purchase coincides with the start of your fiscal year. The G/L Book Amt Taken Purchase YTD column displays purchase year data, while the G/L Book FYTD Depreciation column displays fiscal year data. Although this column is not required, it is essential that you enter the correct value in this column when initializing your historical records because the system cannot depreciate correctly for the current period if the Amt Taken Purchase YTD column is not specified or is incorrect. Please refer to the related topic, Calculate Depreciation, for additional information on how to correctly initialize this column. For both new and historical records, the system will change the value in this column by the amount of depreciation posted when the current accounting period is closed. For an existing Asset Master record, you can edit data that displays in this column. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use caution if you change data in this column for property records once they have begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Salvage Percent |
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 record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. For a new Asset Master record, enter the salvage value percentage rate to be used in the calculation of salvage and depreciable value in this column, if applicable. 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. If you enter a salvage value percentage in this column, note that the system computes and displays the equivalent salvage value in the G/L Book Salvage Value column. Alternately, if you do not enter a percentage in this column but instead enter a salvage value amount directly in the G/L Book Salvage Value column, the system will compute and display the equivalent salvage value percentage in this column. 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 Amount 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%, then 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 or G/L Book Salvage Value columns for salvage unless this is the point at which you want the system to stop depreciation. For an existing Asset Master record, you can edit the value that displays in this column, as desired. Because system calculations use this data to determine how depreciation computations should take place for each record, use caution if you change this column for property records once they have begun depreciating in the system. Note: If you selected the
Subtract Salvage Value Before Calculation check box on the Manage Depreciation Methods screen, the system will subtract the salvage value from the cost of the asset before calculating depreciation. If this check box is clear, the system will ignore salvage value from the
G/L Book Salvage Value column when computing depreciation.
Refer to the examples below, each of which illustrates a different way in which to handle salvage value relative to the computation of depreciation based on years:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Salvage Value |
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 value amount assigned to this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. Salvage value represents the expectation of value upon the retirement of the asset. It is computed as the salvage value percentage multiplied by the asset's total cost. For a new Asset Master record, as applicable, enter the salvage value to be used in the calculation of depreciation in this column. The G/L Book Salvage Value column and the G/L Book Salvage Percent columns are reciprocal in that the entry in one column calculates and displays corresponding data in the other column. If you enter a salvage value in this column, the system computes and displays the equivalent salvage value percentage in the G/L Book Salvage Percent column. Alternately, if you do not enter a value in this column but instead enter a salvage value percentage directly in the G/L Book Salvage Percent column, the system will compute and display the equivalent salvage value in this column. Salvage value is subtracted from the value in the G/L Book Total Cost column, and the result displays in the G/L Book Amount 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%, then 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 Value or G/L Book Salvage Percent columns for salvage unless this is the point at which you want the system to stop depreciation. For an existing Asset Master record, you can edit the value that displays in this column. Because system calculations use this data to determine how depreciation computations should take place for each record, use caution if you change this column for property records once they have begun depreciating in the system. For more information on salvage calculations, please refer to the examples of salvage value calculations illustrated in the G/L Book Salvage Percent section above. Note: If you selected the
Subtract Salvage Value Before Calculation check box on the Manage Depreciation Methods screen, the system will subtract the salvage value from the cost of the asset before calculating depreciation. If this check box is not selected, the system will ignore salvage value from the
G/L Book Salvage Value column when computing depreciation.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Total Cost |
The system adds the values from each of the cost columns and displays the total in this non-editable column. Any edits to columns affecting total cost for the G/L Book must be made in the Unit Price, Sales Tax, Shipping/Handling, Transportation, and/or Other Cost column(s), as appropriate. Note:
Unit Price,
Sales Tax,
Shipping/Handling,
Transportation, and/or
Other Costs associated with an Asset Master record are NOT system-required, because you may wish to track property that has no cost basis. The system cannot, however, compute depreciation if the value in the
G/L Book Total Cost column is equal to zero.
This column displays the optional G/L book total cost amount assigned to this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Cost Info tab of the Manage Asset Master Information screen or on the Manage Asset Cost Information screen. Because system depreciation calculations use the total cost data, use caution if you change the cost for a record once it has begun depreciating in the system. Occasionally, additional asset costs are incurred after depreciation has been posted for a record (as in additional shipping costs, and so on). Alternately, returns may result in the reduction of cost after depreciation has been posted for the record. One way to record cost changes might be to adjust the appropriate cost field(s) on the Cost Info tab of the Manage Asset Master Information screen or on the Manage Asset Cost Information screen. The disadvantages to this approach are the lack of a clear audit trail and the fact that depreciation expense may not be correctly stated until the depreciation year is complete. To compensate for these disadvantages, you could add notes to create an audit trail, or create the correct "catch-up" depreciation adjustment with a manually entered depreciation expense to be posted. (If you have selected the Add to current period amount option in the System-Wide Configuration for Depreciation Calculations group box on the Configure Fixed Assets Settings screen, the system will catch up depreciation under this condition, as long as the "catch-up" period of time is within the same fiscal or purchase depreciation year). Another solution might be to add an additional item for the same asset number with the cost equal to the cost adjustment. With this methodology, the audit trail is clearly preserved. In this situation, however, the asset will consist of more than one item number, which may or may not be considered a disadvantage. How you deal with a "change-in-cost" issue depends on your company policies; it is important only that you handle these changes consistently. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Amount to Depreciate |
This non-editable column computes and displays an amount equal to the total G/L Book cost of the asset less any salvage value from the G/L Book Salvage Value column. Be certain to confirm the data in the G/L Book Salvage Percent and G/L Book Salvage Value column, because the salvage value amount is used directly by the system to compute the value in the G/L Book Amount to Depreciate column. The system will not allow depreciation in an amount greater than the value that displays in this column. As long as you enable automatic calculations for an Asset Master record by selecting the check box in the G/L Book Auto Calculate column, system safeguards that prevent depreciation in excess of amount to depreciate are in place. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book FYTD Depreciation |
This column, along with data in the G/L Book Current Depr Year and the G/L Book Days/Pds Remaining columns, plays an integral role in the system calculation of depreciation for methods using the Fiscal Year basis. (You must select a Date of Purchase or Fiscal Year basis on the Manage Depreciation Methods screen when you set up each depreciation method). This column displays the optional G/L book fiscal year to date depreciation amount for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or directly on the Manage Asset General Ledger Book Information screen. For a new Asset Master record without depreciation history, no data should display in this column, because there has been no fiscal year activity. You should leave this column blank for a new record, because the system will increment (or possibly decrement) the value in this column by the amount of depreciation posted each time the current Fixed Assets period is closed. The value in this column should always be equal to the posted depreciation expense for the current fiscal year, exclusive of the value in the G/L Book Current Pd Depreciation column. The value in this column will be different from the value in the G/L Book Amt Taken Purchase YTD column except when the date of purchase coincides with the start of your fiscal year. The G/L Book Amt Taken Purchase YTD column displays purchase year data, while the G/L Book FYTD Depreciation column displays fiscal year data. For both new and historical records that are being initialized, the system will increase or decrease the value in this column by the amount of the total depreciation posted for the period when the Fixed Assets current period is closed. Data from this column is added to the data from the G/L Book Prior FY Depreciation and G/L Book Current Pd Depreciation columns to derive the total calculated value displayed in the G/L Book Accum Depreciation column. The system will update the value in this column when you perform the Fixed Assets period close process on the last period in your fiscal year. The system will add the value in the G/L Book FYTD Depreciation column to the value in the G/L Book Prior FY Depreciation column and set the value in the G/L Book FYTD Depreciation column back to zero. Although this column is not required, it is essential that you enter the correct value in this column during the initialization of your historical records because the system cannot depreciate correctly for the current period if the value in the G/L Book FYTD Depreciation column is not specified or is incorrect. Please refer to the related topic, Calculate Depreciation, for additional information on how to correctly initialize this column. For an existing Asset Master record, you can edit data that displays in this column, if needed. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use caution if you change data in this column for Asset Master records once they have begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Prior FY Depreciation |
This column, along with data in the G/L Book Current Depr Year and the G/L Book Days/Pds Remaining columns, plays an integral role in the system calculation of depreciation for methods using the Fiscal Year basis. (You must select a Date of Purchase or Fiscal Year) basis on the Manage Depreciation Methods screen when you set up each depreciation method). For an existing asset, this column displays the optional G/L book cumulative depreciation amount for all prior fiscal years entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. The value in this column should reflect cumulatively the total posted depreciation expense for all past fiscal years, and should not include the current fiscal year amount. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or directly on the Manage Asset General Ledger Book Information screen. For a new Asset Master record without depreciation history, no data should display in this column, because there has been no prior fiscal year activity. The value in this column should always be equal to the cumulative posted depreciation expense for all prior fiscal years, exclusive of the value in the G/L Book Current Pd Depreciation column. The system will update the value in this column when you perform the Fixed Assets period close process on the last period in your fiscal year. The system will add the value in the G/L Book FYTD Depreciation column to the value in the G/L Book Prior FY Depreciation column, and will set the G/L Book FYTD Depreciation column back to zero. For both new and historical records, the system adds data from this column to the data from the G/L Book FYTD Depreciation and G/L Book Current Pd Depreciation columns to derive the G/L Book Accum Depreciation column calculated total. Although this column is not required, it is essential that you enter the correct value in this column during the initialization of your historical records because the system cannot depreciate correctly for the current period if the value in the G/L Book FYTD Depreciation column is not specified or is incorrect. Please refer to the related topic, Calculate Depreciation, for additional information on how to correctly initialize this column. For an existing Asset Master record, you can edit data that displays in this column, if needed. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use caution if you change the value in this column for Asset Master records once they have begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Annual Depreciation |
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, along with data in the G/L Book Current Depr Year and the G/L Book Days/Pds Remaining columns, plays an integral role in the system calculation of depreciation (for both Date of Purchase and Fiscal Year basis methods). You should leave this column blank for a new Asset Master record, unless you want to overwrite the system calculation of annual depreciation and you clear the G/L Book Auto Calculate check box. This column displays the G/L book annual depreciation associated with this record, if it was manually entered when the asset was saved on the Manage Asset Master Information screen or is the result of depreciation calculations. Data displayed in this column may also have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. The system populates this column when you calculate depreciation for this record, if the G/L Book Auto Calculate check box has been selected and the date in the G/L Book Depr Start Date column is not a future date (later than the end of the current period). Manual entries are always permitted in this column, regardless of the status of the G/L Book Auto Calculate check box and the date in the G/L Book Depr Start Date column. However, enter all manual overwrites with caution. The timing of any manual entries to this column are especially important; if the G/L Book Auto Calculate check box is selected, any manual edits to the G/L Book Annual Depreciation column will be overwritten by the system when you compute depreciation. For both new and historical records, the system uses the data from this column when calculating depreciation. Depreciation calculations can be performed multiple times within the same accounting period. If you have not manually corrected any critical columns (such as asset cost, annual depreciation, current depreciation year, periods remaining, and so on), there is no danger that the system will calculate a different annual depreciation value for the same asset in the same accounting period. Annual depreciation is computed based on total cost (or cost minus salvage value) times the depreciation percentage (from the depreciation method assigned to the asset) for the year specified in the G/L Book Current Depr Year column. The system does not re-set the value in this column to zero during the period close process. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Current Pd Depreciation |
You should leave this column blank for a new Asset Master record, unless you want to overwrite the system calculation of annual depreciation. For a new Asset Master record, blanks normally display in this column. If you have cleared the G/L Book Auto Calculate check box and you manually entered a value in this column last period, this column should still display the manually entered value. Leave this column blank for a new record unless you want to overwrite the system calculation of depreciation for the period. Note: If you manually change the current depreciation expense and then wish to set it back to the system-calculated number, run the Compute Depreciation process again for that asset.
This column will be populated by the system when you calculate depreciation for this record, if the G/L Book Auto Calculate check box has been selected and the date in the G/L Book Depr Start Date column is not a future date (later than the end of the current period). (The "current" Fixed Assets period is specified on the Configure Posting Settings screen). Manual entries and edits are always permitted in this column, regardless of the status of the G/L Book Auto Calculate check box and the date in the G/L Book Depr Start Date column. You should enter all manual entries and overwrites with caution. For both new and historical records, the system adds the value in this column to the data in the G/L Book FYTD Depreciation and G/L Book Prior FY Depreciation columns to derive the G/L Book Accum Depreciation column calculated total value. When you close the current accounting period, the system sets the value in this column back to zero unless you have cleared the G/L Book Auto Calculate check box. You can perform depreciation calculations multiple times within the same Fixed Assets period. If you have not manually corrected any critical columns (such as asset cost, annual depreciation, current depreciation year, periods remaining, and so on), there is no danger that the system will post the same depreciation expense for the same asset in the same Fixed Assets period after depreciation is re-calculated. The system tracks monthly postings for each record and compares the value in the G/L Book Current Pd Depreciation column with the value in the G/L Book Amount Posted Curr Pd column. If the values in these columns are equal, there can be no additional postings to the G/L for the period. Only changes to the G/L Book Current Pd Depreciation column can generate additional depreciation expense entries if additional postings are performed for the current Fixed Assets period. Note: Changes can take place by means of manual overwrites in this column or as a result of depreciation calculations performed after changes have been made to other critical columns.
As long as the value in the G/L Book Current Pd Depreciation column is different than the value in the G/L Book Amount Posted Curr Pd column, the system will, within the same Fixed Assets period, always post the value needed to bring the G/L Book Amount Posted Curr Pd column up to or down to the value in the G/L Book Current Pd Depreciation column. For example, if you have calculated depreciation and the G/L Book Current Pd Depreciation column displays $50.00, the value in the G/L Book Amount Posted Curr Pd will also display $50.00 after posting to the General Ledger. If you now change the amount in the G/L Book Current Pd Depreciation column to $75.00 and post again within the same Fixed Assets period, the system will recognize that an additional $25.00 is needed to make these columns equal, and will post $25.00 more. After this second posting, the amounts in the G/L Book Current Pd Depreciation column and the G/L Book Amount Posted Curr Pd will be equal. When the accounting period is closed, the system will add the amount displayed in the G/L Book Amount Posted Curr Pd column to the amount in the G/L Book FYTD Depreciation column and will set the value in the G/L Book Amount Posted Curr Pd column back to zero. The value in this column will be posted to the depreciation expense account(s) set up in the Code field in the Accumulated Depreciation Account group box on the Acct Info tab of the Manage Asset Master Information screen or directly in the Depr Expense Acct Alloc Code field on the Manage Asset Account Information screen. Current period depreciation expense is computed as a result of the Date of Purchase or Fiscal Year basis assigned to each depreciation method (established on the Manage Depreciation Methods screen). Depreciation Calculations When Depr/Lease Based On is Years The basic methodology for depreciation calculations in which the "catch-up" amount is to be spread among remaining periods is as follows:
Note: Actual depreciation calculations may be more complex than the simplified explanation above, because you may have used "catch-up" in current period methodology depreciation calculations or computed depreciation on a "days" basis.
For additional information on depreciation calculations, please refer to the related topic, Calculate Depreciation. In the following simplified example, consider the basic differences in current period depreciation calculations for a $ 9,000 asset, useful life of five years, no salvage value, using straight-line depreciation, for both the Fiscal Year and Date of Purchase basis. For this example, the current fiscal year is CY 2003, the current Fixed Assets accounting period is 10, the number of accounting periods in the fiscal year is 12, and the start date is 10-01-03.
The computed annual depreciation expense is identical for both the DP and FY basis in the example above. The current period depreciation expense, however, is different. If the Date of Purchase basis for depreciation is being used, the annual depreciation expense of $1,800 is divided by the number of accounting periods remaining in the purchase year (12). One period of expense is charged for the current period, irrespective of the fiscal year. The depreciation year begins at the date in the G/L Book Depr Start Date column (10-01-2003). If the Fiscal Year basis for depreciation is being used, the annual depreciation expense of $1,800 is divided by the number of accounting periods remaining in the fiscal year. In the example above, there are only three accounting periods remaining in the fiscal year over which to spread the annual depreciation cost of $1,800. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Accum Depreciation |
The system totals the values from the G/L Book FYTD Depreciation, G/L Book Prior FY Depreciation, and G/L Book Current Pd Depreciation columns and displays the result in this column, where it cannot be changed. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Book Value |
The system subtracts the value in the G/L Book Accum Depreciation column from the value in the G/L Book Amount to Depreciate column and displays the result in this column, where it cannot be changed. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Amount Posted Curr Pd |
For all records, both new and historical, zeroes display in this non-editable column at the beginning of each accounting period. The system populates this column when you post depreciation for the first time in the accounting period. Subsequent postings of depreciation expense within the same accounting period for this record will increment or decrement the value in this column, because it displays the cumulative results of all postings for the accounting period. When you close the current Fixed Assets accounting period, the value in this column will be set back to zero. Depreciation calculations can be performed multiple times within the same Fixed Assets accounting period. If you have made no manual corrections to critical columns (such as asset cost, annual depreciation, current depreciation year, periods remaining, and so on), there is no danger that the system will post the same depreciation expense for the same asset in the same Fixed Assets accounting period after depreciation is re-calculated. The system tracks monthly postings for each record and compares the value in the G/L Book Current Pd Depreciation column with the value in the G/L Book Amount Posted Curr Pd column. If the values in these columns are equal, there can be no additional postings to the G/L for the period. Only subsequent changes to the G/L Book Current Pd Depreciation column can generate additional depreciation expense entries. Note: Changes can take place by means of manual overwrites in the
G/L Book Current Pd Depreciation column or as a result of depreciation calculations performed after changes have been made to critical columns.
As long as the value in the G/L Book Current Pd Depreciation column is different than the value in the G/L Book Amount Posted Curr Pd column, the system will, within the same Fixed Assets accounting period, always post the value needed to bring the amount in the G/L Book Amount Posted Curr Pd column up to or down to the value in the G/L Book Current Pd Depreciation column. For example, if you have calculated depreciation and the G/L Book Current Pd Depreciation column displays $50.00, the amount in the G/L Book Amount Posted Curr Pd column will also display $50.00 after you post to the General Ledger. If you now change the amount in the G/L Book Current Pd Depreciation column to $75.00 and post again within the same Fixed Assets accounting period, the system will recognize that an additional $25.00 is needed to make these columns equal and will post $25.00 more. After this second posting, the amounts in the G/L Book Current Pd Depreciation column and the G/L Book Amount Posted Curr Pd will be equal. When the current Fixed Assets accounting period is closed, the amount displayed in the G/L Book Amount Posted Curr Pd column will be added to the amount in the G/L Book FYTD Depreciation column and the G/L Book Amount Posted Curr Pd column will be set back to zero. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Units of Useful Life |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Units of Usage. The column is not available for user entry 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 asset was saved on the Manage Asset Master Information screen. Data displayed in the G/L Book Units of Useful Life column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. For a new Asset Master record, enter up to nine numeric characters in this system-required column to indicate the estimated units of useful life (such as hours or miles) for this asset. This column is similar to the Total Cost column on the G/L Book Info tab, in that it defines the maximum number of units beyond which the system should not calculate depreciation. Although you do not need an entry in this column to save the record under most circumstances, the system cannot compute depreciation based on units when this data is missing. If the G/L Book Auto Calculate check box is selected, this field is required. For units of usage depreciation, the system also uses the value in the G/L Book Amt to Depreciate column as a limiter. The system will not depreciate an amount that is greater than the amount in the G/L Book Amt to Depreciate column OR will not permit usage entries that would create a value in the G/L Book Total Units Used column that is greater than the estimated units of useful life. For an existing Asset Master record, you can edit the value that displays in this column. If you have underestimated (or overestimated) the estimated units of useful life in this column, you can manually edit this column, if necessary. Because system calculations use this column to determine the total limit to depreciation expense, use caution if you change this column for an asset once it has begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Units of Measure |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Units of Usage. The column is not available for user entry if the value in the Depr/Lease Based On column is Years or Lease Pds. This column displays the optional unit of measure description assigned to this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Leger Book Information screen. For a new Asset Master record, 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. For an existing Asset Master record, you can edit the value that displays in this column, as desired. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Depr Rate Per Unit |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Units of Usage. The column is not available for user entry 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 asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. For a new Asset Master record, enter the depreciation rate per unit of usage in this optional column. Although this column is not required, depreciation calculations cannot take place if you do not enter a value in this column. The system multiples the value from this column times the value in the G/L Book Current Units Used column to derive the value in the G/L Book Current Pd Depreciation column. For an existing Asset Master record, you can edit the value that displays in this column. If the G/L Book Auto Calculate check box is selected, this field is required. Because system calculations use this column to determine current period depreciation expense, use caution if you change this column for an asset once it has begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Prior Units Used |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Units of Usage. The column is not available for user entry if the value in the Depr/Lease Based On column is Years or Lease Pds. This column displays the prior units used data entered for this record, as applicable, when the asset was first saved on the Manage Asset Master Information screen. Data displayed in the G/L Book Prior Units Used column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. You should leave this column blank for a new record. This column will be updated during the accounting period close process, in which the value in the G/L Book Current Units Used column will be added to the value in the G/L Book Prior Units Used column, and the G/L Book Current Units Used column will be set back to zero. When initializing your historical records, you should manually enter the correct value in this column. Although you do not need an entry in this column to save the record, depreciation calculations based on units may be incorrect if the historical data is missing or is incorrect. For an existing Asset Master record, you can edit data that displays in this column. Because system depreciation calculations use this data, however, use caution if you change this column for an asset once it has begun depreciating in the system. For both new and historical records, data from this column is added by the system to the data from the G/L Book Current Units Used column to derive the calculated value for the G/L Book Total Units Used column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Current Units Used |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Units of Usage. The column is not available for user entry if the value in the Depr/Lease Based On column is Years or Lease Pds. This column displays the current units used entered for this record for the current period, as applicable. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. In order for system depreciation calculations to take place for units-based assets, you must enter the number of units used in the current accounting period. (The system computes current period depreciation by multiplying the value from this column times the value in the G/L Book Depr Rate Per Unit column to derive the value in the G/L Book Current Pd Depreciation column). This column will be updated during the accounting period close process, in which the system will add the value in the G/L Book Current Units Used column to the value in the G/L Book Prior Units Used column, and will set the G/L Book Current Units Used column back to zero, unless the G/L Book Auto Calculate check box is not selected. The system adds the data in this column to the data from the G/L Book Current Units Used column to derive the G/L Book Total Units Used column calculated total. For an existing Asset Master record, you can edit data that displays in this column. Because system depreciation calculations use this data, always use caution if you change this column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Total Units Used |
This column is applicable only if the value in the Depr/Lease Based On column is Units of Usage. The column is not available for user entry if the value in the Depr/Lease Based On column is Years or Lease Pds. The system totals the values from the G/L Book Prior Units Used and G/L Book Current Units Used columns and displays the results in this column, where it cannot be edited. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Capitalized Lease |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Lease Pds. The column is not available for user entry if the value in the Depr/Lease Based On column is Years or Units of Usage. This column displays the check box selection, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book 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. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Lease Start Date |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Lease Pds. The column is not available for user entry if the value in the Depr/Lease Based On column is Years or Units of Usage. This column displays the lease start date, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. The value in this column is for data purposes only and is not used in system calculations. (When the system calculates amortization, the system checks only the date from the G/L Book Depr Start Date column.) The date in this column can be a historical, current, or future date. For a new or existing Asset Master record, you can edit, enter, or click to select, the lease start date for this record. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Lease End Date |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Lease Pds. The column is not available for user entry if the value in the Depr/Lease Based On column is Years or Units of Usage. This column displays the optional lease end date, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book 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 a historical, current, or future date. For a new or existing Asset Master record, you can edit, enter, or click to select, the lease end date for this record. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Total Lease Value |
The system uses the value from the Total Cost column and automatically displays this value in both the non-editable columns G/L Book Total Lease Value and G/L Book Amount to Depreciate . The value in this column is for data purposes only and is not used in system calculations. The system uses the value from the G/L Book Amount to Depreciate column for depreciation calculations. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Total No Lease Payments |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Lease Pds. The column is not available for user entry if the value in the Depr/Lease Based On column is Years or Units of Usage. This column displays the optional total number of lease payments entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. The value in this column is for information purposes only and is not used in system calculations. (The system uses the value from the G/L Book Lease Periods Remaining column to determine over which how many more accounting periods this property should be amortized.) |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Monthly Lease Payment Amount |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Lease Pds. The column is not available for user entry if the value in the Depr/Lease Based On column is Years or Units of Usage. This column displays the monthly payment entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. For a new Asset Master record, enter the amount of the monthly lease payment in this column. If the G/L Book Auto Calculate check box is selected and the asset's book value on this screen does not equal zero, this column and the G/L Book Lease Periods Remaining column are required. Although this column is not required (except in the instance above), note that amortization calculations will not take place for this record if this column is blank. Note:
The system does not compute a value for this column (by dividing the total lease value or the amount to amortize by the total number of payments) because of inherent rounding problems and changing lease conditions. You must manually enter a value in this column, which will display in the G/L Book Current Pd Depreciation column after depreciation is calculated for the current period. You should edit this column whenever the monthly payment changes so the system will use the correct value for future amortization. For an existing Asset Master record, you can edit the value that displays in this column. Because the system copies the data from this column to the G/L Book Current Pd Depreciation column value after amortization is computed, however, you should use caution if you change the monthly payment for a record once it has begun amortization in the system. There may be instances in which the lease payment changes. In this circumstance, the revised lease payment should be recorded in this column for the first month in which it is effective, before amortization calculations take place. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Lease Period Remaining |
This column is available for user entry or edits only if the value in the Depr/Lease Based On column is Lease Pds. The column is not available for user entry if the value in the Depr/Lease Based On column is Years or Units of Usage. This column displays the optional number of lease payments remaining that were entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the G/L Book Info tab of the Manage Asset Master Information screen or on the Manage Asset General Ledger Book Information screen. The system uses the value from this column to determine over which how many more accounting periods this property should be amortized. Although this column is required only if the G/L Book Auto Calculate check box is selected, amortization calculations will not take place if this column is blank. For a new Asset Master record, enter the total number of lease payments remaining in this column. For an existing Asset Master record, you can edit data that displays in this column, if needed. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use caution if you change this column for a record once amortization has begun in the system. Once this column is initialized, the system decreases the value in this column by one during each Fixed Assets accounting period close process. If the G/L Book Auto Calculate check box is selected, this column and the G/L Book Monthly Lease Payment Amount column are required. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Lease Liability |
This Column displays the lease liability for this record. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Commencement Start Date |
This column displays the commencement start date for this record. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book First Payment Date |
This column displays the first payment date for this record. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Interest Rate | This column displays the interest rate for this record. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Auto Calc Depr |
The system displays the check box status assigned to this record for this book, if applicable, when the asset was first saved on the Manage Asset Master Information screen. The check box status displayed in this column may have been edited on the Other Books Info subtask of the Manage Asset Master Information screen or on the Manage Asset Other Books Information screen. Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
Select this check box if you want this record to be included in system calculations of depreciation. If you select this check box, the system will compute depreciation each period for eligible assets and will display the results in the Book 2 (or your label) Current Pd Depreciation column on this screen. You can always overwrite the automatic system calculation of depreciation. If you select this check box, the system will also re-set the Book 2 (or your label) Current Pd Depreciation column back to zero during the Fixed Assets period close process. Clear this check box if you want to disable the automatic system calculation of depreciation. In this circumstance, you will need to manually enter the amount of depreciation in the Book 2 (or your label) Current Pd Depreciation column for this record. Warning: If you disable automatic calculations for an Asset Master record (when you clear this check box), the system safeguards that prevent depreciation in excess of cost no longer apply.
Usually, if you need to make a one-time adjustment to current depreciation expense, you should manually override the system calculation in the Book 2 (or your label) Current Pd Depreciation column rather than change the default for this check box. If, however, you want to use the manually entered depreciation amount as a recurring override to system calculations, you should clear this box and enter the override amount in the Book 2 (or your label) Current Pd Depreciation column. Note:
If you manually edit the system-computed value in the Book 2 (or your label) Current Pd Depreciation column and then need to set it back to the system-calculated number, run the Compute Depreciation process again for that asset. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Depr Method Code |
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 record for this book, if applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited in the Other Books Info subtask of the Manage Asset Master Information screen or on the Manage Asset Other Books Information screen. Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
You can edit this column or enter a depreciation method code for this record. Valid depreciation method codes are set up on the Manage Depreciation Methods screen. For an existing Asset Master record, you can edit the depreciation method cod1e that displays in this field. Because depreciation calculations use the depreciation method code from this field, use caution if you change the depreciation method code for records once they have begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Depr Start Date |
This column displays the depreciation start date assigned to this record for this book, if applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Other Books Info subtask of the Manage Asset Master Information screen or on the Manage Asset Other Books Information screen. Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
For a new Asset Master record, edit, enter, or click to select, the depreciation start date for this record in this column. Even though data entry in this column is not required, this column is the most important date for depreciable assets, because the system uses this date when computing depreciation. Depreciation calculations will not take place if this column is blank, or if this date is later than the end of the current accounting period. (The Fixed Assets "current" accounting period is specified on the Configure Posting Settings screen). If you anticipate a depreciation start date delay due to installation or calibration requirements, for example, you can enter a future date in this column. In this circumstance, depreciation calculations will not begin until the future date coincides with your current accounting period. The date in this column must be on or before the end of the current accounting period for depreciation calculations to take place. For an existing Asset Master record, you can enter or edit in this column. You should enter the historical date that depreciation began for this record and NOT the date that you began depreciating this record using Costpoint Fixed Assets. Because system calculations use this date to determine if depreciation computations should take place for each record, use extreme caution if you change the depreciation start date for property records once they have begun depreciating in the system. The relationship between the data in this column and the values in the Book 2 (or your label) Curr Depr Yr and Book 2 (or your label) Days/Pds Remaining columns is critical to the accurate calculation of depreciation for new records in which depreciation basis is Years. Note: You can use the Compute/Update Depreciation Computation Data utility to assist you in verifying the relationship of the
Book 2 (or your label) Depr Start Date column to the
Book 2 (or your label) Curr Depr Yr and
Book 2 (or your label) Days/Pds Remaining columns.
Using the value in the Book 2 (or your label) Depr Start Date column, the system prints a report by asset/item number, by book, that includes a side-by-side comparison of both the current values displayed in the Asset Master record AND the values that the system would have computed for the Book 2 (or your label) Curr Depr Yr and Book 2 (or your label) Days/Pds Remaining columns. Although you can print this report for all selected records, you can also print the report for exceptions only, which makes discrepancies easier to identify. After the report has printed, you can select the option in this utility that applies the system-computed values to your Asset Master records. This process updates the existing data in the Book 2 (or your label) Curr Depr Yr and Book 2 (or your label) Days/Pds Remaining columns by replacing your data and writing the system-computed values to these columns. You should always carefully review and agree with the reported results on a record-by-record basis, using the Compute/Update Depreciation Computation Data utility, before performing the Update process. For additional information about this feature, please refer to the specific documentation on the Compute/Update Depreciation Computation Data utility. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Curr Depr Yr |
This column displays the current depreciation year assigned to this record for this book, as applicable, when the asset was saved on the Manage Asset Master Information screen (or when depreciation was first computed for the record). Data displayed in this column may have been edited in the Other Books Info subtask of the Manage Asset Master Information screen or on the Manage Asset Other Books Information screen. Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen
This column, along with data in the Book 2 (or your label) Days/Pds Remaining and Book 2 (or your label) Depr Start Date column, plays an integral role in the system calculation of depreciation. The value in this column signifies which depreciation year of the asset's useful life is current. With this data, the system can use the appropriate percentage for the current year of life from the depreciation method linked with this record. (Years of useful life and percentages for each year are set up on the Manage Depreciation Methods screen.) For a new Asset Master record, blanks normally display in this column as a default. You can leave this column blank because the system will insert 1 in this column for a new blank record the first time that depreciation is calculated for this asset. Alternately, you can manually enter the depreciation year, which should be 1 for a new record. If you enter a value in this column, the Book 2 (or your label) Days/Pds Remaining column is required. This column must be blank for the system to populate it with 1 the first time that depreciation is calculated for this record. If you have entered any number in this column, the system will not replace your entry during depreciation calculations. Although you do not need to make an entry in this column to save a record. If you have overwritten the system-populated value in this column with blanks, system calculations cannot take place. The reason for this is that the system cannot find the appropriate percentage to use from the Manage Depreciation Methods screen if the current depreciation year is not specified. During the initialization of your historical records, you will need to enter the correct current depreciation year for each asset. If, for example, you have an asset for which you have defined a depreciation method with a useful life of five years (the Manage Depreciation Methods screen), you should enter the current year of that life (for example, 1, 2, 3, 4, or 5). In this way, the proper depreciation percentage for the current depreciation year can be used during system calculations. For both new and historical records, once this column is initialized, the system increases the value in this column when required during the appropriate Fixed Assets period close process. The current year increments during the closing process if there are additional years of useful life remaining for the record, and the Book 2 (or your label) Days/Pds Remaining column displays 1 (for assets using period-based depreciation) or if the number of days remaining is less than or equal to the number of days in the Fixed Assets period being closed (for assets using a Date of Purchase basis with depreciation calculated based on the number of days owned). At the same time, the value in the Book 2 (or your label) Days/Pds Remaining column will also change. For an existing Asset Master record, you can edit data that displays in this column. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use extreme caution if you change the current depreciation year for property records once they have begun depreciating in the system. Note: Because manually entered data in the
Book 2 (or your label) Curr Depr Yr and
Book 2 (or your label) Days/Pds Remaining columns is especially prone to user error and misinterpretation, you can use the Compute/Update Depreciation Computation Data screen to assist you in verifying the relationship of these two data columns with the
Book 2 (or your label) Depr Start Date column. The Compute/Update Depreciation Computation Data screen can be accessed from the Fixed Assets Utilities menu. You can run it for one asset/item number, a range of asset/item numbers, or all asset/item numbers.
The utility produces a report, based on the depreciation start date, which shows a side-by-side comparison of both the current values displayed in the Asset Master and the system-computed values for the Book 2 (or your label) Curr Depr Yr and Book 2 (or your label) Days/Pds Remaining columns. You can print the report for all selected records or for exceptions only, which makes discrepancies easier to identify. After the report has printed, you can select the option in this utility that applies the system-computed values to your Asset Master records. This process updates the existing data in the Book 2 (or your label) Curr Depr Yr and Book 2 (or your label) Days/Pds Remaining columns by replacing the existing data with the system-computed values. If you do not apply the system-computed values to your data, you may need to manually adjust some values in the Book 2 (or your label) Curr Depr Yr and Book 2 (or your label) Days/Pds Remaining columns (or, in some cases, the Book 2 (or your label) Depr Start Date column) to ensure the accuracy of depreciation calculations. Because the Update portion of this utility will overwrite your existing data with system-generated data, you should always carefully review and agree with the reported results on a record-by-record basis before performing the Update process. The Update process is similar to posting routines in that the report must first be printed before you can proceed with the Update process. Never run the Update process as a matter of routine unless you are in agreement with the system data changes that will take place in each Asset Master record. Please refer to documentation for the Compute/Update Depreciation Computation Data screen. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Days/Pds Remaining |
This column displays the number of days/periods remaining assigned to this record for this book, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited in the Other Books Info subtask of the Manage Asset Master Information screen or on the Manage Asset Other Books Information screen. Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
This column, along with the Book 2 (or your label) Curr Depr Yr and Book 2 (or your label) Depr Start Date columns, plays an integral role in the system calculation of depreciation. The value in this column indicates the number of days or periods remaining in the current depreciation year of the asset's useful life. (Years of useful life and percentages for each year are set up on the Manage Depreciation Methods screen). For a new Asset Master record, blanks display in this column as a default. You can leave this column blank because the system will insert the correct value in this column for a new blank record the first time that depreciation is calculated for this asset. Alternately, you can manually enter the days or periods remaining in this column. If you enter a value in this column, the Book 2 (or your label) Curr Depr Yr column is required. The value in this column will depend on the Date of Purchase or Fiscal Year basis assigned to the depreciation method for this asset.
This column must be blank for the system to populate it the first time that depreciation is calculated for this record. If you have entered any number in this column, the system will not replace your entry during depreciation calculations. Although this column is not required, system calculations cannot take place if you have overwritten the system-populated value in this column with blanks. The reason for this is that the system cannot depreciate correctly for the current period if the Book 2 (or your label) Days/Pds Remaining column is not specified. During the initialization of your historical records, you will need to enter the correct days/periods remaining for each asset, as applicable. For both new and historical records, once this column is initialized, the system changes this value, as required, during the Fixed Assets period close process. The current year increments during the closing process if there are additional years of useful life remaining for the record, and the Book 2 (or your label) Days/Pds Remaining column displays 1 (for assets using period-based depreciation) or if the number of days remaining is less than or equal to the number of days in the Fixed Assets period being closed (for assets using a Date of Purchase basis with depreciation calculated based on the number of days owned). At the same time, when the value in the current year increases, the value in the Book 2 (or your label) Days/Pds Remaining column will also change for the basis used (DP or FY). For an existing Asset Master record, you can edit data that displays in this column. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use extreme caution if you change data in this column for property records once they have begun depreciating in the system. Note: Because manually entered data in the
Book 2 (or your label) Curr Depr Yr and
Book 2 (or your label) Days/Pds Remaining columns is especially prone to user error and misinterpretation, you can use the Compute/Update Depreciation Computation Data screen to assist you in verifying the relationship of these two data columns with the Compute/Update Depreciation Computation Data column. You can access this screen from the Fixed Assets Utilities menu. Please refer to the documentation for the Compute/Update Depreciation Computation Data screen.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Amt Taken Purchase YTD |
This column, along with data in the Book 2 (or your label) Curr Depr Yr and the Book 2 (or your label) Pds Remaining columns, plays an integral role in the system calculation of depreciation for methods using the Date of Purchase basis. Note:
The column header displays the name for this book as established in the Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the Books Setup group box of the Configure Fixed Assets Settings screen. The system displays the amount taken purchase YTD assigned to this record for this book, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited in the Other Books Info subtask of the Manage Asset Master Information screen or on the Manage Asset Other Books Information screen. This column is active only for depreciation methods that use the Date of Purchase basis. (You must select a Date of Purchase or Fiscal Year basis on the Manage Depreciation Methods screen when you set up each depreciation method).
For a new Asset Master record, no data should display in this column, because there has been no historical purchase year activity. You should leave this column blank for a new record, because the system will increment (or possibly decrement) the value in this column by the amount of depreciation posted each time the current Fixed Assets period is closed. The value in this column will be different from the value in the Book 2 (or your label) FYTD Depreciation column except when the date of purchase coincides with the start of your fiscal year. The Book 2 (or your label) Amt Taken Purchase YTD column displays purchase year data, while the Book 2 (or your label) FYTD Depreciation column displays fiscal year data. During the initialization of your historical records, for records linked to depreciation methods that use a Date of Purchase basis for depreciation, you should enter the correct value in this column for the current purchase year of the asset. Please refer to the related topic, Calculate Depreciation, for additional information on how to initialize this column. For both new and historical records, the system will change the value in this column by the amount of depreciation posted when the current accounting period is closed. For an existing Asset Master record, you can edit data that displays in this column. Because system calculations use this data to determine whether depreciation computations should take place for each record (as well as the amount to depreciate) and the manner in which they should take place, use caution if you change data in this column for property records once they have begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Salvage Percent |
This column displays the optional salvage percent assigned to this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited in the Other Books Info subtask of the Manage Asset Master Information screen or on the Manage Asset Other Books Information screen. Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
For a new Asset Master record, enter the salvage value percentage rate to be used in the calculation of salvage and depreciable value in this optional column. 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. Alternately, if you do not enter a percentage in this column but instead enter a salvage value amount directly in the Book 2 (or your label) Salvage Value column, the system will compute and display the equivalent salvage value percentage in this column. The Book 2 (or your label) Salvage Percent and the Book 2 (or your label) Salvage Value columns are reciprocal in that the entry in one column calculates and displays the data in the other column. The system subtracts data from the Book 2 (or your label) Salvage Value column from the Book 2 (or your label) Total Cost column and displays the result 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) Book Salvage Value columns for salvage unless this is the point at which you want the system to stop depreciation. For an existing Asset Master record, you can edit the value that displays in this column. 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. Note: If you select the
Subtract Salvage Value Before Calculation check box on the Manage Depreciation Methods screen, the system will subtract the salvage value from the cost of the asset before performing depreciation calculations. If this check box is clear, the system will ignore salvage value from the
Book 2 (or your label) Salvage Value column when computing depreciation.
Refer to the specific examples below, each of which illustrates a different way in which to handle salvage value relative to the computation of depreciation based on years:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Salvage Value |
This column displays the optional salvage value amount assigned to this record for this book, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited in the Other Books Info subtask of the Manage Asset Master Information screen or on the Manage Asset Other Books Information screen. Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
Salvage value represents the expectation of value upon the retirement of the asset. It is computed as the salvage value percentage multiplied by the asset's total cost. For a new Asset Master record, as applicable, enter the salvage value to be used in the calculation of depreciation in this optional column. If you enter a salvage value in this column, the system computes and displays the equivalent salvage value percentage in the Book 2 (or your label) Salvage Percent column. Alternately, if you do not enter a value in this column but instead enter a salvage percentage directly in the Book 2 (or your label) Salvage Percent column, the system will compute and display the equivalent salvage value in this column. The Book 2 (or your label) Salvage Value column and the Book 2 (or your label) Salvage Percent columns are reciprocal in that the entry in one column calculates and displays the data in the other column. The system subtracts the salvage value from the value in the Book 2 (or your label) Total Cost column, and displays the result in the Book 2 (or your label) Amt to Depreciate column, which in turn affects the amount of depreciation calculated by the system. In an over-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 Value or Book 2 (or your label) Salvage Percent columns for salvage unless this is the point at which you want the system to stop depreciation. For an existing Asset Master record, you can edit the value that displays in this column. Because system calculations use this data to determine the manner in which 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. For more information on salvage calculations, please refer to the examples of salvage value calculations illustrated in the Book 2 (or your label) Salvage Percent section above. Note: If you select the
Subtract Salvage Value Before Calculation check box on the Manage Depreciation Methods screen, the system will subtract the salvage value from the cost of the asset before calculating depreciation. If this check box is clear, the system will ignore salvage value from the
Book 2 (or your label) Salvage Value column when computing depreciation.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Total Cost |
The system displays the optional total cost amount entered for this record for this book, if applicable. The value in this column may have been entered or edited on the Cost Info tab or in the Other Book Info subtask of the Manage Asset Master Information screen, on the Manage Asset Cost Information screen, or on the Manage Asset Other Books Information screen. Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
You can enter or edit the total price amount in this optional column. Note that cost changes made to any optional book on this screen display in the appropriate columns on the Manage Asset Cost Information screen. Conversely, cost changes made to any optional book on the Manage Asset Cost Information screen display in the columns on this screen. There is no system requirement that the cost for any optional books used be identical to the cost value used for the G/L Book. You can always assign a different cost basis for each optional book (for purposes of stepped-up depreciation basis, and so on.). Because system depreciation calculations use this data, however, use caution if you change the cost for a record once it has begun depreciating in the system. Note: When you first add and save an Asset Master record, the G/L Book Total Cost value from the Cost Info tab of the Manage Asset Master screen (or from the Manage Asset Cost Information screen) displays as the default total cost for all optional books.
The value in this column may be updated based on your selection in the Update the Total Cost in All Other Books column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Amt To Depreciate |
Note:
The column header displays the name for this book as established in the Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the Books Setup group box of the Configure Fixed Assets Settings screen. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
This non-editable column computes and displays an amount equal to the total cost of the asset less any salvage value from the Book 2 (or your label) Salvage Value field. Be certain to confirm the data in the Book 2 (or your label) Salvage Percent and Book 2 (or your label) Salvage Value fields, because they directly influence the system calculation of the Book 2 (or your label) Amt to Depreciate field. As long as the Book 2 (or your label) Auto Calculate check box is selected for this book and you have made no manual overrides to system-calculated data, the system cannot depreciate an amount greater than the amount that displays in this field. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) FYTD Depreciation |
This column, along with other depreciation data, plays an integral role in the system calculation of depreciation for methods using the Fiscal Year basis. (You must select a Date of Purchase or Fiscal Year basis on the Manage Depreciation Methods screen when you set up each depreciation method). Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
The system displays the optional Book 2 (or your label) fiscal year to date depreciation amount entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited in the Other Books Info subtask of the Manage Asset Master Information screen or directly on the Manage Asset Other Books Information screen. For a new Asset Master record, no data should display in this column, because there has been no historical fiscal year activity. You should leave this column blank for a new record, because the system will increment (or possibly decrement) the value in this column by the amount of depreciation posted cumulatively for the period each time the current Fixed Assets period is closed. The value in this column should always be equal to the posted depreciation expense for the current fiscal year, exclusive of the value in the Book 2 (or your label) Current Pd Depreciation column. The value in this column will be different from the value in the Book 2 (or your label) Amt Taken Purchase YTD column except when the date of purchase coincides with the start of your fiscal year. The Book 2 (or your label) Amt Taken Purchase YTD column displays purchase year data, while the Book 2 (or your label) FYTD Depreciation column displays fiscal year data. For both new and historical records that are being initialized, the system will increase or decrease the value in this column by the amount of the total depreciation posted cumulatively for the period when the Fixed Assets current period is closed. Data from this column is added to the data from the Book 2 (or your label) Prior FY Depreciation and Book 2 (or your label) Current Pd Depreciation columns to derive the total calculated value displayed in the Book 2 (or your label) Accum Depreciation column. The system will update the value in this column when you perform the Fixed Assets period close process on the last period in your fiscal year. The system will add the value in the Book 2 (or your label) FYTD Depreciation column to the value in the Book 2 (or your label) Prior FY Depreciation column and will set the value in the Book 2 (or your label) FYTD Depreciation column back to zero. For an existing Asset Master record, you can edit data that displays in this column. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use caution if you change data in this column for property records once they have begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Prior FY Depreciation |
This column, along with other depreciation data, plays an integral role in the system calculation of depreciation for methods using the Fiscal Year basis. (You must select a Date of Purchase or Fiscal Year basis on the Manage Depreciation Methods screen when you set up each depreciation method). Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
The system displays the Book 2 (or your label) cumulative depreciation amount for all prior fiscal years entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. The value in this column should reflect cumulatively the total depreciation expense for all past fiscal years, and should not include the current fiscal year amount. Data displayed in this column may have been edited in the Other Books Info subtask of the Manage Asset Master Information screen or directly on the Manage Asset Other Books Information screen. For a new Asset Master record, no data should display in this column, because there has been no prior fiscal year activity. The value in this column should always be equal to the cumulative depreciation expense for all prior fiscal years, exclusive of the value in the Book 2 (or your label) Current Pd Depreciation column. This column will be updated when you perform the Fixed Assets period close process on the last period in your fiscal year. The value in the Book 2 (or your label) FYTD Depreciation column will be added to the value in the Book 2 (or your label) Prior FY Depreciation column, and the Book 2 (or your label) FYTD Depreciation column will be set back to zero. For both new and historical records, the system adds data from this column to the data from the Book 2 (or your label) FYTD Depreciation and Book 2 (or your label) Current Pd Depreciation columns to derive the Book 2 (or your label) Accum Depreciation column calculated total. For an existing Asset Master record, you can edit data that displays in this column. Because system calculations use this data to determine whether depreciation computations should take place for each record, and the manner in which they should take place, use caution if you change the value in this column for property records once they have begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Annual Depreciation |
This column, along with other depreciation data, plays an integral role in the system calculation of depreciation for both Date of Purchase and Fiscal Year basis methods. Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
You should leave this column blank for a new Asset Master record, unless you want to overwrite the system calculation of annual depreciation and you clear the Book 2 (or your label) Auto Calc Depr check box. This column will be populated by the system when you calculate depreciation for this record, if the Book 2 (or your label) Auto Calc Depr check box has been selected and the date in the Book 2 (or your label) Depr Start Date column is not a future date (later than the end of the current period). You can make manual entries in this column, regardless of the status of the Book 2 (or your label) Auto Calc Depr check box and the date in the Book 2 (or your label) Depr Start Date column. Enter all manual overwrites with caution, however. The timing of any manual entries to this column are especially important; if you select the Book 2 (or your label) Auto Calc Depr check box, any manual edits to the Book 2 (or your label) Annual Depreciation column will be overwritten by the system when you compute depreciation. For both new and historical records, the system uses data from this column when calculating depreciation. Depreciation calculations can be performed multiple times within the same accounting period. If you have made no manual corrections to critical columns (such as asset cost, annual depreciation, current depreciation year, periods remaining, and so on.), there is no danger that the system will calculate a different annual depreciation value for the same asset in the same accounting period. Annual depreciation is computed based on total cost (or cost minus salvage value) times the depreciation percentage (from the depreciation method assigned to the asset) for the year specified in the Book 2 (or your label) Curr Depr Yr column. The system does not re-set the value in this column to zero during the period close process. For an existing Asset Master record, you can edit data that displays in this column. Because system calculations use this data for depreciation calculations, however, use caution if you change this column once it has begun depreciating in the system. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Current Pd Depreciation |
Note:
The column header displays the name for this book as established in the Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the Books Setup group box of the Configure Fixed Assets Settings screen. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
You should leave this column blank for a new Asset Master record, unless you want to overwrite the system calculation of annual depreciation and you clear the Book 2 (or your label) Auto Calc Depr check box. For a new Asset Master record, blanks normally display in this column. If you have cleared the Book 2 (or your label) Auto Calc Depr check box and you manually entered a value in this column last period, this column should still display the manually entered value. You should leave this column blank for a new record unless you want to overwrite the system calculation of depreciation for the period. Note: If you manually change the current depreciation expense and then need to set it back to the system-calculated number, run the Compute Depreciation process again for that asset.
This column will be populated by the system when you calculate depreciation for this record, if the Book 2 (or your label) Auto Calc Depr check box has been selected, and the date in the Book 2 (or your label) Depr Start Date column is not a future date (later than the end of the current period). (The "current" Fixed Assets period is specified on the Configure Posting Settings screen). You can make manual entries and edits in this column, regardless of the status of the Book 2 (or your label) Auto Calc Depr check box and the date in the Book 2 (or your label) Depr Start Date column. Enter all manual entries and overwrites with caution, however. For both new and historical records, the system adds data from this column to the data from the Book 2 (or your label) FYTD Depreciation and Book 2 (or your label) Prior FY Depreciation columns to derive the Book 2 (or your label) Accum Depreciation column calculated total. When you close the current accounting period, the value in this column will be set back to zero unless you have cleared the Book 2 (or your label) Auto Calc Depr check box. Depreciation calculations can be performed multiple times within the same Fixed Assets period. If you have made no manual corrections to critical columns (such as asset cost, annual depreciation, current depreciation year, periods remaining, and so on), there will be no difference in the depreciation amount recomputed. Note: Changes to data in this column can occur as a result of manual overwrites in this column or as a result of depreciation calculations performed after changes have been made to other critical columns.
Current period depreciation expense is computed in accordance with the Date of Purchase or Fiscal Year basis assigned to each depreciation method (established on the Manage Depreciation Methods screen). Unlike the G/L Book, in which depreciation can be computed based on Years, Units of Usage, or Lease Pds, depreciation for all optional books utilized can be computed based only on Years. The basic methodologies for depreciation calculations in which the "catch-up" amount is to be spread among remaining periods are as follows:
In the following simplified example, consider the basic differences in current period depreciation calculations for a $9,000 asset, useful life of five years, no salvage value, using straight-line depreciation, for both the FY and DP basis. For this example, the current fiscal year is CY 2003 the current Fixed Assets accounting period is 10, the number of accounting periods in the fiscal year is 12, and the start date is 10-01-03.
Note: The computed annual depreciation expense is identical for both the DP and FY basis. The current period depreciation expense, however, is different.
If the Date of Purchase basis for depreciation is used, the system divides the annual depreciation expense of $1,800 by the number of accounting periods remaining in the purchase year (12). One period of expense is charged for the current period, irrespective of the fiscal year. The depreciation year begins at the date in the Depr Start Date column (10-01-2003). If the Fiscal Year basis for depreciation is used, the system divides the annual depreciation expense of $1,800 by the number of accounting periods remaining in the fiscal year. In the example above, there are only three accounting periods remaining in the fiscal year over which to spread the annual depreciation cost of $1,800. Note: Actual depreciation calculations may be more complex than the simplified explanation above, because you may have selected to use "catch-up" depreciation calculations for the current period or to compute depreciation on a "days" basis.
For additional information on depreciation calculation, please refer to the related topic, Calculate Depreciation. The date in the Book 2 (or your label) Depr Start Date field does not influence the start of the depreciation year until the date window coincides with the current accounting period. If the end of the accounting period occurs before the depreciation start date, the system will not calculate depreciation for this record. You can edit this field for an existing Asset Master record, but make all edits with caution. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Accum Depreciation |
The column header displays the name for this book as established in the Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the Books Setup group box of the Configure Fixed Assets Settings screen. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The system totals the values from the Book 2 (or your label) FYTD Depreciation, Book 2 (or your label) Prior FY Depreciation, and Book 2 (or your label) Current Pd Depreciation columns and displays the result in this column, where it cannot be edited. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Book Value |
Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
The system subtracts the value in the Book 2 (or your label) Accum Depreciation field from the value in the Book 2 (or your label) Amt to Depreciate field and displays the results in this field, where it cannot be edited. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Auto Calc Depr |
Please refer to the documentation for the Book 2 (or your label) Auto Calc Depr field. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Depr Method Code |
Please refer to the documentation for the Book 2 (or your label) Depr Method Code column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Depr Start Date |
Please refer to the documentation for the Book 2 (or your label) Depr Start Date column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Curr Depr Yr |
Please refer to the documentation for the Book 2 (or your label) Curr Depr Yr column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Days/Pds Remaining |
Please refer to the documentation for the Book 2 (or your label) Days/Pds Remaining column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Amt Taken Purchase YTD |
Please refer to the documentation for the Book 2 (or your label) Amt Taken Purchase YTD column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Salvage Percent |
Please refer to the documentation for the Book 2 (or your label) Salvage Percent column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Salvage Value |
Please refer to the documentation for the Book 2 (or your label) Salvage Value column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Total Cost |
Please refer to the documentation for the Book 2 (or your label) Total Cost column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Amt To Depreciate |
Please refer to the documentation for the Book 2 (or your label) Amt to Depreciate column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) FYTD Depreciation |
Please refer to the documentation for the Book 2 (or your label) FYTD Depreciation column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Prior FY Depreciation |
Please refer to the documentation for the Book 2 (or your label) Prior FY Depreciation column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Annual Depreciation |
Please refer to the documentation for the Book 2 (or your label) Annual Depreciation column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Current Pd Depreciation |
Please refer to the documentation for the Book 2 (or your label) Current Pd Depreciation column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Accum Depreciation |
Please refer to the documentation for the Book 2 (or your label) Accum Depreciation column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Book Value |
Please refer to the documentation for the Book 2 (or your label) Book Value column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Disposal Date |
This column displays the disposal date entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen or when the disposal entry was entered or edited on the Manage Disposal Transactions screen and posted to the G/L. Data displayed in this column may have been edited on the Disp Info tab of the Manage Asset Master Information screen, directly on the Manage Asset Disposal Information screen, or on the Manage Disposal Transactions screen. A disposal date is required on the Manage Disposal Transactions screens during data entry. When a disposal is entered on the Manage Disposal Transactions screen and posted to the G/L, the disposal date from the Manage Disposal Transactions screen is written to and displays in this column. Disposal data that displays in Asset Master records as a result of postings is treated as a "System-Generated" (SYSTEM) disposal, and you cannot edit data in this column. If you entered the disposal data directly on the Disp Info tab of the Manage Asset Master Information screen or directly on the Manage Asset Disposal Information screen, no data is written back to Asset Master records (as with postings), and the data is treated as a "Manual" (MANUAL) disposal. In this circumstance, you can edit data in this column. The "Manual" disposal entry function was designed primarily for entering historical disposal data during initialization. In the rare circumstance that such an entry or edit is necessary in this column for a "Manual" disposal, enter, or click to select, the disposal date in this column. Although the system does not validate the disposal date, several system reports and functions use the disposal date as one of the selection parameters. In addition, you may find that the disposal date is an important parameter when using Query or when using Impromptu to design custom reports. Because there are no system rules regarding the date entered in this column, you may want to develop some internal rules on the relationship of the date to the actual disposal and its consistency with your entries in the Disposal Fiscal Year and Disposal Period fields. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Disposal Fiscal Year |
This column displays:
When a disposal entered on the Manage Disposal Transactions screen is posted to the G/L, the current fiscal year of the posting displays in this field. Disposal data that displays in Asset Master records as a result of G/L postings is treated as a "System-Generated" (SYSTEM) disposal, and you cannot edit the data in this field. If you entered the disposal data directly on the Disp Info tab of the Manage Asset Master Information screen or directly on the Manage Asset Disposal Information screen, no data is written back to Asset Master records (as with postings), and the data is treated as a "Manual" (MANUAL) disposal. In this circumstance, you can edit data in this column. The "Manual" disposal entry function was designed primarily for entering historical disposal data during initialization. In the rare circumstance that such an entry or edit is necessary in this column for a "Manual" disposal, enter the fiscal year that relates to the disposal in this required column. Although the system does not validate the fiscal year, several system reports and functions use the disposal fiscal year as one of the selection parameters. In addition, you may find that the disposal fiscal year is an important field when using Query or when using Impromptu to design custom reports. Because there are no system rules regarding the disposal fiscal year entered in this field, you may want to develop some internal rules on the relationship of the fiscal year to the actual disposal and its consistency with your entries in the Disposal Date and Disposal Period fields. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Disposal Period |
This column displays:
When a disposal entered on the Manage Disposal Transactions screen is posted to the G/L, the current accounting period of the posting displays in this field. Disposal data that displays in Asset Master records as a result of G/L postings is treated as a "System-Generated" (SYSTEM) disposal, and you cannot edit the data in this field. If the disposal data was entered directly on the Disp Info tab of the Manage Asset Master Information screen or directly on the Manage Asset Disposal Information screen, no data is written back to Asset Master records (as with postings), and the data is treated as a "Manual" (MANUAL) disposal. In this circumstance, you can edit data in this column. The "Manual" disposal entry function was designed primarily for entering historical disposal data during initialization. In the rare circumstance that such an entry or edit is necessary in this column for a "Manual" disposal, enter the disposal accounting period in this column. Although the system does not validate the disposal accounting period, several system reports and functions use the disposal accounting period year as one of the selection parameters. In addition, you may find that the disposal accounting period is an important field when using Query or when using Impromptu to design custom reports. Because there are no system rules regarding the disposal accounting period entered in this field, you may want to develop some internal rules on the relationship of the accounting period to the actual disposal and its consistency with your entries in the Disposal Date and Disposal Fiscal Year fields. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Disposal Price |
This column displays the optional disposal price entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen or when the disposal entry was entered or edited on the Manage Disposal Transactions screens and posted to the G/L. Data displayed this column may have been edited on the Disp Info tab of the Manage Asset Master Information screen, directly on the Manage Asset Disposal Information screen, or even on the Manage Disposal Transactions screens. A disposal price is optional on the Manage Disposal Transactions screens during data entry, and a zero disposal price displays as a default. You can use this field to enter the anticipated sales price, if any, from the disposal. When a disposal is entered on the Manage Disposal Transactions screens and posted to the G/L, the disposal price, if applicable, from the Manage Disposal Transactions screens is written to and displays in this column. Disposal data that displays in Asset Master records as a result of postings is treated as a "System-Generated" (SYSTEM) disposal, and you cannot edit the data in this column. If you entered the disposal data directly on the Disp Info tab of the Manage Asset Master Information screen or directly on the Manage Asset Disposal Information screen, no data is written back to Asset Master records (as with postings), and the data is treated as a "Manual" (MANUAL) disposal. In this circumstance, you can edit the data in this column. The "Manual" disposal entry function was designed primarily for entering historical disposal data during initialization. In the rare circumstance that such an entry or edit is necessary in this column for a "Manual" disposal, enter the disposal price in this optional column. Note: The Manage Disposal Transactions screens calculate and display a gain/loss amount that takes into account the disposal price. The displayed gain/loss amount is the expected gain or loss based on the expected disposal price. Regardless of the gain or loss displayed on the entry screens, the book value from the Asset Master record is always posted as the gain or loss. The proceeds (anticipated disposal price) on a disposal are never taken into account when disposals are posted from Costpoint Fixed Assets, and must be entered as a Cash Receipt or Note Receivable to supply the offset to the gain/loss account.
For this reason, because the disposal price represents only anticipated proceeds, you may prefer to leave this optional column blank to avoid distorting the displayed gain/loss data. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Disposal Description |
This column displays the optional disposal description entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen or when the disposal entry was entered or edited on the Manage Disposal Transactions screen and posted to the G/L. Data displayed in this column may have been edited on the Disp Info tab of the Manage Asset Master Information screen, directly on the Manage Asset Disposal Information screen, or even on the Manage Disposal Transactions screens. A disposal description is optional on the Manage Disposal Transactions screens during data entry, and blanks display as a default. When a disposal is entered on the Manage Disposal Transactions screens and posted to the G/L, the disposal description, if applicable, from the Manage Disposal Transactions screen is written to and displays in this column. Disposal data that displays in Asset Master records as a result of postings is treated as a "System-Generated" (SYSTEM) disposal, and you cannot edit the data in this column. If you entered the disposal data directly on the Disp Info tab of the Manage Asset Master Information screen or directly on the Manage Asset Disposal Information screen, no data is written back to Asset Master records (as with postings), and the data is treated as a "Manual" (MANUAL) disposal. In this circumstance, you can edit the data in this column. The "Manual" disposal entry function was designed primarily for entering historical disposal data during initialization. In the rare circumstance that such an entry or edit is necessary in this column for a "Manual" disposal, enter the disposal description in this column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Disposal Type |
This column displays the disposal type entered for this record, as applicable, when the asset was first saved on the Manage Asset Master Information screen or when the disposal entry was entered or edited on the Manage Disposal Transactions screens and posted to the G/L. Data displayed in the Disposal Type column may have been edited on the Disp Info tab of the Manage Asset Master Information screen, directly on the Manage Asset Disposal Information screen, or even on the Manage Disposal Transactions screens. A disposal type is optional on the Manage Disposal Transactions screens during data entry, and blanks display as a default. When a disposal is entered on the Manage Disposal Transactions screens and posted to the G/L, the disposal type, if applicable, from the Manage Disposal Transactions screen is written to and displays in this column. Disposal data that displays in Asset Master records as a result of postings is treated as a "System-Generated" (SYSTEM) disposal, and you cannot edit the data in this column. If you entered the disposal data directly on the Disp Info tab of the Manage Asset Master Information screen or directly on the Manage Asset Disposal Information screen, no data is written back to Asset Master records (as with postings), and the data is treated as a "Manual" (MANUAL) disposal. In this circumstance, you can edit the data in this column. The "Manual" disposal entry function was designed primarily for entering historical disposal data during initialization. In the rare circumstance that such an entry or edit is necessary in this column for a "Manual" disposal, enter, or click to select, a new or different valid disposal type code for this record. Valid disposal types are set up on the Manage Disposal Types screen. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Disposal Doc No |
This column displays the optional disposal document number (or other data) entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen or when the disposal entry was entered or edited on the Manage Disposal Transactions screen and posted to the G/L. Data displayed in this column may have been edited on the Disp Info tab of the Manage Asset Master Information screen, directly on the Manage Asset Disposal Information screen, or even on the Manage Disposal Transactions screen. A disposal document number (or other data) is optional on the Manage Disposal Transactions screens during data entry, and blanks display as a default. When a disposal is entered on the Manage Disposal Transactions screen and posted to the G/L, the disposal document data, if applicable, from the Manage Disposal Transactions screen is written to and displays in this column. Disposal data that displays in Asset Master records as a result of postings is treated as a "System-Generated" (SYSTEM) disposal, and you cannot edit the data in this column. If you entered the disposal data directly on the Disp Info tab of the Manage Asset Master Information screen or directly on the Manage Asset Disposal Information screen, no data is written back to Asset Master records (as with postings), and the data is treated as a "Manual" (MANUAL) disposal. In this circumstance, you can edit the edit data in this column. The "Manual" disposal entry function was designed primarily for entering historical disposal data during initialization. In the rare circumstance that such an entry or edit is necessary in this column for a "Manual" disposal, enter the disposal document number in this column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Disposal Posting User |
You cannot edit the data in this column. This field displays the ID of the user that posted the disposal data from the Manage Disposal Transactions screen to the General Ledger for this Asset Master record, as applicable. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Disposal Entry Type |
You cannot edit the data in this column. This field indicates whether the disposal data that displays on this screen was system-generated data or manually entered. This field displays SYSTEM for system-generated data and MANUAL for historical data manually entered on this screen. System-generated data displays in this table window as a result of postings to the General Ledger. If a record has a status of Disposal and it is marked as a system disposal instead of a manual disposal, certain columns are disabled on this screen to prevent further changes to the record. Note: Disposal data for depreciable assets and non-depreciable assets can display as a result of postings. In the case of postings for non-depreciable assets for which the
Post Disposal to G/L check box has been selected, there will be no display in the
Accum Depreciation and
Depr Adj Amt columns.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Disposal Posted Date |
You cannot edit the data in this column. This field displays the date that disposal data from the Manage Disposal Transactions screen was posted to the General Ledger for this Asset Master record. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
G/L Book Depr Adj Amt |
This column displays the depreciation adjustment amount on disposal entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen or when the disposal entry was entered or edited on the Manage Disposal Transactions screen. Data displayed in this column may have been edited on the Disp Info tab of the Manage Asset Master Information record, directly on the Manage Asset Disposal Information screen, or on the Manage Disposal Transactions screen. Note: The column header displays the name for this book as established on the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so on the
Books Setup group box of the Configure Fixed Assets Settings screen.
When you enter disposal data on the Manage Disposal Transactions screens, you can also enter a value in the G/L Book Depr Adj Amt column. A depreciation adjustment is an optional, manually entered adjustment to depreciation value that is used by the system in computing the gain or loss on a disposal for each book. Timing issues often require depreciation adjustment entries. This type of entry is designed to add to or reduce depreciation expense by debiting and crediting depreciation expense and accumulated depreciation, as appropriate. (One of the most frequently encountered situations requiring a depreciation adjustment occurs when disposal data is communicated "after-the-fact." If, for example, you learn that an asset was disposed of two months ago, you may want to use the depreciation adjustment to reverse two months of depreciation posted to the General Ledger before posting the disposal). Note: Additional depreciation expense as an adjustment displays as a positive value in this column, because it increases (debits) the depreciation expense account(s) and increases (credits) the accumulated depreciation account during posting. Reduced depreciation expense as an adjustment displays as a negative value in this column, because it decreases (credits) the depreciation expense account(s) and decreases (debits) the accumulated depreciation account during posting.
When a disposal is posted (for the G/L Book only), the value(s) in the Depr Adj Amt field from the Manage Disposal Transactions screen is written to and displays in this field. Although you can modify this value at any time for any book on the Disp Info tab of the Asset Master record, the edit function was designed primarily for use in entering historical disposal data during initialization, rather than for altering system-generated data. We recommend that you make certain that data entered on the Manage Disposal Transactions screen is accurate before you select the record for processing and posting. We discourage edits to the depreciation adjustment in an Asset Master record for posted disposals because these changes alter the audit trail upon which the gain or loss on the disposal was calculated. You make a depreciation adjustment, before posting a disposal, to make up for too little or too much depreciation previously booked. Rather than returning to the Asset Master screen to enter and post this type of depreciation adjustment, you can enter a depreciation adjustment directly on the Manage Disposal Transactions screen. Currently, a depreciation adjustment entered in a disposal screen does not have any effect on the gain/loss posted as a result of the disposal. To preserve the audit trail for a depreciation adjustment made on a disposal screen, the depreciation adjustment only debits or credits the depreciation expense and accumulated depreciation accounts, as in a standard depreciation posting. Currently, if you have entered a depreciation adjustment on the Manage Disposal Transactions screens, you will need to manually make a final G/L entry to move the balance created in the accumulated depreciation account to the gain/loss account Note: A cleaner audit trail will result if, before you post the disposal, you enter a change to depreciation directly in the
Current Pd Depreciation column and then post depreciation, rather than enter a depreciation adjustment and post it as a disposal. In this circumstance, you should close the period and post the disposal in the following period.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 2 (or your label) Depr Adj Amt |
This column displays the optional depreciation adjustment amount on disposal entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen for a "Manual" disposal entry or when the disposal entry was entered or edited on the Manage Disposal Transactions screen and subsequently posted. Note: The column header displays the name for this book as established in the
Books Setup group box of the Configure Fixed Assets Settings screen. To edit the book name, you must do so in the
Books Setup group box of the Configure Fixed Assets Settings screen.
When you enter disposal data on the Manage Disposal Transactions screen, you can also enter a value in the Book 2 (or your label) Depr Adj Amt column. A depreciation adjustment is an optional, manually entered adjustment to depreciation value that is used by the system in computing the gain or loss on a disposal for each book. Timing issues often require depreciation adjustment entries. This type of entry is designed to add to or reduce depreciation expense by debiting and crediting depreciation expense and accumulated depreciation, as appropriate. (One of the most frequently encountered situations requiring a depreciation adjustment occurs when disposal data is communicated "after-the-fact." If, for example, you learn that an asset was disposed two months ago, you may want to use the depreciation adjustment to back out two months of depreciation). Note: Additional depreciation expense as an adjustment displays as a positive value in this column, because it increases (debits) the depreciation expense account(s) and increases (credits) the accumulated depreciation account. Reduced depreciation expense as an adjustment displays as a negative value in this column, because it decreases (credits) the depreciation expense account(s) and decreases (debits) the accumulated depreciation account.
No postings to the General Ledger take place for optional books. The system recalculates and re-displays data as a result of the Close Fixed Assets Accounting Period process, however, just as if a posting had taken place. When a disposal is entered on the Manage Disposal Transactions screen and posted to the G/L, the value(s) in the Book 2 (or your label) Depr Adj Amt column from the Manage Disposal Transactions screen if applicable is written to and displays in this column. Disposal data that displays in Asset Master records as a result of postings is treated as a "System-Generated" (SYSTEM) disposal, and you cannot edit the data in this column. If the disposal data was entered directly on the Disp Info tab of the Manage Asset Master Information screen or directly on the Manage Asset Disposal Information screen, no data is written back to Asset Master records (as with postings), and the data is treated as a "Manual" (MANUAL) disposal. In this circumstance, you can edit the data in this column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Book 3 (or your label) to Book 10 (or your label) Depr Adj Amt |
Please refer to the documentation for the Book 2 (or your label) Depr Adj Amt column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Nat Stock No |
This column displays the national stock number entered for this record, if applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Govt Info tab of the Manage Asset Master Information screen or on the Manage Asset Government Information screen. The system does not validate the data in this column. For a new Asset Master record, you can edit this column or enter a new value. For an existing Asset Master record, you can edit or delete data that displays in this column or you can add new data to a blank column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Year Built |
This column displays the year-built data entered for this record, if applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Govt Info tab of the Manage Asset Master Information screen or on the Manage Asset Government Information screen. The system does not validate the data in this column. For a new Asset Master record, you can edit this field or enter up to four numeric characters in year format (for example, 1983). For an existing Asset Master record, you can edit or delete data that displays in this column or you can add new data to a blank column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Tag No |
This column automatically displays the tag number entered for this record, if applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Govt Info tab of the Manage Asset Master Information screen or on the Manage Asset Government Information screen. The system does not validate the data in this column. For a new Asset Master record, you can edit this column or enter a value. For an existing Asset Master record, you can edit or delete data that displays in this column or you can add new data to a blank column. Note: If it is your company policy to assign the physical property tag number as the unique identifier for an Asset Master record, the data in this field will be the same as the identifier in the
Asset No field.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Employee |
This column automatically displays the employee data entered for this record, as applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Govt Info tab of the Manage Asset Master Information screen or directly on the Manage Asset Disposal Information screen. Enter, or click to select, an employee ID. This field can be blank, because employee data is not required to save a row on this screen and is not required in an Asset Master record. For a new Asset Master record, you can edit this column or enter a value. For an existing Asset Master record, you can edit or delete data that displays in this column or you can add new data to a blank column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Govt1 (or your label) |
This column displays the optional data assigned to this record, if applicable, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Govt Info tab of the Manage Asset Master Information screen or directly on the Manage Asset Government Information screen. Note: If you designated a label for
Govt 1 Label field in the
Govt Labels for Asset Master group box of the Manage Asset Master Field Labels screen, that label description displays at this field. Note that you are not required to establish a label for this field. If you did not set up the Govt 1 Label, the system-default label displays at this field.
The system uses "government" as a default 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. There is no system validation for the data in this column. For a new Asset Master record, you can enter a value in this column. For an existing Asset Master record, you can edit or delete data that displays in this column or you can add new data to a blank column. Note: This user-defined "government" information field can be used independently from each of the other 14 user-defined "government" information fields.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Govt2 to Govt15 (or your labels) |
Please refer to the documentation for the Govt1 (or your label) column. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UID |
This column displays the Unique Item Identifier (UID) code for this record, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Govt Info tab of the Manage Asset Master Information screen or on the Manage Asset Government Information screen. For a new Asset Master record, you can enter the UID code in this column. For an existing Asset Master record, you can edit the UID code. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UID Type |
This column displays the Unique Item Identifier (UID) type for this record, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Govt Info tab of the Manage Asset Master Information screen or on the Manage Asset Government Information screen. Edit, enter, or click to select, the Unique Item Identifier (UID) type to indicate what construction method was used for the UID code. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UID Issuing Agency |
This column displays the UID issuing agency for this record, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Govt Info tab of the Manage Asset Master Information screen or on the Manage Asset Government Information screen. Edit, or enter the Issuing Agency code who assigned the enterprise identifier for the UID. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
UID Enterprise Identifier |
This column displays the UID enterprise identifier for this record, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Govt Info tab of the Manage Asset Master Information screen or on the Manage Asset Government Information screen. Edit, enter the UID Enterprise Identifier code assigned by the issuing agency to the manufacturer, vendor, contractor or other entity responsible for creating the UID. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
CAGE ID |
This column displays the Commercial and Government Entity (CAGE) ID for this record, when the asset was saved on the Manage Asset Master Information screen. Data displayed in this column may have been edited on the Govt Info tab of the Manage Asset Master Information screen or on the Manage Asset Government Information screen. Edit, or enter the CAGE ID that identifies the government contractor for this asset record. |