Jack Daryl Espiel-Oracle

Greetings @Paul Salkeld, Upon checking, the reason why you cannot assign an Email Message Template on the Bill Payment Form is that it might not be a supported transaction type yet for the feature as it is not listed in SuiteAnswers Article 8918: Working with Email Templates > Assigning an Email Template to a Transaction…

in How to assign an Email Message Template to be used for Bill Payment Emails? Comment by Jack Daryl Espiel-Oracle Jan 27, 2023 4:35AM

Thank you for providing the requested screenshots and apologies for not getting back to you sooner @User_GNW9Q. If you intend to prevent saving the record and then show the popup message, you should use the Return User Error action as well but with the Before User Submit Client Trigger. If you use the Show Message action,…

in How to set up a Workflow that prevents saving the record and shows a popup based on a Condition? Comment by Jack Daryl Espiel-Oracle Jan 27, 2023 4:08AM

Greetings @Vernita, Thank you for sharing your concern here in NetSuite Support Community. Tagging our gurus @Joy Noreen Magoling-Oracle, @Ivy Lopez-Oracle, and @Niks Blando-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

in How to resolve Effective Date Pricing Timezone Error? Comment by Jack Daryl Espiel-Oracle Jan 26, 2023 11:56PM

Thanks for the response @Varonis inc. Just to be sure, are you using the SuiteAnalytics Connect Browser as a reference for your queries? See the screenshot below: Or, are you using the Records Catalog (Setup > Records Catalog) shown in the screenshot below? -Jack

in How can we have an identifier for Group/Kit Item components in transaction lines via JDBC query? Comment by Jack Daryl Espiel-Oracle Jan 26, 2023 5:14PM

Greetings @Sheene Lim-Oracle, Thank you for posting a new inquiry here in NetSuite Support Community. Tagging our gurus @Ivy Lopez-Oracle and @Joy Noreen Magoling-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

in New Release: Smart count Comment by Jack Daryl Espiel-Oracle Jan 26, 2023 1:32AM

Greetings @Varonis inc., Are you using the new Netsuite2.com Data Source or the legacy Netsuite.com Data Source? -Jack

in How can we have an identifier for Group/Kit Item components in transaction lines via JDBC query? Comment by Jack Daryl Espiel-Oracle Jan 26, 2023 1:10AM

Greetings @OliverK, Thank you for posting a new inquiry here 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

in How to create saved search for system notes of field with most recent change only? Comment by Jack Daryl Espiel-Oracle Jan 26, 2023 12:03AM

Greetings @Matthew QC, 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 will get back to you with an update. To other members who have any ideas, feel free to share them here. -Jack

in Is it possible to Create Access Tokens via SuiteScript? Comment by Jack Daryl Espiel-Oracle Jan 26, 2023 12:02AM

Greetings @User_GNW9Q, Welcome to NetSuite Support Community and thank you for posting your question here! For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. By the way, it would be great if we will be able to recognize…

in How to set up a Workflow that prevents saving the record and shows a popup based on a Condition? Comment by Jack Daryl Espiel-Oracle Jan 25, 2023 2:09AM

