Hi

I am trying to update a custom field in opportunities.  I want to set this to be a copy of the forecast type field.  I need this so I can group opportunity reports by forecast type.  Netsuite does not make this field available in reports but I can see this custom field.

I have under 1000 opportunities to update like this and I wanted to do it with a script to avoid doing it manually.  For new opportunities, I have client script that does the job.

My script is below and works (it is a testing version, if I can overcome the usage restrictions then I will expand it to set alll forecast types, not just upside ones)  I am using a pre-made search (213) to drive it.