Exporting SuiteAnalytics Dataset as SQL
Learn how to export NetSuite datasets as SQL queries to uncover complex joins, field relationships, and improve script performance.
Read the Article
NetSuite Consultant
Basil is joyful, driven, and calm—someone who brings analytical thinking and steady focus to every challenge. He strives to keep faith and love at the center of his life, and he enjoys working alongside people who share these values. He loves software, data analytics, computer programming, and consulting, and he appreciates how his coworkers push him to grow both personally and professionally. He holds a degree in business administration with majors in accounting and information systems. During college, he completed internships in internal audit and tech risk consulting and served as a project analyst and project manager with Badger Consulting, a pro-bono consulting agency through the Wisconsin School of Business. He finds the work at Anchor Group both challenging and enjoyable, which is exactly the combination he was looking for. Outside of work, Basil enjoys fishing, spending time with his wife, hiking, playing ultimate frisbee, singing in choir, drawing, painting, and playing piano.
Learn how to export NetSuite datasets as SQL queries to uncover complex joins, field relationships, and improve script performance.
Read the Article
Fix broken NetSuite email template links by dynamically generating transaction URLs for sales orders, invoices, and other record types.
Read the Article
Recent NetSuite changes have created logo sourcing issues and formatting changes on PDFs. Here's how to resolve the logo sourcing issue on NetSuite PDFs.
Read the Article
This article outlines how a Saved Search can quickly be transformed into a graph on your NetSuite dashboard using the ‘Custom Search' portlet.
Read the Article
Saving a SuiteQL Query is a built-in feature of Tim Dietrich’s SuiteQL Query Tool. Enabling this functionality requires a few simple customizations: you'll need to create a folder in the File Cabinet and make a minor edit to the SuiteQL Query Tool script. The steps to set this up are outlined below.
Read the Article
There is no current native function for a mass update, CSV import, or workflow to inactivate or activate more than one record at a time from an item list.
Read the Article
Sometimes NetSuite reports, saved searches, and analytics workbooks fall short of providing the data needed for a task. When those native tools hit their limits, it’s time to turn to SuiteQL!
Read the Article