Are you using Avalara AvaTax to calculate tax in Netsuite? Avalara AvaTax automatically calculates sales and use tax for transactions, invoices, and other activity powered by NetSuite.Avatax is a comprehensive cloud-based tax calculation.I shared how to set a Customer to be Tax Exempt in U.S. and Canada in Avalara account in the previous blog. In this blog, I will share how to exempt customers from sales tax in NetSuite with an entity use code.
Kevin Suh, NetSuite Administrator
Recent Posts
Entity/Use Code in Customer Record & Transactions in Netsuite
Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Customization, Customer Records, Entity/Use Code, Avalara, AvaTax, Sales Tax
Counting Selected Values in a Custom Field from Saved Search
NetSuite provides a variety of search tools to identifyimportant information, filter criteria, and obtainthe real-time data. I will shareone of the latest NetSuite search tips, methods, formula restrictions, and the importance of using NetSuite’s tools to quickly find information. In this blog, I will share the great tip to count the number of selected values from the custom field.
Tags: NetSuite, ERP, Project Management, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Saved Search, Customization, Custom Fields
Inline Editing and Its Saved Search
Inline editing is a great feature in Netsuite.Inline list editing enables you to update records quickly by changing data directly in a record's row on the list page.This capability supports faster and easier editing because you do not have to go into each record to edit it.
Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, NetSuite Integrations, Saved Search, Cloud ERP, Inline Editing
Main Line Location and Line Level Location of the Vendor Bill
You might have encountered the experience where the GL impact for Line level Location of the Vendor Bill is different from the Mainline Location. You might have set the location field differently on thecustom Vendor Bill form. The expected behavior might be different from the user’s understanding.
Tags: NetSuite, ERP, Reporting, NetSuite How To's, Bills, Vendor Bill
Add/ Remove Multiple Line Items on a Transaction via CSV Import
Having trouble with the error: “Ambiguity error on logical key multi-match”? This article helps you to add multiple line items with the same item on a transaction via CSV Import or you would like to add new line items to existing transactions using CSV file uploads.
Tags: NetSuite, ERP, Reporting, NetSuite How To's, Transactions, Transaction Lines, Multi-Match, Sales Order, CSV Import
Netsuite Connector Saved Search Export
If you have a Netsuite Connector and need to export Saved Search results, the saved search export records in NetSuite can be configured to any File Transfer Protocol (FTP). NetSuite Connector uploads the saved search results to the configured FTP. You might be first interested in the Netsuite Connector. What is Netsuite Connector? NetSuite Connector (formerly called asFarApp) allows you to set up data mapping between NetSuite and your ecommerce storefronts, point-of-sale (POS) systems, online marketplaces and third-party logistics providers. By automating the transfer of data, you keep your vital information centralized and eliminate manual data entry, costly errors and delays, data exports and processes managed with spreadsheets and email.
Tags: NetSuite, NetSuite How To's, NetSuite Tips, Connectors, Saved Search, FTP, SFTP
Multiple Languages in Netsuite
Do you want to view Netsuite in different languages? With the Multi-Language feature, you can choose the language in which NetSuite displays whenever you log in to your account.
Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips, Language, Language Preference, Netsuite Language
Creating Manual Inventory Counts
The Inventory Count feature supports improved tracking of inventory and tighter control over assets. When this feature is enabled, you can enter regular periodic counts of on-hand item quantities to maintain inventory accuracy. Keeping an accurate item count can help reduce required safety stock, which lowers your overhead costs.
Tags: NetSuite, NetSuite How To's, Inventory Management, NetSuite Tips, Inventory
Orders Being Shipped Under North American Free Trade Agreement (NAFTA)
You might have encountered error/ notice: "There are no international customs documents to print for this fulfillment" when printing commercial invoice on Item Fulfillment. When shipping between US, Canada and Mexico, it is a requirement for NAFTA (North American Free Trade Agreement) Certificate of Origin to enter the criteria of the item being exported. What is NAFTA? And how does this impact you?
Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips, Order Fulfillment, Shipping, NAFTA
Change in JP Morgan Chase Connections for U.S. Bank Feeds in NetSuite
You might have received a notice last month regarding the news that JP Morgan Chase (JPMC) is moving away from Screen Scraping technology and will no longer support connections to their credential-based sites. Per notification, this change is part of JPMC’s transition to Open Banking technology which aims to improve security and ensure smooth bank feeds connection. If you are using the NetSuite Bank Feeds SuiteApp which may be importing data from the JP Morgan Chase & Co. (JPMC) financial institution, you might have encountered the bank data import errors on or after April 21, 2022.
Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Financial, Bank Reconciliation, Bank Account, data, Excel, Bank Statements