Bulk Editing of Critical Depreciation Fields
Description
Cause
Resolution

Important Information

  • Bulk Edit can only change Depreciation Method and Estimated life. For other fields, see How to change critical depreciation fields.
  • You only have Bulk Edit available in Sage Fixed Assets Depreciation, Depreciation Network and Premier Depreciation products. It’s only for U.S. Companies.
  • If you see Bulk Edit grayed out, it's disabled in password security. See How to set up Password Security.
  • To limit assets impacted by Bulk Edit, you can create a group. See How to create a group.

Bulk Editing

  1. Perform a back up before proceeding with the next step. The only way to undo bulk edit is to restore your backup.
  2. Open your company and go to Depreciation, Bulk Edit.
  3. Welcome: If you have a current backup of your data, check I have a current backup and click next.
  4. Groups and Books: Select the desired Group and Books and click Next.
  5. Fields to Edit: Check the fields you want to change. Make the desired value selections in the From and To dropdowns. Click Next.
  6. Effective Date: Select when you want the change to take effect. Ensure you know and understand the effects of your selection.
    • Placed-in-Service Date: Clears all depreciation and beginning information from the asset. 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
    • Current Thru Date: All current depreciation information will move into the beginning fields.
    • Only change assets with a Current Thru Date of: Limits changes to only assets with the selected date type.
  7. Validation:
    1. Click Validate to pull the validation report.
      • Valid: The asset will change.
      • Warning: The asset will change, but you can see other effects or issues later. For example, removal of 168 Allowance amounts.
      • Error: The asset can’t change to the selected values.
    2. Review the report and click Execute. The program will create a report showing changes made.
      Note: Re-run Depreciation before seeing changes on reports.



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

 

Steps to duplicate
Related Solutions