Once assets are loaded in NetSuite’s Fixed Asset Management module (“FAM”), besides initiating monthly depreciation, there are some ongoing troubleshooting or maintenance.  This blog will share some common tips and tricks.  

Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips, FAM, Fixed Asset, Troubleshoot, Asset Transfer, Locked Period, Fixed Asset Management

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

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

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

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

You want to review month over month movement of your Balance Sheet.  You will notice in order to see a month-by-month trend, you can add the Accounting Period on the columns, but it shows all the historical periods.  Are there times you would like a quick view of the Balance Sheet for recent periods.  Your options could be running it for all periods and deleting the columns you don’t need in excel or manually set the periods using custom periods.  The process below will help you run a dynamic balance sheet by month for the last 3 periods by changing the date on the Reports Page without having to go back to the customization page.  

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Trend, Balance Sheet, Statement

Have you ever wondered if there was an easier way to get a detail report of Undeposited Funds for a previous Date?  If you have a lot of transactions that flow in and out of this account, it can be a daunting task if you don’t reconcile this right after month-end close or even if there happened to be back-dated transactions after you month-end bank reconciliation.   The following search will help you download a saved search report to solve that issue. 

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Financial, Bank Reconciliation, Bank Account, Saved Search, Transactions, Undeposited Funds

What is Segmentation in Netsuite? Segmentation or classification are ways to categorize entity (Vendor, Customer, Item) records and transactions amounts in NetSuite.  For instance, you may want to see your Income Statement separated out by Location; Location will be a classification field on your transactions.  There is native reporting function that will automatically break up your Financial Statements in segmentations.  

Tags: NetSuite, Reporting, NetSuite How To's, Accounting, NetSuite Tips, Segmentation, Financial, Transactions, Classification, Income Statement, Journal Entry, Trial Balances, Reclass