For users that would like to closely keep track of their assets by adding the Asset Descriptions and Serial Numbers to the Fixed Asset records, this can be done through a CSV Import. These changes will not affect the asset record and other ongoing processes.
Note: Before proceeding, make sure that the Run Server Scripts on CSV Import box is disabled. You can check this by navigating to Fixed Assets > Setup > System Setup > General > Asset. If this box is left checked then information such as Cumulative Depreciation, Last Depreciation Date and Last Depreciation Period will be auto populated with default values of 0.
Solution:
1. Create a CSV file with the following fields:
- Internal ID of the Asset
- Description
- Serial Number
Note: Make sure to save the file as Comma Delimited
2. Navigate to Setup > Import/ Export > Import CSV Records
a. On Scan and Upload CSV file, select the following:
- Import Type = Custom Records
- Record Type = FAM Asset
b. Select File
c. Click Next
3. On Import Options, select the following:
- Data Handling = Update
- Expand the Advance Option field, and enable the RUN SERVER SUITESCRIPT AND TRIGGER WORKFLOWS
- Click Next
4. On the Field Mapping Step, map the following fields:
- Internal ID = FAM Asset: ID
- Description = FAM Asset: Asset Description
- Asset Serial Number = FAM Asset: Asset Serial Number
5. Click Save and Run
RESULTS:
Are there any other ways you can think of to better keep track of the fixed asset records? Share them with us by commenting on the thread.
If you need help with Updating FAM Records and its Depreciation Schedule, watch this video.
CHEERS