Vernita Bronze Trophy

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?

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…

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…

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"); //…

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…

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

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…

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…

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, }; });…

Thanks Mikko. This is the working line var notesFieldUpdate = record.submitFields({ type: record.Type.INVOICE, id: parentField, values: { custbody_notes_check: "<span style='color:#e74c3c;'>Check Notes</span>", }, });

Hi Mikko I haven't had a chance to test this yet sorry. I will update the results here once tested

Hi Mikko This is the client script that finally worked /** *@NApiVersion 2.x *@NScriptType ClientScript */ define(["N/record", "N/url", "N/currentRecord"], function ( record, url, currentRecord ) { /** * @param {ClientScriptContext.pageInit} context * @param {ClientScriptContext.onclick_callforSuitelet} context */ function…

Hi @Mikko De La Fuente-Oracle This is how I have set up the field on the script itself, I am trying to set the value for this field using: var notesFieldUpdate = record.submitFields({ type: record.Type.INLINEHTML, id: notesField, values: { custbody_notes_check:…

Found the solution: Creating a saved search under vendor-subsidiary relationships instead of vendor relationships allows you to search the balances by subsidiary

Thanks @Jack Daryl Espiel-Oracle Is it possible to hide that field and use a custom create button instead? I found this thread and was wondering if the solution of a suitelet form would work in this use case?

Hi @Jack Daryl Espiel-Oracle Thank you for this. I will test this out. For the second part of the query, is it possible to make the child record set up form appear as a pop up instead of redirecting to the page? thanks

Hi @Mikko De La Fuente-Oracle I am trying to script the notes record not the system notes:

Hi @Micah Timbol-Oracle It is not possible to delete a journal without voiding the time entry first. This is where the problem lies: There is no way to filter the void time entry screen by journal. I was wondering if there was a workaround for this limitation?