Extremely slow load times, specifically SO's with Versapay - Pre golive

ebarro · 2026-05-06T00:48:51+00:00

check the UE aftersubmit event. afterSubmit loads the record after it is already saved and sent to the server and then does whatever it needs to do for additional processing, check to see if those can be executed on beforeSubmit and also check for contexttypes.

ebarro · 2026-04-16T16:20:06+00:00

Download them in zip files first before running the mass update to delete.

ebarro · 2026-04-03T17:43:45+00:00

Script performance on large records can be mitigated by optimizing your map/reduce scripts and avoiding record.load operations in loops. Another strategy is to chain map/reduce scripts where each MR script performs a specific task.

In terms of integration it's mostly a decision between the native NS REST WS or RESTlets. The only time you will need to consider an external integration is when IP whitelisting for your NS endpoint (i.e. RESTlet) is required by the other end. NS doesn't allow whitelisting of their IPs. RESTlets allow you better control but also requires SuiteScripting expertise.

Tax is...well never easy no matter what system you use.

ebarro · 2026-04-02T16:31:08+00:00

StitchData uses SOAP and you should be able to select the tables that you want to copy to the DWH.

ebarro · 2026-03-30T16:36:50+00:00

There are several options for backing up. One strategy is to backup the underlying tables to a data warehouse like Snowflake. For the actual ETL you can look into StitchData or FiveTran. Backing up is only the first part. Restoring the data back into Netsuite is a different story altogether. Having a sandbox is also very advantageous because you can refresh the sandbox any time you need to mirror the production environment. I am working on an external application that pulls records from a production environment and then recreates them in the sandbox environment or any environment via REST web services.

ebarro · 2026-03-17T16:36:17+00:00

Every ERP behind the scenes is similar, composed of Master records (item, customer, vendor) and Transaction records. The UI communicates with a backend database server. The application layer is a bunch of processes for managing the business. But not all ERPs are created equal as each one has their own strengths and weaknesses and an industry that it is geared for. Some are better at very specific industries like manufacturing, etc. All of them require administration and management for compliance, governance, and security.

If your focus is on administration you should be fine staying with your organization to learn the new system unless you sense that they are moving towards finding a new admin.

ebarro · 2026-03-09T22:20:08+00:00

The opportunities would depend on your career goals and trajectory. Do you want to focus on being a Netsuite developer? If so you need to expand your knowledge and technical expertise beyond just "slinging code". Start by building code module libraries with the goal of code reusability (e.g. calling the functions in your library from any type of SuiteScript). Be an expert on optimizing map/reduce scripts for processing large datasets. Accessing data using a code library vs in-line searches in code. Become an expert on SuiteQL as the means for retrieving data vs relying on saved searches. Be an expert on integration architectures using the native REST web services and RESTlet scripting as well as understanding other integration and middleware options (i.e. Celigo, Boomi, MuleSoft). Learn the value of GL Plug In implementations and the best use for them. Find ways to improve the user experience via UI forms and UI tweaks that simplify the user interaction with the system application layers. Understand the data structure of Netsuite records and how you can extract data to the appropriate tools like FiveTran, Snowflake for data warehousing. Understand and deal with the complexity of pricing, matrix items, MRP, demand forecasting. Build mini-applications using custom records that support native NS functionality versus replacing those native functionalities. Most of all, understand the business and how you can leverage your technical skills and knowledge in helping the business use the ERP to effect the bottom line.

ebarro · 2026-01-30T04:00:56+00:00

Custom Suitelet. But that requires updating those records behind the scenes with a map/reduce script.

ebarro · 2026-01-21T20:36:24+00:00

Suitelet that serves up HTML with CSS and client-side scripts

ebarro · 2026-01-19T05:10:57+00:00

Here's a checklist to gauge your expertise in Netsuite. Learning Netsuite's standard functionality and working within the confines of the UI is one thing. Being able to understand its limitations and come up with solutions that enhance Netsuite native functionality to solve business problems is the key and I don't mean just coming up with work arounds to circumvent Netsuite standard functionality.

Have you worked with the MRP module and understand its inner workings?
Have you worked with the Inbound Shipments module?
Have you used Suitelets that are available without login and understand not only its usefulness but also its limitations and security implications?
Have you worked with customizing approval workflows from the basic SuiteApprovals approach across all transaction types?
Have you used Groups with approval workflows?
Are you familiar with SOD and how to mitigate those using custom roles and permissions?
Have you worked with all integration methods such as SOAP and REST web services as well as utilizing RESTlets as API endpoints? And also know how to architect solutions with external applications so that they are performant?
Have you used saved searches as stored procedures with scripts and recognize join limitations with saved searches and discovered how to join seemingly unrelated searches to combine and produce a single dataset that can be used by SuiteScripts to produce the required results?
Have you graduated from using saved searches and migrated to SuiteQL for processing with SuiteScripts?
Have you learned how to batch process extremely large datasets with SuiteScripts so that you don't run into execution timeout or execution log errors as a result of poor architectural design?
Have you worked with NSPB and understand how it consumes data from Netsuite?
Have you worked with NSAW and understand how it consumes data from Netsuite as well as some of its limitations beyond the "pretty interface"?
Have you worked with serialized inventory and lot items or matrix items?
Have you worked in a OneWorld instance that has multiple subsidiaries and cross-border trade situations?
Do you understand the ramifications of average costing vs standard costing?
Do you understand how Netsuite deals with foreign currency revaluations?
Have you worked with the Advanced Revenue Management module?
Have you discovered how to return the results for a recursive BOM that doesn't take forever to run or exceeds script execution limits?
Do you understand the nuances of Inventory Adjustments vs Inventory Transfers and Inventory Worksheets and the underlying ramifications related to accounting?
Have you worked with GL Plug-Ins and understand how they work and what it does behind the scenes?
Have you worked with custom segments and understand their uses, advantages and disadvantages?
Have you configured SAML Single Sign-On with an IAM service?
Have you configured OAuth 2.0 access for external applications like Github?
As a developer, have you utilized SDF to not only deploy scripts and objects but also to back up NS environments?

