This field (INPUT_ROW) is not a field in the ASSET_OTH_BK_DEPR table, but must be included in the import for data to be uploaded into the ASSET_OTH_BK_DEPR table.

This field is required, it must be numeric, and it can hold up to 10 integers.

The purposes for this row are to match this row with the ASSET (A) row and to serve as an identifier on the Error report for records that fail validations.

Possible Error Message:

• ERROR MESSAGE: Input Row is not numeric.

This field (STATUS) is not a field in the ASSET_OTH_BK_DEPR table, but must be included in the data to be uploaded into the ASSET_OTH_BK_DEPR table.

This field is required and it can only hold one of these values:

• I: records have been successfully uploaded into the Fixed Assets and GENL_UDEF tables Fixed Assets Asset Preprocessor 100
• E: record previously uploaded and failed validations
• U: records that have not yet been uploaded or that have been validated and passed validations such that the records may be imported but have not yet been imported.

Record Type is not a field in the ASSET_OTH_BK_DEPR table, but must be included in the data to be uploaded into the ASSET_OTH_BK_DEPR table by input row.

This field is required and it can only hold one of the following alphabetic characters:

• H (Header table)
• A (Asset table)
• B (Other Books table)
• O (Other Info/Books Disposal tables)
• U (User-Defined tables)

The purpose of the record type designation is to indicate whether the row is a header row or whether it should be linked with the ASSET, ASSET_OTH_BK_DEPR, or other tables that store Asset Master data (such as such as ASSET_OTHER_INFO or ASSET_BOOKS_DISP or GEN_UDEF).

Possible Error Message:

• ERROR MESSAGE: Row Type exceeds 1 character.

To enter data for optional books 2 to 10 in the ASSET_OTH_BK_DEPR table, as applicable, you must first initialize each book that you plan to use on the Configure Fixed Assets Settings screen.

This non-editable field holds the previously-established asset identifier assigned to this record when the Asset Master record was originally created and saved. The data in this field must exactly match the data entered for the same Asset Master record in the ASSET table and the ASSET_OTHER_INFO table.

To enter data for optional books 2 to 10 in the ASSET_OTH_BK_DEPR table, as applicable, you must first initialize each book that you plan to use on the Configure Fixed Assets Settings screen.

This non-editable field holds the previously-established asset item number assigned to this record when the Asset Master record was originally created and saved. The data in this field must exactly match the data entered for the same Asset Master record in the ASSET table and the ASSET_OTHER_INFO table.

This required field (B2_DEPR_MTHD_CD) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Setting screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years. As a result, this field is always required for system depreciation calculations to take place.

Since depreciation is always and automatically based on “Years” methodology for this optional book, this required field holds up to 6 alphanumeric characters and can be populated by manual entry or by importing data from a specified Asset Template record.

The methodology parameters that you set up with each depreciation method during initialization provide the system with the instructions for depreciation calculations.

Depreciation Method Codes are validated against user-specified data initialized on the Manage Depreciation Methods screen. Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after you have begun depreciating this record to avoid unexpected results.

Template Numbers (along with any applicable revision numbers) are permitted in the input file/table. If the Template No/Rev No is populated on an input file/table record, the asset record will be populated with the values associated with the Template No/Rev No as they exist in the Receiving database, as follows:

• If the Depr Method Code field for Book 2 is blank in the input file/table for which there is a corresponding template data field value, the system will use the Template No to determine the data for that field.
• In the circumstance that data exists in the input file/table for the Depr Method Code field for Book 2, even if there is a corresponding template data field value, the system will bypass any reference to the Template No.

This optional field (B2_USEFUL_LIFE_NO) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Setting screen.

This optional field (B2_USEFUL_LIFE_NO) holds up to 4 numeric characters to specify the useful life of the asset (which may not be obvious from the Book 2 Depr Method Code you have assigned). This field can be populated by manual entry or by importing data from a specified Asset Template record.

The data in this field is for information purposes only and is not used in system calculations. (When the system calculates depreciation, the depreciation year and percentage for that year are derived from the data in the Book 2 Depr Method Code that you have assigned to the Asset Master record.)

