Have you ever wanted or needed a quick comparative view of your Intercompany transactions between your subsidiaries?  One way to achieve this is through the use of CASE Statements in Saved Searches.  What is a CASE Statement?  A CASE Statement is similar to that of an if-then-else statement.  You may have encountered this in spreadsheets.  In NetSuite, it’s an available function that allows you to program conditions to return values when those conditions are met.  So, when a condition is true, NetSuite will provide the results based on those conditions.  You can have multiple conditions in one CASE Statement.

Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips, Saved Search, Reconciliation, CASE, Formula, If-Then

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

NetSuite’s Fixed Asset Management Module (“FAM”) is a great tool to manage the full life of an asset.  It gets a little tricky when you load in assets at mid-life.  Several things can throw off your balances and values.  Let’s say it’s been a few months since you’ve implemented the FAM module and you’ve run a few deprecation transactions with the module. You notice that the cumulative deprecation from your asset records do not match the cumulative depreciation on your Balance Sheet. Below are a few tips on how to troubleshoot and fix the issue.  

Tags: NetSuite, NetSuite How To's, NetSuite Tips, Fixed Asset, Troubleshoot, Net Book Value, Cumulative Depreciation

Enterprise resource planning (ERP) systems are key to getting a single, 360 degree view of your business. It helps you move from disparate data to actionable, real-time data that you can use to increase your bottom line. And guess what? People are getting it. ERP adoption has soared in the last few years because companies understand how important it is to overall business success.  

Tags: NetSuite, ERP, Reporting, NetSuite How To's, NetSuite Tips, Acumatica, Statistics

In a previous blog, I covered the order release process through the Netsuite WMS wave release feature. The feature comes standard with Netsuite’s warehouse management software and among its toolset provides several options to specify how warehouse pickers should pick assigned orders. If you’re considering Netsuite WMS, or perhaps already use it, you may want to know the different methods available to pick orders and how they differ. If so, this blog is for you! Let’s jump right in and see what’s available in Netsuite WMS.  

Tags: NetSuite, NetSuite How To's, Warehouse Management System (WMS), NetSuite Tips, WMS, Supply Chain Management, Netsuite WMS, Pack Station, Pack

Netsuite’s PackStation application offers a way to re-print important documents through the mobile UI on the go. In most cases, mobile warehouse operators are able to quickly reprint documents right from the handheld. However, there may be occasions where this may not be possible or where an alternative may be desired. An alternative option is to print the document through the Netsuite UI, and the process is fairly straightforward. In addition to printing documents through the Netsuite UI, you are also able to send documents straight through the PrintNode connection out to the warehouse. Let’s take a look at both options.

Tags: NetSuite, NetSuite How To's, Warehouse Management System (WMS), NetSuite Tips, WMS, Supply Chain Management, Netsuite WMS, Pack Station, Pack

Time entry is important for many different businesses, particularly project based businesses.  For instance, service companies charge their clients by the hour.  Therefore, tracking and billing the correct number of hours by project determines the profitability of a company.  Ultimately, it helps companies track costs or billable time is the source of their revenue.   

Tags: NetSuite, NetSuite How To's, NetSuite Tips, Project Time Entry, Troubleshoot, Errors, Time Entry, Billable Time

There are many reasons why a company may want to have dates and periods not match-up.  One common reason may be related to the month-end close process. A company may want to enter the actual date (which is in a prior period) of a vendor bill, but since the previous period has already been closed, they will post to the current period for financial purposes.  NetSuite can allowtransaction dates outside of the posting periods through the company’s Accounting Preferences.  This can increase the risk of unwanted date/period mismatches as well as cause headaches for reconciliations between AR/AP Aging reports to the Balance Sheet.  One way to monitor this is through a Saved Search. 

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Accounting Periods, Saved Search, Transactions, Date Mismatch

During your WMS PackStation implementation, you may have noticed your packages have autogenerated numbers. Generally, those autogenerated packages follow the numbering scheme of sales order # + some number. In most cases, the default numbering scheme will suffice for most customers. However, as with most settings in Netsuite, this can be customized based on business requirements.  

Tags: NetSuite, Reporting, NetSuite How To's, Warehouse Management System (WMS), NetSuite Tips, WMS, Supply Chain Management, Netsuite WMS, Shipping, Pack Station, Carton

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