About Mass Generating Depreciation Schedules

Note:

We recommend generating depreciation schedules for multiple assets using a fixed asset process. For more information, see Fixed Asset Process Management Overview.

You can generate depreciation schedules for multiple assets simultaneously by clicking the Generate Depreciation Schedules button on the Fixed Asset Batch Jobs tab.

The process generates depreciation schedules for all depreciation books where schedules have not already been generated, provided that assets have a status of Active or Approved.

You can also choose to regenerate depreciation schedules for depreciation books where schedules have been generated but not exported. Again, only assets with a status of Active or Approved are processed.

When you run the generate process:

  • You do not need to supply any parameters for an accounting or MACRS tax book. Depreciation is automatically calculated for the entire life of the asset.
  • You need to supply the Period Start Date and the Duration (6 months, 12 months, remaining service life) for a tax or custom book. If no Period Start Date is supplied, a default date is used as explained below.

Depreciation schedules generated by this process are given the status of Pending.

If depreciation schedules cannot be generated for a particular asset book, an error is logged and that book is skipped. See 'Log Information' below for details of how to review the logs.

Note:

If you encounter platform limits when running this process, try lowering the value for Depreciation Book Batch Limit in the Fixed Asset Management Batch Settings custom setting. See Fixed Asset Management Custom Settings for more information.

How the default Period Start Date is determined for Tax and Custom Books

When generating depreciation schedules for a tax or custom book, a Period Start Date is required. If you do not supply one, it is defaulted as follows:

  • If there are no existing depreciation schedules it defaults to the Date in Service.
  • If there are existing depreciation schedules it defaults to the day after the end of the last depreciation schedule unless you have chosen to replace existing schedules and the status of the existing schedules is Pending - in this case it defaults to the Date in Service.

Log Information

The process to mass generate depreciation schedules runs as a batch Apex job. You are notified by email once the job has completed. A link in the email takes you to the batch job record where you will find individual logs for the assets and depreciation books that were processed. You must review these logs and resolve any errors before attempting to repeat the process.

Note:

If a batch job fails because of a system error, you must delete the failed batch process before another batch job can run. To delete a failed batch process, go to the batch job record then follow the link in the Batch Process field and click the Delete button on the page that is displayed.

Batch logs are deleted automatically once the number of batches stored exceeds the Number of Generate Batches to Keep in the Fixed Asset Management Batch Settings custom setting. They are deleted on the basis of oldest first.