r/Netsuite

I missed the distinction that Netsuite Next is not an upgrade to 'legacy' Netsuite but a separate product. Has there been any discussion about the cost of this 'upgrade'? One year after implementation and we are running a legacy system - wonderful.

I’m curious how everyone approaches the Buy vs. Build decision in NetSuite.

Over the years, I’ve seen companies accumulate a long list of SaaS subscriptions - approvals, inventory tools, reporting, integrations, document generation, customer portals, workflow automation, etc. Many of these solve a real problem, but they also add recurring monthly or annual costs.

With how much NetSuite has evolved (SuiteScript, SuiteFlow, SuiteQL, REST APIs, AI capabilities, custom records, dashboards), I wonder if some of these subscriptions could now be replaced with native NetSuite solutions built once and maintained internally.
A few questions for the community:

What third-party subscription are you paying for today that you wish NetSuite could handle?

Have you replaced any SaaS product with a custom NetSuite solution? If so, what was it?

Was the one-time development cost worth eliminating recurring subscription fees?

Are there automations your team still performs manually because you haven’t found the right solution?

I’m not suggesting everything should be built in-house - there are plenty of products that are absolutely worth paying for. But I’ve also seen cases where companies continue paying subscription fees simply because nobody revisited the process after NetSuite became more capable.

I’d love to hear real examples. What has been your biggest “buy vs. build” win (or regret)?

The client requirement is to create a saved search where it has to show all the following fields in the results:

Date

PR#

Requester Name

PO#

Item

Item description

Status

Receipt Date

What we did is:

created 2 saved searches as follows

1. PR->PO->IR

https://preview.redd.it/lwipuplvxlbh1.png?width=934&format=png&auto=webp&s=42bc9575510291a2ef682ce086ab525a84ffcef6

2. PO->IR

https://preview.redd.it/3vbtrvxxxlbh1.png?width=933&format=png&auto=webp&s=efbfeb8f68101670df52312ea81bbabb4cc3953c

But in the second saved search i am having results of saves search 1(obviously) but how can i remove POs created from PR.

Also how can i get exact IR date?

Is it possible to combine both the saved Searches into 1

Every answer/response is appreciated. :D

So, there is this case where the client needs watermark called "Draft" when it is on Pending Approval state.
So, I found 2 solutions for this.

1. using macro id = "watermark"

2. Directly giving it in style section.

But in both the cased I can't Resize the watermark/img. So, I had to walk a hard path by resizing it manually using word and exported as image.

Do you guys have any better solution for such cases.
Every response is appreciated. :D

Hi everyone,

I'm facing an issue with a NetSuite saved search and would appreciate any insights.

I have a saved search based on Purchase Requisitions. In the Results tab, I've added Item : Description, but the output shows "- None -" for every record.

However, when I open the related Purchase Order, the Description column on the item line contains a value.

Here's what I've checked so far:

• The item is a Non-Inventory Item.
• The Purchase Description field on the item record is empty.
• There is no standard Description field populated on the item record.
• Yet the PO line still displays a description.

My questions are:

1. Where is this line-level description coming from?
2. Is it possible that it's being populated by a Workflow or SuiteScript?
3. How can I retrieve the same line-level description in a saved search?
4. Should I be using a different field instead of Item : Description?

Has anyone encountered this before? Any suggestions on how to identify the source of the description or the correct saved search field would be greatly appreciated.

Greetings. I work for a company who's primary business is as an Electrical Supply distibutior. We run on a home grown ERP system that is just not meeting our needs. We received demos and quotes from both Acumatica and NetSuite. Right now we are leaning toward NetSuite but the initial cost (implementation + software licenses for ~25 users) is daunting. Would love to hear from others that have been through a NetSuite implementation, especially anything to be aware of and possible mistakes to avoid. Thank you very much

I'm a Lead NetSuite Consultant with 7+ years of end-to-end implementation experience and I'm looking for new job opportunities. I mainly look at linkedin but there aren't too many opportunities open right now. Any other job posting spaces fellow consultants use to get clients?

I'm also curious to see if it's better to just do freelance NetSuite consulting rather than working for a company. Let me know your thoughts!

I’m an AP Analyst at human services company that provides Representative Payee services for Social Security beneficiaries. Our accounting workflow doesn’t fit a typical AR or AP process, and we’re trying to determine the best-practice NetSuite design.

Our process

* We have one pooled bank account that receives Social Security deposits for many clients.

* The money belongs to each client individually—we’re only managing it as their Representative Payee.

* We need to track each client’s running balance separately.

* We issue payments from that same bank account for:

* Room & Board

* Personal Needs

* Other approved client expenses

* Payments are made by ACH or check.

* Every transaction must reconcile through the bank feed.

What we’ve tried

Initially we linked each person as both:

* a Customer (Client) for deposits and balance tracking
-this includes creating invoices from billable bills and applying the deposit to the invoice so their deposit balance decreases.

* a Vendor for outgoing payments

A NetSuite Pro Bono consultant thought this approach made sense.

This week, another consultant recommended eliminating the Vendor entirely and using only:

* Customer Invoice

* Client Deposit

* Credit Memo

* Client Refund

Their reasoning was to keep everything on the AR side.

My concern

