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.
Add/ Remove Multiple Line Items on a Transaction via CSV Import
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
What better way to automate paperwork than to send and receive documents electronically. NetSuite already has the ability to electronically send PDF versions of Sales Order or Purchase Orders or Custom Forms. DocuSign brings another level of automation. Now, with DocuSign, you can efficiently send, track, sign, and save documents for approval, eliminating the back and forth emails or scanning in manual signatures. You can see a quick demo of the SuiteApp in one of our Short N Suite Videos - https://www.youtube.com/watch?v=rPff5VLTgY0.
Tags: NetSuite, NetSuite How To's, NetSuite Tips, Docusign, esignature, Electronic Signature
A large part of warehouse management is cycle counting inventory and consolidating inventory to a single area or bin. If you are using Advanced Bin / Numbered Inventory Management feature in NetSuite one function, you’ll have access to is Bin Transfers. This process allows you to move inventory from one bin to another without creating financial impacts.
Tags: NetSuite, NetSuite How To's, NetSuite Tips, Bin Transfer
Create an EBITDA Income Statement Layout
In a continuing series of customizing your Income Statement Layout, I wanted to show you how you can get a Statement with EBITDA calculated after Net Income. First, please review my previous blog here (or https://blog.concentrus.com/create-a-new-income-statement-layout).
Tags: NetSuite, NetSuite How To's, NetSuite Tips, Income Statement, Financial Report, Layout, Customization, EBITDA
Charge Rules: Deeper Dive Into Time-Based Charges
In a previous blog (https://blog.concentrus.com/charge-rule-overview) we walked through a high overview of NetSuite’s Project Charge Rules. In this article, we will dive a little deeper into more complex Time-Based rules.
Tags: NetSuite, NetSuite How To's, NetSuite Tips, Billable Time, T&M, Time and Material, Project, Charges, Invoicing
If you are a service based or project based business, NetSuite provides flexibility in how to track charges and invoice customers. Besides standard invoicing functionality (simple unit times price per unit), NetSuite provides a project based billing called Charge Rules.
Tags: NetSuite, NetSuite How To's, NetSuite Tips, Fixed Asset, Billing, T&M, Time and Material, Expenses, Project, Charges
Is your Income Statement in need of a face lift? If you are not able to over-haul your Chart of Accounts, you can update your Income Statement Layout directly in NetSuite. I will walk you through some steps that will consolidate the GL accounts on your Income Statement. From this walk through, you should have enough information for you to customize your own report.
Tags: NetSuite, NetSuite How To's, NetSuite Tips, Financial, Income Statement, Financial Report, Layout, Customization
NetSuite vs. Dynamics: Key Differences
Tags: Project Management, People Management, NetSuite How To's