That fixed the issue with being able to run the script. I applied the same .js fix to all 4 scripts and deloyed them all. Now when creating a sales order or editing an existing one, I get the following error {"type":"error.SuiteScriptError","name":"INVALID_FORMULA_FIELD","message":"Your formula has an unrecognized field in…

Good Morning Leonard, I have disabled all scripts related to this specific process. I have not disabled all scripts that affect our sales order. It does work correctly with all of the other scripts enabled. It only fails when adding in this new script. Here are the UE and Client Scripts we currently have running on the…

This section of script only runs when creating a new sales order. Editing an existing one does not error out. That is unless I deploy the second script for "Update Custom Fields User Event Script". When doing that, it will also give the same error on trying to edit and save an existing sales order. I originally deployed…

@Leonard Mallare-Oracle I commented out everything except for the return and still get the error message. Here is the text version of what I deployed. Nothing in the deployement excecution logs either. Did I comment out one too many lines or not enough?

Hi Lenoard, The script, in txt form, is attached. It was copied and pasted from here: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section_157141180023.html Here is the screen shot of the error. It looks like it may be erroring out the instant it tries to run the script as there are no logs being created…

@Dominica Sevilla-Oracle have you been able to get this entire thing to work yet? Please see my message from last week.

Saved search is working but scripts are erroring out. I was able to create them and deploy successfully. But when trying to either create or update a sales order it give s a generic Suite Script error. When checking the logs on the deployment, it does not show anything. When checking the script execution logs, it does not…

That took care of it. Looks like the original documentation has it as a single quote when it actually needed to be an apostrophy. Not sure I would have ever figured that out. Thank you for your help. Not sure who can update the documentation, but in both the suiteanwsers that I linked to above and the NetSuite…

Setting it to formula {id} works. Thanks!

Good Morning, I would like this task to be created and linked to the opportunity that created the task from this workflow. But when setting up the workflow, I do not see a current transaction as an option for that field value. Under selection, I see a list of every transaction we have, but not one that will auto default to…

Thanks @Jack Daryl Espiel-Oracle I think this will be the solution we need.

I have what might be some important additional information as I am learning more on how the PO/SO processes are linked. We do not create the PO from the SO. We have an existing PO where we bought the stand alone inventory from an unrelated vendor. It then sits in the warehouse until we sell it to another customer.…

It is set to store value and it is not populated by a saved search. The field is populated from a standard list.

It is a custom field. In the results we have tried using "Purchase Order : Pickup Status (Custom Body)" and regardless of summary type, it is always blank. Is there a different PO filed we should attempt to pull into the results?

Hello, The field we would like to have show in this saved search is the Pickup Status that exists on the Purchase Order of the related item. You can see in the attachment that the item is related to both the sales order that shows up in the saved search as well as the purchase order that has the Pickup Status

Changing it from getText to getValue was the change I needed. Thanks for your help!

Mikko the item is an active item.

Hi Joahnna, Apologies for the delayed response. I have tried setting it on Create and it is still not adding the training line item when I add something from that manufacturer. Do I need the workflow itself to have the condition for manufacturer or the individual action for Create Line to have that condition? As for the…

Hi Joahnna, Ideally we would like this to happen when we creating the sales order, before saving it. So we go to the customer, we add new sales order, we add the widget to the sales order. At that point the workflow would see the widget made by WidgetsRUS and add the training line item. All prior to saving the sales order.…

Thanks Michelle this looks like it should work for what I need. Messages: Internal ID and the count summary are the two things I was missing.