source Paired Intercompany Transaction PO from sales order on item fulfillment

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you are trying to source a Paired Intercompany Transaction Purchase Order (PO) from a Sales Order on Item Fulfillment. In NetSuite, once an Item Fulfillment record is created, the paired transaction cannot be edited. This is a native behavior of NetSuite. If you need to make changes, you would have to unpair the transactions, which could mean replacing all the lines with non-inventory items. However, you can use SuiteQL to read an Item Fulfillment and get the PO. The PO is on the Sales Order (otherrefnum). Here is a rough example of how you might do this:

sql
SELECT
    Transaction.type,
    Transaction.trandate,
    Transaction.number,
    Transaction.shippingaddress,
    TransactionLine.item,
    TransactionLine.quantity
FROM
    PreviousTransactionLink
    INNER JOIN Transaction ON 
        (Transaction.ID = PreviousTransactionLink.nextdoc)
    INNER JOIN Transactionline ON 
        (Transactionline.transaction = Transaction.id)
WHERE
    PreviousTransactionLink.previousdoc = 1317801
    AND PreviousTransactionLink.linktype = 'ShipRcpt'

Please replace

1317801

with your actual transaction ID. This query joins the

PreviousTransactionLink

table with the

Transaction

and

TransactionLine

tables to get the details of the transaction. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******