
Oracle NetSuite Introduction
The navigation menu bar is located at the bottom of the header. The tabs in the bar depend on your user role. Users with the Administrator role and users with the Custom Center Tabs permission can create new tabs.
When you log in, NetSuite opens your home page. Your home page is a dashboard, a collection of real-time data. The specific content of your home page depends on your user role. Here is an example of a portion of a Home page for a fictitious company.
1. **Administrator Access**: You need administrative access to configure the company settings.
2. **Company Information**: Enter basic details such as company name, address, fiscal calendar, and primary currency.
3. **Accounting Preferences**: Configure accounting preferences like chart of accounts, subsidiaries, departments, and classes.
4. **Tax Setup**: Configure tax codes, tax groups, and tax jurisdictions according to your business requirements.
5. **Financial Preferences**: Set up preferences for financial reporting, including accounting periods, fiscal years, and reporting periods.
6. **Banking Setup**: Add bank accounts, set up bank reconciliation, and configure payment methods.
7. **Customer and Vendor Management**: Set up customer and vendor records including contact information, payment terms, and credit limits.
8. **Item Records**: Define items or services your company sells, including descriptions, pricing, and inventory details if applicable.
9. **User Access**: Create user accounts for employees with appropriate roles and permissions.
10. **Customization**: Customize NetSuite to fit your specific business processes by creating custom fields, workflows, and scripts if needed.
Upon completion of this course
1. You will be able to create a Single Company in NetSuite
2. You will learn, to setup Currency in NetSuite
3. You will learn, to setup Financial Year in NetSuite
4. You will learn, to setup company’s multiple address in NetSuite. Such as Billing Address, Shipping Address & Return Address.
5. You will learn, to add Company Logo and Company account id.
6. You will understand difference between the NetSuite Single Entity and NetSuite OneWorld
NetSuite OneWorld enables you to manage data for a hierarchical structure of separate legal entities (subsidiaries). This structure is organized as a tree that rolls up to a root, or top-level parent subsidiary. The root subsidiary is the highest-level subsidiary in your account, and all other subsidiaries are below it in the hierarchy. If your account was upgraded to OneWorld, the preexisting data is used for the root subsidiary.
Each subsidiary represents a separate company within your global organization. Subsidiaries can be international or domestic. When you create a subsidiary record in OneWorld, the country you define for its address determines the NetSuite edition. It also determines the tax nexus associated with that subsidiary.
In addition to the subsidiaries representing your organization's separate legal entities, you must create elimination subsidiaries for use in balancing consolidated financials. Each OneWorld transaction generally posts to a single subsidiary, with the exception of transactions between two or more subsidiaries. Intercompany transactions include intercompany sales and purchases, intercompany inventory transfers, cross subsidiary fulfillment and return, and advanced intercompany journal entries. Because intercompany transactions post to two or more subsidiaries, the revenue and expenses must be eliminated at the consolidated level to maintain balanced financials. OneWorld uses elimination journal entries, associated with elimination subsidiaries, to maintain this balance.
Subsidiary Hierarchy Planning
Before you create subsidiary records you should plan the structure of your organization's subsidiaries. For each subsidiary record you create, you must define its parent, and as you create subsidiaries, NetSuite automatically defines a hierarchical structure.
You should diagram the parent-child relationships in your subsidiary hierarchy, starting at the top with the root subsidiary. This visual representation can help you consider how you want to organize and consolidate data, for both accounting and reporting purposes.
As you diagram your subsidiary hierarchy, it is a good idea to record the country, base currency, and tax nexuses for each subsidiary.
The country you enter on a subsidiary record automatically determines the first tax nexus and NetSuite edition associated with that subsidiary.
A base currency is the currency in which a subsidiary manages its financials. After you define and save a base currency on a subsidiary record, you cannot change it.
A nexus is a tax jurisdiction. You can add and change nexuses on subsidiary records.
After you diagram a hierarchy of subsidiaries, you should include one elimination subsidiary as a child of each parent subsidiary. The elimination subsidiary should use the same base currency as the parent subsidiary.
Use the subsidiary hierarchy diagram as a roadmap for setting up subsidiaries. You can refer to the base currency listed for each subsidiary to ensure that all necessary currencies are set up in NetSuite.
You should create subsidiary records in a top-down fashion. Begin with the root subsidiary, then all of its child subsidiaries, then the next level of subsidiaries, and so on. This order is best practice because you must define the parent for each child subsidiary when you create the subsidiary record.
You should create a subsidiary record for each legal entity in your organization. In addition, you should create a separate elimination subsidiary record as a child of each parent subsidiary.
When you create a subsidiary, the system creates a Subsidiary Settings page for that subsidiary. The subsidiary record has a one-to-one relationship with its Subsidiary Settings page. You can access the Subsidiary Settings page from the Subsidiary Settings Manager page.
You should create subsidiary records in a top-down fashion. Begin with the root subsidiary, then all of its child subsidiaries, then the next level of subsidiaries, and so on. This order is best practice because you must define the parent for each child subsidiary when you create the subsidiary record.
You should create a subsidiary record for each legal entity in your organization. In addition, you should create a separate elimination subsidiary record as a child of each parent subsidiary.
When you create a subsidiary, the system creates a Subsidiary Settings page for that subsidiary. The subsidiary record has a one-to-one relationship with its Subsidiary Settings page. You can access the Subsidiary Settings page from the Subsidiary Settings Manager page.
When subsidiaries transact, you may have to eliminate the revenue and expenses at the consolidated level to remove the effect of transactions between subsidiaries.
For example, intercompany transaction balances may require elimination for the following reasons:
Sales and services between subsidiaries
Inventory transfers between subsidiaries
Loans between subsidiaries
You use elimination subsidiaries to post journal entries that balance consolidated books. These journal entries, called elimination journal entries, reverse the impact of the intercompany transactions. Each elimination journal entry posts to an elimination subsidiary.
You create an elimination subsidiary (as a child of the parent subsidiary) for any subsidiary that has child subsidiaries. Set the currency to the same currency as the base currency of the parent subsidiary.
The following illustration shows a sample subsidiary hierarchy that includes an elimination subsidiary.
You create elimination subsidiaries the way you create other subsidiaries except that you check the Elimination box on the subsidiary record. For more information, see Creating Subsidiary Records.
License fees for subsidiaries do not include charges for elimination subsidiaries, and elimination subsidiaries do not count toward the maximum of 250 subsidiaries.
Note the following about elimination subsidiaries and transactions:
An elimination subsidiary must use the same base currency and country combination as their direct parent subsidiary.
With consolidated exchange rates, an elimination subsidiary must use a consolidated exchange rate of 1 to its direct parent subsidiary.
You can select an elimination subsidiary only for journal entries, not for other transactions.
A journal entry that is associated with an elimination subsidiary is a normal journal entry, not an advanced intercompany journal entry. It posts to a single elimination subsidiary. For more information about journal entries in OneWorld.
Elimination transactions post only to the elimination subsidiary and do not affect the general ledger.
The system can automatically generate elimination journal entries if you enable the Automated Intercompany Management feature.
You cannot select an elimination subsidiary on a bank account record or a credit card account record.
You cannot select an elimination subsidiary on item records.
Enable Features
The Enable Features page is where users with the Administrator role can turn on or off features in NetSuite.
The following topics describe the features available on each sub-tab of the Enable Features page.
General Company Features
Accounting Features
Tax Features
Transaction-Related Features
Items and Inventory Features
Employee and Payroll Features
CRM and SFA Features
Analytics Features
Commerce Features
SuiteCloud Features
Users with the Administrator role can enable the following features on the Accounting subtab of the Enable Features page. Many of these features create system-generated accounts when enabled. These accounts are included in the descriptions. For a complete listing of system-generated accounts, see Feature-Specific, System-Generated Accounts.
Basic Features
Accounting
Use NetSuite for your business's accounting.
Note
Enabling this feature creates the system-generated Undeposited Funds and Refunds Payable accounts. If you are using NetSuite Canadian Edition, you will also have Payable and Expenses accounts. If you are using NetSuite (U.S.), you will have the additional Sales Tax Payable account.
A/R (Accounts Receivable)
Maintain accounts receivables records and track invoices, receipts, cash sales, payments, and customer records.
Note
Enabling this feature creates the system-generated Accounts Receivable account.
A/P (Accounts Payable)
Maintain accounts payable records and track purchases, bills, vendors, and payee records.
Note
Enabling this feature creates the system-generated Accounts Payable account.
On the Tax subtab of the Enable Features page, users with the Administrator role can enable tax features and access the installation pages of related SuiteApps:
Advanced Taxes
Use the Advanced Taxes feature. This feature enables you to use tax schedules to track taxes for each nexus in which your company is required to pay taxes.
Users with the Administrator role can enable the following features on the Transactions subtab of the Enable Features page.
Processed lines for certain transaction types contribute to the Monthly Transaction Lines metric that counts toward maximum limits for your NetSuite service tier.
Estimates
Provide estimates to your customers and then convert them into invoices.
Sales Orders
Track customer orders and then convert them into invoices.
Users with the Administrator role can enable the following features on the Items & Inventory subtab of the Enable Features page.
Drop Shipments & Special Orders
Ship items from your vendor directly to your customer.
Matrix Items
Track inventory and pricing of items separately based on item options, such as tracking shirts by color and size.
Multiple Vendors
Manage procurement of items you buy from more than one vendor. Identify and track each vendor's name, item code, and purchase price.
Users with the Administrator role can enable the following features on the Employees subtab of the Enable Features page.
Compensation Tracking
Track basic wage and salary information for employees directly from the employee record.
Job Management
Create jobs with job descriptions and assign them to employees.
Job Requisitions
Create job requisitions for recruiting, associate requisitions with jobs, and track status through the hiring process.
Users with the Administrator role can enable the following features on the CRM subtab of the Enable Features page.
Customer Relationship Management
Manage all your business relationships with lists of contacts, companies, events, and tasks.
Sales Force Automation
Use SFA to manage your sales process.
Customer Support and Service
Track, route, and manage customer support request.
Marketing Automation
Create targeted marketing campaigns and customize your email communications.
You must agree to the NetSuite Marketing Application Terms of Service before you can enable this feature. To agree to the terms, click Terms of Service. Read the terms, check the box at the bottom of the page and click Close Window.
Opportunities
Create opportunity records you can use to track sales opportunities.
Lead Conversion
Convert leads to prospects, contacts, opportunities, and tasks.
Before you begin using the Lead Conversion feature, you should do the following:
Set the Default Lead Type preference to Individual at Setup > Company > Preferences > General Preferences.
Set the Preferred Lead Form preference to Standard Lead Form at Setup > Sales > Preferences > Sales Preferences.
Users with the Administrator role can enable the following features on the Analytics subtab of the Enable Features page.
KPI Scorecards
Add the ability to display a portlet on your dashboard that shows the results of multiple KPIs for multiple date or period ranges.
SuiteAnalytics Connect
Enable the SuiteAnalytics Connect feature to access and query your NetSuite data using SQL through database standards such as ODBC, JDBC, and ADO.NET.
NetSuite Analytics Warehouse
Configure and transfer data to the NetSuite Analytics Warehouse. You can use any data transferred with Oracle Analytics for applications.
Users with the Administrator role can enable the following features on the Web Presence subtab of the Enable Features page.
Web Site
Enable initial website functionality, for example, creation of domains. Also enable activation of other Commerce features, such as SuiteCommerce and SuiteCommerce Advanced.
Site Builder (Website)
Create a Site Builder website to give customers information about your company and enable them to browse your product catalog.
Users with the Administrator role can enable the following features on the SuiteCloud subtab of the Enable Features page.
Item Options
Create and use item-specific options on purchase and sales transactions.
Custom Records
Use custom records to create a database of information specific to your business. This feature is also required for center and tab customization.
Advanced PDF/HTML Templates
Enable powerful, template-based rendering of selected transactions.
The Advanced PDF/HTML Templates feature provides a template-based model for print customization of transaction and entry forms.
These HTML-based templates provide greatly expanded customization capabilities over the previously supported transaction form layouts, now known as basic layouts.
Record numbers for Entities, CRM, and Schedules cannot be reverted back to names after update. If you check Update, a number is assigned to each existing record of that type, and the name is stored in the Company Name field.
You can return to this page at any time to turn on or off numbering for new records. However, after you turn on numbering, records will be listed by number rather than name.
It typically takes just a few minutes for 5000 records. While it is running, this page will not be available.
The Set Up Auto-Generated Numbers page enables users with the Administrator role to choose the record types that should be automatically numbered in the order in which they are created. On this page you can also add prefixes and suffixes to auto-generated numbers. Prefixes and suffixes are useful in determining a record, transaction, or document’s type and estimated age at a glance.
For example, you may choose to enable auto-generated numbering for the customer record type in your account and prefix the number with CUST. Each time you add a new customer record, the record number increases sequentially by one. When you view your customer list, you can quickly see that CUST0025 is a newer customer than CUST0004.
When you set a record type to have auto-generated numbers, the number replaces the name that was stored in the Company Name field. Record numbers cannot be reverted back to names after auto-generated numbering has been enabled and the records have been updated.
Users with the Administrator role can change the names of their records and transactions from the NetSuite default names to names that fit the terminology of their company on the Rename Records/Transactions page. On this page, you can also change the names of account types used in NetSuite.
By changing the names of your records and transactions, your employees do not have to change their terms to fit NetSuite terms. Instead, NetSuite changes to fit the terms your employees are accustomed to using.
When you change the names of records or transactions, those names change in most places they appear in NetSuite to your preferred term. You can always return to the Rename Records/Transactions page to change them to the default name or to another term.
This course is a complete reference of Oracle NetSuite with real time examples.
This is a 100% practical course so that you can directly dive into the concept and i designed the lectures of this course with two part. first one is explanation part (with screenshot) and another is Video Demo part.(note:for some concepts i skipped video Demo since there is no need)
This course teach you from very beginning such as how to login and navigate and upto advanced concepts.
This course teaches you accounting impacts of some crucial processes since accounting is the heart of any ERP system,you can learn accounting concepts needed for netsuite from practical perspective in this course.
Before diving into Oracle NetSuite functions ,some important features must be enabled i explained about this in beginning
This course explains all concepts of Procure-To-Pay(purchase) process such as vendor creation, purchase order, item receipts ,vendor bills and payment in an in-depth approach.
This course explains all concepts of Order-To-Cash(Sales) process such as customer creation, sales order, item fulfillment ,Invoice and customer payment in an in depth approach.
This course not only teaches you the process but also the accounting impacts of transactions as well so that you can be a master in NetSuite and understand the concept better.
This course covers the reporting aspect so that you can take reports in different angles as reporting is crucial part of any business.
In short, you will learn complete Oracle NetSuite from Scratch.
Section 1: INTRODUCTION TO ORACLE NETSUITE
Learn how to navigate Oracle NetSuite .
Learn about Oracle NetSuite Dashboard.
Learn about Reminders in Dashboard and how to setup and configure
Section 2: CREATING A SINGLE COMPANY / MULTIPLE COMPANIES IN NETSUITE ERP
Learn to create a single company in NetSuite
Learn to setup currency in NetSuite
Learn to setup financial year in NetSuite
Learn to setup multiple address in NetSuite. Such as Billing Address, Shipping Address and Return Address
Learn to add the company logo in NetSuite
Learn to identify the company account id
Learn the difference between NetSuite Single Entity and NetSuite One World.
Multi-Company Setup
Subsidiaries in Oracle Netsuite OneWorld and subsidiary Hierarchy Planning
Creating Parent & Child Company
Elimination Subsidiaries
Multiple Currencies in Oracle NetSuite OneWorld
Nexuses and Taxes in Oracle NetSuite OneWorld
Assigning Subsidiaries to a Customer
Assigning a Subsidiary to an Employee
Assigning Subsidiaries to a Vendor
Associate Subsidiaries With Items
Section 3: ENABLE FEATURES
Learn to enable the required features of Oracle NetSuite.
Learn to configure the Company, Accounting, Procure-To-Pay, Order-to-Cash & Inventory Management Module in NetSuite
Section 4: CHART OF ACCOUNTS
Understand the Chart of Accounts in NetSuite
Understand the Default Chart of Accounts for Inventory Management, Procure to Pay Module & Order to Cash Module.
Learn to understand the Accounting Impact of every transactions.
Section 5 : AUTO-GENERATED NUMBERS
The auto-generated numbering feature prevents assigning duplicate numbers to transactions in NetSuite
Learn how to automatically generate unique numbers for various documents and transactions such as invoice
Purchase Order,Sales Order and so on.
Section 6 : RENAME RECORDS / TRANSACTIONS
Learn how to rename default names, edit the names to better suit your company
Section 7 : CLASSIFICATIONS
Learn about Classification concept such as Department,Class, and Location that you can use to identify and categorize records in your NetSuite account.
Learn to create Departments, Classes & Locations and how to use them.
Section 8 : MULTI-CURRENCY
NetSuite Multi-currency Features can help your global business! It supports over 190 currencies with real-time currency conversation & consolidation
Learn to Create and Setup Multi-Currency within NetSuite
Section 9 : CURRENCY EXCHANGE RATE
NetSuite currency exchange rates features will ensure that your NetSuite account can keep up with fluctuating exchange rates
Learn how to convert foreign currencies to base currencies
Learn how to set up and use the NetSuite Currency exchange rate
Section 10 : MULTIPLE UNIT OF MEASURE [UOM]
Learn to Measure and track inventory using different units of measure such as weight, volume, length, or quantity.
Set up a different Units Type and define each unit for that type
This feature helps keep your inventory counts accurate when you buy, stock, and sell inventory in different units.
Section 11 : FINANCE MODULE
Learn What is Accounting and its type
Learn Debit & Credit
Golden Rules of Accounting
Accounting Equation
Chart of Accounts
Opening Balance [Capital]
Journal Entry
Section 12 : INVENTORY ITEMS
Learn to create Inventory Items in NetSuite
Understand the difference between Inventory Items, Lot Numbered Items and Serialized Items in NetSuite
Learn to create the item class in NetSuite
Learn to create the multiple unit of measure i.e purchase unit, stock unit, sales unit and base units.
Learn to create the inventory items, lot numbered items, Serialized items in NetSuite
Learn to understand the Lot Numbered (Batch Number), Product Expiry Date and Serial Number
Learn to understand the Costing Method. i.e Average Costing, Lot Numbered Costing, Specific Costing, FIFO and LIFO
Learn to enter the Lead time for the items.
Learn to enter the Stock Account, Sales Account, Cost of Goods Sold Account.
Learn to check the item’s product expiry date in NetSuite.
Learn to enter the item weight in NetSuite
Learn to configure the tax schedule in NetSuite.
Learn to add the multiple vendor price in NetSuite
Learn to add the multi currency item price in NetSuite.
Learn to enter the item barcode in NetSuite.
Learn to print the item label in NetSuite.
Learn to create the lot numbered items. such as food items.
Learn to create the Serialized items. such as Smart Watch & Smart Phone
Section 13: PROCURE TO PAY MODULE
Vendor creation in NetSuite
Learn to create a vendor in NetSuite
Learn to add the vendor’s CRM details in NetSuite.
Learn to add the vendor’s address, Web address, email address and telephone number.
Learn to add the vendor Tax ID
Learn to add the vendor currency, vendor payment terms and vendor inco-terms.
Learn to add the item price.
Track the vendor’s financial information. i.e outstanding amount or Aging report.
Track the vendor’s related transactions.
Learn to attach the vendors important documents in NetSuite File Cabinet.
Purchase Order in NetSuite
Learn to create a purchase order in NetSuite.
Learn to create a purchase order in Multi currency
Learn to add different item types in Purchase Order
Learn to add the vendor’s specific price to the items.
Learn to select the “bill to” and “ship to” address in purchase order.
Accounting impact of purchase order.
Identify key reports related to purchase module.
Key reports such as open purchase order, current inventory items, purchase order register, purchase by vendors, purchase by items.
Item Receipts in NetSuite
Learn to create the item receipts from purchase order in NetSuite.
Learn to Receive full or partial item Qty.
Learn to enter the batch number, product expiry date for the lot numbered items. such as food items.
Learn to enter the serial number for the serialized items. i.e smart phone / smart watch / equipments
Understand the auto-generated numbered for lot numbered items.
Accounting impact of item receipt.
Identify the key reports related to item receipts such as current inventory items, Item valuation, Pending Bill, Inventory Register.
Vendor Bills in NetSuite.
Learn to create the vendor bill from purchase order in NetSuite.
Learn to create the full / partial vendor bill from purchase order in NetSuite.
Enter the vendor’s bills number in NetSuite.
Learn to verify the vendor payment terms, vendor item price, vendor bill qty and total amount.
Enter the posting date in vendor bill.
Lear to understand the Match to Bill Concept in NetSuite.
Accounting impact of vendor bills
Identify the key reports related to vendor bills such as open bill, vendor’s aging report, vendor’s aging register, purchase order register, purchase order history.
Payments in NetSuite.
Learn how to Make payment against the vendor bill.
Learn to verity the due date in vendor bill
Learn to Pay full or partial payment to the supplier invoice.
Learn to pay the supplier bill in multi-currency
Learn Multiple method to pay the vendor bill in NetSuite
Learn to Pay to the multiple vendor in one time.
Accounting impact of Bill Payment.
Identify the key reports in NetSuite such as vendor’s payment history, open bills for payment and aging report with due date.
Section 14: ORDER TO CASH MODULE
Customer creation in NetSuite
You will learn how to
Create a Customer (Company or Individual) in NetSuite
Enter the company information i.e e-mail id, telephone number and website address.
Enter the multiple address in NetSuite. i.e Billing and Shipping address
Enter the customer’s CRM details. i.e contact person details of the customer (Sales Man, Accounts Person, General Manager)
Enter Customer’s Payment Terms, Shipping Terms and VAT Number details
Enter the Customer Trade Currency. Able to Enter the Multiple trade currency in the customer.
Create a customer’s item price book or item pricing in NetSuite.
Generate Customer’s Price List in NetSuite
Sales Order in NetSuite
You will learn how to
Enter a Sales Order in NetSuite
Enter the Customer’s Purchase Details in Sales Order. Such as customer’s purchase order number, currency, items, qty, price, payment terms, shipping terms and delivery details. etc
Able to check the Gross Profit of the each items.
Able to check the overall Gross profit of all the items.
Verify Item price in the customer’s purchase order vs the customer’s price book in NetSuite
Select warehouse location in Sales Order. Items will be shipped from that location. (Our Warehouse Location)
Print or email the sales order to the customer.
Identify key reports and analytics
Item Fulfillment in NetSuite
You will learn how to
Create a Delivery Note / Packing Slip from the Sales Order
Ship / Deliver full or partial qty from the sales order
Choose the particular ”Expiry Date & Batch Number” for the lot numbered items. i.e food items.
Select the Customer’s delivery location
Enter the packaging details in Item Fulfillment
Enter the order’s shipping status. i.e items in the orders are picked from the warehouse, under packing stage and once its shipped, mark as shipped.
Understand Accounting Impact of Item Fulfillment.
Print the “Packing Slip / Delivery Note” from NetSuite
Identify key reports and analytics
Invoice in NetSuite
You will learn how to
Create a Invoice from Sales Order or Item Fulfillment
Create multiple invoice from sales order or item fulfillment
Select the customer’s payment terms, inco-terms in the Invoice
Pick the invoice date and posting period
Verify the Customer’s Tax ID in the Invoice
Enter the Memo in the Invoice
Understand Accounting Impact of Invoice.
Print / email the “Invoice” from NetSuite
Generate the Customer’s Statement from the NetSuite and Identify key reports and analytics
Payment in NetSuite
You will learn how to
Enter the customer payment against the invoice in NetSuite.
Multiple ways to enter the customer payment against the invoice in NetSuite.
check the invoice status in NetSuite
Receive full / partial payment from the customer and apply against the invoice
Select the account where the payment is received. i.e Bank or Cash.
Enter the payment received date and posting period in the NetSuite
understand Accounting Impact of Payment.
Print / email the “Payment Receipt” from NetSuite to Customer
Generate the Customer’s Statement and identify key reports and analytics