NetSuite allows you to import current sales tax codes for the states where you apply sales tax. Every month, NetSuite refreshes its database with the latest tax rates for all U.S. states. The Version field on the State Tax Import page shows the date when the tax rate change becomes effective. NetSuite sources these tax updates from Wolters Kluwer, and you can find more information on their website at wolterskluwer.com. 

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Tax Codes, State Tax

Bank reconciliation is a critical to financial management. NetSuite allows for efficiency in matching your bank transactions, allowing you to maintain accurate financial records seamlessly. NetSuite provides the ability to create custom reconciliation rules, which allows one to skip a lot of the manual process that comes in matching bank transactions.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Bank Reconciliation, Bank Data

If your business is printing a lot of checks, the use of multiple printers may be common. There may be cases where the Check PDF format set up in NetSuite may work for one printer, but may not work for another. There may also be cases where you need to print checks using different stocks. In these scenarios, utilizing the print offset settings in your Set Preferences may offer a quicker solution compared to creating a separate PDF Layout from scratch.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, PDF Formatting, Print Offsets

The Auto Assign UPC SuiteApp (Bundle ID: 316640) streamlines the process of assigning UPC codes to various item types within NetSuite, including inventory, assembly, inventory matrix, and assembly matrix items. Additionally, it provides functionality for creating, removing, and managing UPC codes. Through this SuiteApp, users can access a comprehensive list of all assigned UPC codes, along with their respective assignment and retirement dates, conveniently linked to the item records.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, SuiteApp, UPC

A common problem is updating values in NetSuite and then needing those old values or trying to recall what was there before. NetSuite system notes is a great tool that tracks changes throughout the system on essentially every record type. This will be an example of how to use systems notes on an item saved search.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Saved Search, System Notes

During normal operations, it is common to have checks not deposited or maybe a duplicate check was issued.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Void Check, Reverse Void

On August 2, 2024, UPS will be updating their authentication process. This will require NetSuite administrators to make several changes in the system to accommodate the authentication process change. Not implementing the changes may cause existing UPS integrations to fail on August 2. If you use the native NetSuite Shipping integration to quote shipping for sales orders during order entry or use the integration to generate shipping labels for UPS, this blog will help walk you through the necessary changes in NetSuite. Note: this change will not be required if you use Ship Central’s Ship Engine authentication for UPS.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Shipping, Integrations, UPS

Gift Certificates are managed through NetSuite’s Design to Build process; it is considered an Item Type. In order to add the Gift Certificate as an Item Type, you must first enable the feature and set account preferences. Below is a demonstration of how Gift Certificates are created, sold, and applied.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, NetSuite Gift Card, payment method, Gift Certificates

You can use the Mass Updates feature to locate multiple records with outdated information and update all their fields at once.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Netsuite Updates, Mass Updates, functionality, NetSuite Scripts

When creating custom fields that are many different options to choose from. The different options being in the field type, how the field is getting its value, are you using a list or saved search, do you need it to store its value, the list is quite long. There is one option that can be overlooked that is quite powerful, that field is the Global Search checkbox.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Custom Fields, Search, Global Search