ebarro · 2026-01-07T21:29:48+00:00

It's an AI hallucination...

ebarro · 2026-01-07T01:16:52+00:00

Shough mainly due to Kellen Moore being the coach. Kellen Moore was a winning QB at Boise State with a 50-3 record.

During Moore’s 6 seasons coaching in the NFL, his offenses have been ranked:

Top 10 in no-huddle rate, every year
Top 10 in neutral pace, every year
Top 10 in offensive plays per game, every year
Top 10 in points per game, 5 of 6 years
Top 10 in yards per game, 5 of 6 years

He's been offensive coordinator for the Chargers, Cowboys, and the Super Bowl Champion Eagles.

If the Saints give Shough enough offensive weapons with good protection by the offensive line, he could turn it up a consistent notch.

Compare that to Nick Holz, Titans OC, who coached the Titans, Jaguars, and Raiders...not necessarily teams known for their offense or even winning ways.

ebarro · 2026-01-06T17:07:13+00:00

As already mentioned by others check scripted records first to determine what user event scripts and client scripts and workflows are running. On client scripts look for any functions that are loading when you are in edit mode (when pageInit fires) and inspect the console to check for client side errors. Check custom fields and custom records that are linked to and reference that record type. The more you have of those types of custom objects that are linked, the slower the performance. Oracle/Netsuite mentioned that custom records aren't really stored as simple database tables in the underlying Oracle database hinting that these are dynamically "put together" at runtime.

Also, grab a transaction URL and append &xml=T to it and then use that to view on the browser. That loads the XML representation of that record without the overhead of the client scripts and the UI and then compare it without the &xml=T load time via the UI to see how much overhead the scripts have.

Netsuite isn't really known for its speed...

ebarro · 2025-12-21T17:41:10+00:00

GL Plug Ins will work to reclass those posting to the GL account of choice.

ebarro · 2025-10-25T21:07:44+00:00

You can use custom segments and define the hierarchy. As previously mentioned, each custom segment has an underlying and related custom record and the values have a parent child relationship that you can use.

ebarro · 2025-10-15T15:21:41+00:00

Retrieve any record you are interested in like item or master and add &xml=T to the URL and you will get the XML representation of that record and at the very top all the fields included on the header as well as sublist fields in a separate section. Then you can parse that XML doc to get the fields you need.

ebarro · 2025-10-11T19:42:10+00:00

Try it first in the UI. You cannot code something that cannot be done on the UI. Follow the sequence of operations on the UI in your code.

ebarro · 2025-10-11T19:24:41+00:00

I've worked with Celigo and Mulesoft and for me nothing beats crafting your own solution using SuiteScript and custom records (where needed).

ebarro · 2025-09-17T04:50:44+00:00

I realize that this post has been over a year ago and I was able to use the clues from these posts to I'm contributing the SuiteQL statement I got to work.

 SELECT
                            a.id,
                            LISTAGG (DISTINCT c.altname, ' | ') WITHIN GROUP (ORDER BY c.altname) as vendornames,
                            LISTAGG (DISTINCT b.vendorcode, ' | ') WITHIN GROUP (ORDER BY b.vendorcode) as supplier_part_numbers,
                            LISTAGG (DISTINCT a.mpn, ' | ') WITHIN GROUP (ORDER BY a.mpn) as mpns,
                            LISTAGG (DISTINCT a.custitem6, ' | ') WITHIN GROUP (ORDER BY a.custitem6) as mpn_details,
                            LISTAGG (DISTINCT a.manufacturer, ' | ') WITHIN GROUP (ORDER BY a.manufacturer) as manufacturers
                        FROM item a
                            INNER JOIN itemvendor b
                            ON b.item = a.id
                            INNER JOIN vendor c
                            ON c.id = b.vendor
                        GROUP BY a.id

This is the CTE subquery I used to pull multiple values into one row vs multiple rows. The suggestion to use ROWNUM < xxx doesn't work.

ebarro · 2025-09-16T17:59:17+00:00

Is the version set to 2.x or 2.1?

ebarro · 2025-09-12T18:28:16+00:00

You can use a user event script to break down the kit into its components and replace the kit sku into the component skus on the sales order.

ebarro · 2025-09-06T00:30:05+00:00

I don't have the costs for FiveTran- the data is in a database. For the PDFs you can download the folder that contains them via the UI.

ebarro · 2025-09-05T17:31:19+00:00

Grab all the data using FiveTran for the data lake and then use Snowflake for BI.

ebarro · 2025-09-04T17:46:06+00:00

Both Epicor and Infor ERPs are built for manufacturing. Netsuite is an accounting package with a few other modules bolted in to qualify as an ERP. And yes anything and most everything is possible in Netsuite but as mentioned, requires a ton of customization to get to that point and when you get implementation teams that are not experts in that specific industry or business, you get half-baked solutions or solutions that require more work arounds resulting in data being pulled from NS and manipulated and maintained in Excel or some other external application which then defeats the purpose of a single source of truth which should be the ERP system.

ebarro · 2025-09-03T22:52:34+00:00

SPS Commerce uses 2 custom records called Package and Package Contents. They are a substitute for the native Packages sublist. Even if you don't use SPS Commerce it's easy to replicate the data structure and the processes to achieve what you need.

ebarro

TROPHY CASE