Template Numbers (along with any applicable revision numbers) are permitted in the input file/table. If the Template No/Rev No is populated on an input file/table record, the asset record will be populated with the values associated with the Template No/Rev No as they exist in the Receiving database, as follows:

• If the Book 2 Useful Life field is blank in the input file for which there is a corresponding template data field value, the system will use the Template No to determine the data for that field.
• In the circumstance that data exists in the input file for Book 2 Useful Life, even if there is a corresponding template data field value, the system will bypass any reference to the Template No.

Preprocessor Default Rules:

• If this field is NULL in the input file/table and in the Template, and any Other Book’s Depreciation Method Code is not NULL, (i.e., Bx_DEPR_MTHD_CD is not NULL), insert a zero (‘0‘), since NULLs are not permitted by the system for this field.
  Note: In the Asset Master record, the system displays the Book Name that you established for this book on the Configure Fixed Assets Settings screen as part of the label for this field. For example, if you established “Tax” as the name for Book 2 on the Configure Fixed Assets Settings screen, the system will display “Tax Useful Life” as the label for this Asset Master record field.

This required field (B2_AUTO_CALC_FL) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Settings screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This required field for Book 2, as applicable, can only be selected (Y in the import data) (Yes) or cleared (N in the import data) to indicate whether the auto calculation feature should be enabled. In an Asset Master record, this check box can be activated by manual entry or by importing data from a specified Asset Template record.

The system default for this field is Y (Depreciable), which can be changed by manual entry or by importing data from a specified Asset Template record.

If the Book 2 Auto Calculate Depreciation check box is selected for an Asset Master record, the system will automatically include the record in depreciation computations (providing all other rules of eligibility for depreciation calculations are met). In addition, the system will re-set the Book 2 Current Pd Depreciation field back to zero during the Fixed Assets period close process.

You should clear the Book 2 Auto Calculate Depreciation check box (or enter N in the import data) for this field if you want to disable the automatic system calculation of depreciation for this book for this Asset Master record. In this circumstance, however, you will need to manually enter the amount of depreciation in the Book 2 Current Pd Depreciation field in order to be able to record any depreciation for the record.

In general, if you need to make a one-time adjustment to current depreciation expense, you should manually override the current period depreciation amount calculated by the system rather than change the default for this check box. If, however, if you want to record the monthly depreciation expense for this book as a recurring override to system calculations, you can set this field to cleared (or N in the import data) and enter the recurring override amount in the Book 2 Current Pd Depreciation field.

You can select/clear this check box, as desired, at any time in Asset Master records.

Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after you have begun depreciating this record to avoid unexpected results.

Template Numbers (along with any applicable revision numbers) are permitted in the input file/table. If the Template No/Rev No is populated on an input file/table record, the asset record will be populated with the values associated with the Template No/Rev No as they exist in the Receiving database, as follows:

• If the Book 2 Auto Calc field is blank in the input file/table for which there is a corresponding template data field value, the system will use the Template No to determine the data for that field.
• In the circumstance that data exists in the input file/table for Book 2 Auto Calc, even if there is a corresponding template data field value, the system will bypass any reference to the Template No.

Preprocessor Default Rules:

• If this field is NULL in the input file/table and in the Template, and any Other Book’s Depreciation Method Code is not NULL, (that is, Bx_DEPR_MTHD_CD is not NULL), insert a ‘Y, since NULLs are not permitted by the system for this field.

This optional field (B2_SLVGE_RT) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Setting screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This optional field for Book 2, as applicable, holds up to three integers and four decimal places (that is, 100.0000 or 99.9999) and can be populated by manual entry or by importing data from a specified Asset Template record.

In an Asset Master record, if you enter a salvage value percentage in this field, note that the system automatically computes and displays the equivalent salvage value in the Book 2 (Salvage) Value field.

The Book 2 (Salvage) Percent and Book 2 (Salvage) Value fields in an Asset Master record are reciprocal in that the entry in one field automatically calculates and displays the appropriate data in the other field.

