Process new cost inserts in one batch without lookups. This will create individual costs without attention to duplicates.
Process updates to costs in another batch while using the cost id (created when the costs were added) as a lookup key.
Note: The costid must be known to update the cost record. The costid is an integer value in the arg_costdet table of the mdb.
To extract the costid from the database.
- Run an advance search in the UAPM GUI choosing the following fields to display in the results. All of these fields are not needed, but they will help identify the cost records.
asset serial number
asset cost cost type value
asset cost Begin date
asset cost Unit amount
asset cost cost id
- Export the results to csv.
- Incorportate the costid into the source import csv file.
- Use the costid as a lookup key in the mapping.