I have added code to Suitelet script to check Script Unit usage. Where getUsage is a function to get remaining script units. Wht I found out is, In each loop step to update one record, the remain usage is redcued by 30. Before enter this code block, the remaining unit is 885, so when entering this block, the maximum…

Thanks Garav! This script runs in SB_2 (QA) environment. That is good thought to check. However, this script does not trigger any other scripts. When the error occurres, did some test to choose less record to test, the issue never happens unless select more than 30 records to process. The error will occur when to update…

Nicole, Thanks. I'll go the links provided to try them out.

Hi, Ivy, I have a question on to use N/query tp update record in database. I got error whe n update a record in transaction table. From Netsute support, I was toold that becasue SuiteAnalytics is behind N/query and SuiteAnalytics is for read only, the database record can not be updated using N/query. Would you please…

From some research on this issue, I saw the N/query module description that, the N/query module using 'SuiteAnalytics Workbook query engine.'. Then from SuiteAnalytics document, it said 'The SuiteAnalytics Connect Service provides a read-only method for obtaining NetSuite data. You cannot use the Connect Service to update…

Thanks Joahnna. Here are the screen shots for the issue. First one: Query transaction table: have output without issue Second one. Write to record: with error. The third one: related colums in transaction table

One more things to add. Based on research, looks like Netsuite does not provide the functionality to add button on Save Search Result. To meet that goal, have to create a suitelet to run the saved search and provide a button on search result for customer action. Whether it is true or not, Netsuite expert, please comment.…

One thing to add. Netsuite document talk about to add button to record page or take add button action on workflow. In my case, the saved search neither records nor work flow. However, from google search, indicating with a user event script to related form will add button. View my saved search result is neither records nor…

Hi, Mikko. Your description make sense and that anwsered my question. Thanks lot!

I went my sandbox of Netsuite, and checking setup ->Company ->Send Email list. I saw many emails that sent to me. Now, from netsuite page, press button to trigger my suitelet script, see error that trigger email to send out to me. The email appears on "Send Email List". Checked my outlook, the email is there too. Now, went…

Thanks Mikko for details. My understanding is, these setting are applied to system error like some unhandled exception, the email will send to the script owner regardless what current user did that triggered the script exception. The email notification what I talked about is the hnadled exception from the script, it will…

Suitelet and Map\reduce running in the same sandbox. One can send out to outside Netsuite email acocunt, one is not. Will this exclude setup issue? But, I will try to check it and update with the result. But the concern I have is will it impact globally for other applications ?

Thanks Mikko for your help and information. Very appreciate! I will check all articales your referring.

Thanks Mikko. The setting is below: Execute As role is 'Current role'. But did not Roles under subtab Audience. Now, setting is Select All becasue don't know what is users role. I need to work with business to figure out the corresponding role. However, now have check the box "AVALABLE WITOUT LOGIN' for test team to be…

Thanks Jack for the response to my question. Adding some additional information here. My client script is triggered from a custmized button. The client script running without deployment as instruction from Netsute help document. User can trigger this script to run from Netsuite payment page without any issue. The issue is…

Thanks MIkko. WIll do as you recommended.

Thanks Mikko. I got your point. As a matter of fact, when came toBill Payment, all what I saw are saved search and it does show, if go to subtab, the line is expense or item. Now I need to upload these information to an external system so need to get these information. Retrieving information from the saved search can do…

Sorry Mikko, just realize that I wrote your name as Michelle.

Thanks Michelle for quick response. Unfortrunately, there is no save search for this. I used SuiteQL to run query against Transaction, TransactionLine, Account, item and TransactionAccoutingLine tables. The query result does not indicate directly which line is Expense or item. The only thing I now found is, if the…

Thanks Michelle for your comment. The record that woking on is Bill Payment. On Bill payment page, click each Bill, it goes to detail line page where tab listed the lines are either Expense or Items. However, they are not active in each Bill Payment page directly. According to NetSuite document, if they are not active in…

Thanks Leonard. Will try this out. Yesterday, tried using javascript dom to work around and it worked var obj = document.getElementById('custbody_ofc_request_id'); obj.value = requestId; But thinking using Netsuite module is the best way to do it. Again, thanks lot!

Thanks Leonard. The clientscript is below. The comment block inside that is the part to adding code to set field on the form so user will not need to copy the request_id to add to form manually. /** *@NApiVersion 2.x *@NScriptType ClientScript */ define(["N/currentRecord", "N/runtime", "N/url", "N/log", "N/ui/dialog",…

Yes, can see this script records but it is not deployed. The deployment is not required because it is triggered from a customized button on the form page. Yes, the alert dialog window is there. I will try to see if it can load form and then populate the field needs to update with data. Any document or code link that can…

Thanks Leonard provide recommendation and code example to how to get this done. The button click is from Netsuite payment form that trigger clientscript then calling suitelet from the clientscript. The response from suitescript is back to clientscript and then open dialog window to end user. The issue is how to get data…

Thanks Leonard for comment on my post. The transaction form referred here is -> payable -> Pay Single vendor form where is customized button added that will trigger client script. The field is also a customized field (After it was added, it appears on Transaction record on both payment page and transaction table). Yes, it…