The system subtracts the amount from the Book 2 (Salvage) Value field from the amount in the Book 2 Total Cost field, and automatically displays the result in the Book 2 Amount to Depreciate field, which, in turn, as applicable, affects the amount of depreciation computed for the asset.

The value in this field must be equal to the Book 2 (Salvage) Value amount divided by the Book 2 Total Cost amount for the Asset Master record.

Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after you have begun depreciating this record to avoid unexpected results.

Template Numbers (along with any applicable revision numbers) are permitted in the input file/table. If the Template No/Rev No is populated on an input file/table record, the asset record will be populated with the values associated with the Template No/Rev No as they exist in the Receiving database, as follows:

• If the Book 2 (Salvage) Percent field is blank in the input file/table for which there is a corresponding template data field value, the system will use the Template No to determine the data for that field.
• In the circumstance that data exists in the input file/table for Book 2 (Salvage) Percent, even if there is a corresponding template data field, the system will bypass any reference to the Template No.

Preprocessor Default Rules:

• If this field is NULL in the input file/table and in the Template, and any Other Book’s Depreciation Method Code is not NULL, (that is, Bx_DEPR_MTHD_CD is not NULL), insert a zero (‘0‘), since NULLs are not permitted by the system for this field.
• If the (Salvage) Value field is populated and this field is not populated, compute and insert this value in the field: (Salvage) Value (B2_SLVGE_VAL_AMT) divided by Total Cost (B2_TOT_COST_AMT).

This optional field (B2_SLVGE_VAL_AMT) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Setting screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This optional field for Book 2, as applicable, holds the salvage value amount, as applicable. The format cannot exceed 999,999,999,999.99, and the salvage value amount can be populated by manual entry.

In an Asset Master record, if you enter a salvage value amount in this field, note that the system automatically computes and displays the equivalent salvage rate in the Book 2 (Salvage) Percent field.

The Book 2 (Salvage) Percent and Book 2 (Salvage) Value fields in an Asset Master record are reciprocal in that the entry in one field automatically calculates and displays the appropriate data in the other field.

The system subtracts the amount from the Book 2 (Salvage) Value field from the amount in the Book 2 Total Cost field, and automatically displays the result in the Book 2 Amount to Depreciate field, which, in turn, as applicable, affects the amount of depreciation computed for the asset.

The value in this field must be equal to the Book 2 (Salvage) Percent multiplied by the Book 2 Total Cost amount for the Asset Master record.

Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after you have begun depreciating this record to avoid unexpected results.

There is no corresponding Asset Template field.

Preprocessor Default Rules:

• If this field is NULL in the input file/table and in the Template, and any Other Book’s Depreciation Method Code is not NULL, (that is, Bx_DEPR_MTHD_CD is not NULL), insert a zero (‘0‘), since NULLs are not permitted by the system for this field.
• If the Book 2 (Salvage) Percent field is populated and this field is not populated, compute and insert this value in the field: Book 2 (Salvage) Percent (B2_SLVGE_RT) multiplied by Book 2 Total Cost (B2_TOT_COST_AMT).

This optional field (B2_FYTD_DEPR_AMT) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Setting screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This optional field for Book 2, as applicable, holds the depreciation expense already recorded for the current fiscal year for all previously-closed periods in the current fiscal year, and excludes any value in the Book 2 Current Pd Depreciation field. The value cannot exceed 999,999,999,999.99, and the FYTD depreciation amount can be populated by manual entry.

The system automatically adds the value from this field to the values in the Book 2 Prior FY Depreciation and Book 2 Current Pd Depreciation fields to derive the total calculated value displayed in the Book 2 Accum Depreciation field.

For a new Asset Master record, this field should be blank, as there will have been no current fiscal year activity. Each accounting period, the system will automatically increase (or possibly decrease) the value in this field by the total amount of current period depreciation when you close the Fixed Assets period.

For both new and historical records that are being initialized, the system will increase or decrease the value in this field by the total amount of current period depreciation when you close the Fixed Assets current period.

