There is at least one saved search function that you won’t see in the dropdown list, NS_CONCAT. If you ever need to concatenate line items into one row for example this function may be helpful. Using a formula of “NS_CONCAT({item})” set to a Summary of Maximum like shown above will reveal all of the items …
Your company may use existing platforms such as SalesForce, Shopify, Coupa, or a number of other CRM, eCommerece, or expense reporting software that you need integrated into NetSuite. The benefit of NetSuite integration is having a single accurate database for all your reporting and accounting needs. Many companies struggle getting these integrations right which can …
NetSuite Integrations – What’s the best integration solution? Read More »
If you’re frustrated with seeing duplicate results or seeing blank spots in your rows there may be a quick fix. Here’s a primer to get you started. 1. What records are we searching? Usually, I see NetSuite users are most often looking for a Transaction, Customer, or Item search. Transaction being the most complicated due …
Sometimes doing a search for a customer in your system, even with wildcard characters in the global search, doesn’t reveal everything in NetSuite with that customer’s data: There may be fields that aren’t exposed to the global search, other records or files containing the reference to a customer’s PII (Personally Identifiable Information). With this bundle …
Need to export all your records ( including custom records ) for backup or moving to another system? This bundle is a collection of scripts that crawl through your NetSuite instance and creates JSON or CSV files for each record type in your system. In a sandbox account with demo data this creates several hundred …
My non-profit work on healthXdata.com has taught me how data can be visualized to gain a quicker and deeper understanding. By visually mapping your NetSuite data (invoices, customers, leads, sales rep territory, etc.) and even combining it with other data sources such as COVID-19 data (e.g. county/state restrictions) we may draw unique comprehendible insights. As …
Here’s a project I started to make it easier to build for SS 2.0 scripts.Still a WIP: https://netsuiteguide.com/template-generator.html
What I’m using: iTerm2 on mac OSx JDK ( version 11 – https://www.oracle.com/java/technologies/javase-jdk11-downloads.html ) node js ( version 10.2 ) npm ( version 6.14 ) Some prerequisites to get the SDF CLI working include making sure you have a token-based authentication integration setup, a user role setup with sufficient permissions, and the bundle “SuiteCloud Development …
NetSuite has officials introduced their Node.js SuiteCloud Development Framework. I’ll be posting some tutorials on using it soon, until then please check out their Git repository SDK which includes both: • CLI for Node.js• Unit Testing framework https://github.com/oracle/netsuite-suitecloud-sdk
NetSuiteGuide.com provides NetSuite development assistance for coding, best practices, and Tips & Tricks.
