Vernita

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

in Formatting a rich text field when setting value using Suitescript Comment by Vernita Apr 18, 2022 7:33AM

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

in Update values on parent record from Suitelet form Comment by Vernita Apr 17, 2022 6:44AM

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…

in Custom button to trigger a client script and then suitelet Comment by Vernita Apr 17, 2022 6:42AM

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

in Update values on parent record from Suitelet form Comment by Vernita Apr 12, 2022 12:28PM

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

in Vendor balance by subsidiary Comment by Vernita Apr 10, 2022 11:50PM

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?

in Only allow child custom records to be created if linked to parent record Comment by Vernita Apr 7, 2022 1:34AM

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

in Only allow child custom records to be created if linked to parent record Comment by Vernita Apr 6, 2022 9:12PM

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

in Is the user notes sublist accessible via suitescript? Comment by Vernita Apr 5, 2022 8:38PM

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?

in How to void time entries in bulk for multiple projects and employees Comment by Vernita Apr 5, 2022 8:36PM

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…

in How to void time entries in bulk for multiple projects and employees Comment by Vernita Apr 5, 2022 2:53AM

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…

in How to void time entries in bulk for multiple projects and employees Comment by Vernita Apr 2, 2022 1:44AM

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…

in Quantity received, fulfilled and billed on a vendor bill Comment by Vernita Mar 16, 2022 9:13AM

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?

in Quantity received, fulfilled and billed on a vendor bill Comment by Vernita Mar 16, 2022 7:49AM

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?

in Quantity received, fulfilled and billed on a vendor bill Comment by Vernita Mar 16, 2022 7:29AM

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

in Quantity received, fulfilled and billed on a vendor bill Comment by Vernita Mar 15, 2022 9:41PM

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

in Suitelet buttons Comment by Vernita Mar 12, 2022 2:20AM

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

in Extract time from date time field and store result as time Comment by Vernita Mar 11, 2022 4:25AM

/** *@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…

in Suitelet buttons Comment by Vernita Mar 10, 2022 9:54PM

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

in Suitelet buttons Comment by Vernita Mar 10, 2022 4:44AM

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…

in AE: Is it possible to restrict items that can be sold to a customer's project? Comment by Vernita Feb 17, 2022 9:15PM

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…

in AE: Workflow action to send email Comment by Vernita Feb 7, 2022 11:49AM

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…

in AE:Refreshing a page on record save Comment by Vernita Jan 29, 2022 10:40PM

If I wanted to save the custom record once the field values are set, how would I do that? (without the user clicking the save button?) I would want the save record to occur just after: objRecord.save({ enableSourcing: true, ignoreMandatoryFields: false, }); }

in AE:Refreshing a page on record save Comment by Vernita Jan 24, 2022 8:57AM

Hi @Joahnna Given Uy-Oracle thank you for your detailed instructions. I have tested this and am not getting a value on the invoice record. One thing I wanted to check is why the contract field on the project record needs to be populated with a workflow? At the moment, I am able to have this pull information directly from…

in Linking a field on a sub customer; customer and project record Comment by Vernita Jan 21, 2022 12:12AM

Is there a way to submit a record without the user pressing the 'save' button? E,g, in this case, for a function to be created on the client side that submits the record to the database essentially 'mimicking' what would occur if the user were to click the save button and submit the record to the Netsuite database

in AE:Refreshing a page on record save Comment by Vernita Jan 20, 2022 9:17AM

Hi @Joahnna Given Uy-Oracle Yes, I would like details from the sub customer and the project record on the invoice header. In terms of the fields in question, they are custom fields on the sub customer and project record. The fields I am trying to source on the invoice are : From the project record, a field with id:…

in Linking a field on a sub customer; customer and project record Comment by Vernita Jan 20, 2022 1:01AM

Sorry, I am not too sure I understand @Mikko De La Fuente-Oracle . So the part of the client script function to set field values (function executeRecurring() ) is working as expected. The values are being set. It's the page reload that isn't working. Or is that what you mean? That a function to reload the custom record…

in AE:Refreshing a page on record save Comment by Vernita Jan 19, 2022 7:19AM

Hi @Joahnna Given Uy-Oracle Did you want a screenshot of the sub customer or project record? or for the advanced pdf template source code?

in Subcustomer or Project details on customer statement Comment by Vernita Jan 19, 2022 4:12AM

Hi @Dominica Sevilla-Oracle I am using an advanced pdf printing type

in Subcustomer or Project details on customer statement Comment by Vernita Jan 18, 2022 11:15AM

Hi @Michelle Jabanes-Oracle I was able to log a call with Netsuite to get this resolved. What I was trying to do was set up a DKIM in production after making the sandbox one inactive. What I hadn't realised is that I need to create a different domain selector and not re-use this between the two environments (even if it…

in DKIM between Sandbox and Production Account Comment by Vernita Dec 22, 2021 1:24AM

MFA for Oracle Community

Vernita Bronze Trophy

Comments