pcutler

Your analysis is correct - when child records are set to display as a sublist on a parent record, only the parent record's user event script is invoked even if child records are edited in the list. The way to handle this is to run all of your user event logic for each sublist line when the parent record's user event is…

in Web Services based alignment with legacy platform Comment by pcutler Nov 28, 2017 5:33PM

If you read up on the auto-installation of integration records feature, for that to work NetSuite must be maintaining a master list of integration records across all accounts. Unlike almost all records, the integration record doesn't only exist inside of your NetSuite specific account, be it sandbox, production, etc. I…

in Sandbox Tokens Automatically Updating Production Tokens Comment by pcutler Oct 26, 2017 9:14PM

Agreed, it adds complexity, but if you require user event triggers then you have to use the parent record to accomplish that. Other approaches could include asynchronous searches of system notes or comparisons of a cached history of ODBC data to the latest version.

in Web Services based alignment with legacy platform Comment by pcutler Nov 30, 2017 4:15PM

Try sharing the SOAP request and response logs from SETUP > INTEGRATION > WEB SERVICES USAGE LOGS. The error could be in your request, or the error could be a caused by a user event script deployed on customer records. The purpose of the error ID is to provide to NetSuite Support when you file a case if you can't figure…

in Error when creating customer record: An unexpected error occurred. Error ID: j9066vxpxus1u7rc9vsr Comment by pcutler Oct 20, 2017 5:08PM

NetSuite Support informed us on Friday that there is now a new defect. Unfortunately, no movement on this defect yet. We have attached your case to the following defect: Defect #453473- SUMMARY: SSS > nlapiRequestURL HTTPS > SSS_CONNECTION_TIME_OUT Alternate Solution: None Your defect has been prioritized as an S1

in nlapiRequestURL() Timeouts Comment by pcutler Jul 17, 2017 4:22PM

Have you checked under Setup > Integration > Web Services Preferences to see if "Run Server SuiteScript and Trigger Workflows" is checked?

in Upsert triggers what? Comment by pcutler Jun 21, 2017 1:37PM

Has this issue reappeared for anyone? We have a customer who was experiencing this issue, it was resolved with this defect, and now they are getting this error intermittently again.

in nlapiRequestURL() Timeouts Comment by pcutler Jul 14, 2017 2:42PM

One option with SOAP services is to use multiple employee records for multi-threading. A single employee is generally limited to one simultaneous SOAP request, so with 100 employee records you can have 100 simultaneous requests. There should be no limit as long as your NetSuite account is sized correctly for the number of…

in What is the best possible way to insert around 200000 data from another system to Netsuite Comment by pcutler Dec 1, 2016 12:54PM

Try adding a "Formula Text" search result column to your saved search and setting the formula to the field ID in braces.

in How to get Display Text / Value and not internal Id in a saved search Comment by pcutler Oct 31, 2017 3:16PM

Also interested in this, any updates? Thanks in advance!

in Referencing custom records using scriptid instead of internalid Comment by pcutler Aug 23, 2017 4:33PM

chanarbon That's what I thought, thanks for confirming.

in Referencing custom records using scriptid instead of internalid Comment by pcutler Aug 24, 2017 11:07PM

In the user interface, is the field editable on the custom form you're using? Most likely you're using web services to try to set a field that's displaying as either inline or disabled.

in Do not have permission to set a value element Comment by pcutler Mar 25, 2014 12:14PM

Based on the records browser, those fields do not appear to be available as search filters or columns. Do you have the SuiteAnalytics Connect module? If so, those fields are available through ODBC/JDBC/etc. according to the connect browser.

in Third Party Shipping Fields Comment by pcutler Nov 8, 2017 5:19PM

You'll have to think about exactly what you mean - last sales order? last invoice? Anyway, the solution will be something along the lines of a saved search with the item column summarized by GROUP and the Transaction Fields...Date column summarized by MAX.

in Report for showing Last Order Date for Inventory Item Comment by pcutler Oct 6, 2017 5:55PM

Can't think of a way to accomplish this in a pure saved search, but with a "list" type suitelet, you can run a saved search and display the results in a numbered list.

in Sequence numbers for Saved Search Results Comment by pcutler Oct 26, 2017 10:21PM

