Jack Daryl Espiel-Oracle Gold Crown

Hi @"csteinhaus", Upon checking, Show in Filter Region is not available for Multi-Select Fields and the following related Enhancement Request has been filed for this: Enhancement 164787: Saved Searches > Available Filters tab > Custom Field of Type is Multiple-Select > Ability to Mark Show In Filter Region and Show As…

Hi @"RafaelM", Thank you for clarifying your requirement. If you intend to update the values of the Custom Fields on your Custom Record with values of your Summary Saved Search, create separate Saved Searches for each of the fields to be updated. Based on the example you provided, you would need to create separate Saved…

Hi @"basem.mohamed", Have you tried enabling the Execute as Admin option in the Workflow General Settings like in the screenshot below? If the Workflow still doesn't work, please post screenshots of your Workflow set up so that we can also test it on our end. -Jack @"Jack Daryl Espiel-Oracle"

Hi @"lilywu", I agree with @"Brian Altares-Oracle"'s answer but starting 2019.2, you can now prevent data mismatch errors like the one you encountered by utilizing the new freemarker built-in added to NetSuite called nsformat_*. This built-in is used to manually format data according to your liking. Here are some usage…

Hi @"samzad_31571", In order for the Journal Entry Approval Workflow to designate an Approver for System-generated JEs, modify the workflow settings as follows: 1. On the Context Panel, click on the Workflow tab then on Fields (...) subtab, and click on Created By Workflow Field. 2. On the Workflow Field settings window,…

Hi @"PaulFleetwood", Do you still experience the error in your Advanced Template? If so, it is recommended to file a case to support since they have access to the details of unexpected errors. -Jack @"Jack Daryl Espiel-Oracle"

Hi @"RafaelM", There are 2 options to pull up the results of a Saved Search to a Custom Record. Here are the options: 1. Create a Custom Field with value derived from Summary Saved Search Results. 2. Create a Custom Sublist. Here are some example applications for both methods: 1. The first option is used if the Saved…

Hi @"Rado", If you update the value of Approval Status field on Edit mode, the Workflow setup you posted will work just fine. But, if the Approval Status field would be updated outside of Edit mode (i.e. by clicking the Approve button on the form in View mode), the Set Field Value action will not trigger. The reason for…

Hi @"plantscan", Currently, there is no native way in determining which Workflows or Scripts would be affected by the change of a Custom Field's ID if the field is being referenced by formula. But, you can apply @"BrianE"'s solution for Saved Searches. Upon checking, we didn't find any related Enhancement Request for this.…

Hi @"Constantly Confused..", Upon checking, the option to change font settings of the Excel file to be exported from Saved Search Results is not yet available in NetSuite and the following related Enhancement Request has been filed for this: Enhancement 68693: Reports (Excel)>Allow custom formatting - column widths, font…

Hi @"CDuf", Populating field(s) in an existing record via Go To Record action is currently not supported natively by Workflows. However, there is a workaround available via Workflow Action Script. Refer to this SuiteAnswers Article for details: 74546: Update an existing record using Go To Record Action Hope this helps.…

Hi @"4104350", You can do CSV Import in Setup > Import/Export > Import CSV Records. For more information, refer to SuiteAnswers Article 10022: CSV Imports Overview. Hope this helps. -Jack @"Jack Daryl Espiel-Oracle"

Hi @"hamshah", I did the same steps on my Test Account and found out that you cannot drop ship by partial quantities for a single line item. The Drop Ship Purchase Order to be created will be set to all quantities of the item on the Sales Order. Changing the quantity on the Purchase Order will prompt the following dialog:…

Hi @"gmihaylov", Upon checking, getting the Internal IDs of Units of Measure under a Units Type Record via Saved Search is not yet supported by NetSuite and the following related Enhancement Request has been filed for this: Enhancement 294403: Unit of Measure > Ability to search the Internal ID of each of the conversion…

