Richard James Uri-Oracle NSC Guru

Hi, Apologies on this but we need to check this SuiteAnswers Article to further investigate since I have got an error on executing this. However, the provided SQL query is a simple query to let the Customer get started on building complex Balance Sheet report via ODBC. We recommend that you consult your technical…

Hi @ONO4 , Good day! According to SuiteAnswers Article, CURRENCY field type rounds the number based on the user's currency precision setting and is limited to hundredths / 2 decimals (0.00). See for more details: 44525 format.Type I was able to check the currency precision setting and found out the Currency Precision field…

Hi @User_PRW7Z , Upon checking all of our resources, I have not found any related information about the existing QR Codes to recognize in NetSuite. With this, kindly coordinate this to your Account Manager to discuss your concern. Thank you for understanding. Have a great weekend!

Nice to see you posting here, @Charles B , Kindly allow us to review your concern about Suitelet and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

Nice to see you posting here, @User_YMWNR Kindly allow us to review your concern about customization and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

Hi @Vernita , This is James, a SuiteCloud Guru. Upon checking and searching in SuiteAnswers Article about SuiteScript Supported Records, "SuitePromotions" is not included in the records. To further check, kindly open this SuiteAnswers Article. 10242 SuiteScript Supported Records Thank you!

Hi @User_PRW7Z , Apologies on the late response. Upon checking all the related articles, you can customize NetSuite to generate QR codes in PDF files for transactions. To do this, you must first create a custom template, and custom form, a custom body field, and a user event script to add the QR code in e-documents. After…

Hi @Ron Mc , Can you try this one? Select T.tranid,I.itemid From Transaction as T,bomAssembly as B,item as I Where BUILTIN.DF(T.Type) = 'Work Order' and I.id = B.assembly and BUILTIN.DF(T.TranID) = 'WO7-2217'; assembly field is under the bomAssembly table. id field of an item us under the Item table. Given this, we need to…

Hi @GiCo74 , Upon checking all of the records, SuiteScript can load an existing file in the file cabinet but this object only encapsulates a file’s metadata. Content is only loaded into memory (and returned as a string). Given this, open a file from file cabinet and view it on browser directly is not possible. SuiteAnswera…

In REST, as long as you will call the Internal ID, you can update a specific record. Like this, In SOAP, there's an update operation wherein you can modify the records. Like this, These screenshot were found on the said SuiteAnswer Articles. Thank you!

Hi @Ron Mc , It seems that the Custom Field ID and the field ID is not the same. Since you are using the custbody_atlas_assy_desc field in the query, this means the value of field ID assemblyitem will not return. Try to use this query to see the output. Select T.id as WOId, T.assemblyitem as assy From Transaction as T…

Nice to see you posting here, @Julien Mi Electronics Kindly allow us to review your concern about customization and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

Hi @Ron Mc , Would you mind sending a screenshot of the custbody_atlas_assy_desc Transaction Body Field record. Go to Customization >List, Records & Fields > Transaction Body Fields > Go to Concerned Custom field. Like this, In Work Order Record, would you mind double clicking the Custom Field then screenshot the Field…

Hi @Ron Mc Upon replicating your concern on my end, it seems that I have returned the right output. Tried to create a Transaction Body Field I have created a Work Order Tried to get Internal ID and the Custom Field With this, can you try to check the ID of the Transaction Body Field to verify if you got the correct one.…

Hi @ONO4 , Upon checking all of our resources and trying to test in saved searches, your concern is really not possible. We apologize for the inconvenience and appreciate your understanding on this. To other members of the community, feel free to share your thoughts. Thank you!

Thank you!

Hi, Apologies on not understanding easily your concern. As standard behavior in search.result, to determine the field type in search result is not possible since ResultSet.getText or ResultSet.getValue only returns the result, not the field name or type. We apologize for the inconvenience and appreciate your understanding…

Hi, No possible workarounds for this, Suitelet can only use Sublists for editable objects. We apologize for the inconvenience. Thank you!

Nice to see you posting here, @PaulFleetwood Kindly allow us to review your concern about customization and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

Hi, Upon checking the article about N/search Module, it is used to to create and run on-demand or saved searches and analyze and iterate through the search results such as Search for a single record and Create and save searches. Given this, if you want to extract all of the custom fields in different records or transaction…

Nice to see you posting here, @Wendy_M Kindly allow us to review your concern about matrix item and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

Nice to see you posting here, @Kedalene Kindly allow us to review your concern about permissions and we'll be keeping you updated on the results. To other members of the community, feel free to share your thoughts. Have a great one!

Hi @Vernita , Upon checking all of our resources, the possible way to print a specific file or record is thru PDFs. Given this, to directly print a specific file to their printer is not possible. We apologize for the inconvenience and appreciate your understanding of this. Thank you!

Hi, I would like to follow up on this thread. Please let us know if you need further assistance. Thank you!

Hi, I would like to follow up on this thread. Please let us know if you need further assistance. Thank you!

Hi, Upon checking the supported records via API, these are the only supported record connected to your concern. Expense Report Expense Category Thank you!

Thank you for joining with me into today's session! Hope you had a wonderful time! We are now closing today’s session. We hope to see you in the next #AskAGuruLive session. Follow AskAGuruLive for more updates. Feel free to post your feedbacks or suggestions to help improve the program. Have a great one!

Hi, Thanks for posting your concern! I think this question is more suited to our OTC/P2P Gurus. Kindly post your question on Ask a Guru and OTC/P2P Gurus will be happy to help you with your concern.

Tip #3: Does the search still retain its 1000 result limit on each run? The SuiteScript 2.0 search API contains searchResult.getRange(n, n+999) and searchResult.each(function(result){}); The first can return 1000 per page but has no overall limit to the number of result retrieved from a given search. The second supports up…

Tip #2: How to know if a record is scriptable? If you are unsure if the records you want to execute in your Suitescript is supported, NetSuite provides an Article about the SuiteScript Supported Records. With this, you can reference the article whenever you want to execute or customize a specific record via SuiteScript.