How to perform a Bulk Edit of Critical Depreciation Fields
Description


Cause


Resolution
[BCB:1:Backup warning:ECB]

Warning: Create a backup before proceeding with this solution. There is no undo for the Bulk Edit process except restoring a backup. See How to back up a company for details.

Notes:

  • Bulk Edit can only change Depreciation Method and Estimated life. For other fields, see How to change critical depreciation fields
  • Bulk edit is only available in the Sage Fixed Assets Depreciation, Depreciation Network and Premier Depreciation products only for U.S. Companies
  • To limit assets impacted by Bulk Edit, you can create a group. See How to create a group

In Sage Fixed Assets, go to Depreciation, Bulk Edit and follow the prompts:

  1. Welcome: If you have a current backup of your data, check I have a current backup and click next.
  2. Groups and Books: Select the desired Group and Book(s) and click Next.
  3. Fields to Edit: Check the field(s) you want to change. Make the desired value selections in the From and To dropdowns. Click Next.
  4. Effective Date: Select when you want the change to take effect.
    Note: Ensure you know and understand the effects of your selection.
    • Placed-in-Service Date: Clears all depreciation and beginning information from the asset. You must recalculate assets from their Placed-in-Service Date
      • Retain Begin Info: This checkbox clears all current depreciation information except for existing Beginning information on assets. For more information see What is the Beginning Date?
    • Current Thru Date: All current depreciation information will move into beginning fields
    • Only change assets with a of: Limits changes to only assets with the selected date type
  5. Validation:
    1. Click Validate to pull the validation report.
      • Valid: The asset will change
      • Warning: The asset will change, but there may be additional effects or issues later, such as removal of 168 Allowance amounts
      • Error: The asset cannot change to the selected values
    2. Review the report and click Execute. The program will create a report showing changes made.
      Note: You must re-run Depreciation before seeing changes on reports.



[BCB:165:Chat Fixed Assets US:ECB]

Defect ID
Steps to duplicate
Related Articles