You can’t use script parameters to control a scheduled script like you’re trying to. When a scheduled script is executed, NetSuite takes a snap shot of the Script parameter values and that’s all the script can access during that invocation.

runtime.getCurrentScript().getParameter()

Is looking up values from this snapshot. When it’s started over it will pick up any changes to params. For what you want to do you’re better off with a custom record handling your runtime control, then the script fetches that single record at whatever frequency appropriate. Mind you, this is a bad practice to be hammering the database like that, but not too bad as custom record access is fast, especially considering you can use search.lookupFields

I was thinking if there was a way to use the session state repo for this, but the scheduled job will run as System and the SuiteLet (What I was thinking could serve as a control panel) will run as a user. Maybe a SuiteLet that ran a scheduled job to set the session value, but Yuck! – that would be pretty ugly.

Sorry, I read your post a few times and have no idea what you’re trying to do or what is what. I know SuiteFlow, but can’t follow your explanation. Also, that field ID isn’t valid.

If you’re stuck with Access you’ll need a process that can run on the machine hosting access and push data to NetSuite via RESTlet or web services. If you can sync your access data to a web-accessible SQL server (MS SQL, MySQL, etc.) then you can use something like Celigo Integrator IO to push the data to NetSuite. If you can tolerate some degree of manual processing, you can export your Access data to CSV and then perform CSV imports into NetSuite, or once again use a Data Loader with Celigo Integrator IO if you need a rich toolset to handle mapping and transformation.

 

Sure, this is easy to do. The field you want to use is

createdfrom

which by itself will display the format “Sales Order #nnnnn” (or something similar. If you want to show only the transaction number you can use createdfrom as a join:

createdfrom.tranid

Use the NetSuite Record Browser as a reference for field names and available joins.