Hi @"tsheetz", Upon checking, the feature to automate Bin transfers is not yet available in NetSuite and the following related Enhancement Request has been filed for this: Enhancement 197087: Automate transfer of quantities from one bin to another bin You can vote for the Enhancement Request by Submitting a case to support…

Hi @"bboese", What role were you using when you encountered the error? Is it reproducible using the Administrator Role? -Jack @"Jack Daryl Espiel-Oracle"

Hi @"Drewmich", Please try the steps described in the screenshots below to clear Google Chrome's cache: If the problem still persists after clearing the cache, try disabling some extensions detailed in the steps below since there are other users who have reported the same problem and fixed it by disabling specific browser…

Hi @"Drewmich", Have you tried clearing Chrome's cache if it resolve the printing problems? -Jack @"Jack Daryl Espiel-Oracle"

Hi @"Sonics", Upon checking, printing information from the Contacts sublist under the Relationships subtab of Estimate/Quote Records is not natively supported by Advanced PDF/HTML Templates and the following related Enhancement Request has been filed for this: Enhancement 297850: Advanced PDF/HTML Templates > Print the…

Hi @"hamshah", According to SuiteAnswers Article 28180: Drop Ship Items under Item Commitment section, drop shipped items do not show up as committed quantity. To learn more, also refer to SuiteAnswers Article 28188: Fulfilling and Receiving Drop Ship Items. Hope the references above prove useful in explaining your…

Yes, your understanding is correct since it is still a limitation of NetSuite as mentioned in my previous post.

Hi New_44789, You can create a Custom Employee List Field applied to different records filtered to only show active employees. However, the field's type-ahead search is limited to only using the unique identifiers as keywords. This Enhancement Request has been filed for the limitation: Enhancement 321846: Source out…

Hi @"MSStoke", SuiteAnswers Article 65176 explains how can you get started with SuitePeople. If you need more information about this feature, you can refer to your account manager. -Jack @"Jack Daryl Espiel-Oracle"

Hi @"Martha Hakes", Good to hear that you figured out that the concern has to do with the Saved Search for the Scheduled Workflow. For your information, The Workflow will not execute on all records in Testing mode and only for the first 20 or so records returned by the Saved Search, as stated in SuiteAnswers Article 36738:…

Hi @"kimt", There could be a Workflow deployed to your Custom Record that has a Go To Record action that redirects the page to the Customer Record. You can check by going to the Scripted Records Page for the Custom Record by navigating to Customization > Scripting > Scripted Records > Click the View link beside the Custom…

Hi @"Martha Hakes", Have you changed the Release Status of the Workflow from Testing to Released? You can do this in Context Panel at the right side of the Workflow Setup Page > Workflow Tab > click on Pencil Icon > Release Status field. With the Release Status set to Testing, the Workflow will not run on schedule and will…

Hi @"MSStoke", If you would like to implement the workaround via Workflow, you can refer to the set up below that I tested. However, the workaround can only accept one(1) additional email recipient since the Send Email Action only supports Email Address Type Custom Field which can only contain one(1) email address. 1. Here…

Hi @"RickG_1136", If the submenus and options under the duplicate Center Tabs are the same, you can go ahead and delete them. Otherwise, you can edit the Center Tabs and change their Label to be more appropriate. -Jack @"Jack Daryl Espiel-Oracle"

Hi @"robbiekozak", You can append the Link text to the URL in the Saved Search using this sample formula, assuming that the link text should be the filename: REPLACE(NS_CONCAT('<a href=https://1111111.app.netsuite.com' || {file.url} || '>' || {file.name} || '</a>'), ',' , '<br>') or better use the simpler LISTAGG()…

Hi c321dc41-15d1-4dac-97f3-c219c0bf8db0, NetSuite currently does not support setting exemptions in logging System Notes which might be due Data Integrity Requirements and Rules of some countries. However, you can implement @"Pauline Joy Cac-Oracle"'s solution for compliance to GDPR Rules in EU territories. But there is an…