The system will also update the value in this field when you perform the Fixed Assets period close process on the last period in your current fiscal year. The system adds the value in the Book 2 FYTD Depreciation field to the value in the Book 2 Prior FY Depreciation field and then sets the value in the Book 2 FYTD Depreciation field back to zero.

There is no corresponding Asset Template field.

Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after you have begun depreciating this record to avoid unexpected results.

Preprocessor Default Rules:

• If this field is NULL in the input file/table and in the Template, and any Other Book’s Depreciation Method Code is not NULL, (that is, Bx_DEPR_MTHD_CD is not NULL), insert a zero (‘0‘), since NULLs are not permitted by the system for this field.

This optional field (B2_PFY_DEPR_AMT) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Setting screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This optional field for Book 2, as applicable, holds the cumulative depreciation expense recorded for ALL prior (and previously-closed) fiscal years. The amount in this field should exclude any recorded amounts for the current fiscal year. The value cannot exceed 999,999,999,999.99, and the prior FY depreciation amount can be populated by manual entry.

The system automatically adds the value from this field to the values in the Book 2 FYTD Depreciation and Book 2 Current Pd Depreciation fields to derive the total calculated value displayed in the Book 2 Accum Depreciation field.

For a new Asset Master record, this field should be blank, as there would have been no activity in prior fiscal years.

For both new and historical records, the system will automatically update the value in this field when you perform the Fixed Assets period close process on the last period in your current fiscal year. The system will add the value from the Book 2 FYTD Depreciation and Book 2 Current Pd Depreciation fields to the value in the Book 2 Prior FY Depreciation field, and will set the values in the Book 2 FYTD Depreciation and Book 2 Current Pd Depreciation fields back to zero.

Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after you have begun depreciating this record to avoid unexpected results.

There is no corresponding Asset Template field.

Preprocessor Default Rules:

• If this field is NULL in the input file/table and in the Template, and any Other Book’s Depreciation Method Code is not NULL, (that is, Bx_DEPR_MTHD_CD is not NULL), insert a zero (‘0‘), since NULLs are not permitted by the system for this field.

• This optional field (B2_CUR_DEPR_AMT) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Settings screen.
• Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This optional field for Book 2, as applicable, holds the current period depreciation expense amount. The amount in this field should exclude any recorded amounts for prior periods in the current fiscal year. The value cannot exceed 999,999,999,999.99, and the depreciation expense amount can be populated by manual entry.

The system automatically adds the value from this field to the values in the Book 2 Prior FY Depreciation and Book 2 FYTD Depreciation fields to derive the total calculated value displayed in the Book 2 Accum Depreciation field.

For a new Asset Master record, this field should be blank unless you want to overwrite the system calculation of annual depreciation and you clear the Book 2 Auto Calculate Depreciation check box. If you have cleared the Book 2 Auto Calculate Depreciation check box and you manually entered a value in this field last period, this field should still display the manually-entered value.

For both new and historical records, the system will automatically populate/update this field when you calculate depreciation for this record (if you have selected the Book 2 Auto Calculate check box and the date in the Book 2 Depr Start Date field is not a future date which is later than the end of the current period).

(The "current" Fixed Assets period is specified on the Configure Posting Settings screen.)

When you close the current Fixed Assets accounting period, the system sets back the value in this field to zero unless you have cleared the Book 2 Auto Calculate Depreciation check box.

You can perform depreciation calculations multiple times within the same Fixed Assets period. If you have made no manual corrections to critical fields (such as asset cost, annual depreciation, current depreciation year, periods remaining, and so on), there is no danger that the system will record the same depreciation expense for the same asset in the same Fixed Assets period after you re-calculate depreciation.

