Discussions
How to identify the Item Receipts created from a particular Inbound Shipment using SuiteQL
We have a need to identify the Item Receipts that have been created from a given Inbound Shipment using SuiteQL.
We are able to determine the PO that an Item Receipt was created from using the createdfrom field, however, when the Item Receipt is created from an Inbound Shipment, the createdfrom field is still the PO, not the inbound shipment.
The createdfrom field on the inbound shipment identifies the PO as well, however, we need to be able to identify which inbound shipment created a particular item receipt, especially, in the case that multiple inbound shipments are created from the same PO line.