Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
NetSuite Admin Tip | SuiteQL: Clean up Status Name in Results
When running SuiteQL queries on the Customer record, you might want to include the customer's status (e.g., Closed Won) in your results. This is commonly done using BUILTIN.DF(EntityStatus). This built-in function returns the display name (DF = display value) of the status from the related EntityStatus list. However, for customers, these prepends the word "Customer-" to the status label (e.g., "Customer-Closed Won"), which can make your results look cluttered, especially when generating reports or exporting data for your business use.
Original Query:
SELECT
ID, CompanyName, BUILTIN.DF(EntityStatus) AS Status FROM Customer
Improved Query with Cleaned Status:
Richard James Uri - SuiteCloud | WMS Tech | SuiteCommerce Advanced
----
- NetSuite Admin Corner | New to NetSuite
- Explore the NSC Webinars Category
- Join our poll and share your ideas! We want to know what you think. Don't forget to comment and make your voice heard!
- Expand your NetSuite knowledge by joining this month's Ask A Guru Live about Suitebuilder . RSVP on this event now!
Tagged:
1