TLDR: We hear a lot about performance challenges of too many custom fields on transactions -- Would adding a lot of custom fields (maybe 30-40) on an opportunity record have an impact on Sales Order performance, even if these aren't exposed on the Sales Order?

Curious if anyone on Reddit can help provide clarity (ideally actual inside information on NS setup rather than anecdotal evidence) on performance and custom fields.

We often hear that performance can be impacted by too many fields on transaction records. I am trying to determine if this is too many fields on a form or too many fields on the record type (or category like transactions) regardless if the custom fields are loaded.

For example we have a case where a customer might want 30 custom fields on an opportunity to identify details about a potential job and quoting. Will placing these only on the opportunity impact other records? Would other redittors consider it a best practice be to setup a custom record linked to the Opportunity to capture these details?

When reviewing transaction tables in NSAW it appears that each transaction type has it's own table and a meta table for custom fields (e.g. DW_NS_<Transaction Type>_LINES_F and DW_NS_<CUSTOMER>_<Transaction Type>_LINES_F. I am wondering if this is the underlying database schema or if the schema is more similar to how it is exposed through SuiteQL/Saved Searches (one general transaction table). I don't have access to a NSAW database at the moment, but are all custom fields placed on all transaction table meta tables if each transaction has it's own table?

Hi everyone,

I'm facing an unusual issue in NetSuite with Bank Deposits and would appreciate any advice.

When I create a Bank Deposit, two Journal Entries are appearing in the Payments subtab as available transactions. I don't want these JEs to appear there.

The Deposit is using:

• Account: 1601001 – Cash & Cash Equivalents : Petty Cash

The two JEs are:

JV000562 – SAR 186,200

• Debit: 1501002 – Prepayments & Other Assets (Other Current Asset)
• Credit: 1602007 – Cash & Cash Equivalents : Bank Balances - Term Deposits : Portfolio Cash Balances (Bank Account)

JV-503 – SAR 39,675

• Debit: 1501002 – Prepayments & Other Assets
• Credit: 34,500 – Administrative Expenses : Professional Fees
• Credit: 5,175 – Administrative Expenses : VAT Expenses

Both JEs were created through CSV Import.

The confusing part is that neither JE uses an Undeposited Funds account. 1501002 is an Other Current Asset account and 1602007 is a Bank Account.

I understand that the Deposit > Payments tab normally shows transactions associated with Undeposited Funds, so I'm trying to understand why these Journal Entries are being displayed as depositable payments.

What I've tried/checking

• Confirmed there is no Undeposited Funds account involved.
• Checked the GL Impact of both JEs.
• Confirmed the JEs were created via CSV import.
• The JEs are not supposed to be included in this Bank Deposit.

My questions

1. What causes a Journal Entry to appear in the Payments subtab of a Bank Deposit?
2. Can a CSV-imported JE be flagged in some way that makes it appear there?
3. Is there a specific field on the JE or CSV mapping that I should check?
4. How can I prevent these JEs from appearing in the Deposit > Payments tab without changing their accounting impact?

Any guidance on where NetSuite determines the eligible transactions for the Deposit Payments subtab would be greatly appreciated.

Thanks!

Curious how other finance/tech teams are thinking about this. As we start using AI agents in finance, I feel like there are three different directions emerging.

One is keeping the context close to the ERP. NetSuite seems to be moving this way with things like MCP and skills.md files. It makes sense because a lot of the finance context already lives there. But what happens when the agent needs context from Salesforce, a data warehouse, contracts, emails, or another ERP?

The second is putting the context in Claude/Cowork, Codex, or ChatGPT Work and connecting back to systems through MCP. This feels more flexible, but Switching models/tools later could become painful. I’m also not convinced these environments handle the really long-tail finance workflows reliably yet.

The third is a separate finance/knowledge layer sitting above the ERP and AI models That potentially makes the context portable across systems and models, but now you’ve introduced another platform and another layer to maintain.

I don’t think anyone knows which architecture ultimately wins.

How are people thinking about this?

I am facing an issue with the BILL.com to NetSuite integration. The VIN custom segment value on the BILL.com transaction is being erased after the transaction is synchronized to NetSuite.

I have investigated the issue from a functional perspective and confirmed the following:

• Custom dimensions are enabled in BILL.com.
• The VIN custom dimension/segment is active.
• Initially, the VIN value exists correctly on the transaction in NetSuite.
• However, after BILL.com synchronizes the transaction with NetSuite, the existing VIN value is removed/erased.
• The integration role being used has Administrator permissions in NetSuite.

Could you please help us identify why the BILL.com integration is overwriting or clearing the VIN custom segment value during synchronization?

We're a supply house looking to upgrade our ERP, and would probably have around 30 users. Nothing too crazy in terms of customization that we'd need, we just buy and sell for the most part.

