Revert full disposals in bulk—Fixed Assets Management

You can use the import service to revert multiple full asset disposals at once.

Reverting a full disposal does the following:

• Deletes the related full disposal journal entries.

• Removes the full disposal record from the asset's Disposals tab and each depreciation schedule.

• Changes the state of Canceled depreciation entries to Not posted.

• Changes the asset's state to In service.

Before you begin

Verify the following:

• The disposal date is in an open period. If it's in a closed period, you must manually reverse the journal entries and recreate the asset as a historical asset. Contact your account manager for further assistance.

• The asset is in the Disposed state.

• The asset is active.

Step 1. Create a custom list view

1. Go to Fixed Assets Management > All > Assets.

2. Set the filter on the State column to Disposed.

3. At the top right of the page, select Settings > Configure columns.

4. Select the following columns:

   • Asset ID

   • State

   You can include other fields, but these are the only ones needed for this task.

5. Select Manage view > Save as.

6. Enter a name for the view.

   For example, "Bulk revert full disposal".

Step 2. Export the custom list view

1. Go to Fixed Assets Management > All > Assets.

2. From the views dropdown at the top left, select the view you created for export.

3. Optionally, filter the list to show only the assets that you want to update.

4. At the top right of the page, select Export > Excel.

Step 3. Update the exported file

1. Open the Excel file that you exported.

2. Delete rows for any assets that you do not want to update.

3. Change the values in the State column to In service.

4. Save the file.

Step 4. Import the updated file

1. Go to Company > Setup > Import data.

2. Select New import service.

3. Find the Fixed Assets Management section.

4. Next to Assets, select Update.

5. Upload your file.

6. Verify that the fields are mapped correctly.

   Learn about mapping fields.

7. Select Complete.

8. If there are any errors, review and correct your data.

   Learn about fixing errors in the import service.

9. Select Import.