Bulk Import of Assets and link it to a PO number so that procurement cycle is also followed
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11 hours ago
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
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10 hours ago
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