Author: Ann Maria Wilson

Performing a VLOOKUP for multiple columns in Excel requires a bit of creativity since the standard VLOOKUP function is designed to return a single value from one column. However, there are several methods to achieve this, depending on your exact requirements. Here are a few approaches: Method 1: Using Helper Columns You can concatenate multiple… Continue reading VLOOKUP for multiple columns

NetSuite offers an employee commission feature as part of its Incentive Management module (available as an additional purchase). This feature allows you to automate commission calculations and payments for your sales reps and other employees. Here’s a breakdown of how employee commissions work in NetSuite: Setting Up Employee Commissions: Enable the Feature: An administrator needs… Continue reading Employee Commission in Netsuite

In NetSuite, applying a journal entry (JE) to a vendor bill isn’t the typical way to process a payment. However, it can be a helpful technique in certain situations. Here’s a breakdown of the process: Why Use This Method: This method is generally used when the standard bill payment process in NetSuite isn’t suitable. Common… Continue reading Applying journal entry to a vendor bill

Journal reversals in elimination subsidiaries are a common occurrence in consolidation processes, particularly for balance sheet accounts. Here’s why they happen: Purpose of Elimination Entries: When a parent company owns subsidiaries, intercompany transactions (sales/purchases between subsidiaries) distort the consolidated financial picture. Elimination entries are created to remove these intercompany transactions from the consolidated statements. Reversal… Continue reading ELIMINATION ENTRIES

NetSuite allows for some flexibility in transaction dates, but with limitations due to accounting period controls. Here’s a breakdown of backdating and postdating transactions: Backdating: Entering a transaction date prior to the current date. Possible: You can enter a date in the past for some transactions, but… Limited by Posting Periods: NetSuite uses posting periods… Continue reading Back dating and postdating transactions in NetSuite

A successful ERP implementation goes beyond just selecting the right software. Change management plays a critical role in ensuring a smooth transition from your existing systems and processes to the new ERP. Here’s how: Facilitating User Adoption: Understanding the Impact: Change management helps assess how the ERP will impact different departments and user roles. This allows… Continue reading The Role of Change Management in ERP Implementation

In NetSuite, Vendor Return Authorizations (VRAs) are a core functionality within the purchasing module. They streamline the process of returning items to vendors and ensure clear communication throughout the return journey. Here’s a breakdown of VRAs in NetSuite: Creating a VRA: You can create VRAs in two ways: From an Existing Purchase Order: If the return… Continue reading Vendor Return Authorization in NetSuite

Reports and saved searches in NetSuite (or any system) serve similar purposes but have key distinctions in functionality and use cases: Reports: Pre-defined Templates: Reports are typically pre-designed layouts that display specific data sets or answer particular business questions. They often include charts, graphs, and other visualizations to present information in an easily digestible format. Focus… Continue reading Difference between Reports and Saved Searches

The customer return process in NetSuite involves several key steps: 1. Issuing Return Authorization (RMA): This is the initial step where you authorize the customer’s return request. You can initiate an RMA through various methods: Directly from a sales order or invoice by clicking “Authorize Return.” Creating a new return authorization form. The RMA form… Continue reading Customer return process in NetSuite