This meeting was on a selection of NetSuite topics:

SuiteQL – Tim Dietrich

Tim will introduce SuiteQL, a database query language that can be used to access data in NetSuite. He will explain the benefits of using SuiteQL, show example queries, and demonstrate the SuiteQL Query Tool (a free NetSuite application that can be used to run queries).

Bank Feeds – Dana Larson
The Bank Feeds feature in NetSuite allows you to connect with your bank and have the transactions imported automatically.  We will talk about how to set this up and its limitations along with options for reconciling your bank accounts in NetSuite.

Invoice Grouping – Mike Kachline
In 2021, Netsuite introduced the ability to “group together” invoices. In this quick chat, we will cover Netsuite’s “Invoice Group” functionality. What does it do? What can you do with invoice grouping? And general pros and cons.

Payment Link – Cory Anderson
The Payment Link feature allows your customers to conveniently pay an invoice online, using a computer or mobile device. Your customers can receive an email of the invoice with a link to the payment page. Learn how to enable and setup Payment Links in your account.

Matching Bills to Receipts and POs – Margie Komninos

Easily identify any price or quantity discrepancies on your vendor POs, item receipts and bills by using the Post Vendor Bill Variances feature to reveal and correct those transactions lingering in the Inventory Received Not Billed account.

Ethan Haberman, from Eide Bailly, will take us through a demonstration of the updated SuiteAnalytics Workbook functionality in NetSuite. With SuiteAnalytics Workbook, you can create highly customizable workbooks that combine queries, pivot tables, and charts using a single tool which accesses data directly from the underlying records in NetSuite. Recently added functionality allows for exporting to Excel, joining of multiple datasets, and support for additional records. Any NetSuite user or administrator, beginner to advanced, will find this useful. Even if you aren’t creating the Workbooks yourself you will learn what you can and can’t do with them.

Alexis Matson from RSM will discuss how to manage roles, including adding, updating and managing permissions, creating custom centers and creating and managing dashboards. She will cover these topics both from the perspective of an administrator managing items for a group of people as well as individual users who may want to change the look and feel of their dashboards. Any NetSuite user or administrator, beginner to advanced, will find this useful. Even if you aren’t creating dashboards, centers or roles yourself you will learn what you can and can’t do with them.

Cory Anderson of Eide Bailly and Margie Komninos of PlantScan Corporation (a manufacturing company) will present Inventory and Advanced Inventory functionality in NetSuite. Our main focus will be around physical inventory. The intended audiences are those new to NetSuite Inventory and those that have been using it, but want to understand some of the more complex areas of inventory associated with manufacturing. The list of planned topics includes:

• Different Type of Inventory
• Elements of an Item Record
• Warehouse Locations
• Inventory Adjustments vs Inventory Worksheets
• Reorder points, preferred stock levels, auto calc, …
• Purchase Order to Payment Process
• Drop Shipping and Special Order Inventory
• Landed Cost
• Assembly / Serialized Assembly Items
• Phantom vs Stock Items
• Useful Pages for Managing Inventory
• Work Orders and Assembly Builds
• Planned vs Released Word Orders to Identify Shortages

Once a year we focus on all things accounting.  For our July meeting, Dana Larson will be presenting on some core accounting topics that will be helpful to anyone responsible for this area of the business. The Standard report customization will be relevant for anyone customizing standard reports in NetSuite. 

• Date vs. Period Reporting
• Account Registers
• Journal Entries
• Advanced Intercompany Journal Entries
• Amortization Schedules
• Standard Financial Reports
• Customizing Financial Reports