When you close the current Fixed Assets accounting period, the system will add the amount displayed in this field to the amount in the Book 2 FYTD Depreciation field (or to the Book 2 Prior FY Depreciation, if appropriate) and will re-set the value in this field back to zero.

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 Based On is Y (Years)

  The basic premise for depreciation calculations in which the "catch-up" amount is to be spread among remaining periods is as follows:

  • If you have linked a Date of Purchase depreciation basis method with the asset, the Book 2 Current Pd Depreciation field will display the annual depreciation expense less the amount taken this purchase year divided by the number of periods remaining in the purchase year.
  • If you have linked a Fiscal Year depreciation method basis with the asset, the Book 2 Current Pd Depreciation field will display the annual depreciation expense less the FYTD amount divided by the number of periods remaining in the fiscal year.
  Note: Actual depreciation calculations may be more complex than in this simplified explanation because you may have selected to use "catch-up" depreciation calculations for the current period or to compute depreciation on a "days" basis.

  In the following simple 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 Purchased basis.

  For this example, the current fiscal year is CY 2007, 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-07.

  	DP (Date-Purchased)	FY (Fiscal Year)
  Asset Cost	$ 9,000	$ 9,000
  Annual Depreciation	$ 1,800	$ 1,800
  Current Pd Depreciation	$ 150	$ 600

  Note: The computed annual depreciation expense is identical for both the DP and FY basis. The current period depreciation expense, however, is different.
  • Using the Date of Purchase basis for depreciation, 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 for the month based on the date in the Book 2 Depr Start Date field (10-01-2007).
  • Using the Fiscal Year basis for depreciation, 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 FY 2007 over which to spread the annual depreciation cost of $1,800.

  Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after you have begun depreciating this record to avoid unexpected results.

  Note: In the Asset Master record, the system displays the Book Name that you established for this book on the Configure Fixed Assets Settings screen as part of the label for this field. For example, if you established “Tax” as the name for Book 2 on the Configure Fixed Assets Settings screen, the system will display “Tax Current Pd Depreciation” as the label for this Asset Master record field.

There is no corresponding Asset Template field.

Preprocessor Default Rules:

• If this field is NULL in the input file/table and in the Template, and any Other Book’s Depreciation Method Code is not NULL, (that is, Bx_DEPR_MTHD_CD is not NULL), insert a zero (‘0‘), since NULLs are not permitted by the system for this field.

This optional field (B2_ANNL_DEPR_AMT) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Settings screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This field for Book 2, as applicable, holds the system-computed annual depreciation expense amount. The value cannot exceed 999,999,999,999.99 and this field can be populated by manual entry.

You can leave this field blank for both new and historical records unless you want to overwrite the system calculation of annual depreciation and you clear the Book 2 Auto Calculate Depreciation check box.

The system will populate this field when you calculate depreciation for this record if you have selected the Book 2 Auto Calculate Depreciation check box and the date in the Book 2 Depr Start Date field is not a future date (later than the end of the current period).

Manual entries in an Asset Master record are always permitted in this field, regardless of the status of the Book 2 Auto Calculate Depreciation check box and the date in the Book 2 Depr Start Date field, but should be entered with caution. The timing of any manual entries to this field in an Asset Master record is especially important; if you have selected the Book 2 Auto Calculate Depreciation check box and make any manual edits to the Book 2 Annual Depreciation field, the system will re-compute and repopulate this value during the calculation and overwrite your manual edits.

For both new and historical records, the system uses the value from this field during depreciation calculations. You can perform depreciation calculations multiple times within the same accounting period.

