How to perform a Bulk Edit of Critical Depreciation Fields

CAUTION: Use caution when working with the below product functionality. Always create a backup of your data before proceeding with advanced solutions. If necessary, seek the assistance of a qualified Sage business partner, network administrator, or Sage customer support analyst.

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.