Greetings one and all -- I'm seeking a means of connecting items on an Item Fulfillment with their respective originating line on a Sales Order via SuiteQL using N/query in a Suitelet. I don't see anything in the Analytics browser or on my inspection of query results in transactionline or similar tables that look to function the

orderline

field which is available in other schemas. I need this for a refactoring of an Advanced PDF rendering process which would be greatly helped by synthesizing into a single query rather than multiple searches which I knit together in Suitescript. Our production team often creates Sales Orders which repeat items on multiple lines due to differing shipment dates and/or shipping some lines from internal stock and drop-shipping others, so I need to key off the line itself rather than the item. Thanks in advance for any guidance!

In the UI of the analytics, starting at item fulfillment, you can get data from the related sales order line with '`Related Transactions Lines - Previous: Transaction' -> Transaction Line: ____`

@Sandii thanks for the reply -- do you know if that maps to the column

previouslinks

in the Analytics browser? https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/transactionline.html?mode=id

Building this via code and

N/query

would be

transactionlines.previouslinks.previousline

Great, I'll head in that direction and see what I can work out. Thanks again! 🙌

No problemo, certainly changed the naming convention from applied to or applying transaction to just next/previous.