Use PDIs? Take our 5-minute survey to help shape the PDI roadmap.

Bulk Import of Assets and link it to a PO number so that procurement cycle is also followed

LearnerSN
Tera Contributor

How to bulk import assets in alm_hardware table and link it to PO so that procurement cycle is also not skipped.

1 REPLY 1

Jill N
Tera Expert

Assuming you are not using the Purchase order module in ServiceNow (if you're using that it should auto-correlate the PO and PO Line to the asset upon receipt).

 

To perform a bulk asset update in ServiceNow, create an Import Set template that includes the key fields needed to identify each asset, such as Serial Number, Model, Model Category, State, and Substate. Then add any additional fields you want to update, such as PO Number, Vendor, Cost, Invoice Number, Purchase Date, or other asset attributes.  See attached sample of an asset upload template.
 
The bulk upload process uses an Import Set and Transform Map, where the Serial Number can be configured as the coalesce field to match existing asset records. During the transform, ServiceNow updates the matched assets with the new information, allowing missing or outdated purchase and procurement data to be populated efficiently without manually updating each asset. This approach is commonly used for large-scale updates to asset records and procurement information