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

Greetings @brocha, You can follow the Advanced PDF/HTMLTemplate code snippet below for writing the condition that will address your requirement : <#if business.id==1> <#if quote_type=='project' || quote_type=='contract builder'> <#-- use the logo with ID 14501 --> <#else> <#-- use the new logo with ID 588679 --> </#if>…

Hi @Vernita, Have you already checked the behavior described in our previous post? -Jack

Greetings @User_XMFHV, Upon checking, the option to only show the last subclass and not the whole class hierarchy in the popup list for the Class field is currently not available in NetSuite. The following related Enhancement Request has been filed for a possibility of future implementation: Enhancement 143940:…

Greetings @John Griffin, Your workflow condition does not work because you are using the Sales Order Join Field as part of your formula when you are not supposed to. To elaborate, your formula tries to look up the Entity field on another record linked via the Sales Order join field while the field is located on the current…

Greetings @User_ZPOBI, If you are using Advanced PDF/HTML Templates, you can display the Company Phone and Company Email on the Customer Statement printout by writing ${companyinformation.phone} and ${companyinformation.email} respectively in the template source code. See the sample screenshots below: Expected Result:…

Thank you for clarifying the desired result @Dwight Schrute. To fulfill your requirement, add Formula field columns of Date/Time type with their formulas written as follows: CASE WHEN {systemnotes.field}='<Field Name>' THEN {systemnotes.date} END Note: Replace <Field Name> with the actual name of the field to be checked…

Hi @OliverK, 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 will…

Hi @User_T2FH5, Do you still need assistance with this inquiry? If so, we would appreciate you providing the additional information we were requesting in the previous post. -Jack

Greetings @Vernita, Testing on my end, it seems that using ${statement.currency}, the Currency ID is being printed on the Template Preview only, while the ISO Code is being printed on the Actual Statement. Can you check if the behavior described above is also reproduced on your end? -Jack

Greetings @Betsy Vance, A Workflow can only address your requirement if you schedule it. Scheduled Workflows can be set to execute every 30 minutes on the results of a Saved Search Filter. See the screenshots below for sample Saved Search filter and Scheduled Workflow setup: Saved Search Filter: Workflow: To test the…

Hi @Vernita, I may have overestimated the capabilities of Client SuiteScript since upon checking and testing, it appears that hiding sublist fields can be only done using User Event Scripts at the moment. So, I retract the client script part in my previous answer. The following related Enhancement Request has been filed…

Greetings @Dwight Schrute, I'm a bit confused about your desired result here. Can you share a sample of the needed output so that we visualize it? Thanks! -Jack

You're very welcome @brocha! Glad that we could help 🙂 -Jack

Hi @User_VXKKP, Did our suggestion help resolve your concern? 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 will also get…

Hi @RichardMc, 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 you…

Hi @Constantly Confused.., 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…

Greetings @Eklon Eleuterio, We are currently looking into your inquiry here and will get back to you with an update. -Jack

Greetings @User_T2FH5, Which Trigger are you using for your Set Field Value Action? The appropriate formula to use depends on the trigger type. The trigger is set in the field shown below: By the way, we will be having a webinar on December 8 that covers this very topic! For more details including the registration…

Greetings @Intelligere, Thank you for posting a new inquiry here in NetSuite Support Community. Tagging our gurus @Clarisa De Torres-Oracle and @Patrick Fresnosa-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

Greetings @jitendrapratap, The following Employee Saved Search setup might be able to provide the information that you are looking for: Hope this helps. If you find this reply to your question useful, others might be as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the…

Greetings @OliverK, You can utilize Custom Document Fields and/or the Files sublist to associate files uploaded to the file cabinet to supported records. Document fields can be referenced like any other fields on searches while the files attached in the Files sublist can be shown via the File Fields... option. Take note…

I see. I realized that you should also do the following additional adjustments to the workflow setup to make it work as you intended: • The additional Set Field Value Action should have the same condition as the existing one under the Sublist Action Group for price level range of 3-6. • The first Send Email Action should…

Apologies for the confusion @brocha. What I meant is you should add a Set Field Value action that unmarks the Send Price Level Email Flag 1-2 under the Sublist Action Group for price level range of 3-6. Hope that this makes sense now. -Jack

@Asher_123, if the Item Fulfillment is created from the Sales Order. You can configure the Recipient section as shown below to send the email to the Sales Rep on the SO: Hope this helps. -Jack

Glad to hear that the provided solution on our previous post worked on your end @brocha! To address the additional scenario you brought up, unmark the Send Price Level Email Flag 1-2 under the Sublist Action Group for price level range of 3-6. This prevents the supervisor email from being sent and the email to the specific…

Hi @MichelCA, Have you already gotten started with the script conversion? As mentioned, we might be able to help you with specific concerns or inquiries in the course of the script conversion process. Let us know if you have come across some roadblocks. -Jack

Greetings @RichardMc, To get the desired results for your Saved Search, use the Join Field to the Child Custom Record (Child Custom Record Fields...) to peek into the value of a field within that Child Custom Record if there is any attached to the transaction, and use a Summary Criteria that excludes records from the…

Thanks for the update @User_VXKKP. Another thing you can try to troubleshoot the issue is to create a similar Custom Line Field on another transaction (e.g. Sales Order) where the script you found is not deployed. If the behavior does not reproduce, the script that you've found might be the culprit. Hope this helps. If you…

Thanks for the update @Constantly Confused.., Looking into your script further, I have found more parts that need adjustment for it to work. Apologies for not being able to include these in the previously suggested code fix. Here are the additional adjustments needed: The comparison operator in the second parameter of the…