This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

The item receipt has an `orderline` field which relates to the `line` on the PO

Thanks! That's very interesting, and would solved the mapping from item receipt line to po line. Any idea if there is a similar way to map the vendor bill line with either the PO line or the item receipt line?

I see that the Vendor Bill also has an `orderline` . Does that one relates to the PO? I am going to try to determined that through testing.

<@U5TF1GQ20> do you think this mapping would achieve the same as the custom column solution?

depends on what your needs are, i wouldnt expect it to work on longer transaction chains, but if you only need to support transaction that are one level away from the parent, it should work fine

This field is not documented by NetSuite and only points from item receipt to purchase order line or from item fulfillment to sales order line. The field it points to is the {line} field -- I have a function ready that finds the related line - let me know and I can share it with you.