Hi @Kristoffer Viray-Oracle Any updates on this? Thanks

Hi @Mikko De La Fuente-Oracle Yes the field is mandatory for amount. However, when I put the record into edit mode and save without clicking into any fields, why would this prompt me? Shouldn't the script not trigger unless I click into the account field (in the expense sublist)?

Hi @Kristoffer Viray-Oracle That was one of the fields I had used and got the same result

Hi @Mikko De La Fuente-Oracle Apologies for the late response. I have and it is now working. I have marked your post as the correct answer. thanks

This is the amended version though /** *@NApiVersion 2.x *@NScriptType MapReduceScript */ define([ "N/search", "N/record", "N/render", "N/file", "N/xml", "N/email", "N/runtime", ], function (search, record, render, file, xml, email, runtime) { function getInputData(context) { var scriptObj = runtime.getCurrentScript(); var…

Hi @Patrick Fresnosa-Oracle The vendor bill has been approved though there is no option to link to the intercompany transaction in the customer invoice This is the customer the vendor bill The options under the vendor bill The unrelated transaction belongs to this customer: The vendor for the vendor bill

Hi @Mikko De La Fuente-Oracle Custom record: I had tried using the integer though that also didn't work. With the map reduce script, I have tried to convert the existing UE script though am not sure what goes into the map stage? i.e. from the UE script, would the email template merge and the email send function be part of…

Thanks @Leonard Mallare-Oracle EDIT: it turns out the record is being saved though I just need to navigate it back to the invoice record. Thanks for your help Leonard That got rid of the error of 'select at least one item' However, nothing is being populated in the sublist. It doesn't prompt me with an alert and doesn't…

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}…

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

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

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…

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…

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

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

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}…

Thanks. It doesn't have the symbol though

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

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

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",…

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?

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…

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

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…

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)?

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…

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…

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

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

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