Vernita Bronze Trophy

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…

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

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…

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

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

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…

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?

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

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…

Hi @Erick Dela Rosa-Oracle I was able to extract the value from a message field and store it in another field (custevent_case_creation). I then had a workflow action script that looks up the record referenced in the workflow state field(custevent_case_creation). and stores it against another…

Thanks Erick I am still trying to work through getting this formula into a script. I will let you know if this works once I am done testing.

Thanks @Mikko De La Fuente-Oracle I am currently looking at a few different options to achieve what I need... One of the other things I wanted to look at is the use of a Suitelet to capture information from the user and create create transactions. From my research on Suitelets, I can find information about it being used to…

Hi @Mikko De La Fuente-Oracle The only functions I can see from the moment library is // Moment prototype object function Moment(config) { copyConfig(this, config); this._d = new Date(config._d != null ? config._d.getTime() : NaN); if (!this.isValid()) { this._d = new Date(NaN); } // Prevent infinite loop in case…

Thanks @Mikko De La Fuente-Oracle Is there a way to have validation on the line so that it can only be committed for the quantity available? Anything above that cannot be saved?

Hi @Joy Noreen Magoling-Oracle I have found that even after the transaction is saved, the quantity for back order is not updated on the transaction. Or in this case, there is reference to the item being on back order if you create another transaction with the same item. However, the back order column is not populated on…

Hi Jack I haven't had a chance to test this yet sorry. I will do and post the results here. Thanks

Thanks Erick. Would a script use the same formula functions as, for example, a saved search? I have currently got a saved search formula which uses REGEXP_Substr which correctly extracts the value of the sales order number from the 'message' field. I'm not sure how that would be used in a script so that the extracted value…

Hi Ivy I realised why the issue was occurring. I had toggled the auto numbering feature on and off which was causing the name to appear in the hierarchy format. I switched it off and so didn't get a chance to test the formula sorry. I will mark this as answered as this does seem to be what I was after :) thanks