Answering your first question, yes, there is a preference whether or not to run scripts on web services calls - check the web services preferences in your account. As far as the best way to approach this, a few options: [LIST=1] [*]How committed are you to using SOAP services? Consider using a RESTlet to create a RESTful…

in Line Item Shipping Enabled - How to get Ship-To Address Linked to Transaction Only using WebServices Comment by pcutler Jan 23, 2018 1:15PM

Do you have any experience with SuiteScript development? Depending on the details of what you're trying to do, it may or may not be possible with a workflow, but it is definitely doable with SuiteScript.

in Copy field value from item fullfilment to invoice Comment by pcutler Dec 11, 2017 4:14PM

There are no system notes for the fulfillment email text, but you can revert to the default by pasting the default into the customization field. The default is as follows: <html><head> <style> .smalltext { font-size: 9pt; } .texttable { font-size: 10pt; padding: 2 0 2 0 ; border-style: solid;…

in Customize Fulfillment Email Comment by pcutler Oct 18, 2017 5:43PM

For read-only access to data, you can create a saved search for them to use, define the criteria on the search according to your needs, and check the "RUN UNRESTRICTED" checkbox on the results tab to allow them to view the desired data.

in Unable to view Sales Order with multiple mixed line locations Comment by pcutler Oct 3, 2017 6:01PM

Here you go! https://netsuite.custhelp.com/app/answers/detail/a_id/31727

in Total Weight of Shipment Comment by pcutler Oct 17, 2017 3:19PM

Here's an approach I've used: 1. Create a custom transaction line field 2. Configure it to default to a large random number with a SQL formula (basically a GUID) 3. That value will carry over as the transaction is transformed so that you can link lines with their source.

in Line Link from Sales Order to Fulfillment to Invoice for lines with multiple fulfillments / invoices Comment by pcutler Jun 15, 2017 6:04PM

I'm not personally involved in this particular Thomson Reuters product, but have you looked at TR's global trade solution? https://tax.thomsonreuters.com/onesource/global-trade-management/restricted-party-screening/

in Denied Party Screening Comment by pcutler Apr 18, 2018 3:37AM

My guess is that "item record that is linked to a custom field" refers to the other direction - a field somewhere else, i.e. custom transaction column field, who's type is List/Record of item.

in Custom fields/records - System storage Comment by pcutler Mar 4, 2018 3:29PM

A sandbox is linked to a production account and can be refreshed with a copy of production data. A development account has similar limitations of a sandbox account (not for production use, redirects emails, etc.), but is otherwise an independent account that is treated as a "production" account. These accounts are only…

in Developer Account in Production Comment by pcutler May 2, 2018 3:00AM

I'd check the web service integration logs to see what SnapLogic is passing in the quantity available field.

in 'QuantityAvailable' error with integration Comment by pcutler Nov 28, 2017 1:52PM

I'm not 100% clear on your request, but would these components help you solve your issue? 1. There is an nlobjRecord.getAllFields() method in SuiteScript 1.0 for getting all fields on a record object. SuiteScript 2.0 has a comparable method. 2. There is an nlapiLookupField() method in SuiteScript 1.0 to look up fields on a…

in List field listing fields from transaction Comment by pcutler Oct 11, 2017 4:28PM

A couple ideas to throw out: 1. You could create script parameters, set them to be company-level preferences, and manage the values on the custom tab of the company preferences page. Scripts can access preference values using the nlapiGetContext().getSetting('SCRIPT', '...') API method. 2. For more complex data structures,…

in Easy way to manage/swich connection strings/variables to different external systems? Comment by pcutler Dec 8, 2017 3:33AM

I don't have any experience with Bronto specifically, but I have used SOAP libraries for JavaScript to convert JSON to SOAP. There are a few different libraries available, see x2js or JXON. Slight modifications may be necessary to some libraries if you're using server-side scripting.

in How to fire Bronto transactional email from Netsuite Comment by pcutler Oct 31, 2017 3:41PM

Center tabs always display on the main list of tabs. Maybe what you're trying to do is create a center category on an existing custom tab?

in How to add a center tab under a category? Comment by pcutler Oct 31, 2017 3:34PM

There might not have been any changes, but did you check the last modified date to see if the record was re-submitted (even without changes)? It seems odd to me that anything would change if the record truly wasn't edited.

in Line Ids randomly changing Comment by pcutler Oct 5, 2017 12:05PM

MFA for Oracle Community

pcutler Newbie

Comments