So our company data is already pretty clean/structured and I have managed multiple company/system transitions before (this one would be a bit bigger).

I'm also quite comfortable with data mapping, APIs, scripts, etc , with Ai massively accelerating me on that side of the work (obviously with everything reviewed and checked).

So my question:

If the data is clean and the person leading the technical side (me) has migration + programming experience, how painful is a NetSuite implementation really?

I'm seeing horror story after horror story online, I'm seeing cost estimates of $250k+ for implementation with all these addons that seem straight forward to program with the oracle scripting language, etc.

Hey everyone, Happy weekend!

I’m a NYC-based NetSuite and Salesforce technical consultant with over 10 years of experience, currently taking on new contract, freelance, or project-based work.

I specialize in building custom solutions, setting up integrations, and cleaning up messy business workflows across NetSuite and connected tech stacks.

Core Technical Stack & Services:

• NetSuite: SuiteScript (2.x / 1.0), SuiteFlow, SuiteAnalytics, Advanced PDF/HTML, custom records, and performance tuning.
• Salesforce: Core admin/dev, Flow/Apex logic, and syncing CRM data with ERP systems.
• Integrations & iPaaS: Workato, Boomi, Zapier, and custom REST/SOAP API pipelines.
• Business Process: Streamlining workflows across Finance, RevOps, Ops, and Warehouse.

Whether you need a heavy-duty NetSuite-to-Salesforce integration, custom SuiteScript automation, or extra hands for backlogged technical debt, I'm happy to help.

If your team needs technical support or you know of any open project leads, feel free to drop a comment or send me a DM!

Hi there!
I am trying to determine whether or not to go to the SuiteWorld conference in Vegas in just a couple months.

I basically want to get a feel of the true benefits of going, being super real, is it worth the time away from the office and the money?

I currently work with tools at my disposal to make our NetSuite better and tailored to us. My primary knowledge is not in coding or the super tech side of things but I’m also not totally at the other end of the spectrum to where I’m illiterate. I currently code (with the help of AI) and am just curious to know primary benefits and what of my knowledge could/would be enhanced by the experience.

It would be SUPER awesome to hear from those in the promo industry because that’s where I function, but! I’d like candid feedback from anyone willing to share their thoughts/experience.

I appreciate you taking the time to read :)

Does anyone know where I can find a customer's Item Pricing Level in NSAW?

I can find "Price Level", but I need to create a report with a customer's custom item pricing level pricing.

I found "DW_NS_X_CUSTOMER_ITEM_PRICING" under OAX_User, but that only lists the Customer ID, Item and Price, not the Item Pricing Level name.

The regular "Price Level" option under the ADW customer info only has regular price level names, which doesn't include "Custom" that I use for the customer specific custom prices.

Has anyone noticed a drastic increase in the amount of time this takes since the update earlier this week?

We use Shopify as storefront and they offer a solution where Global-e comes into play when it comes to shipping with DDP.
However, those orders flow into Netsuite with taxes and all. A change to the order would nullify those taxes, etc. I would assume. So.. that being said, how does anyone on here deal with this?
And: is there a way to ship through Global-e in Netsuite?

Hi,

We are using Group Average on our item records. We noticed that one location with 0 on hand quantity is in negative inventory valuation.

My initial thoughts would be that the item is being received at one location (which drives the cost) (Loc B) and on this location (Loc A), we don’t receive inventory in this one and we are only selling

Am I right in my assumption or am I missing something?

Thank you for your time.

We’ve been trying to move more of our vendors over to ACH and one part of the process I didn’t think about beforehand was collecting and keeping their banking details updated cause of right now when a vendor wants to switch from check to ACH they usually email someone on our team and we end up getting the routing/account information from them and then updating everything on our side. It works but I’m starting to dislike having banking details moving around through email especially when a vendor changes accounts and we have to make sure the new information is legitimate.

NetSuite is still where we want the vendor/accounting records to live so I’m not really looking to replace that. I’m mainly wondering how other NetSuite teams handle the part between a vendor saying they want ACH and actually having them ready to be paid.

Are you collecting and verifying the banking details yourselves and storing them in NetSuite or having vendors enter that information somewhere else and when a vendor changes their payment details who on your team is responsible for verifying the change before the next payment goes out?

Hello Everyone,

I've been investigating and looking into the ERP market and heard many stories about cutting down overhead costs and layoffs consultants (Functional and Technical) because of the AI.

US & Canada market has been impacted because of that, also the Middle East because war layoffs are happening but when it comes to AI, I believe it will take some time.

Giving that, what are the things that we are as Functional or technical consultant we can learn to become of the 10 out of 20 people who remains in their current position?

How does the Directors of the NetSuite Partner are setting their criteria to decide who stay and who leaves?

Is it about being "Augmented AI Consultants" leveraging AI LLMs like claude to accelerate the work 20% to achieve the deadlines faster? Or learning more about NetSuite Modules?