Our clients do not owe us money in the traditional AR sense.

We are simply holding and disbursing their own funds.

Using Credit Memos and Client Refunds feels more like refunding an overpayment than paying expenses from funds we manage.

My questions

1. Has anyone implemented a Representative Payee or trust-account style process in NetSuite?

2. Would you keep the linked Customer + Vendor model?

3. Is there a better native NetSuite approach for tracking individual client balances while reconciling one pooled bank account?

4. How would you produce a client ledger or monthly statement showing deposits, rent, personal needs, and the remaining balance?

Any advice would be greatly appreciated!

I'm sure a lot of companies use Shopify as their shopping cart and do their fulfillment for those orders out of Netsuite.

Shopify offers Shopify shipping and it's cheaper than Stamps.com/Endicia in Netsuite and cheaper than regular UPS/Fedex/whatever, but Netsuite cannot use Shopify's shipping rates/labels as there is no integration there.

What do you use that is -preferably- cheaper than Shopify's own shipping rates? I'm sure companies that use Netsuite don't fulfill their orders in Shopify?

Recovering from a failed ERP implementation. New to NetSuite.
We have advanced manufacturing on and I want to Kit, then build, then complete work order.
Does the following make sense? there must be a better way to do this?
1 My kitting person needs to be able to see released work orders so Manufacturing>Print Dispatch list.
2 Now to kit parts, create a Work Order Issue and use the Kit operation. I kit all components because I want this to draw inventory and move things to WIP.
3 The shop guys make a Work Order completion, but the quantity is greyed out because I used everything in the Kitting step. I cannot finish this for with 0 quantity.

So how can I really kit these items because it seems like i finished building them in the kitting stage.

Hey everyone,

I have evaluated Ramp a few times but never pulled the trigger because of them syncing a URL to the bill record and that was a deal breaker for our team.

They have reached out to me saying that their integration can now sync the pdf copy of the invoice to the bill record.

Can any users confirm that this is actually working for them? I haven’t seen the update on their support page, and I don’t want to waste my teams time to bring them back into an evaluation without confidence it will work.

TIA

Hi all,

I'm trying to access the allocatedSupply table through NetSuite2.com (ODBC) and have run into some strange behaviour.

Our company has two NetSuite instances. I have been granted what appears to be the same permissions in both instances. When running SuiteQL directly in the NetSuite UI, I can successfully query allocatedSupply in both environments:

1. SELECT * FROM allocatedSupply

2. SELECT TOP 5 * FROM allocatedSupply

Both return data as expected.

However, when I run the same queries through the NetSuite2.com ODBC driver:

• Instance A returns an empty table. Interestingly, it includes all the columns I see in the UI plus some additional columns.
• Instance B returns "Base table allocatedSupply was not found"

I've also tried joining allocatedSupply to transactionLine, but that either returns no data or produces the same error.

A few things I'm wondering:

• Is allocatedSupply actually supported through NetSuite2.com ODBC?
• Are there any known limitations where a table is available in SuiteQL but not through ODBC?
• Could this be permission-related even though I can query it from the UI?
• Has anyone found an alternative way to retrieve allocated supply information?
• Any ideas why two instances would behave differently with the same user permissions?

Any suggestions or workarounds would be greatly appreciated. Thanks!

Can someone explain how AR written off can be done in netsuite by creating CM?it has item based transaction. Thanks in advance

What do the Left/Right arrow buttons do, in the top right of a record next to List and Search

Instinctively this would take you to the next record of the same type, in numerical order of internal ID… or just the next record. But it seems to be random. Is it the next record assigned to you in some way?

Interestingly, not mentioned in the “navigating NetSuite” documentation, that I could see: https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/section\_N474404.html

Hey guys! We’re trying to find an automated setup for our accounts receivables NetSuite. Right now we have to constantly manually update our billing schedules via spreadsheets to handle custom client discounts / tiered usage.

Looking for any recommendations to remedy this. Thanks!

We are currently manually setting up all our LTL shipments, what options are out there for TMS Integration? Anyone have preferred options and ones to avoid like the plague - We ships HAZMAT often

Hi there. I'm not sure if anyone has experience with this, but I can't seem to find much online. I'm playing in sandbox as admin and we have a new non-posting book set up for this, but it doesn't appear that we can associate a non-primary book to an asset type. If anyone has knowledge or can point me in the right direction, it would be greatly appreciated. Also, love that we are trying to tackle this at quarter close LOL. 🤯

Last time I shared this Chrome extension for NetSuite and Celigo (it auto-detects which one you're on). I really want this tool to be a swiss army knife with everything included so you do not have the need for extra extensions. I added some new features

• SuiteScript Search 
• Page Performance Checker 
• JSON Inspector
• SuiteQL Runner
• Field Highlighter — find any field on a record instantly
• Saved Search input-field helper

It's read-only by default and runs on your existing logged-in session — no credentials stored, nothing sent anywhere. 

Free here: https://chromewebstore.google.com/detail/teknuro-power-tools-for-n/fbclbmdlaofmojkhfmejnlhhgfmammji

If there is any other feature you would like to be included please let me know.

​

Has anyone ever implemented NetSuite for a doctors office? Or provided support for an existing netsuite client?