Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
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.
0