Sorry, I spoke too soon. Using your formula above will still result in negative qty if PREFERRED STOCK LEVEL (37) plus BACK ORDERED (50) minus ON ORDER (96) is less than 0.

Coffeeguy, That fixed it! Thank you for your help.

Shamaine, Thank you for your suggestion. Unfortunately I tried those fields before and they did produce the desired result of including results which the sales order had no related / linked purchase order.

OMG !!! It worked !!! Thank you so much!!! You made my Friday.

Thank you for your help. Your proposed solution with Express Entry will work.

Thank you. That explains why I could not find it while trying to create a WorkFlow.

I have succeeded in my task for the first part. See first 2 pics. What I am having difficulty doing now is to replicate that action for the SALES DESCRIPTION on the System Information tab. See 3rd pic. . 

Pauline Joy Cac-Oracle, This is on a part numbers. Fields: purchasedescription and salesdescription For Instance, when a new part number is entered into NetSuite, I want to be able to enter the description only in the purchasedescription field and have that description automatically copied into the salesdescription field.

AWESOME! That fixed it. Thank you so much for your help!

That is correct: The Standalone invoices are not pulled out by the search right?

Fantastic! You solved my issue Thank you so so much!

Your suggestion was a success! THANK YOU OH SO MUCH!!!

Thank you for replying. We do have Advanced Bill of Materials enabled.