Adding or Deleting Asset Values Using the Review Assistant
The FAM Diagnostics portlet checks for assets without an Asset Values record. Click Review Assets to open the Review Assistant and download a CSV file with the asset details. You can review and modify the assets in the file as needed. After uploading the file back to the Review Assistant, you can choose to delete or add asset values.
Review these guidelines before uploading your CSV file:
-
If you are adding asset values, fill out all the columns in the CSV file. If you are deleting asset values, only the Internal ID column is required.
-
Ensure that the dates and numbers in the CSV file match the format specified in the General Preferences page. Check the system date and number format in Setup > Company > General Preferences.
-
If the CSV file has multiple entries with the same asset internal ID, the system processes them as follows:
-
Entries that fail the validation process are skipped.
-
If only one entry passes the validation process, it's processed normally. Otherwise, the system displays a duplicate error.
-
-
If an asset in the CSV file already has an Asset Values record, the system doesn't process it.
-
Ensure that your CSV file does not exceed 10 MB.
To add or delete asset values:
-
From the FAM Diagnostics portlet, click Review Assets.
-
On the Review Assistant — Step 1 screen, do the following:
-
Click Download CSV to save the list of assets with no asset values record.
-
Click Next.
-
-
On your computer, open the CSV file that you downloaded, and enter values in the following columns:
-
Internal ID — If this field is blank, enter the internal ID of the asset.
To display internal IDs, check the Show Internal IDs box under the General subtab at Home > Set Preferences.
-
Current Net Book Value — Enter the current net book value (NBV). The current NBV is calculated as the original cost minus accumulated depreciation and write-down amounts.
-
Last Depreciation Period — Enter the period number (within the asset's useful life) in which the asset was most recently depreciated.
-
Last Depreciation Amount — Enter the amount of the asset’s most recent depreciation.
-
Last Depreciation Date — Enter the date of the asset’s most recent depreciation.
-
Prior Year NBV — Enter the asset original cost if the transaction date is within the asset’s acquisition year. Otherwise, enter the net book value as of the end of that year.
-
-
On the Review Assistant — Step 2 screen, do the following:
-
Click Choose File.
-
Select the CSV file that you updated in the previous step.
-
Click Next.
-
-
On the Review Assistant — Step 3 screen, do the following:
-
Select the action to apply to the assets in the CSV file:
-
Delete Assets — Select this option to delete the assets.
-
Add Asset Values — Select this option to add asset values.
-
-
Click Finish.
A popup window displays a confirmation message. Click OK to continue.
-