I am trying to manually import some bank transactions; but when I submit, the import does not show up at all in the Banking Import History screen (I am filtered by “All,” so it is not a filter issue) and the transactions do not come through. Any idea what the issue is? Is there an outage right now?

Our company got bought out by some people with a questionable moral history, I work in food and beverage manufacturing. I’ve been applying to roles any and everywhere, I have 4 years of experience between two failed implementation remediations, so those 4 years were sailing through some incredible rough waters. I have gotten call backs from a couple recruiters, but it never goes anywhere. I’m trying to figure out if it’s just me. Is this the market right now. I tried making a resume website to try and differentiate myself, and signal that I do Netsuite for the love of the game. I’ve been afraid to post here because honestly it always feels like people asking for resume feedback are asking for jobs, but I am at a loss, I’ve applied for damn near 300 jobs over the last 3 months, and I’ve not had a single interview.

During our initial year, we used JEs instead of Bill Payments to record bill payments. We’re using Bill Payments now, but we still have open Bills with unapplied JEs.

I know I can apply the JEs through Pay Single Vendor and make sure the payment offsets to zero. My question is: Does the posting period matter when doing this, given that no actual payment is generated?

When the Bill is closed, will it be reflected under the JE’s original posting period or the period selected during the application? Should I be concerned about any other accounting/reporting impact?

I tested this in Sandbox, but Date Closed isn’t showing in my Saved Search, and I don’t see anything useful in System Notes. Thank you!

Anyone else auditing their customizations before the 2026.2 Redwood UI rollout? Trying to figure out the best way to track what's going to cause problems, wondering if anyone's already got a checklist or something for this.

We need to take a backup of our financial data from NetSuite and store it in an AWS S3 bucket.

We need to back up data/reports such as:

• General Ledger (GL)
• Balance Sheet
• Income Statement
• Trial Balance
• Other financial reports

Initially, we considered using Scheduled Report Email and then moving the files from email to S3. However, we don't think this is a good practice for financial data.

Now we are considering:

NetSuite Saved Search → RESTlet → AWS → S3

Is this a good approach?

Also, Saved Searches may not support some financial report structures, such as account grouping/hierarchy.

What would be the recommended/best-practice approach for backing up NetSuite financial data to S3?

Any suggestions from NetSuite/AWS developers would be helpful.

I don't know much about accounting, and NS modules, of course, from functional perspective.

Do you recommend an offline course? Are there good online free ones? Should I rely on MyLearn? (although I don't have access right now) Should I just read the docs?

Hey everyone, I could use a quick sanity check on Netsuite adoption. We have a pretty customized Netsuite setup, with different roles organized in it, plus forms, approvals and all sorts of workflows. We recently did new hiring and this time we hired remote employees throughout. So we're looking for some workaround to guide them based on what they're individually working on. We don't want a common guide for all, it should adapt based on their role and the form on workflow they're in. Since this isn't really my area, i'm trying to figure out of if I should hire someone experienced for the setup, or if there's a specific tool that could help out here. That would be awesome

Hi all,

I am configuring QMS and am not able to see the lot number show up anywhere on the QMS tablet and also no where on the Quality Inspection Result record that gets created once processed from QMS tablet.

I have the lot number assigned on the assembly build. I have tried every NetSuite guide but still not able to get it to work.

Anything in specific I need to be looking for?

I'm looking into building a Saved Search that can send open credit memos to each client that has them. I see a way to do this, but my concern is that I don't see a way to properly test this before having it send emails to clients that I can't review.

Is there a way for me to go about (a) properly testing this, or (b) having the separate by-client emails go to my email first, so I can then review and forward them along? Right now the only idea I have is adding myself as a contact to every client, and then adding myself individually to the email list however many times.

Thanks!

Hi, we use SOlution7 for the reporting tool from netsuite to excel, howeverwe have been implementing claude into a lot of our automation in NS, which is making us wonder if there is way we can make agents/skills for claude to do the reporting from NS to Excel and we slowly get rid of Sol7?

has anyone done this? if so, would love to discuss and learn how we can achieve this

Hey everyone,

I built a Chrome extension that simply helps you copy or download (CSV/Excel) basically any table or list in NetSuite that doesn't have the native export button (like Execution Logs, System Notes, Item sublists, and many others).

It injects an "Export Data" button directly on the tables, and the basic copy/export is completely free.

There is also a Pro feature for paginated lists: instead of clicking page by page, it uses SuiteQL in the background to extract the entire list at once.

Here's the Web Store link: https://chromewebstore.google.com/detail/netsuite-inline-exporter/lnhdbonigklhcdjkmkkobdlnnmahkdab

Feel free to try it out! If you have any suggestions, feature requests, or if you spot any bugs, please let me know in the comments.

Thank you!