Mikko De La Fuente-Oracle · SuiteCloud Support · Gold Crown

Have you tried the disabling swap memory limit and setting memory limit on the docker side? -Mikko

Not exactly, what I meant was that for example, line 1 on SO could be the line 3 on RA if the RA was edited. But most of the time, it is same line like line 1 on SO is line 1 on RA and the line count of RA could not exceed the line count of SO. On the sample SQL, if the line sequence from RA is different from SO, it will…

@Michael Shparber , there is no direct relationship from Revenue Arrangement and Sales Order and Revenue Element with Sales Order line as SO line does not have Revenue Element Field in which if you use Revenue Element field on a transactionline table, it will pull out Revenue Arrangement Table. Most of the time, SO and…

Apologies for confusion. As I have said, the 'Created From' field mainline is no longer available on NetSuite2.com like it was available from previous data source. We can make use of the links table since 'Created From' is relatable to links as it links one transaction to another. See article for more information regarding…

For SOAP Web Services, have you tried creating the Saved Search on the UI and load it via SOAP Web Service? For REST WS, process on getting values for extended resources is limited. You can get the values from as much as the 'expandResources' enabled(see article) or connected links when you work with OpenAPI 3.0 Metadata.…

Could you provide a sample script you are working on? Are you aware if you are using dynamic or standard mode? Instead of fieldChanged have you tried using sublistChanged function?

I understand that you are working with NetSuite2.com. I just compared the 2 data sources to differentiate. The Transaction_link and createdfrom(mainline) from NetSuite.com is different from NetSuite2.com. You are correct that I meant previous/next transaction link on NetSuite2.com since createdfrom(mainline) is no longer…

Hi @Michael Shparber , the created from field is related to the table "Transaction_Link" from NetSuite.com while it is next/previous transaction link on the NetSuite2.com. You may want to explore these tables on your query. -Mikko

It seems that this issue is within the docker container. Please note that I do have a limited knowledge over docker application. However, upon checking external resources, I do found that on some cases, the error was fix by setting memory limit and disabling the swap memory limit on docker. This article might help you with…

Hi @Lahtine , Have you considered using SOAP Web Service? -Mikko

Apologies for the late response. Upon further checking, you are correct that the value from source is now text as the column sourced from NetSuite2.com is VARCHAR compared to NetSuite.com which is Number. However, you can still use this field/column in your SQL with additional steps of manipulating the result string(E.g…

Have you tried including the port in your connect parameter? Also, have you tried using different internet connection? Are you also using VPN? -Mikko

Hi @User_GE47I , Welcome to NS Support Community and thank you for posting your concern here! We encourage that you update your profile, add a profile picture and preferred username so other members can address you properly moving forward. You can also visit Community Tip: Updating Your Profile! Regarding the concern,…

That should work for the trigger type. Let us know if it still does not work. Additional information for SS 1.0 can be found on this article. -Mikko

Hi @User_3BTAC , Thank you for posting in the community! Please note that we do have limited documentation regarding docker with ODBC. However, checking external resource, you may want to look into this article and let us know if this helps. -Mikko

Have you check the Revenue Element table join Transaction(Source/Target Record) -> Transaction Lines(Field Id)? Also, Tables/Fields/Joins that can be found on the Records Catalog are the only available access with your account when using the NetSuite2.com data source. Additionally, what user/role are you using when…

Hi @Lahtine , the contents of the Vendor Bill record on REST Web Service is still on beta feature and may be changed in the future without prior notice. This is not advisable to fully use on your business process as this might affect your process in the future. However, would it be possible for you to test this case on…

This concern also fall on the same enhancement as you need to hide all the fields(E.g subtotal,total) before you can hide the summary box. You could submit an enhancement request/SuiteIdea to hide the Summary Box without customizing the fields inside it. -Mikko

Hi @Michael Shparber , Thank you for posting in the community! Please allow some time for the gurus/members to check on this and update for any findings. -Mikko

Hi @Wendy_M , Thank you for posting again in the community! Our gurus/members will look into your concern and get back with more information. Hi @Leonard Mallare-Oracle , any thoughts to share? ? To everyone. feel free to comment your ideas. -Mikko

Hi @Dirk Nieuwkamp , Thank you for posting again in the community! This concern is currently logged as enhancement(# 217539 - Ability to customize the Transaction Total Summary box in transaction forms (e.g. Sales Orders, Invoices, Cash Sales, Cash Refund and Credit Memos, Estimates). No alternate solution mentioned on the…

Hi @PaulFleetwood , Thank you for posting again in the community! Please give some time for the gurus/members to look into your concern and update this thread for any findings. Hi @Joy Noreen Magoling - Oracle-Oracle /@Ivy Lopez-Oracle , care to share ideas? ? To everyone, feel free to provide knowledge that can help.…

Hi @CK Job , Thank you for posting again in the community! Let's see how we can help you on this matter. Hi @Dominica Sevilla-Oracle /@Ely Gulen-Oracle , any ideas to share? ? To everyone, feel free to give insights. -Mikko

Hi @Dirk Nieuwkamp, Thank you for posting again in the community! Please allow some time for the gurus/members to check on this. Hi @Kristoffer Viray-Oracle /@Jack Daryl Espiel-Oracle /@Joahnna Given Uy-Oracle , any idea came to mind?? To everyone, feel free to provide some insights -Mikko

Hi @Jeff Pineda , Thank you for posting in the community! Our gurus/members will look into this and get back with more information. Hi @Kristoffer Viray-Oracle /@Jack Daryl Espiel-Oracle /@Joahnna Given Uy-Oracle , any ideas on this?? To everyone, feel free to comment your insights. -Mikko

The server_error is caused by authorization server encountered an unexpected condition which prevented it from fulfilling the request. Things you could check/do is try to trace your steps backwards and double check the parameters/values. If possible, try to create/start from credential setup and check the certificate…

Apologies for delayed response. Could you confirm if the Custom Role has the following permission listed on this article. You could also check the Custom Record permission if it has the Custom Role and the form used. You could add the Custom Role you are using and the default form for it. See this article for the guide.…

May I ask what version of SuiteScript are you using? The operation type for this event is either pick, pack, or ship. You could log the type and see what it is. For more information, you could check this article. -Mikko

Hi @User_JVL1I , there is no cross-reference tool available. However, you could check this article for the available Oracle NetSuite reference tools. -Mikko

Hi @Kedalene , Thank you for posting in the community! Our gurus/members will look into your concern and update for any findings. To everyone, feel free to share your ideas. -Mikko