Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Best Of
Trying to find an old discussion - 100 Ways to Use Formula Fields
Hi all!
It's been quite some time since I've visited the forums, and it looks like all of my subscribed discussions are missing.
I'm trying to locate an old discussion thread titled "100 Ways to Use Formula Fields" (https://usergroup.netsuite.com/users/node/423589)... however it doesn't seem to exist anymore. Wishing I printed a PDF of it for posterity.. Can a mod chime in on this? Maybe pull some strings and recover the discussion thread?
Thanks in advance!
Re: Electronic Bank Payments - Accessing the Bill Payment > Applied To Sub-tab
As I mentioned, we're already in the middle of implementing EBP and have created a custom file format so I don't know why you're telling me to purchase Electronic Bank Payments license. We can access everything we need except for what I said above. I'll go ahead and submit a case to Netsuite support.
Thank you
Re: Entity Relationship Diagram for NetSuite2.com Schema
Hello,
You may also check the Records Catalog Overview SuiteAnswer Article to find information about the record types and fields available for specific NetSuite channels. This dynamic NetSuite model reflects the customizations and features enabled or disabled in your account.
Thank you!
Anyone having issues with promotions on free items?
NetSuite Users — I need your help!
There’s an open enhancement request that would fix a long‑standing issue with Flat Rate Promotions.
🆔 Enhancement 860915
Title: Flat Rate Promotions should not be applied to Free Items
Status: Open – Accepting Votes
Right now, if a promo is set up as a Flat Rate discount, NetSuite still applies that discount to items that are intentionally added to the order at $0.00. This creates inaccurate discounts, messy reporting, and prevents businesses from giving free items without unintended markdowns.
This enhancement would allow (or default) Flat Rate Promotions to exclude free items, which is exactly how most businesses expect promotions to behave.
If this would help your team or your clients, please take a moment to vote for Enhancement #860915 in SuiteIdeas. Every vote helps push this forward.
Let’s get NetSuite to fix this one!!!
Re: CoPilot and MCP - How to get it working?
Hi @mv_gibson . It looks like Oracle took down the article. I'm not sure it does any good to post what it said here, but you can find the link still on this page:
Note that the link from that page is the same, so is also invalid (maybe will be valid again if Copilot Studio decides to support PKCE).
glindner
Re: Unrestricted Saved Search not returning results for non-admin users on formula columns.
I see what you mean, and, in theory, the formula should have worked.
At the same time, because you are referencing "WHEN [type] = …", NetSuite should scan all transaction types to find the right types. These roles likely don't have access to all transaction types, which is causing the issue.
Can you check whether the Custom Roles have the "Find Transaction" permission, with the level set to Edit or Full? I wonder if that may help.
If not, try the "WHEN {recordtype} IN ( 'invoice', 'creditmemo' )" and see if that helps.
The only other options are to update the roles and give them access to the missing Transaction Types (that you use in your account) or check the "Core Admin Permissions" checkbox on the Custom Role.
Re: Unrestricted Saved Search not returning results for non-admin users on formula columns.
Hey @Dext3r,
Most likely, the users don't have access to the records where the Formula is applied.
The "Run Unrestricted" can be confusing. It lifts some of the Role restrictions, but you should assign the right permissions to the related Custom Roles.
Here is an extract from SAID 8474
Re: CoPilot and MCP - How to get it working?
I'm also hitting a similar issue and when I try to connect I get
PkceFailed
This is really frustrating as there is a suite answers article specifying this is possible to do but it doesn't seem like it is.
Re: rejection remark with no script
Hi @User_Q1DPO ,
What record types are you trying to approve or reject? There are a lot of them in NetSuite.
We need these details to help.
Re: Sales order print has an error, unable to identify the same
Hi @User_IM2YY
If you can't find the error, you may need to file a case with support.






