A Potpourri of NetSuite Topics

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.

SuiteAnalytics Presentation

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.

Roles, Permissions, Centers and Dashboards

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.

Inventory and Advanced Inventory

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

NetSuite Accounting Spotlight

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

SuiteTax, Advanced PDFs, and 2021.1 Update Overview

This meeting is a three-part meeting addressing two specific areas of NetSuite.

SuiteTax – This hour we will discuss how how NetSuite handles sales tax, including the Legacy Tax Solution, SuiteTax and alternative tax engines when SuiteTax isn’t robust enough.

Advanced PDFs – This hour we will discuss how to setup and start using the highly customizable Advanced PDF Printing templates. Starting with the basics, you’ll learn how to set standard transaction forms to use Advanced PDFs, how to start customizing Advanced PDFs with the WYSIWYG editor versus the source code mode, and then touch on some more advanced capabilities.

2021.1 Release Overview We will review what new features are coming out with the new 2021.1. Some of the new features include improvements to the shipping process as well as improved intercompany functionality in the Payables module.

Cash – How to Get Paid in NetSuite

It can be a challenge figuring out how to get cash in the quickest and most efficient way.  In this session, we will explore various NetSuite tools that help make the process easier.  We will start by an overview of Netsuite’s Order to Cash process, and then dive in where receiving cash comes into play. We will also touch on other aspects of the collection process such as dunning, credit cards, ACH and lockbox.  This session is ideal for all levels of NetSuite users who are interested in exploring different ways NetSuite handles incoming cash. This session will be presented by a variety of people with expertise in each of the topics being presented.