Delete Duplicate Acquisition Records of Fixed Assets

Written by
Carmela Batalla
Published on
January 30, 2024 at 7:40:05 AM PST January 30, 2024 at 7:40:05 AM PSTth, January 30, 2024 at 7:40:05 AM PST

Scenario

User is trying to delete duplicateAcquisitionrecords ofFixed Assets.

Solution

1. Create aSaved Search


a. Navigate to List>Search>Saved Searches>New
b. Click FAM Depreciation History
c. Search Title: enter search title
d. Click Criteria
e. Click Standard
f. Select Filter:
* Transaction Type: Acquisition
g. Click Add
h. Click Results
i. Click Columns
j. Select Fields:
* Internal ID
k. Click Add
l. Click Save & Run


2. Export search results by clicking the Excel icon

3. Modify exported file and retain those lines with duplicate acquisition records
4. Import file via CSV


a. Navigate to Setup>Import/Export>Import CSV Records
b. On the Import Assistantpage, select:
* Import Type: Custom Records
* Record Type: FAM Depreciation History
c. Select CSV file
d. On the Data HandlingOption, selectUpdate
e. Map fields:
* Internal ID: Internal ID
* Null: Asset
f. Import Map Name: enter Import Map Name
g. Click Save & Run