In today's data-driven world, businesses rely on robust systems to manage and analyze their financial and operational data. Open Database Connectivity (ODBC) stands out as a powerful tool for integrating NetSuite with other applications.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, ODBC, Database Connectivity, API

In NetSuite, you can create saved csv mappings, so that you can save time mapping fields for reoccurring imports. However, you must mark them as Public for other users to access the mapping.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, CSV Import, CSV Import Mappings

Item records allow you to track and manage the goods and services your company buys and sells in the course of doing business. This can be done by using two files during the upload: one is for Primary, the other is for Item Members. Below are the steps:

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, Inventory Management, NetSuite Tips, CSV Import

CSV imports is a great and powerful tool for all users to master. However, there is a function that is not available to all users on imports which is the Run Server SuiteScript and Trigger Workflows checkbox.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, Inventory Management, NetSuite Tips, CSV Import, Workflow, NetSuite Scripts

Returns can be a complicated process if the proper steps are not followed. The proper steps for returns in NetSuite include three to four records. This is the breakdown of that process RMA > Item Receipt > Credit Memo > Customer Refund (optional). As you can see, these are the required steps, but each one could be done by different users and cause delay if proper communication is not done.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, Inventory Management, NetSuite Tips, Item Receipt, RMA, Customer Refund

When creating saved csv imports, these saved mappings are defaulted to Private. This means that they are not able to other users in the system. Only Admin users would be able to see and use these if needed.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, Inventory Management, NetSuite Tips, CSV Import

A fulfillment request serves as an intermediary transaction between a sales order and the actual fulfillment process in the order fulfillment workflow. Essentially, it is a request to fulfill a sales order. This process allows employees at a fulfillment location, typically a store, to manage orders that need to be shipped to or picked up by customers. At the store, employees can view, accept, reject, and process fulfillment requests to complete the order.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, Inventory Management, NetSuite Tips

We previously published a Short & Suite on our YouTube channel covering NetSuite WMS’s inventory cycle count process. Quick aside, if you have not checked out our line up of YouTube videos, I encourage you to search for us by typing Concentrus into YouTube for loads of helpful NetSuite videos and how-tos. In any case, in that video I demonstrated one way to count inventory in NetSuite using a handheld. The other way is through the Smart Count SuiteApp which is included with your NetSuite WMS license. These two process options are both available to you, but Smart Count is considered the latest and greatest from NetSuite and will continue to receive updates as the software matures. Regardless, I would like to give you an overview of how SuiteApp can help you manage your inventory accuracy and cycle count process.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, Inventory Management, NetSuite Tips, WMS, Inventory Counts, Warehouse Management, Inventory Control, Cycle Count

The Trial Balance is a report that displays the balance of each active account as of a specific date, typically the end of the month. The account balances are listed in both debit and credit columns. Accountants generate this report before creating financial statements to ensure that the debits and credits are balanced. Once the trial balance is in equilibrium, the financial statements can be prepared. To view the Trial Balance report, follow these steps: Navigate to Reports > Financial > Trial Balance.

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

If you have worked with NetSuite item records, you might be familiar with the Locations subtab found under the Purchasing/Inventory tab. In general, this tab offers useful informational attributes about an item including inventory, costing, among others. However, depending on the features you have enabled in your environment or the needs of the people working with these item records, the amount of information displayed can equate to noise. To address these and other concerns, NetSuite has developed a feature named Advanced Item Location Configuration which we will review in this blog.

Tags: NetSuite, ERP, Reporting, NetSuite Partner, NetSuite How To's, NetSuite Tips, Inventory, Items, Costing, Configuration, Location