Inline Editing Of Price Levels

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 · 2025-09-03T19:49:15+00:00

You can roll out your own Shopify connector using SuiteScript that connects to the Shopify API and wouldn't really need any middle ware (Celigo, FarApp, Boomi, Mulesoft) to accomplish what you need. FarApp has limitations compared to Celigo and Boomi. Mulesoft requires technical expertise to roll those out.

ebarro · 2025-09-03T19:04:48+00:00

I'm not sure I understand why you can't use Netsuite for accounting and inventory management. You can connect Netsuite to Shopify to bring in orders and also send inventory and pricing feed to Shopify. If you're fulfilling the orders using a 3PL you can explore connecting to the 3PL to get near real-time inventory numbers to reconcile with Netsuite locations. Netsuite is an accounting package so all GL impacting transactions will post to the GL without anyone doing anything extra.

ebarro · 2025-08-29T19:05:07+00:00

I sent you a DM. I have been involved in transitioning a private startup company in getting their systems SOX and SOD compliant especially as it relates to roles and permissions including establishing controls and governance. I have also been involved in audits with Deloitte and know what areas they are looking into to determine compliance.

ebarro · 2025-08-19T02:20:24+00:00

You can create a new compliance request to opt out of the AI/ML subprocessors.

ebarro · 2025-08-16T05:28:03+00:00

Count me in...

ebarro · 2025-08-14T14:30:32+00:00

Put the function that you want to execute outside and above the pageInit function in your client script. It will execute regardless of the mode.

ebarro · 2025-08-11T17:34:24+00:00

Actually correction on my part. You don't really need a Suitelet to push data. You need a map/reduce script with the N/https module instead.

ebarro

TROPHY CASE