r/Netsuite

We recently went live on NetSuite and I’m trying hard to keep an open mind, but I honestly need a reality check from people who’ve lived in it longer than a few months.

I came from more traditional GL/accounting systems where a lot of things felt faster and more intuitive. In NS, I feel like simple tasks require way too many clicks, tabs, mappings, validations, uploads, approvals, etc.

A few examples:

• Uploading journal entries feels unnecessarily painful
• Intercompany entries seem especially cumbersome
• Running basic GL detail or researching transactions feels less straightforward than expected
• The segmentation structure makes sense conceptually, but operationally it feels like every entry turns into a logic puzzle
• The overall UI/look-and-feel just feels… busy? disconnected? I don’t know how to explain it

To be fair: We are very early in implementation, have multiple entities/subsidiaries, still harmonizing mappings and workflows.. I know some frustration is probably “learning curve” pain.

But I’m genuinely wondering if it gets significantly better once you know the system well?
Or is some level of “this takes 14 steps for something that used to take 3” just part of the NetSuite experience?

I’d especially love feedback from accountants/controllers working in complex nonprofit or multi-entity environments. I can’t tell if I’m being "old-school"… or if others felt this same agitation early on.

Would appreciate honest feedback, tips, or even “you’re not crazy” validation.

We have a subsidiary hierarchy 3 levels deep. we have the main org (ONE Company) we then have 2 branches (US Co, CANADA Co), then individual companies underneath that.

Most items were setup under ONE Company, but some items mistakenly got setup under US Co. How can I get the items that were setup as ONE Company : US Co, instead of ONE Company on saved search? Pulling US co gives me all items since they are under ONE Company.

We recently implemented a Claude MCP connection into NetSuite, and it’s working well for conversational querying and analysis.

However, our client is now asking for a more direct reporting workflow into Excel, without needing to ask Claude for a report first and then export it manually.

The ideal use case they described is something like:

• Paste a report/link/query into Excel
• Pass parameters like date range, subsidiary, etc.
• Hit refresh
• Pull live NetSuite data automatically

Mainly for things like:

• Trial Balance
• GL detail
• AP aging
• transaction-level reporting

From what I understand so far, native NetSuite report URLs probably aren’t the right approach for this, so I’m trying to understand what architecture people usually use in practice.

Questions:

• Are you typically exposing SuiteQL through RESTlets/custom endpoints?
• Is SuiteAnalytics Connect/ODBC a better long-term solution for Excel refreshes?
• Can Excel realistically consume the same data layer already being used for MCP/Claude integrations?
• How are people balancing AI tooling vs direct BI/reporting pipelines right now?

Would appreciate hearing how others are approaching this in real-world NetSuite environments.

Hi all,

When using a specific text field in netsuite and displaying it as a result, the filter option of this field expects the exact match. For example the result is 135780, it will only bring back the result if the filter is applied as 135780. Is there a way to use perhaps a formula as a filter to accept 5780 and still bring back the result? I can in the results use a text formula to remove all the first two digits from a field value for example, but I'm not sure how to make the filter option accept that or make the connection.

I need help finding a 3rd party reporting / analytics service, out of the box. I need to be able to make better visuals & dashboards, ideally tie in date from other LOBs.

Back in the QB days, I used Syft Analytics or Fathom, but neither supports NS.

Thoughts? Suggestions?

Hello guys,

My main goal is to create an intercompany adjustment entry for employee expenses.

For this, I have created and employee expense report in which the billing subsidiary is different from the employee subsidiary. I have followed the suiteanswers and the steps given on the help in NetSuite. Enabled the preferences, and the IC clearing account is also present.

But even after creating, approving and paying the expense report and later trying to create an intercompany adjustment by selecting the period and clicking on submit, I am still not able to see this expense report in on the inter company adjustment page.

Am I doing something wrong? Or missing any steps?

Basically, I'm trying to Achieve this

Hi All -

I've got one user who lives and dies by his KPI's. The problem we're having is that his KPI numbers are often out of date and/or just wrong.

As an example, here is what he sees as his receivables:

Even after refreshing the widget and/or a control-F5 in the browser, his current Receivables is listed at $194,627.

However, if we drill down on the Receivables, the summary shows this:

While it showed $194,627 in the KPI, the actual A/R Aging Summary is showing $262,075.68. If we drill down into the A/R detail, it matches that $262k number.

Right now there is a difference of ~$72,020 between the A/R KPI and the A/R Summary/Detail reports. As I said, refreshing things doesn't matter.

How/why are these numbers different? I tried to find some combination/permutation of the detail report that adds up to the $72,020, but I could not.

Hey everyone,

I’m getting a record doesn’t exist error when using record.load in a suitelet script

var rec = record.load({
type: record.Type.SALES_ORDER,
id: 12345,
isDynamic: false
});

I tried (type: “salesorder”)

The record is right in front of me through UI, deployment has run as administrator, all roles, all employees

I tried searching for the record through the same script and I’m getting nothing, any idea what to try next?

I also checked my user, I have admin access and no location and the sales order has no location as well and there doesn’t seem to be any restrictions my user and the sales order have the same subsidiary as well and the script also doesn’t work with different subsidiary sales orders, not sure if that makes a difference.

Hi everyone, I want to ask for some career advice from people working in ERP or NetSuite-related roles.

I’m currently working in Accounts Receivable and use NetSuite everyday. Recently I noticed that the part of my job I enjoy the most isn’t really the AR work itself, but the system side of things like making saved searches, building reports, figuring out workflows, and trying to make processes more efficient. It honestly made me interested in eventually moving into a NetSuite or ERP-focused career path, maybe as a consultant, admin, functional analyst, or support role.

