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

Does anyone knows a good way to match IC PO Lines to IC SO Lines?

The IC SO is created via native netsuite : Manage Intercompany Sales Orders, each line on the IC SO represents a line in the IC PO it was crated from.
What would be a good way to match those lines when you have the same item and quantities in multiple lines?

The IC PO and IC SO are paired via the native field Paired Intercompany Transaction 

Does line 1 of the PO map to line 1 of the SO? If so you can use that. Just a thought there.

i can't imagine they jumble the lines up if they are created from one another. :netsuite:

My suggestion would be to create a custom live item field called unique ID and maintain it using script in IC Po and whenever IC SO created from IC PO this field will value the same. In this way you can take care it

<@U2C4P9YR3> Thanks; the only real and reliable relationship I found was that Line ID {line} from the IC PO matches the Line ID {line} of the IC SO in all the tests I ran.

<@UPJ2ST05N> Sadly, custom lines field values on the IC PO lines are not carried over to the lines of the IC SO.