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?

The time entries relate to several years ago though the transactions were posted in the current period. e.g. an entry from 2018 is posted in March 2022 (the current open period). While the time entry is posted, it doesn't appear to be possible to edit the time entry until a voiding journal is created. The problem is, I…

Thanks for your quick response @Micah Timbol-Oracle I have uploaded the csv, changed the form (to one where the reversal date is visible) and updated the records. I have tried this with both 'run server side scripts' checked and unchecked. It shows as being successfully uploaded though the record hasn't actually been…

Hi @Kristoffer Viray-Oracle I was after the relationship between the sublist lines. In any case, I have found it by testing a scenario where the number of lines and the line order on the bill is different between the purchase order and the vendor bill and seeing how Netsuite manages to match which PO line relates to which…

Thanks @Kristoffer Viray-Oracle How would you match a line on the purchase order with a line on a vendor bill? Is there a unique key that allows you to join the PO and the vendor bill record at the sublist line level?

Thanks @Kristoffer Viray-Oracle , does that mean it is not currently possible to script the quantities for the sublist? Is the enhancement request to offer the feature natively or to allow the fields to be scripted?

Hi @Kristoffer Viray-Oracle Yes, that is correct. I was wanting the columns (in the blue box) from the purchase order on the vendor bill as well using a custom field

The custom record page is a consolidated invoicing set up page. This was part of the SuiteSolutions Consolidated Invoicing bundle i.e. the equivalent to this page

Hi @Katerina Winklerova-Oracle Is it possible to delete the other thread? I accidentally posted it when I pressed 'post comment' instead of 'save draft' which is what I was intending to do apologies for that

/** *@NApiVersion 2.x *@NScriptType ClientScript */ define(["N/record", "N/runtime", "N/url", "N/log"], function ( record, runtime, url, log ) { /** * @param {ClientScriptContext.pageInit} context */ function pageInit(context) {} function executeRecurring(context) { var scriptObj = runtime.getCurrentScript(); var…

Hi @Mikko De La Fuente-Oracle The code for the Suitelet is as follows /** *@NApiVersion 2.x *@NScriptType Suitelet */ define(["N/ui/serverWidget"], function (ui) { var exports = {}; function onRequest(context) { if (context.request.method === "GET") { var form = ui.createForm({ title: "Consolidated Invoicing Type", }); //…

Hi @Kristoffer Viray-Oracle That suiteanswer appears to deal with filtering by a customer at the header level. In this case, I was wanting to filter the item list based on the project selected at the line level. i.e. Line 1: a project (customer ABC: project 1) is selected in the sublist field --> The user tabs to the item…

Hi @Kristoffer Viray-Oracle Thanks for looking into it. I have been experimenting with the workflow after posting the original message. At the moment, it seems to not be throwing an error if I change the 'approval limits' field population to before submit To get around the original issue of why I couldn't use the before…

This is the revised script which is still not redirecting on record save /** *@NApiVersion 2.x *@NScriptType ClientScript */ define(["N/record", "N/runtime", "N/url", "N/log"], function ( record, runtime, url, log ) { /** * @param {ClientScriptContext.pageInit} context */ function pageInit(context) {} function…