NetSuite Data Targets

Overview

DataBlend Supports the following data targets for creating and modifying records in NetSuite.

• External Payments

• Manage Financials

• Manage inventory

• Resource Planning

To "export" the script, click to open one. Ctrl + A to select the text or manually highlight it to copy and paste into, for example, Notepad. Also copy the JavaScript File name listed in the table including the "_(MM.DD.YY)" for versioning control and ".js" for file type. In Notepad, click on File > Save As, and paste the copied name. 

If you have uploaded a script from DataBlend into NetSuite before but the file name and API version doesn’t determine whether the script in NetSuite is the latest, compare the potentially outdated script in NetSuite versus the latest script version (from the table above) by navigating to Customization > Scripting > Scripts in NetSuite. Then, follow the below instructions.

1. Expand the filter to ensure TYPE is “RESTlet”, plus API VERSION and SCRIPT FILE is “All”. The SHOW INACTIVES box should NOT be checked.

2. Search for a key word that the file name would include, such as “map” for the Map Reduce or Map Reduce Wrapper script and click Edit on it.

3. Note the API VERSION, then hover your mouse over the SCRIPT FILE box to Open (in a new tab) and click the “preview” link under the MEDIA ITEM section. Note that the SCRIPT FILE field in the Edit Script page allows you to create a new script, or select another one by clicking on the double-down arrows > List > search for the file to select > Save.

4. Ctrl + A or click-and-drag to manually highlight all text, then copy and paste into the left or right textbox of a free online text file comparison tool.

5. Open the latest script in the table above, highlight all text, and copy to paste into the other textbox of the free online text file comparison tool and click the button for the tool to compare both scripts. If there are differences, a new script file will need to be added in NetSuite.

Reminder: de-activate outdated scripts. See NetSuite Collectors for more scripts and the below links to script-specific instructions for Data Targets.

• Bulk Import
• Map Reduce

Configuration

For record types like “customer” or “vendors”, where “address” is a subrecord, two queries and two data targets required.

Data Target with upload-file.js script URL and Record Type “customer” will update everything on the customer record except for addresses. We create a separate query and Data Target for addresses only.

Required fields for Address Book query:

The only other thing we also need is CUSTOMER ID to identify the customer.

“attention” and “addressee” are usually the same value fields. To avoid duplicates in NetSuite UI set “attention” to Null Literal.

With address sent to “customer” we can do billing (from client’s source), we can do shipping. We can not do both. Below is a screenshot from subrecord module.

Advanced

History Retention

History Retention (Days) allows users to decide how long they want the information from their data targets to be stored. This field is optional.

Timeout (seconds)

The Timeout section allows users to determine if they would like to timeout collections taking longer than a set number of seconds to collect data.

Skip If No Records Found

The “Skip if No Records Found” button is used to eliminate sending information to Data Targets unnecessarily. Simply enable the “Skip if No Records Found” toggle. The use of this toggle is optional.

Agent

The Agent drop-down for users to select any agent they have established. This is optional.

Run As

Run As allows users to select from a drop-down list of users to run the Workflow. This is optional. Please note that Run As is only available to Admin users. If a user is set as the Run As and then demoted to a Member, the user which demoted the Run As user will instead be set as the Run As.

Journal Entries Data Target

Minimum required fields to create a Journal Entry in NetSuite: