The Cloud is especially useful for medium-sized businesses because it gives them access to ERP at a reasonable price and doesn't require them to buy a lot of hardware and software up front. Find out why moving to a cloud ERP is a good idea.
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
In this article, we speak with Vincent Huang, owner and CEO of VHA, a wireless cell phone distribution company that has been in business for over 20 years. Here, he discusses all the technical, financial, and strategic considerations he had to make before switching from a client-server / on-premise ERP to one based in the cloud.
Tags: NetSuite, ERP, Reporting, NetSuite How To's, Accounting, NetSuite Tips, cloud-based ERP
Creating Statistical Accounts and Unit Types
NetSuite offers Statistical Accounts as part of their Advanced Financial module and these accounts enable you to track non-monetary data that you can use in reports and income statements. Users who utilize this function are often being asked to provide cost and revenue allocation, financial reporting using ratios and managing period close activities. Users can manually make statistical journal entries or autogenerate them through a saved search run by a statistical schedule. Users can also run record an absolute value when they manually create statistical journals, enabling them to capture periodic reporting such as office space by department or headcount by department.
Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips, Statistical Account, Dynamic Allocations, Unit Types
One of the most important Netsuite metric is your monthly transaction line use. Your transaction line use directly impacts yourNetsuite service tier because of how Netsuite’s service tiers scale with use. Simply put, the more transaction lines you use, the higher your service tier will be. For this reason, it’s critical to have a clear understanding of the distribution of transaction lines across the types of transactions you create. Understanding this data can help youidentify opportunities to reducetransaction use and can have a tangible impact on financial costs relating to your Netsuite service tier. In this blog we’ll look at what tools are available for monitoring transaction line usage and provide a use case for reducing usage if you have standard costing enabled.
Tags: NetSuite, Reporting, NetSuite How To's, NetSuite Tips, Netsuite Tier, Standard Cost, Inventory Costing, Inventory Cost Revaluation, Transaction Usage, Transaction Lines
We continue our Netsuite WMS series by discussing the bin concept and how bins are used to drive warehouse activities from an implementation perspective. Whether you are in the process of a WMS implementation, or are considering your options, it is important to put consideration behind your bin design. If you haven’t already, make sure to check out our blog on WMS zones and how they interact with bins. Understanding both concepts is critical to successfully implementing zones and bins as you go live with your chosen WMS.
Tags: NetSuite, Reporting, NetSuite How To's, Warehouse Management System (WMS), NetSuite Tips, WMS, Supply Chain Management, Netsuite WMS, Pick, Zone, BIN
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
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
CASE STATEMENT use case – Intercompany Reconciliation
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