How can I identify an OOB RMA-related Shipment record created when a Shipment RMA Task is closed?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
a month ago
Hi Community,
I am working with the out-of-box RMA process in ServiceNow.
When a Shipment RMA Task is closed, the system creates a record in the following table:
sn_itam_common_shipment
I need to reliably determine, from the Shipment record, whether it was:
- Created as a result of closing a Shipment RMA Task; or
- Otherwise related to an RMA, RMA line, or RMA task.
Could someone please clarify the following?
- Which out-of-box field or reference on sn_itam_common_shipment links the Shipment record to the RMA, RMA line, or Shipment RMA Task?
- Is there an OOB relationship, related list, or dot-walk path that can be used to trace the Shipment back to the RMA process?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
7 hours ago
Hi @ajha27 ,
The relationship between the RMA and the Shipment record is maintained through the Shipment Asset record (sn_itam_common_m2m_shipment_asset).
The Shipment Asset has two relevant fields:
Source – a Document ID field that points to the originating RMA.
Shipment – a reference field that points to the corresponding sn_itam_common_shipment record.
So the relationship is:
RMA → Shipment Asset → Shipment (sn_itam_common_shipment)
When the Shipment RMA Task is closed, the Shipment Asset and the Shipment are created, and the Shipment asset record is associated with the respective RMA.
Therefore, to identify which RMA a Shipment belongs to, we can look at the Shipment Asset records associated with that Shipment and check the Source field.