Hi @Judy Perry, See the JavaScript code snippet below that can be used in SuiteScript that addresses your requirement: var today=new Date(); var todayAt12pm=new Date(new Date().setHours(12,00,00)); if(today.getTime()<todayAt12pm.getTime()){ //Before 12PM } else { //12PM or After } DISCLAIMER: The sample code described…

in How to compare current date/time to today at 12pm in SuiteScript? Comment by Jack Daryl Espiel-Oracle Jan 25, 2023 1:44AM

Greetings @SanjeevV, Thank you for posting a new inquiry here in NetSuite Support Community. Tagging our guru @Michelle Jabanes-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

in How to disable Include Transaction checkbox when sending email from a transaction? Comment by Jack Daryl Espiel-Oracle Jan 25, 2023 12:31AM

Greetings @Judy Perry, Welcome to NetSuite Support Community and thank you for posting your question here! For new members, we suggest that you visit the NetSuite Support Community - Frequently Asked Questions (FAQs) for more information regarding the community. By the way, it would be great if we will be able to recognize…

in How to compare current date/time to today at 12pm in SuiteScript? Comment by Jack Daryl Espiel-Oracle Jan 25, 2023 12:18AM

Greetings @User_AK587, 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 will get back to you with an update. To other members who have any ideas, feel free to share them here. -Jack

in How to auto approve a Journal Entry with SuiteApprovals Enabled? Comment by Jack Daryl Espiel-Oracle Jan 25, 2023 12:02AM

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

in How to handle Colorado Delivery Fee Comment by Jack Daryl Espiel-Oracle Jan 24, 2023 11:54PM

Greetings @User_NC62U, Upon checking, the ability to Inline Edit Multiple Select Fields is still not yet implemented. I found the following related Enhancement Request for this: Enhancement 174569: Saved Search > Inline Editing > Add the ability to direct list edit a multiple select field in a saved search result page You…

in Is Inline Editing allowed for Multiple Select type fields? Comment by Jack Daryl Espiel-Oracle Jan 24, 2023 10:25PM

Greetings @User_ZPOBI, The option to resize Standard Fields such as the Memo field is not yet available on NetSuite Custom Forms. Also, you cannot change the field type of the Memo field to another that is freely resizable (e.g. Text Area, Rich Text, etc.). The following related Enhancement Request has been filed for the…

in How to modify the size of a field on an invoice header? Comment by Jack Daryl Espiel-Oracle Jan 24, 2023 8:55PM

Hi @User_IJB6M, As you can see in the screenshot below, the Department Numbers can still be defined under the Values subtab without the filters. -Jack

in How can we assign Department Numbers for each Subsidiary under specific Departments? Comment by Jack Daryl Espiel-Oracle Jan 23, 2023 6:35PM

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

in How to show Invoiced Amount less related Credits on Sales Order? Comment by Jack Daryl Espiel-Oracle Jan 23, 2023 6:23PM

Hi @HGrimmick, Did you find our answers above useful? 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 closer to…

in Can you answer some of my very high level questions about SuiteCloud and SuiteBuilder? Comment by Jack Daryl Espiel-Oracle Jan 23, 2023 6:21PM

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

in How can we assign Department Numbers for each Subsidiary under specific Departments? Comment by Jack Daryl Espiel-Oracle Jan 23, 2023 6:10PM

Greetings @Muzzyelk, 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

in Why does the Deferred Revenue Waterfall Report include JE, SO and RA transactions? Comment by Jack Daryl Espiel-Oracle Jan 21, 2023 12:21AM

Greetings @Gabriel Jarillo Soto, For the PDF printout to be displayed directly on the browser, the user who prints the record should disable the Download PDF Files User Preference in Home > Set Preferences > General subtab. See the screenshot below for the preference: Hope this helps. If you find this reply to your…

in How to prevent printed PDF files to open in Acrobat and show it directly on the browser? Comment by Jack Daryl Espiel-Oracle Jan 20, 2023 6:05PM

Greetings @Nickey, Testing on this, it seems that your requirement can be only addressed using SuiteScript since Saved Searches are only capable of single-level record joins, and your requirement needs 2 levels (Sales Order > Invoice (Level 1) > Credit Memo (Level 2)). The following enhancement request has been filed for…

in How to show Invoiced Amount less related Credits on Sales Order? Comment by Jack Daryl Espiel-Oracle Jan 20, 2023 3:17AM

Greetings @HGrimmick, See my responses below to your inquiries: The webinar recommended no more that a total of 5 scripts and workflows on a record. I'm seeing cases, like our salesorder with 51 scripts and 79 workflows. This code should be reviewed for validity, migrated to SuiteScript 2.x, consolidated where/however…

in Can you answer some of my very high level questions about SuiteCloud and SuiteBuilder? Comment by Jack Daryl Espiel-Oracle Jan 20, 2023 2:39AM

Greetings @User_1J19L, 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 will get back to you with an update. To other members who have any ideas, feel free to share them here. -Jack

in How to retrieve data from Customer list with netsuite script ? Comment by Jack Daryl Espiel-Oracle Jan 20, 2023 1:54AM

Greetings @User_1J19L, We noticed that you already asked this question in the following thread: https://community.oracle.com/netsuite/english/discussion/4479708 So, we will assist you in the above thread instead and close this one as duplicate. -Jack

in How to retrieve data from Custmer List using suitescript Comment by Jack Daryl Espiel-Oracle Jan 20, 2023 1:54AM

Hi @User_IJB6M, Yes, you can also apply the Custom Segment to Transaction records and auto-populate the Department field based on the selected Department Number value by setting up a Workflow and using the Set Field Value action. Note that by doing the latter, you may need to remove the filtering of the Custom Segment for…

in How can we assign Department Numbers for each Subsidiary under specific Departments? Comment by Jack Daryl Espiel-Oracle Jan 20, 2023 12:09AM

Greetings @Maleeka, Upon checking, NetSuite does not yet have Audit Trail/History pages for Auto-Generated Numbers and Renamed Records/Transactions. So, you cannot track changes to those settings yet, unfortunately. The following related Enhancement Requests have been filed for the possibility of implementing those…

in Are there Audit Trail Pages for Rename Records/Transactions & Auto-Generated Numbers? Comment by Jack Daryl Espiel-Oracle Jan 19, 2023 8:07PM

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

in Why does my Workflow not able look up value when creating record via SOAP Web Services? Comment by Jack Daryl Espiel-Oracle Jan 18, 2023 2:37AM

Greetings @Vernita, 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 will get back to you with an update. To other members who have any ideas, feel free to share them here. -Jack

in How to set a Child Level in SOAP Web Services? Comment by Jack Daryl Espiel-Oracle Jan 18, 2023 2:02AM

MFA for Oracle Community

Jack Daryl Espiel-Oracle Gold Crown

Comments