Brian Finlay Green Ribbon

Removing everything but that field did not fix the issue. The data was still showing multiple results. What I did find that worked was setting up a Case When formula to only show that data only when it is on the sales order, which is the only place that field exists. So it now will no longer show for other related records,…

@Leonard Mallare-Oracle Our Misc account is a different account number in our Chart of Accounts. But the saved search is set up correctly to match that account number. I added the logging and it is not showing that it is running the search after creating a deposit. It does successfully run the search when I edit and save…

@Leonard Mallare-Oracle The saved search in the UI is showing the deposits in the UI. Adding in the log.debug in the location you suggested is not being recorded. I added a debug log to the function afterSubmit and it shows that it is running that part of the script. At this point I think it is either not loading the saved…

@Leonard Mallare-Oracle Thanks for the debug log trick. Let me start with adding it to these scripts and see if I can figure out which script either isnt running or isn't running correctly. I have been able to determine from more testing that after the deposit application is saved, the next time I edit and save a sales…

Updating that section of text resolved the error on save. Your update looks almost exactly the same as what was there. What changes did you make? Now I can create and edit a sales order without error. I created a sales order and a deposit on that SO. The customer is showing in the saved search, but when I view the sales…

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.