If you have made no manual corrections to critical fields (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.

The system computes annual depreciation by multiplying 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 Curr Depr Yr field. The system does not re-set the value in this field to zero during the period close process.

Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after you have begun depreciating this record to avoid unexpected results.

There is no corresponding Asset Template field.

Preprocessor Default Rules:

• If this field is NULL in the input file/table and in the Template, and any Other Book’s Depreciation Method Code is not NULL, (that is, Bx_DEPR_MTHD_CD is not NULL), insert a zero (‘0‘), since NULLs are not permitted by the system for this field.

This optional field (B2_TOT_CST_AMT) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Settings screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This field for Book 2, as applicable, holds the optional total cost amount entered for this record. The value cannot exceed 999,999,999,999.99 and this field can be populated by manual entry. Although this field is optional to save an Asset Master record, the system cannot compute depreciation if cost data is missing.

There is no system requirement that the cost for any optional books used be identical to the cost value used for Book 1 (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.

When you first add and save an Asset Master record, the G/L Book Total Cost value displays as the default total cost for all optional books. If you add, edit, or delete the G/L Book Total Cost value, the system will display a message that will ask if you want to update the Total Cost of the Other Book(s) whose cost matched the original cost. If you specify Yes, the system will copy the G/L Book Total Cost value and display this amount as the cost for all applicable optional books. The purpose of this default feature is to save you some data entry because, for the majority of users, the G/L Book cost amount is normally the same for the optional books.

There is no corresponding Asset Template field.

Preprocessor Default Rules:

• If this field is NULL in the input file/table and in the Template, and any Other Book’s Depreciation Method Code is not NULL, (that is, Bx_DEPR_MTHD_CD is not NULL), insert a zero (‘0‘), since NULLs are not permitted by the system for this field.

This optional field (B2_DEPR_START_DT) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Settings screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This field for Book 2, as applicable, holds the optional depreciation start date for this record. Data in this optional field must be in date format (YYYYMMDD) and can be populated by manual entry.

Even though data entry in this field is not required to save an Asset Master record, this field is the most important date for depreciable assets because the system uses this date during depreciation calculations. Depreciation calculations will not take place if blanks display in this field, 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 field, if desired. In this circumstance, depreciation calculations will not begin until the future date coincides with your current accounting period. The date in this field must be on or before the end of the current accounting period for depreciation calculations to take place.

For an existing asset 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.

The relationship between the data in this field and the values in the Book 2 Curr Depr Yr and Book 2 Days/Pds Remaining fields are critical to the accurate calculation of Book 2 depreciation. You can use the Compute/Update Depreciation Computation Data utility to assist you in verifying the relationship of the Book 2 Depr Start Date field to the Book 2 Curr Depr Yr and Book 2 Days/Pds Remaining fields.

Using the value in the Book 2 Depr Start Date field, 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 Curr Depr Yr and Book 2 Days/Pds Remaining fields.

Although you can print this report for all selected records, you can also print the report for exceptions only, which may make discrepancies easier to identify. After the report has printed, you can activate the option in this utility that applies the system-computed values to your asset records. This process updates the existing data in the Book 2 Curr Depr Yr and Book 2 Days/Pds Remaining fields by replacing your data and writing the system-computed values to these fields.

You should run this utility to verify (and optionally update) your data after you initialize your historical records before you compute depreciation for the first time. After initialization, you may want to run this utility on a regular basis each period as part of your company's standard procedures, to confirm that your period additions have been initialized correctly.

When you enter data for new records or for historical records during the initialization process, there are no system restrictions regarding the appropriateness and/or accuracy of the start date. Because of the important relationship between the start date and the data in the Book 2 Curr Depr Yr and Book 2 Days/Pds Remaining fields, however, in most cases you should enter the date at which depreciation originally began for this record.

There is no corresponding Asset Template field.

This optional field (B2_IN-SERVICE_DT) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Settings screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This field for Book 2, as applicable, holds the optional in-service date entered for this record and data in this optional field must be in date format (YYYYMMDD), and this field can be populated by manual entry.

This date is for information purposes only and is not used in system calculations. (When the system calculates depreciation, the system checks only the date from the G/L Book Depr Start Date field.) The optional date in this field can be a historical, current, or future date.

There is no corresponding Asset Template field.

This optional field (B2_ CUR_DEPR_YR_NO) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Settings screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This field for Book 2, as applicable, holds the current depreciation year for the Asset Master record. The value (and format) cannot exceed 2 numeric characters (99) and the data can be populated by manual entry.

The current depreciation year, along with data in the Book 2 Days/Pds Remaining and Book 2 Depr Start Date field, plays an integral role in the system calculation of depreciation. The value in this field 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.)

For a new asset record, blanks normally display in this field as a default. You can leave this field blank, if desired, because the system will insert 1 in this field 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 desired. If you enter a value in this field, however, you must also enter a value in the Book 2 Days/Pds Remaining field, or you will not be able to save the asset record.

This field must be blank for the system to populate it with a 1 the first time that depreciation is calculated for this record. If you have entered any number in this field, the system will not replace your entry during depreciation calculations. Although this field is not required, system calculations cannot take place if you have overwritten the system-populated value in this field 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.

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 (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.

For both new and historical records, once this field is initialized, the system increases the value in this field 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 Days/Pds Remaining field displays a 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 Days/Pds Remaining field will also change appropriately.

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 Curr Depr Yr and Book 2 Days/Pds Remaining fields. You can print the report for all selected records or for exceptions only, which makes discrepancies easier to identify.

After printing the report, you can activate the option in this utility that applies the system-computed values to your asset records. This process updates the existing data in the Book 2 Curr Depr Yr and Book 2 Days/Pds Remaining fields 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 Curr Depr Yr and Book 2 Days/Pds Remaining fields (or, in some cases, the Book 2 Depr Start Date field) 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 agree with the system data changes that will take place in each Asset Master record.

Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after the system has already posted depreciation to the G/L to avoid unexpected results.

There is no corresponding Asset Template field.

This optional field (B2_ PDS_REMAIN_NO) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book on the Configure Fixed Assets Settings screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This field for Book 2, as applicable, holds the number of periods or days remaining, as applicable, in the current depreciation year for the Asset Master record. The format cannot exceed 3 numeric characters (999) and the data can be populated by manual entry.

The days/periods remaining field, along with the Book 2 Curr Depr Yr and Book 2 Depr Start Date fields, plays an integral role in the system calculation of depreciation. The value in this field 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 record, blanks display in this field as a default. You can leave this field blank, if desired, because the system will insert the correct value in this field 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 field. If you enter a value in this field, however, you must also enter a value in the Book 2 Curr Depr Yr field, or you will not be able to save the asset record. The value in this field will depend on the Date of Purchase or Fiscal Year basis assigned to the depreciation method for this asset.

• If you have linked a Date of Purchase basis for depreciation method with this record, the value in this field should reflect the number of days or periods remaining in the current purchase year, depending on the option you selected in the System-Wide Configuration for DP Basis Depreciation Methods group box on the Configure Fixed Assets Settings screen.
• If you have linked a Fiscal Year basis for depreciation method with this record, the value in this field should reflect the number of periods remaining in the current fiscal year. The number of periods remaining cannot be more than 18.

This field 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 field, the system will not replace your entry during depreciation calculations. Although this field is not required, system calculations cannot take place if you have overwritten the system-populated value in this field with blanks. The reason for this is that the system cannot depreciate correctly for the current period if the Book 2 Days/Pds Remaining field is not specified.

For both new and historical records, once this field is initialized, the system changes this value, as required, during the Fixed Assets period close process. The system increments the current year during the closing process if there are additional years of useful life remaining for the record, and the Book 2 Days/Pds Remaining field displays a 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 Days/Pds Remaining field will also change appropriately for the basis used (Date of Purchase or Fiscal Year).

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 Curr Depr Yr and Book 2 Days/Pds Remaining fields. You can print the report for all selected records or for exceptions only, which makes discrepancies easier to identify.

After printing the report, you can activate the option in this utility that applies the system-computed values to your asset records. This process updates the existing data in the Book 2 Curr Depr Yr and Book 2 Days/Pds Remaining fields 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 Curr Depr Yr and Book 2 Days/Pds Remaining fields (or, in some cases, the Book 2 Depr Start Date field) 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 agree with the system data changes that will take place in each Asset Master record.

Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after the system has already posted depreciation to the G/L to avoid unexpected results.

re is no corresponding Asset Template field.

This optional field (B2_ DP_DEPR_YTD_AMT ) is only available in an Asset Master record if the asset is depreciable and you have already initialized this book in the Fixed Assets Setting screen.

Unlike the G/L Book (Book 1), in which you can designate that depreciation be based on Y (Years), L (Lease Periods), or U (Units of Usage), depreciation methodology for this optional book can only be based on years.

This field for Book 2, as applicable, holds the dollar amount of depreciation recorded for the current purchase year, exclusive of any amounts recorded during the current accounting period. The value cannot exceed 999,999,999,999.99, and the data can be populated by manual entry.

This field is available 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.)

If the method from the Book 2 Depr Method Code field on this screen references a method that uses a Date of Purchase basis, this field is available.

If the method from the Book 2 Depr Method Code field on this screen references a method that uses a Fiscal Year basis, this field is not available.

The amount taken purchase YTD, along with data in the Book 2 Curr Depr Yr and the Book 2 Days/Pds Remaining fields, plays an integral role in the system calculation of depreciation for methods using the Date of Purchase basis.

For a new asset record, no data should display in this field. You should leave this field blank for a new record because the system will increase (or possibly decrease) the value in this field by the amount of depreciation recorded to history each time you close the Fixed Assets period.

The value in this field will be different from the value in the Book 2 FYTD Depreciation field except when the date of purchase coincides with the start of your fiscal year. The Book 2 Amt Taken Purchase YTD field displays purchase year data, while the Book 2 FYTD Depreciation field displays fiscal year data.

During the initialization of your historical records, for records linked to depreciation methods that use the Date of Purchase basis for depreciation, you should enter the correct value in this field for the current purchase year of the asset.

r both new and historical records, once this field is initialized, the system will automatically change the value in this field by the total amount of depreciation recorded for the current accounting period when you perform the Fixed Assets Period Close process. Once each purchase year is complete, the system automatically resets the value in this field to zero, as appropriate.

This utility will verify/update Asset Master data only for books in which the assigned depreciation method uses a Date of Purchase basis and whose depreciation start date is prior to the current Fixed Assets posting Fiscal Year, Period, and subperiod. (For assets in the first period of a purchase year, the Book 2 Amt Taken Purchase YTD value will be set to zero.)

In the Asset Master record, the system displays the Book Name that you established for this book on the Configure Fixed Assets Settings screen as part of the label for this field. For example, if you established “Tax” as the name for Book 2 on the Configure Fixed Assets Settings screen, the system will display “Tax Amt Taken Purchase YTD” as the label for this Asset Master record field.

Although the system permits you to edit the data in this field in an Asset Master record as you choose, use caution if you make changes to this field after the system has already recorded depreciation to the history table to avoid unexpected results.

There is no corresponding Asset Template field.

Preprocessor Default Rules:

• If this field is NULL in the input file/table and in the Template, and any Other Book’s Depreciation Method Code is not NULL, (that is, Bx_DEPR_MTHD_CD is not NULL), insert a zero (‘0‘), since NULLs are not permitted by the system for this field.

Please refer to the documentation for the Book 2 (Or Your Label) Depr Method Code field.

Please refer to the documentation for the Book 2 (Or Your Label) Useful Life field.

Please refer to the documentation for the Book 2 (Or Your Label) Auto Calc field.

Please refer to the documentation for the Book 2 (Or Your Label) Salvage Percent field.

Please refer to the documentation for the Book 2 (Or Your Label) Salvage Value field.

Please refer to the documentation for the Book 2 (Or Your Label) FYTD Depreciation field.

Please refer to the documentation for the Book 2 (Or Your Label) Prior FY Depreciation field.

Please refer to the documentation for the Book 2 (Or Your Label) Current Pd Depreciation field.

Please refer to the documentation for the Book 2 (Or Your Label) Annual Depreciation field.

Please refer to the documentation for the Book 2 (Or Your Label) Total Cost field.

Please refer to the documentation for the Book 2 (Or Your Label) Depr Start Date field.

Please refer to the documentation for the Book 2 (Or Your Label) In-Srvc Date field.

Please refer to the documentation for the Book 2 (Or Your Label) Curr Depr Year field.

Please refer to the documentation for the Book 2 (Or Your Label) Days/Pds Remaining field.

Please refer to the documentation for the Book 2 (Or Your Label) Amount Taken Purchase YTD field.