To update the Current Net Book Value of the newly imported Fixed Assets

The Cumulative Depreciation and Net Book Value fields were not populated after importing new Asset Records. Upon checking the Asset Values List, Asset Value Records were not created for the Asset imported. 

Solution

The missing values usually happen when the Run Server SuiteScript and Trigger Workflows are not marked under the Advanced Options during the CSV import of the Asset. To show the missing values of the Cumulative Depreciation and the Current Net Book Value, we may follow the steps below:

Navigate to Customization > Scripting > Script Deployments

On the Filters region, set all the filters to -All- except for the filter Script

On the filter Script, select FAM Migrate to Precompute SS

 Click on Edit

Set the following:

  • Status = Not Scheduled
  • Schedule = Single Event

Hover to Save and click Save and Execute

Navigate to Fixed Assets > Background Processing > Status

Wait for the Migrate to Depreciation Schedule process to finish

Once finished, Global Search: FAM Asset Values

Verify if the affected asset has an Asset Value Record

Edit the imported Asset Record and populate other missing values including the Net Book Value
Note: We must enable Allow Asset Values Editing under FAM System Setup in order to edit the Net Book Value Field in the Asset Record

On the General Tab, set Depreciation Active to False

Hit Save

Verify if the Cumulative Depreciation and the Net Book Value now show in the Asset Record

Once the missing Cumulative Depreciation and Net Book Value now shows, we may then Reset the Asset Values and trigger the Precompute Depreciation Values by following the steps below:

Navigate to Fixed Assets > Setup > System Setup
Click on Reset Asset Values
Wait for the Reset Asset Values Process to finish
Open the imported Asset again and check if there are no Forecasted Depreciation History Records
Once verified that there are none, edit the Asset Record and set the Depreciation Active to True under the General Tab
Hit Save
Repeat Step 1 but this time, click on the Precompute Depreciation Values button to generate a Forecasted Depreciation Schedule

Notes
The solution is also applicable for Alternate Depreciation Records
Asset Value Record with Parent Tax Method Source will pertain to the Alternate Depreciation Record

Leave a comment

Your email address will not be published. Required fields are marked *