The problem is I don’t have direct consultant experience yet, only user experience from the finance side. I’m planning to study more seriously and hopefully get certifications in the future, but I’m wondering if that’s enough to at least get my foot in the door.

For people already in the field:

1. Is it possible to transition from AR/FinOps into ERP roles?

2. Would certifications help even without direct implementation experience?

3. What roles should I realistically aim for first?

Would really appreciate hearing from anyone who made a similar move. Thanks!

Is anyone else experiencing a NetSuite outage? Our account is completely down, and we can’t log in to NetSuite.

Is there a way to populdate the createdFrom field when creating a standalone credit memo

Hello,

I have my first interview for NetSuite Senior Consultant role at EY and Deloitte. I would appreciate tips to prepare for the interview or just learning about other people’s experiences.

Thank you!

Hi everyone, I've passed Suitefoundation exam 5 days ago through Webassessor, and I only got the result email and don't know any platform to download my certificate. I've also emailed nsgbu-certification_ww@oracle.com but no reply. Can anyone help?

Running NetSuite for a Mexico subsidiary. We have a large number of vendor bills from 2023 where the main AP line (account 20200002) has been paid and the bill shows Paid in Full, but the withholding tax lines on accounts 20520003 (ISR 10%) and 20510006 (IVA 2/3 partes) still appear as open on our Open Bills aging report.
Background on what happened: when we originally paid the withholding taxes to SAT, the JE that debited those accounts was posted without a vendor tag. So the GL balance is correct, but the AP subledger still sees the original bill credits on those accounts as open because there's no vendor-tagged debit to match against them.
I tried posting a correcting JE with the following structure:
Debit 20520003 / 20510006 [with vendor] → line ID 0
Credit 20520003 / 20510006 [no vendor] → line ID 1
The JE uploaded successfully but I still can't close the bill. Since the bill shows "Paid in Full" I can't apply anything directly to it through the normal payment flow.

Any idea how to handle this?

When creating a vendor bill and saving via the UI, I am getting a SuiteScript error that the invoice number already exists. Saved searches are showing that it doesn't actually exist. What can be causing this incorrect error to show??

our company is being purchased, and for a number of reasons id rather not re live, I need to set up a new subsidiary to use moving forward. I need to have our inventory transfered from the old subsidiary to the new subsidiary, and I need to add the subsidiary to all the items to be able to do this. I get an error about location on 63 of our 3300 items, on the other 3237 i removed the preferred location and it worked. but on 63 lot numbered assembly items i get the error complaining about the location.

https://preview.redd.it/nenrbi1lu42h1.png?width=930&format=png&auto=webp&s=f7228ce792e818f63549502d5463f8d09b3c05b1

I am building an SQL query that calculates the balances per each Bank Account in that ACCOUNT CURRENCY.

I do see transactions where the transaction currency is different from the account currency.
My question is - what is the meaning of the foreignamount field in the transactionline table in such cases? For example, one of the accounts is in USD, but one of the transaction currencies is GBP, so if I see 20000 in foreignamount - is it in GBP or USD
Can someone clarify please?
Thank you

SELECT a.id AS account_id, a.acctNumber AS account_number, a.fullname AS account_name, BUILTIN.DF(a.currency) AS account_currency, SUM(tl.foreignamount) AS balance_account_ccy, SUM(tal.amount) AS balance_base_ccy FROM TransactionAccountingLine tal JOIN TransactionLine tl ON tal.transaction = tl.transaction AND tal.transactionline = tl.id JOIN Account a ON tal.account = a.id JOIN Transaction t ON tal.transaction = t.id WHERE a.accttype = 'Bank' AND tal.posting = 'T' AND tal.accountingbook = 1 -- Primary Book - verify ID AND t.trandate <= TO_DATE('2024-12-31', 'YYYY-MM-DD') -- as-of cutoff GROUP BY a.id, a.acctNumber, a.fullname, a.currency ORDER BY a.acctNumber

Hi everyone,

I got a requirement in NetSuite where on Credit Memo creation, I need to create a parent custom record (X) along with multiple child records (Y). The number of child records is dynamic.

Initially, I handled this using a User Event script to track Credit Memo creation and then triggered a Scheduled Script to create the records asynchronously, since the process was a bit heavy for real-time execution.

The issue is that if multiple users create Credit Memos simultaneously, some executions get skipped because only one scheduled script deployment was available. I then added multiple deployments, which improved things, but now the concern is: how many deployments should realistically be created since concurrent submissions are unpredictable?

The client wants the process to feel near real-time, so a periodic scheduled approach is not preferred.

From an architecture/scalability perspective, what would be the best approach here or I am doing it in a right way.

I am always confused on such kinds of things where the process needs to be in real time but we cannot handle the whole thing in one user event only.

Hey everyone,

We’re reviewing our Order‑to‑Cash (O2C) flow and want real feedback from folks using NetSuite day‑to‑day. If you could change or add a single improvement to your O2C process (anything from quoting, sales orders, fulfillment, invoicing, payments, AR collections, settlements, automations, reporting, or integrations), what would it be and why?

Anyone willing to share their permission list for a Custom IT Role that they assign to their IT Department?

We recently switched our managed services IT company and they have no clue about NetSuite. I need to remove their Admin login so they don’t mess anything up but not sure what a standard IT user should have. User resets and a few integrations are the extend of their NetSuite involvement.