Customizing NetSuite 2022

Cory Anderson of Cory Anderson Consulting presents Customizing NetSuite. He covers some of the basic and essential customizations possible in NetSuite as well as a few advanced topics. This meeting is designed for any NetSuite administrator or power user and will provide insight on how to customize NetSuite for your company’s users and business processes. Beginner and seasoned NetSuite users alike will find valuable takeaways to help them get the most out of NetSuite for their businesses. We will be covering, custom fields, custom lists, customizing forms (screen and printing options), and custom records. Margie Komninos of PlantScan Corporation will present Custom Segments in the Tips & Tricks section.”

Foreign Currency Exchange in NetSuite – FX 101

Peggy Evleth hosted a special, deep-dive session covering Foreign Currency Exchange (FX) in NetSuite. This session focused on key NetSuite functions including the following: • Company functional currency • Handling of foreign currency transactions • FX gains and loss handling • Consolidation of subsidiaries • CTA processing This session provides a basic overview for people who are using foreign currencies as part of their business but seek deeper knowledge as to how the system works.

NetSuite 101 – Back to Basics

Dana Larson from Dana Larson Consulting presented NetSuite 101 – Back to Basics. This meeting is a great meeting for folks who are new to NetSuite, as well as for those who have been using NetSuite for a while but could use a refresher on the basics. Even seasoned users might find pearls in this presentation!

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.