Jack Daryl Espiel-Oracle Gold Crown

@Mahmoud Alshami, You may need to do a workaround described in SuiteAnswers Article 76655 to use the field in a workflow since Summary Search Fields are Non-Stored. I'm also looking forward to those games' releases. Cheers! -Jack

How are you doing @User_VAYT1? Glad that you asked that question. Looping in an Approval Workflow is usually caused by having Exit States where the workflow restarts once it has reached any of them. See one of my answers in the following thread to fix the issue: -Jack

Tip#2: Did you know that you can filter the Items available for selection based on a Saved Search in some transactions? This is done by customizing the Transaction Form and setting the Saved Search Filter in the Item Filter field under the Sublist Fields subtab. For more details, see SuiteAnswers Article 9048. -Jack

Greetings @Mahmoud Alshami, Hope you're doing great as well! To answer your question, if you only need to display the document numbers in a Custom Field, create a Summary Summary Saved Search that uses the NS_CONCAT function to roll up the document numbers into a comma-separated string, then set the search on the Search…

Tip#1: Unsure which checkbox to mark under the Applies To subtab to apply a Custom Field for a certain Transaction Type? Look no further! Have the appropriate checkbox marked for you by going to Customize link (form's upper-right side) > New Body Field/New Column Field on the target transaction page you need to apply the…

I knew you'd ask @Micah Timbol-Oracle! I would recommend CodeNames because not only does it promote camaraderie amongst teammates but also the leadership of the one who is assigned as the Spymaster. You may also like this game as it allows you to customize the words list ? -Jack

Hi @Nikka Paula Castillo-Oracle, To set proper expectations, please be informed that the scope of our support here in NetSuite Support Community does not include creating and implementing any complete scripting solutions from scratch. For this, we recommend that you consult your technical requirements with your in-house…

Greetings @Talon3x8, Thank you for posting a new inquiry in NetSuite Support Community. Tagging our guru @Leonard Mallare-Oracle who might be able to help you out on this one. To other members who have any ideas, feel free to share them here. -Jack

Hi @Paul Salkeld, The Billing subtab and other existing subtabs themselves cannot be removed via script, but can be done for the Individual sublists under it. To determine the appropriate Sublist ID, refer to SuiteScript Records Browser. If a sublist is not available, it could be a Custom Sublist or a Custom Child Record…

Greetings @paula.courtemanche, Upon checking and testing, the - New - option in the Vendor Select dropdown can be removed in a Custom Role by setting the Lists > Vendors permission to View or lower. However, it seems that the - Custom - option cannot be removed by any means and is a limitation. The following related…

Greetings @Paul Salkeld, Upon checking, unfortunately, you cannot hide subtabs via script and this must be done on the custom form level. You cannot reference existing subtabs as well and can only add custom subtabs. With the above said, a possible alternate solution would be to identify all the fields under the subtab you…

Greetings @Benjamin Paul - USA, The error could be caused by transactions in your account that do not have values in the Created From field and other issues related to string length. So, you need to check first if the Created From field is not empty, starts with "Sales Order #", and you will need to consider the length of…

Greetings @jb123, Thanks for following up on this thread. Kindly allow our gurus some time to look into your inquiry, and they will get back to you with their insights. -Jack

Hi @Michaela Howard, Did the given solution above help address your requirement? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the solution post which will also help us and the other community members track replies that are meaningful, and…

Greetings @Vernita, Thank you for posting a new inquiry in NetSuite Support Community. We will look into this and will get back to you with an update. To other members who have any ideas, feel free to share them here. -Jack

Greetings @Michaela Howard, Customizing the form alone does not affect the PDF print-out that uses Advanced PDF Templates which seems to be the case on your end. To customize the print-out, edit the Advanced Template(s) selected in the Print Template and Email Template fields (can be set to different templates) on the…

Hi @KR Mike, Did the given solution above work on your end? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the solution post which will also help us and the other community members track replies that are meaningful, and you will also get…

Hi @Matan Shachaf, Did the given response above help address your requirement? If so, we would greatly appreciate you giving us an update and clicking the "Yes" button for “Did this answer the question?” for the response post which will also help us and the other community members track replies that are meaningful, and you…

Greetings @Matan Shachaf, Here are the answers to your inquiries about SuiteQL: 1. what I should install. This depends on which method you will use to connect to NetSuite that supports SuiteQL. Some of the supported methods include the SuiteAnalytics Connect Service and SuiteTalk REST Web Services. Refer to the…

Greetings @KR Mike, I have removed the attachment from the thread description on your behalf that may contain sensitive information. Please be reminded to check this for every thread that you post. Anyway, to have the topmost value in a Custom List selected by default, make sure that the Custom List is configured to show…

Thanks for suggesting an alternative solution @Emil T.! We greatly appreciate all of our member's contributions here in the NetSuite Support Community ? @filippo.blengini - Feel free to click the "Yes" button for “Did this answer the question”, on any replies here that have helped address your requirement. By doing this,…

Hi @User_VAYT1, Regarding your inquiry about workflow training resources, we currently do not have webinars about workflows yet. But, I do recommend the SuiteFlow User Guide that can be downloaded from the following SuiteAnswers Article: 50287: User Guides Hope this helps. -Jack

Greetings @Camila O, It seems that the only way to address your requirement is to use SuiteScript since Workflows currently cannot check if there are 2 open prepayments for a vendor already. Please be informed that the scope of our support here in NetSuite Support Community does not include creating and implementing any…

Hi @S. van den Oever, Did the given suggestion above work on your end? If you need further assistance, please let us know. -Jack

Hi @filippo.blengini, Do you still need further assistance with this inquiry? -Jack

Greetings @User_3CSJR, If the Sublist field in question is under the Items/Expenses (Expense Reports only) sublist of a Transaction, you can set up a Workflow and use the Set Field Mandatory Action to make the field mandatory. See the sample screenshots below for sample action setups: For Fields under the Items Sublist:…

I'll need to do this at the time the customer refund is created and before it is saved. Is that possible? Yes, this is possible. Can you point me to an example script? There are links to sample scripts in the SuiteAnswers Articles I provided thus far. But here are additional related SuiteAnswers Articles that can help:…

The only remaining problem is retrieving a field from the (only) Credit Memo from which a customer refund was created. A possible approach for this would be to retrieve the appropriate credit memo from the Apply > Credits sublist. This can be done using the N/record Module and N/search Module. See the sample screenshot…

Hi @GaryR, For your additional inquiry, it seems that scripting is also the only solution since the PN/Ref. field is currently not available in Workflows. So, let us know if you need assistance with any related script that you created. -Jack

No worries @Scott Bukolt. You may post the requested screenshots whenever you're ready ? -Jack