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.

Tip # 1: How many characters can we input in the Log.Debug? Log messages appear on the Execution Log tab of the script deployment for deployed scripts, or on the Execution Log tab of the SuiteScript Debugger if you are debugging a script. Log messages also appear on the Script Execution Logs page at Customization >…

Hi Miguel, Since subsidiary record is supported in client and server SuiteScript. You can try to use these SuiteAnswer Articles for your concern. 85613 Hide Field via Client Script 62616 SuiteScript > Hide a Sublist on a Record 74009 Field.isDisplay 50230 Sublist.isDisplay Thank you!

Nice to see you posting here, @Ivan Babiichuk Kindly allow us to review your concern about field mandatory 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, @Martha Hakes Kindly allow us to review your concern about Integration 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!

Welcome @Neo_Suite . Let me know if the concern is supported via SOAP and/or REST. Thank you! If you find this reply to your question useful, others might be as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the community members who might have a similar concern find…

Hi @Neo_Suite , Upon checking all of our resources. Here's what I have found. In SOAP Web Services and REST Web Services, there's no feature about the 'SuiteApprovals' upon searching this keyword but you can check these SuiteAnswer Articles to know more about Transaction records that are supported. 11001 SOAP Web Services…

Hi @Johann Granados , Technically, all of the reports can be replicated on ODBC (SuiteAnalytics Connect) and SuiteQL since you can directly access the Database using these Core Features. Sample SuiteAnswer Article: 24540 Sample Query to Pull Balance Sheet Through ODBC while As per NetSuite current standard behavior,…