Copy an Active depreciation schedule for a different asset

This option provides an easy way of setting up depreciation schedules for a group of assets with common attributes; e.g. if you purchase 50 computers that are the same, you can set up the depreciation schedule for the first computer, and then copy that schedule for the remaining 49.

1. At the Asset Management main menu, select Assets / Asset Level Depreciation | Depreciation Schedules. The Depreciation Schedules By Asset Number display screen appears.
2. Right-click on the schedule to copy and select Copy. The Copy Asset Depreciation Schedule enter screen appears.
3. Fill in the fields as required.

   Same Asset, Different Type of Depreciation- set this to No. It identifies whether or not the new depreciation schedule should be for the same asset as the one being copied.

   Templatedoes not apply to this type of copy.

   Schedule Typedoes not apply to this type of copy.

   New Schedule's Capital Amountdoes not apply to this type of copy.

   New Schedule's Initial Residualdoes not apply to this type of copy.

   Range of Assets, Same Type of Depreciation- set this to Yes. It identifies whether or not the new depreciation schedule(s) should be for a range of other assets, using the same type of depreciation schedule. In this process, you are able to create the same type of depreciation schedule for all of the assets in the range.
        Screen Flow:
        - Copy Asset Depreciation Schedule -> Asset Number Mask -> Copy Depreciation -> Copy Depreciation for Asset Range -> Select Capital Transactions for Copy Depreciation Schedule.
        - The second and fourth screens are optional, depending on the number of assets assigned to each unit.

   Asset Number Range From/Toare the beginning and ending assets in the range for which depreciation schedules should be created. You can click on the Prompt button to select the assets from a list.

   If Available, Use Copy To Asset's Postable Schedule Capital Amountidentifies whether or not to use the postable schedule capital amount on the copy to asset(s) as the depreciation amount on the new schedule(s).
        When copying a non-postable schedule, you have the option of using the capital amount of the "to" asset's postable depreciation schedule. When you do this, the capital transactions cross-reference file will be updated to show that the same capital adjustments have been applied to the new non-postable schedule.
        When copying a postable schedule, the capital amount will be set using the sum of unapplied capital adjustments for the assigned unit. There are options to change the capital amount during the process.

   This is a Tax Depreciation Schedule, Should the Residual Amount by Zeroidentifies whether or not the residual amount should be set to zero for the new depreciation schedule(s).

   Exclude Secondary Assets- if you are copying from a primary asset depreciation schedule, this identifies whether or not to exclude the same kind of depreciation schedule for the secondary assets in the asset number range.

   Exclude Primary Assets- if you are copying a secondary asset's depreciation schedule, this identifies whether or not to exclude the same kind of depreciation schedules for the primary assets in the asset number range.

4. If the message "Asset Number Masking is required to exclude other secondary assets" appears:

   If you have several assets assigned to the same unit, the first copy screen will recommend when you should use a "mask" on the asset number for excluding certain assets. For example, units 06003002 through 06003011 each have three assets assigned to them. There are a primary asset for the unit itself, and two secondary assets for a GPS system and a satellite communications system. Using the first units as an example, its assigned asset numbers are set as follows:

   • Primary asset: 06003002
   • Secondary asset for GPS: 06003002-GPS
   • Secondary asset for satellite communications: 06003002-SAT

   If we have set up depreciation schedules for the assets assigned to unit 06003002 and then want to copy them for the remaining assets for units acquired on the same equipment PO, the message "Asset Number Masking is required to exclude other secondary assets" will be displayed when you are copying a secondary asset's depreciation schedule and there are other secondary assets assigned to the unit to which the copy from ass et is required.

   So, if you are copying the postable schedule for asset 06003002-GPS to assets 06003007-GPS through 06003008-GPS, you would see this message because asset 06003007-SAT is also assigned to unit 06003007. You would then set the asset number mask to tell the system which assets in the range should get the new schedule.

   If you don't set the asset number mask, you will get a new depreciation schedule for any other assets that fall in the range. You would end up with the same kind of depreciation schedule for the other asset(s), but this schedule will remain in Entered status.

   1. Click Set Asset Number Mask . The Asset Number Mask - Copy Depreciation screen appears.
   2. To identify the character positions in the mask that have a consistent value for copying the depreciation schedule, put the character "D" in the positions where you are storing special characters to identify each kind of secondary asset. This tells the program that the characters in these positions of the from asset must match each of the to assets before creating a new depreciation schedule. Note that the masking logic only looks for the capital letter "D".
   3. Click Enter . You will return to the Copy Asset Depreciation Schedule enter screen where you will see a new message underneath the asset number range fields.
5. Click Enter . The Copy Depreciation for Asset Range enter screen appears to show you what the system will be assuming in the copy. The text below the copy options explains how the capital amount, initial residual value, and depreciation start date will be set for your new schedules.
6. To review and select capital transactions for the capital amount of your copy-to schedule:

   Taking this action is advised if you purchased more than one secondary asset for each unit. If you don't use Select Capital Amount, the first secondary asset may end up with the full amount of all unapplied capital transactions for the unit.

   When all of the assets were acquired on the same equipment PO, Select Capital Amount will show you the capital transaction that was used for the copy-from asset depreciation schedule. If the copy-to assets were acquired on a different equipment PO, Select Capital Amount will show you the unapplied capital transactions for the first asset in the copy-to range of asset numbers.

   1. Click Select Capital Amount . The Select Capital Transactions for Copy Depreciation Schedule display screen appears.
   2. To select a capital transaction, right-click on the transaction and select Select. An asterisk appears in front of the transaction.
   3. To deselect a capital transaction, right-click on the transaction and select Deselect. The asterisk is removed from the transaction.
   4. To view the schedules a transaction has been applied to, right-click on the transaction and select Applied to Depreciation Schedules. The Applied Schedule List display screen appears.
   5. To confirm that your selections are complete, click Selection Completed . You return to the Copy Depreciation for Asset Range screen.
7. To perform the copy, click Confirm Copy Options .
   • A job is submitted to copy depreciation schedules for the asset number range requested, and a message is displayed indicating that the copy job has been submitted.
   • The batch job will create new schedules for valid assets -- assets that are defined in the Asset Master file -- where the "to" asset does not already have such a depreciation schedule.
   • If the schedule type is postable, all entries for the target assets will be marked as Not Posted.
   • The start date and status of the target schedules will be determined by the assigned unit revenue start dates:
   • • If the unit does not have a revenue start date, the resulting schedule will remain in Entered status; i.e. no detail records will be created.
     • If the unit has a revenue start date, the resulting schedule will be set to Active.
   • Depreciation schedules for the target assets will be created by calculating the schedule from scratch. The result of this will be that the target schedule will not reflect any adjustments that may have been made to the source schedule.

Back to Asset Depreciation