A work order is control your production and flow of inventory within your business, it means track the assembly items required for stock. work order representing a each step of physical work to be completed in a warehouse and track the availability of each component an assembly that need to be built. WORK ORDER CREATION In Administrator… Continue reading Work Order Creation
Author: Vishnu Mohan
Setting up Budget In NETSUITE
Budgets allow users to choose and define the accounts they need for their budgets, as well as generate spending and revenue statements for a specific time period. It’s simple to create a new budget in NetSuite or to import an existing budget. To build or import budgets, the user must have the “Set Up Budgets”… Continue reading Setting up Budget In NETSUITE
The Index Function
The INDEX function returns the value at a given location in a range or array. INDEX is a powerful and versatile function. You can use INDEX to retrieve individual values, or entire rows and columns. INDEX is frequently used together with the MATCH function. In this scenario, the MATCH function locates and feeds a position to the… Continue reading The Index Function
ways to delete blank rows in Excel
1 Get & Transform Data The Get & Transform Data tool in Excel allows you to quickly retrieve data. There are several ways to modify the data while doing so, one of which is to eliminate blank rows. Fortunately, it’s simple to use, although it does necessitate the usage of a Table object; if your… Continue reading ways to delete blank rows in Excel
ADVANCED FILTER IN EXCEL
Extracting a Unique list using Excel Advanced Filter to quickly extract unique records from a data set (or in other words remove duplicates). Select the entire data set (including the headers). Go Data tab –> Sort & Filter –> Advanced. (You can also use the keyboard shortcut – Alt + A + Q). This will open the… Continue reading ADVANCED FILTER IN EXCEL
3D reference in Excel
A 3D reference in Excel allows you to refer to the same cell or a range of cells across multiple worksheets. In other words, it refers to a range of worksheet names as well as a range of cells. The important thing to remember is that all of the referred sheets must have the same… Continue reading 3D reference in Excel
Copy a worksheet from one workbook to another
where copying a worksheet from one workbook (a collection of multiple sheets) Go to your “source” workbook (the one with the data you want to copy). Open your “target” workbook (the one you want to copy to). This can be a new workbook or an existing workbook. In your source workbook, look toward the bottom… Continue reading Copy a worksheet from one workbook to another
Extending NetSuite Transaction E mail Address List
NetSuite can send automatic emails for the following popular transactions: • Purchase Orders• Item Fulfillments• Customer Invoices• Sales Orders Steps: 1. In the message body recipient field: Enter the name of the recipient, only entities (customers, vendors, employees) existing in NetSuite can be selected. 2. Enter the “Copy Others List:” Enter additional names of the… Continue reading Extending NetSuite Transaction E mail Address List
Customize your NetSuite color scheme
All users of NetSuite can customize their color scheme via the NetSuite user settings. To do this: Click The Home Icon in the Tool box Click set preferences > Apperance tab Modify the the color theme Colors can be more than just an aesthetic change as well. If you have a Sandbox, Development, or Release… Continue reading Customize your NetSuite color scheme
Global Search Bar to Find Records Faster
Use Prefixes: By adding a prefix to the search phrase, you can limit your search to documents of a specific type. This will speed up the search and reduce the number of records returned that aren’t relevant. A search prefix is made up of all or part of a record type’s letters plus a colon.… Continue reading Global Search Bar to Find Records Faster