Coupa Spoke

[AmolJ]

We need to get the purchase order from Coupa (either from Purchase Order module or Receipt module or any other module like ASN) and marry it up to the Serial Number field on the alm_asset table so each asset record has appropriate purchase order number.

Is there a one-to-one mapping of serial number and purchase order number anywhere in Coupa that can be used in this scenario?

[Marcos Gianoni]

The most effective solution is to integrate Coupa Receipt data directly into the ServiceNow alm_asset table using the Coupa IntegrationHub Spoke.

Direct Solution Steps

1. Data Source: The reliable link (Serial Number to PO Number) is captured in Coupa Receipt Line Items or ASN records during goods receiving.

2. Tooling: Use a Flow Designer flow with the Coupa Spoke actions to pull the receipt data.

3. Mapping: Configure an Import Set and Transform Map targeting the alm_asset table.

4. Critical Mapping: Map the Coupa Serial Number $\rightarrow$ ServiceNow serial_number and the Coupa PO Number $\rightarrow$ ServiceNow po_number.

5. Coalesce: Set the Serial Number field as the Coalesce key in the Transform Map to ensure the asset record is uniquely identified and updated or created correctly with the associated PO number.

This approach automates the process based on validated receiving data, providing a robust one-to-one (or one-to-many, if multiple items share a PO) link.

[AmolJ]

Thank you Marcos, I will give it a go.