NS Admin Lab

Rodolfo Guerra · NetSuite Specialist

What I learn running NetSuite, explained plainly.

I have worked with NetSuite every day for 7 years. Here I share practical notes on development, queries and administration: what works, and the mistakes worth avoiding.

Explore the lab Connect on LinkedIn ↗

About me

I’m Rodolfo Guerra. I started as a NetSuite administrator at a services company, and today I lead the NetSuite product at a multi-subsidiary company.

My work sits between the business and the system. I listen to what a team needs, turn it into configuration or code, and make sure it keeps working as volume grows.

I built this lab to organize what I learn and share it. Every note comes from a real case.

7 yearsrunning NetSuite
2.xSuiteScript: Map/Reduce, Suitelets, User Events, RESTlets
SuiteQLcustom queries and reports

Focus areas

What I work on day to day.

Development

SuiteScript 2.x

Automations that hold up under volume.

  • Map/Reduce and Scheduled
  • Suitelets and Client Scripts
  • User Events and validations
Data

SuiteQL and reporting

Clear answers from the data.

  • Custom queries
  • Saved searches
  • Backlog analysis
Operations

Administration

A tidy, secure system.

  • Roles, forms and workflows
  • Bulk CSV imports
  • Duplicate-safe REST integrations

Lab

Short notes, each based on a real case. These are the latest.

CSV imports

5 mistakes that ruin a customer import

The five most common mistakes when importing customers via CSV into NetSuite, and how to avoid them.

 Integrations

Same order, two sales orders

How to avoid duplicate orders when an external system retries: idempotency with External ID in a RESTlet.

 Best practices

The sandbox is not optional

Why every NetSuite change should go through the sandbox first, and the three-step rule to do it.

 SuiteScript

It worked fine… until the volume grew

Scheduled Script or Map/Reduce: when to use each so your jobs hold up as volume grows.

 SuiteQL

Readable names in SuiteQL, no extra JOIN

BUILTIN.DF turns IDs into readable names in SuiteQL with no extra JOIN. Use it for display, not for filtering.

 Finance

Paying vendors shouldn’t take an afternoon

From four places to one flow: paying vendors from NetSuite with Electronic Bank Payments, and what needs a license.

See all notes by topic →

Let’s talk

If you work with NetSuite and want to discuss any of these notes, message me on LinkedIn.

Go to my LinkedIn ↗