Hi everyone. I'm trying to make a SuiteQL query to find the Item Fulfillment records that were created from a given Sales Order. I've tried querying using the createdFrom field on the Item Fulfillment but it tells me that field is an unknown identifier. Has anyone been able to do this? The query string I've tried is:

SELECT * FROM Transaction WHERE CreatedFrom = '{Sales Order Id}' AND type = 'ItemFulfillment'

I think that something like this may be what you are looking for?

SELECT
    *
FROM
    Transaction
JOIN
    PreviousTransactionLink ON
        PreviousTransactionLink.nextdoc = Transaction.id
WHERE
    recordType = 'itemfulfillment'
    AND
    PreviousTransactionLink.previousdoc = '{SalesOrderID}'

@Bailey Feldewerd That is returning exactly what I was looking for. Thank you so much!! I hadn't read anywhere about the PreviousTransactionLink. Awesome. Thank you.

Are you using the Rest API?

Yes

I think if you do the following you can get the packages /record/v1/itemFulfillment/{the Id of one of the returned Item Fulfillments}/package

I tried that and /shipmentPackage too and both return no items. I've never been able to get requests to the urls in those links fields like those to return stuff.

Hmm, I'm not too familiar with the Rest API.

All good! Thanks for being helpful and trying when you didn't have to.

You may have already found these, but if not they might help @John Phillips https://timdietrich.me/blog/netsuite-suiteql-shipments/ https://timdietrich.me/blog/netsuite-suiteql-item-fulfillments-pacejet-packages/