BrianE Green Ribbon

Noticing this as well and as a result have been researching DMARC and tightening up our email settings. One issue is getting DMARC SPF alignment as it tests both the FROM domain and the RETURN-PATH domain. Have not been successful in getting DMARC SPF alignment for various domains NetSuite uses in the return-path like…

The SuiteCloud IDEs can pull down XML based representations of the various NetSuite objects which you can search through. The XML is the same as when you do for example Actions -> Download XML when editing a saved search. While most of it is in binary there is an XML dependencies block that lists the custom fields. At…

There are third party JDBC/ODBC/Other connectors for NetSuite. They can be costly. CDATA (various including ODBC, JDBC, FireDac, ADO.NET etc https://www.cdata.com/drivers/netsuite/ ) and DevArt (ODBC https://www.devart.com/odbc/netsuite/ ) are two such third party providers. These use webservices (SuiteTalk) calls to…

That is the situation in which I saw the error as well. The fulfillment is missing item(s) or qty from the kit because they are out of stock or low in stock and this causes the kit contents to not match. The solution was to either fix the inventory with an adjustment so you can fulfill the full kit or realize you can't…

One way is to use a Formula (Numeric) with a case statement. Depending on the field type you might need quotes around each value. In addition there is a limit to how large the formula can be so you might need to break it into multiple formula joined with OR after checking [X] USE EXPRESSIONS. For sales orders by the number…

It is usually easier to write the CASE statement using separate WHEN conditions followed by an ELSE: CASE WHEN {department} LIKE 'North%' THEN 'North' WHEN {department} LIKE 'South%' THEN 'South' ELSE 'No Region Identified' END This is the same form as suggested by MarthaHakes.

If some items are outright missing the culprit could be "Item : Location Preferred Stock Level is not empty". Might be worthwhile to create an item search with the criteria your using on items to make sure all show up that you think should. I would also suggest using "Date is within previous one year". That would reference…

The two levels of case statements are not really needed: CASE WHEN {shipaddress1} IS NULL THEN {shipaddress2} WHEN {shipaddress1} LIKE 'Attn:%' THEN {shipaddress2} ELSE {shipaddress1} END

The help for Subsidiary on the item record mentions: "A subsidiary must be associated with an item in order for the item to be added to a transaction related to that Subsidiary." If items should be shared across all subsidiaries assign the top most subsidiary to the item and check [X] Include Children. The error message…

You can delete both private and public saved searches you own so no need to make them public. Note the href for the confirm after clicking on the button that deletes a saved search: /app/setup/assistants/nsimport/savedimports.nl?method=delete&recid=78 so you could just use that to delete them by id.

A fulfillment has a list of one or more packages which each have weight, tracking number and a text field for a description of the package's contents. The Tracking Numbers field that shows up in some places is a summary taken from the list of packages.

The help mentions development accounts for production accounts including that you can give up to 10 users access to each development account and how to have them inherit the password from the production account. This does not sound like the same thing as the developer accounts for SDN partners. From the help inside…

There is also Last Quantity Available Change field available on the item that you can use in searches to find items that quantity available has changed since a given date and time.

The GNU utility recode can change encodings of a file. With WSL available on Windows 10 installed you can use the Linux version from within a Windows command / batch file. wsl recode utf16..utf8 text.txt You can also load and save a text file using the windows notepad application by using save as and setting the encoding…

The full UI and integrations are working for us but our SCA site while able to show the home page can't do searches without an error including bringing up the contents of a commerce category. Internal Error Search failed

They updated the message: 7/24/2018 NA East incident update: Service has been restored for the majority of customers impacted. Our engineers continue to work on the the remaining customers and we will provide an update when the work is completed. We greatly appreciate your continued patience. 03:32 PM Can log in but the…

They just updated the message again: 7/24/2018 Service has now been restored for all customers. If you are still experiencing problems please contact NetSuite Customer Support. Thank you for your patience. We take these incidents very seriously and apologize for this service interruption. 08:15 AM Still not fully up for us.

Suspect this has actually been an issue since last night because one of our integrations failed around 1030p Central. Could be unrelated, but the behavior then is the same as this morning Might be unrelated. Users and integrations were running fine overnight here - just all started failing ~ 8:10 EST this morning. A few…

Heard that it is related to a Power Outage. Can't be too large of one since otherwise they should have failed over to the separate DR data center that is available in each region. See Disaster Recovery section under Data Management in : NETSUITE DATA CENTER FACT SHEET