Vernita

Hi @Leonard Mallare-Oracle I have passed the values to a form level client script via the parameters. The record load is part of the client script: /** *@NApiVersion 2.x *@NScriptType ClientScript */ define(["N/url", "N/record", "N/runtime"], function (url, record, runtime) { /** * @param {ClientScriptContext.pageInit}…

in Is it possible to copy a sublist from one record to a different record type? Comment by Vernita Jul 21, 2022 10:30AM

Hi @Leonard Mallare-Oracle How is the sublist array passed across from the invoice to the vendor bill? Is this through the url parameters? In your example, you have the record being loaded to obtain the values. Is this step necessary if I am using a beforeload entry point on a invoice record in view mode? thanks

in Is it possible to copy a sublist from one record to a different record type? Comment by Vernita Jul 21, 2022 4:11AM

Hi Leonard thanks so much for your help. I’m still testing this and will update once I have

in Is it possible to copy a sublist from one record to a different record type? Comment by Vernita Jul 20, 2022 9:48PM

Hi @Katerina Winklerova-Oracle Thanks for looking into this. Regarding the first question, what I meant was the amount is $0.03 stored in a field (e.g. {amount}) However, rather than displaying as $0.03, if this value is part of a formula calculation (e.g. formula(text)= "$" & {amount}). then it displays as $.03 without…

in Zero in a saved search drops off in the results Comment by Vernita Jul 17, 2022 11:38PM

Hi Kristoffer Regarding making the sublist the preferred view, this will be true for all sublists of this record type from what I can see. i.e. the base record for this sublist is transactions. If I were to make this the preferred sublist, wouldn't that apply to all transaction sublists? (and not just the case record I am…

in Filters on a custom transaction body field Comment by Vernita Jul 12, 2022 11:06PM

Thanks @Kristoffer Viray-Oracle Would that filter the transactions so that the only ones available are related to the same customer as the case?

in Filters on a custom transaction body field Comment by Vernita Jul 12, 2022 9:25AM

Thanks for the suggestion Emil. I was wanting to change the default behaviour of the sublist for all users by customising the fields that are available in the filters

in Filters on a custom transaction body field Comment by Vernita Jul 12, 2022 8:50AM

Thanks Ivy. Is there a way to convert this using to_number and using formula(numeric)? I have tried the following TO_NUMBER(CASE WHEN {type} IN ('Credit Memo','Payment') AND {fxamountremaining}*-1 < 0 THEN '(' || (CASE WHEN {currency} in('USD','NZD','AUD') THEN '$' WHEN {currency} = 'British pound' THEN '£' WHEN {currency}…

in Negative Number Format for Saved Search Comment by Vernita Jul 7, 2022 12:50AM

Thanks. It doesn't have the symbol though

in Negative Number Format for Saved Search Comment by Vernita Jul 6, 2022 10:50PM

Hi @Ivy Lopez-Oracle Thanks for the formula. I copied it exactly and used type formula(currency). I am getting an error message When I change the formula type to text, I get the following

in Negative Number Format for Saved Search Comment by Vernita Jul 6, 2022 10:38PM

Hi @Katerina Winklerova-Oracle I have that setting though the numbers for credit memos or payments do not appear as negatives and therefore the setting doesn't apply to them I have used a case when formula to convert them to negative first though doing this means the currency symbol has dropped off

in Negative Number Format for Saved Search Comment by Vernita Jul 1, 2022 10:49AM

Thanks @Mikko De La Fuente-Oracle This is what I get when trying to add the globalVariable The revised script /** * @NApiVersion 2.1 * @NScriptType UserEventScript * @NModuleScope Public */ */ var log, query, serverWidget, record define([ "N/log", "N/query", "N/ui/serverWidget", "N/record", "N/runtime", "N/recordContext",…

in How to pass variables to SuiteQL Suitelet Comment by Vernita Jun 30, 2022 12:11AM

Hi @Mikko De La Fuente-Oracle Currently the page where the browsers were downloaded make reference to Netsuite2.com. I believe this account had a connection set up over a year ago however using a third party app (similar to Power BI). How can I see whether that was set up to connect to Netsuite.com or Netsuite2.com?

in Using Connect browser SQL syntax with an ODBC connector Comment by Vernita Jun 27, 2022 11:13PM

Hi Katerina This has now been resolved. The issue was related to one of the user's changing the asset type on the asset record though not updating the asset depreciation record (accumulated depreciation) or the asset acquisition record which were both reflecting the old asset type. Changing the asset type only resulted in…

in Midlife Assets appearing incorrectly in Asset Register Comment by Vernita Jun 27, 2022 5:56AM

Hi @James Virtudazo-Oracle The tab from the secondary case issue field

in Dependent Drop Downs on external forms Comment by Vernita Jun 21, 2022 7:11AM

Hi @Kristoffer Viray-Oracle That wouldn't work as it's not looking for a particular phrase and is just extracting a number (while here, I need to extract anything after the phrase and before the first blank space after the phrase). The following is working REGEXP_REPLACE({incomingmessage}, '^.*?(our purchase order…

in Regexp Substring in Workflow Comment by Vernita Jun 17, 2022 2:14AM

Hi @Katerina Winklerova-Oracle Thanks for looking into this. I am finding the hours available is giving me the following (from a test account): From the employee record: Shouldn't the available hours be showing for the date range? (i.e. 3/5/2022 to the 7/5/2022)?

in Available Work Hours on Report Comment by Vernita Jun 17, 2022 1:55AM

Hi @Kristoffer Viray-Oracle I have adjusted the formula slightly though am still having issues with it I have a workflow applicable to case records One of the actions is 'set field value' before record submit. The field it is looking at is {incomingmessage} to extract the string of text The formula is supposed to look at…

in Regexp Substring in Workflow Comment by Vernita Jun 8, 2022 2:40AM

I found the cause of the issue: The Regexp_substring formula was used as part of workflow action. The workflow action for the {incomingmessage} was set to trigger on before record submit. However this didn't work on the {title} field on before record submit as this field doesn't exist until after the record is saved to the…

in Finding a particular substring in the middle of a string Comment by Vernita May 30, 2022 12:32AM

Found the answer. The subject field is {title}. So the formula can be changed to CASE WHEN REGEXP_SUBSTR({title}, '[SO][SO][0-9]+') IS NOT NULL THEN REGEXP_SUBSTR({title}, '[SO][SO][0-9]+') ELSE REGEXP_SUBSTR({incomingmessage}, '[SO][SO][0-9]+') end

in Email Case Capture-Extracting Subject Line from Incoming Message Comment by Vernita May 27, 2022 5:16AM

Hi @Mikko De La Fuente-Oracle Do you know why the client script might be failing to trigger in this case?

in How to close a suitelet on submit Comment by Vernita May 27, 2022 1:54AM

Hi @Michelle Jabanes-Oracle Thanks for looking into this. If this is a defect, does that mean this is currently being resolved?

in Incoming message rendering as plain text Comment by Vernita May 26, 2022 10:23PM

Hi Kristoffer I couldn't get another field to populate using the same triggers either. In the end, I suspected the issue might be with the bank details record type (from the Netsuite electronics payment bundle) so ended up not using a workflow for all required actions, and using a combination workflow and client script…

in Workflow Action not setting field value Comment by Vernita May 26, 2022 3:02AM

Hi @Kristoffer Viray-Oracle I have tried setting the state to 'do not exit' and that made no difference. I suspect it might be going wrong with other parts of the workflow though I can't see how since it matches another workflow exactly which does not have this issue. Here is the log The workflows in full The second…

in Workflow Action not setting field value Comment by Vernita May 18, 2022 10:05AM

I am also using the administrator role. /** *@NApiVersion 2.x *@NScriptType ClientScript */ define(["N/url"], function (url) { /** * @param {ClientScriptContext.pageInit} context */ function pageInit(context) { // var window = document.location(); // log.debug("window", window); console.log("client script triggered"); //…

in How to close a suitelet on submit Comment by Vernita May 17, 2022 8:33AM

This is the script after I have removed the other lines in the post response /** *@NApiVersion 2.x * *@NScriptType Suitelet * */ define(["N/ui/serverWidget", "N/log", "N/record", "N/url", "N/redirect"], function ( serverWidget, log, record, url, redirect ) { /** * @param {SuiteletContext.onRequest} context */ function…

in How to close a suitelet on submit Comment by Vernita May 16, 2022 11:48PM

Hi @Kristoffer Viray-Oracle Thanks for looking into this. There are no scripts or workflows running on this page updating this field. This is a custom field (not native to the Netsuite electronics payment bundle) that is updated with this workflow

in Workflow Action not setting field value Comment by Vernita May 16, 2022 12:27PM

This is how I have tried to call the pageinit function from the client script /** *@NApiVersion 2.x * *@NScriptType Suitelet * */ define(["N/ui/serverWidget", "N/log", "N/record", "N/url"], function ( serverWidget, log, record, url ) { /** * @param {SuiteletContext.onRequest} context */ function onRequest(context) { if…

in How to close a suitelet on submit Comment by Vernita May 14, 2022 5:09AM

This is the working version of the suitelet where the formatting now works /** *@NApiVersion 2.x *@NScriptType Suitelet */ define(["N/ui/serverWidget", "N/log", "N/record", "N/url"], function ( serverWidget, log, record, url ) { /** * @param {SuiteletContext.onRequest} context */ function onRequest(context) { if…

in Update values on parent record from Suitelet form Comment by Vernita May 14, 2022 4:06AM

Hi @Mikko De La Fuente-Oracle I can't get the syntax right for this This is the client script I have created: /** *@NApiVersion 2.x *@NScriptType ClientScript */ define([], function () { /** * @param {ClientScriptContext.pageInit} context */ function pageInit(context) { window.close(); } return { pageInit: pageInit, }; });…

in How to close a suitelet on submit Comment by Vernita Apr 25, 2022 5:07AM

MFA for Oracle Community

Vernita Bronze Trophy

Comments