Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
NetSuite Admin Tip | Display Values from the Transaction Record Using SuiteQL BUILTIN.DF
When working with the Transaction record in SuiteQL, some fields return internal values that are not easily understood at a glance. For example:
- The Status field may return a single-letter code.
- Fields like Entity, Employee, and LastModifiedBy return internal IDs.
- The Type field displays abbreviations like SalesOrd or PurchOrd.
These internal values are meaningful to the system but not very useful to end users or admins reviewing query results.
To improve readability, you can use the BUILTIN.DF() function, which translates internal IDs and codes into display-friendly (DF) values—such as customer names, employee names, or transaction types.
Here’s an example query that pulls data from the
Richard James Uri - SuiteCloud | WMS Tech | SuiteCommerce Advanced
----
- 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 Basic Accounting. RSVP on this event now!