Many businesses use standard account numbers and the names of those accounts on their general ledger. You can set up account numbers that appear in your chart of accounts, transactions, and most financial reports. When you start to work with NetSuite, account numbers are not enabled. An administrator must enable the preference on the Accounting… Continue reading Chart of Account Numbering
Author: Mridula P U
MULTI – CURRENCIES
NetSuite Multi-currency allows for the assignment of more than one currency to a customer or vendor enabling you to do business with customers/vendors who use multiple currencies in their business. This feature enables you to enter transactions in multiple currencies for an individual customer or vendor. Set up > Company > Enable features > Under Company subtab… Continue reading MULTI – CURRENCIES
Data Migration Process in NetSuite
ERP data migration is the process of transferring data from its original sources to the ERP system’s database. It often involves moving data from a variety of different systems, formats, and storage types into a single, common structure. Before the adoption of ERP, some departments may use systems designed to support only their specific functions,… Continue reading Data Migration Process in NetSuite
Delete All Hidden Rows or Columns in Excel
If you want to delete all hidden rows or columns in Excel, just do the following steps: 1. click File tab, and select Info menu from the popup menu list. 2. click Check for Issues button in the Info page. And select Inspect Document from the drop-down list. The Document Inspector dialog box will appear. 3. click Inspect button in the Document Inspector window. 4. click Remove All button in the Hidden Rows and Columns section.
Powerful Functionality for Manufacturers
NetSuite Supports the the important functionality that’s key to running a manufacturing business, including:1. Assembly ManagementNetSuite’s assembly management capabilities enables you to more effectively manage component quantities and multi-level assemblies. Building on NetSuite’s core strength in inventory and warehouse management, NetSuite closelyties assemblies with work orders, allowing multi-level assemblies to be built one level at… Continue reading Powerful Functionality for Manufacturers
Excel Formulas And Functions
1. LEN() The function LEN() returns the total number of characters in a string. So, it will count the overall characters, including spaces and special characters. Given below is an example of the Len function. 2. NOW() The NOW() function in Excel gives the current system date and time. The result of the NOW() function… Continue reading Excel Formulas And Functions
PIVOT TABLE IN EXCEL
A Pivot Table is an interactive way to quickly summarize large amounts of data. You can use a Pivot Table to analyse numerical data in detail, and answer unanticipated questions about your data. Moving rows to columns or columns to rows ( or “pivoting”) to see different summaries of the source data. HOW TO CREATE… Continue reading PIVOT TABLE IN EXCEL
How to work the formula even if some columns are blank in Saved Search
We can execute the formula even if some columns are blank in Saved Search using the following:-Navigate to1. Lists > Search > Saved Search > New 2. Select the Type of the search3. On the Results tab , Column Subtab;Field – Formula Numeric Formula : NVL({location on order},04. Save and Run
Release Preview Account – Test drive before you go live
“Test drive before you go live” is NetSuite’s standard pre-release mantra and good advice which you should take seriously. NetSuite is a cloud-based ERP platform. As such, upgrades do not require any installation on your end. However, you should be informed of what’s coming your way by carefully reviewing the release notes. You should also… Continue reading Release Preview Account – Test drive before you go live
What Is Data Migration?
Data migration can simply be explained as moving data from one source to another. In this case from a legacy system to cloud – based NetSuite. The process involves different formats and structures and therefore a thorough cleansing of data is key for efficient data transfer.Data migration is the process of moving data from one… Continue reading What Is Data Migration?