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

Is it possible to store the related PO in a custom  field in the vendor bill where it was created from via workflow? There is no created from field, so not sure how it's gonna be picked up.

Yes you can use a formula of {appliedtotransaction.internalid} in your set field value action


Actually you might need to do 
CASE WHEN {appliedtotransaction.type} = ‘Purchase Order’ THEN {appliedtotransaction.internalid} END

I think sometimes it considers item receipts as applied to because of the 3 way match

Also probably best to do as After record submit

You can have several POs applied to the same bill, so that's why you don't have that field. No 1to1 relation. You have the PO sublist instead

You can play around with the lines though, they are just from one PO

Thanks. I'll try that. We only have one PO per bill so it's not a problem.