NetSuite OneWorld Guide
NetSuite OneWorld Guide
This software and related documentation are provided under a license agreement containing restrictions
on use and disclosure and are protected by intellectual property laws. Except as expressly permitted
in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast,
modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any
means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for
interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-
free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it
on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software,
any programs installed on the hardware, and/or documentation, delivered to U.S. Government end
users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation
and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and
adaptation of the programs, including any operating system, integrated software, any programs installed
on the hardware, and/or documentation, shall be subject to license terms and license restrictions
applicable to the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other
measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks
of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks
are used under license and are trademarks or registered trademarks of SPARC International, Inc.
AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of
Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content,
products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and
expressly disclaim all warranties of any kind with respect to third-party content, products, and services
unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and
its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use
of third-party content, products, or services, except as set forth in an applicable agreement between you
and Oracle.
This documentation is in pre-General Availability status and is intended for demonstration and preliminary
use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation
and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to
this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of
this documentation.
The information contained in this document is for informational sharing purposes only and should be
considered in your capacity as a customer advisory board member or pursuant to your pre-General
Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and
should not be relied upon in making purchasing decisions. The development, release, and timing of any
features or functionality described in this document remains at the sole discretion of Oracle.
This document in any form, software or printed matter, contains proprietary information that is the
exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms
and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle
PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has
been executed by you and Oracle and with which you agree to comply. This document and information
contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle
without prior written consent of Oracle. This document is not part of your license agreement nor can it be
incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website
at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc
Oracle customers that have purchased support have access to electronic support through My Oracle
Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://
www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Sample Code
Oracle may provide sample code in SuiteAnswers, the Help Center, User Guides, or elsewhere through
help links. All such sample code is provided "as is” and “as available”, for use only with an authorized
NetSuite Service account, and is made available as a SuiteCloud Technology subject to the SuiteCloud
Terms of Service at www.netsuite.com/tos.
Oracle may modify or remove sample code at any time without notice.
As the Service is a multi-tenant service offering on shared databases, Customer may not use the Service
in excess of limits or thresholds that Oracle considers commercially reasonable for the Service. If Oracle
reasonably concludes that a Customer’s use is excessive and/or will cause immediate or ongoing
performance issues for one or more of Oracle’s other customers, Oracle may slow down or throttle
Customer’s excess use until such time that Customer’s use stays within reasonable limits. If Customer’s
particular usage pattern requires a higher limit or threshold, then the Customer should procure a
subscription to the Service that accommodates a higher limit and/or threshold that more effectively aligns
with the Customer’s actual usage pattern.
Beta Features
This software and related documentation are provided under a license agreement containing restrictions
on use and disclosure and are protected by intellectual property laws. Except as expressly permitted
in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast,
modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any
means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for
interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-
free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it
on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software,
any programs embedded, installed or activated on delivered hardware, and modifications of such
programs) and Oracle computer documentation or other Oracle data delivered to or accessed by
U.S. Government end users are "commercial computer software" or “commercial computer software
documentation” pursuant to the applicable Federal Acquisition Regulation and agency-specific
supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure,
modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any
operating system, integrated software, any programs embedded, installed or activated on delivered
hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other
Oracle data, is subject to the rights and limitations specified in the license contained in the applicable
contract. The terms governing the U.S. Government’s use of Oracle cloud services are defined by the
applicable contract for such services. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management
applications. It is not developed or intended for use in any inherently dangerous applications, including
applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other
measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages
caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks
of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks
are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD,
Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a
registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content,
products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and
expressly disclaim all warranties of any kind with respect to third-party content, products, and services
unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and
its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use
of third-party content, products, or services, except as set forth in an applicable agreement between you
and Oracle.
This documentation is in pre-General Availability status and is intended for demonstration and preliminary
use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation
and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to
this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of
this documentation.
The information contained in this document is for informational sharing purposes only and should be
considered in your capacity as a customer advisory board member or pursuant to your pre-General
Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and
should not be relied upon in making purchasing decisions. The development, release, and timing of any
features or functionality described in this document remains at the sole discretion of Oracle.
This document in any form, software or printed matter, contains proprietary information that is the
exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms
and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle
PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has
been executed by you and Oracle and with which you agree to comply. This document and information
contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle
without prior written consent of Oracle. This document is not part of your license agreement nor can it be
incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.
Answering the following questions will help us improve our help content:
■ Did you find the information you needed? If not, what was missing?
■ Did you find any errors?
■ Is the information clear?
■ Are the examples correct?
■ Do you need more examples?
■ What did you like most about this document?
Click here to send us your comments. If possible, please provide a page number or section title to identify
the content you're describing.
NetSuite OneWorld
■ Introduction to NetSuite OneWorld
■ Subsidiaries in OneWorld
■ Subsidiary Setup
■ Set up NetSuite OneWorld
■ Intercompany Framework
■ Automated Intercompany Management
■ Viewing Open Intercompany Balances
■ Subsidiary Settings Manager
■ Associate Subsidiaries with Entities and Items
■ Consolidated Reporting in OneWorld
■ Subsidiary Navigator
■ OneWorld ERP Accounting
■ OneWorld CRM
■ OneWorld and SuiteCommerce
To manage financials, OneWorld enables you to adjust for currency, taxation, and legal compliance
differences. You can make adjustments at the local level, with regional and global business consolidation
and roll-up. This roll-up provides worldwide business visibility in real time.
To manage customers, OneWorld enables you to manage a complex multinational sales organization that
requires multiple languages and currencies. It provides global visibility to every aspect of CRM including
quotas, forecasts, sales, customers, partners, support cases, issues, leads, and campaigns.
Global E-commerce
To manage e-commerce, OneWorld enables you to conduct web business around the globe. You can
have multi-language, multi-currency, multi-country, and multi-brand web stores that can be run and
managed from a single NetSuite account.
With SRP, OneWorld streamlines the complete services lifecycle. Workflows from marketing to project
management, service delivery, billing, and revenue management. SRP helps you drive repeat business
from existing clients.
To manage business intelligence, OneWorld provides real-time visibility across your entire enterprise. This
visibility provides unprecedented access to financial, customer, and business data worldwide. It provides
multiple levels of consolidated reporting, and enterprise-wide key performance indicators (KPIs) display in
real time on dashboards.
Growing regulatory challenges, compliance risk, financial penalties, and more frequent system-based
tax audits burden businesses with ever more complex tax compliance requirements. OneWorld tax
and compliance management capabilities provide a robust foundation for transparency, automation,
simplicity, and controls in managing your global tax and compliance responsibilities.
For details about working with NetSuite OneWorld, see the following help topics:
■ OneWorld Overview
■ Subsidiaries in OneWorld
■ Subsidiary Setup
■ Set up NetSuite OneWorld
■ Intercompany Framework
■ Automated Intercompany Management
■ Viewing Open Intercompany Balances
■ Subsidiary Settings Manager
■ Associate Subsidiaries with Entities and Items
■ Consolidated Reporting in OneWorld
■ Subsidiary Navigator
■ OneWorld ERP Accounting
■ OneWorld CRM
■ OneWorld and SuiteCommerce
OneWorld Overview
NetSuite OneWorld supports global, multi-subsidiary organizations. OneWorld lets you use a single
NetSuite account to manage records and transactions for multiple subsidiaries conducting business
across multiple tax jurisdictions involving multiple currencies.
OneWorld organizes both domestic and international subsidiaries into a single hierarchical structure.
Each subsidiary is treated as a unique legal entity for taxation and regulation purposes. Each subsidiary
has a specific nexus (tax jurisdiction) and a specific base currency. This base currency is the currency in
which the subsidiary manages its financials. Subsidiary-specific data is available for reporting. Data for
multiple subsidiaries can be rolled up into consolidated reports in the currency of a parent subsidiary.
OneWorld supports local and foreign currencies for transactions with foreign companies and between
subsidiaries. Consolidated reports including aggregated financial statements provide foreign currency
translation and consolidation for all child subsidiaries of a selected parent subsidiary.
OneWorld Capabilities
With NetSuite OneWorld, you can manage inter-related business processes across multiple subsidiaries.
Some of the capabilities that NetSuite OneWorld provides include:
OneWorld Implementation
A new NetSuite implementation can be set up to use NetSuite OneWorld, and an existing account can
be upgraded to use NetSuite OneWorld. Any edition of NetSuite can be upgraded. This is a one-time
upgrade to your NetSuite implementation that cannot be reversed.
Subsidiaries in OneWorld
NetSuite OneWorld enables you to manage data for a hierarchical structure of separate legal entities, or
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.
Note: Subsidiary licenses are sold on a per-country basis. You can have 250 subsidiaries in
your OneWorld account, including the root subsidiary. If you require more than 250 subsidiaries,
contact your NetSuite account representative for pricing information.
License fees for subsidiaries do not include charges for elimination subsidiaries, and elimination
subsidiaries do not count toward the maximum of 250 subsidiaries. Inactive subsidiaries also do
not count toward the maximum.
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,
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. For more information, see Elimination Subsidiaries.
Elimination Subsidiaries
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:
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.
Note: Only journal entries post to elimination subsidiaries. No other transactions post to
elimination subsidiaries. See the help topic Elimination Journal Entries.
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.
■ 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, see the help topic 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. See Automated Intercompany Management Overview.
■ 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.
Important: NetSuite enables you to modify your subsidiary hierarchy structure if your company
requires modification. Be aware that a modification may corrupt your data and reporting. For
information about modifying your subsidiary hierarchy and possible consequences, see Subsidiary
Hierarchy Structure Modification.
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. See
Multiple Currencies in OneWorld. You can refer to the country listed for each subsidiary to ensure that all
tax nexuses are set up and linked to the appropriate country. See Nexuses and Taxes in OneWorld.
Use your diagram to reference the order in which to create subsidiary records, in top-down order,
beginning with the root. Be aware that you cannot change several fields on the subsidiary record after
you create and save the record for the first time. See Creating Subsidiary Records and Editing Subsidiary
Records.
If you enable the GL Audit Numbering feature, you can apply gapless numbering sequences to all general
ledger posting transactions. These numbering sequences enable companies to meet international
auditing requirements. The feature also enables you to specify that a subsidiary’s transactions are
locked to the general ledger. This option permits NetSuite to automatically generate journal entries
when changes are made to a transaction that posted to the general ledger. See the help topics GL Audit
Numbering and GL Impact Locking.
Modifying entries in the Subsidiary Hierarchy can have significant legal and financial consequences.
Please be certain you are authorized to make such changes and consult with the appropriate
stakeholders in your business before proceeding.
At a minimum, Oracle recommends that you read the official documentation and review and download
all documents that may be relevant to these modifications, including but not limited to Financial
Statements such as the Balance Sheet, Income Statement, Trial Balance, and audited reports from prior
periods on both Consolidated and Subsidiary Levels, as well as Consolidated Exchange Rates.
To ensure modifications are implemented correctly, make the modifications first in a Sandbox
Environment and then thoroughly review all Financial Statements and Consolidated Exchange Rates
to ensure the modifications had the anticipated consequences before deploying the modifications in a
Production Environment.
The consequences of implemented modifications are outside the scope of any support made
available to your organization by Oracle, and your organization is solely responsible for the
effect of such modifications on your organization’s use of the product and for any costs or
expenses arising from or related to such modifications, including but not limited to the cost of
any required data fixes.
Areas of the product that may be affected by such modifications include but are not limited to the
following:
If you have questions before making such modifications, you may open a support ticket to request
assistance from Oracle.
The Allow Subsidiary Hierarchy to be Modified general preference enables you to modify your
subsidiary hierarchy structure, as required by your company.
■ You acquired a company and you must establish a new head quarter subsidiary.
■ You must change the headquarter subsidiary to another subsidiary in your hierarchy.
For example, subsidiary number two becomes the parent subsidiary.
■ You want to elevate a subsidiary in the hierarchy.
For example, subsidiary number three becomes a regional subsidiary rather than a local subsidiary.
Important: In addition to the known product areas listed in the license agreement, check the
product areas you use that a modification may impact. The license agreement appears earlier in
this topic.
On the Permissions subtab, ■ You must have edit or full level Subsidiaries permission to modify the subsidiary
click the Lists subtab. hierarchy structure.
■ You must have access to all subsidiaries.
On the Permissions subtab, ■ You must have full level Set Up Company permission to set the Allow Subsidiary
click the Setup subtab. Hierarchy to be Modified preference. This preference is on the General
Preferences page. See the help topic Set Company Preferences.
■ You must have full level Subsidiary Hierarchy Modification permission to modify the
subsidiary hierarchy structure.
■ You must have access to all subsidiaries.
Note: You cannot set a new parent directly on a new record. If you want to create a new
record as a new parent, you must first save the record. Then, in edit mode, position the new
parent within the hierarchy.
You cannot make an elimination subsidiary the parent subsidiary.
3. In the Subsubsidiary Of list, move the subsidiary to the new place in the hierarchy.
4. Read the license agreement that includes the consequences associated with subsidiary hierarchy
modification.
Only if you agree with the license content and are eligible to modify your subsidiary hierarchy, click
Accept.
5. Click Save.
6. Click List in the top right corner of the page.
The Multiple Currencies feature is required for NetSuite OneWorld. With OneWorld, each subsidiary can
have a separate base currency, which is used to manage the subsidiary's financials. You cannot change a
subsidiary's base currency after the subsidiary record has been saved for the first time.
Currency Records
As you are planning your subsidiary hierarchy, you must determine the base currency of your root
subsidiary, then the base currencies of all of your other subsidiaries. All subsidiary base currencies as well
as any other currencies used in transactions should be set up in NetSuite. See the help topic Creating
Currency Records.
When you enter a transaction for a subsidiary, the currency defined on the customer's or vendor's
record determines the currency used in the transaction amounts. If a customer or vendor has a currency
different from the subsidiary, the transaction must use two currencies. The foreign currency used by the
customer or vendor, and the base currency used by the subsidiary.
each accounting period. See the help topic Accounting for Fluctuation in Exchange Rates for Closed
Transactions. In addition, before you close each period, you are required to revalue open balances to
account for variances. See the help topic Revaluation of Open Currency Balances.
When you edit a subsidiary record, a Nexuses subtab is available where you can add or remove nexuses.
See Editing Subsidiary Records.
Important: For U.S. subsidiaries, a state nexus is required. For Canada subsidiaries, a province
nexus is required.
It is best to create and set up taxes for nexuses before you create subsidiary records. You can create a
nexus at Setup > Accounting > Nexuses > New. See the help topic Creating Tax Nexuses.
You set up taxes for nexuses at Setup > Accounting > Taxes > Set Up Taxes. When you create a subsidiary,
if a nexus does not exist for the subsidiary's country, it is automatically created when you save the
subsidiary record. However, all that is created for the nexus is a name and description. You must still set it
up at Setup > Accounting > Taxes > Set Up Taxes.
■ Advanced Taxes Feature - This feature provides management of taxes for multiple tax jurisdictions
and must be enabled in NetSuite OneWorld. See the help topic Enabling Advanced Taxes.
■ Tax Agency Vendors - These vendors represent taxing authorities to whom you pay collected taxes.
The system automatically creates a tax agency vendor when you create a tax nexus. See the help topic
Setting Up Tax Agencies as Vendors.
Multiple subsidiaries can pay taxes to the same tax agency. When a new subsidiary shares a tax nexus
with an existing subsidiary, the system creates a copy of the preferred tax vendor for that nexus.
The copy of the preferred tax vendor gets associated with the new subsidiary. The copy is necessary
because you cannot share a vendor tax agency with multiple subsidiaries. You can, however, share
non-tax agency vendors with multiple subsidiaries. For more information, see Assigning Subsidiaries
to a Vendor.
■ Tax Control Accounts - These are Other Current Liability Accounts that you can set up in your
general ledger to post and track tax collection and payments. See the help topic Tax Control Accounts
Overview.
■ Tax Types - These types provide categories used to link each tax code or tax group to a tax control
account. Available tax types depend upon the country selected for the tax code. See the help topic Tax
Types Overview.
■ Tax Codes and Tax Groups - A tax code represents a tax collected from customers in a specific
geographic area and paid on their behalf to a taxing authority. The amount collected is based on a
specific percentage rate. You can create tax groups that combine taxes for all tax jurisdictions relevant
to a transaction. See the help topics Tax Codes Overview and Tax Groups Overview.
■ Tax Schedules - Tax schedules permit different calculations of taxes on items, for different nexuses.
When you enable the Advanced Taxes feature, the system creates tax schedules for each tax code. See
the help topic Creating Tax Schedules.
■ Tax Reporting Periods - (Editions other than US and Canada) You can set up these periods to track
tax reporting separately from accounting periods. In NetSuite OneWorld, the same tax reporting
periods apply across all subsidiaries that use the feature. See the help topic Setting Up Tax Periods.
Note: Available tax items and features vary for different NetSuite editions. See NetSuite Editions
Overview.
Subsidiaries within a single OneWorld implementation may use different NetSuite editions. When you
create a subsidiary record in NetSuite, the country you define for its address determines the NetSuite
edition.
■ NetSuite (US)
■ NetSuite Australia (AU)
■ NetSuite Canada (CA)
■ NetSuite Japan (JP)
■ NetSuite UK (UK)
■ NetSuite International (XX) (This edition is not country-specific and is used for countries that do not
have a localized edition. You can customize tax functions for specific countries using the Advanced
Taxes feature.
An important difference among editions is their different handling of taxes, as shown in the following
table:
Type of Tax Sales Tax GST GST, PST Consumption VAT N/A Based on
Tax Subsidiary
Edition
Subsidiary Setup
Before you begin to set up subsidiaries for NetSuite OneWorld, ensure you review the following help
topics:
■ Subsidiaries in OneWorld
■ Elimination Subsidiaries
■ Subsidiary Hierarchy Planning
■ Multiple Currencies in OneWorld
■ Nexuses and Taxes in OneWorld
You must create a record for each subsidiary, including elimination subsidiaries. See Creating Subsidiary
Records.
After you create and save a subsidiary record, you can edit tax nexuses and define preferences on that
record. You can then associate subsidiaries with customers, employees, vendors, partners, items, and
shipping items. For information and guidelines, see the following help topics:
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. For information about Subsidiary
Settings Manager, see Subsidiary Settings Manager. When you delete a subsidiary record, the system
deletes its corresponding Subsidiary Settings page.
Important: If you upgrade your account to NetSuite OneWorld, the preexisting data is used for
the root subsidiary.
Subsidiary Licenses
Subsidiary licenses are sold on a per-country basis. You can create up to 249 subsidiary records, in
addition to the root subsidiary, for a total of 250. License fees for subsidiaries do not include charges for
elimination subsidiaries, and elimination subsidiaries do not count toward the maximum 250 subsidiaries.
Inactive subsidiaries also do not count toward the maximum 250 subsidiaries.
■ GL Impact Locking - This feature locks transactions for subsidiaries located in countries where the
general ledger impact of a transaction must be locked to the general ledger. For more information,
see the help topic GL Impact Locking.
■ Transaction Locking SuiteApp (Bundle ID 8791) - This SuiteApp is available at no cost from the
NetSuite bundle repository. Contact NetSuite Customer Support to request access to the Transaction
Locking SuiteApp. For more information, see the help topic Transaction Locking SuiteApp.
Important: You cannot change the values or states of some fields after you save the
subsidiary record the first time. For a list of fields that you cannot change on the parent or
child subsidiaries, see Editing Subsidiary Records.
Note: The logo you select does not affect the pages in your account. The logo that
displays on pages is selected in the Subsidiary Logo (Pages) field.
f. In the Subsidiary Logo (Pages) field, select the logo image to display on all pages for this
subsidiary.
Click New to upload a logo. Logos must be in JPG or GIF format.
Note: The logo you select does not affect printed forms. The logo on printed forms
is selected in the Subsidiary Logo (Forms) field.
Note: You must also enable subsidiary-specific transaction numbering at Setup >
Company > Auto-Generated Numbers. For more information, see Using Subsidiary-
Specific Transaction Auto-Numbering.
using an email address from the appropriate subsidiary. For information about setting email
preferences, see the help topic Setting Email Preferences.
l. Enter a fax number.
m. Check the Elimination box if this subsidiary record is used for only intercompany journal
entries that reverse transactions between subsidiaries.
For information about elimination subsidiaries, see Elimination Subsidiaries.
For information about intercompany journal entries, see the help topic Making
Intercompany Journal Entries.
n. If this subsidiary uses multiple languages, select the default language for NetSuite users in
this subsidiary.
Note: You can enable multiple languages in the International section on the
Company subtab at Setup > Company > Enable Features.
Individual users can choose their language at Home > Set Preferences.
o. If this subsidiary uses multiple calendars, select the calendars to roll up accounting and tax
periods.
The fiscal calendar determines the start date for the accounting year.
The tax fiscal calendar determines the start date for the tax year.
Note: You can enable multiple calendars in the Advanced Features section on the
Accounting subtab at Setup > Company > Enable Features.
Note: The NetSuite Edition used by the subsidiary is automatically provided based
on the country entered for the subsidiary address.
The following subsidiaries are available:
AU - NetSuite Australia
CA - NetSuite Canada
XX - NetSuite International (This edition is not country-specific. It is used for countries
that do not have their own edition. The underlying tax engine must be customized for
each country.)
JP - NetSuite Japan
UK - NetSuite UK
US - NetSuite US
Note: This option is visible only when the GL Audit Numbering feature is enabled.
For more information, see the help topics GL Audit Numbering and GL Impact
Locking.
t. The read-only Enable Period End Journal Entries box reflects the state of the feature
relative to this subsidiary. The Period End Journal Entries feature can be enabled for
the primary accounting book only through the Subsidiary Settings Manager page. For
information about the Subsidiary Settings Manager page, see Subsidiary Settings Manager.
u. Click Edit next to the Address field. Complete the fields, as required, and then click OK.
Note: The address form displayed in the popup may vary according to the country
where the subsidiary is located. It also depends on the custom address forms defined
in your account. For more information, see the help topic Customizing Address
Forms.
3. Click Save.
Important: If the new subsidiary exceeds the number of purchased country licenses, an
error message appears. This message prompts you to inactivate an existing subsidiary, or
contact your account manager to purchase additional licenses.
Note: If you have not entered transactions for a subsidiary, you can change the base
currency. To change the base currency, perform the following tasks:
▪ Delete the nexus.
▪ Delete the subsidiaries related to that nexus.
▪ Recreate the nexus.
▪ Recreate the subsidiaries using the correct currency and then reassociate them with the
nexus.
For subsidiary planning information, see Subsidiary Hierarchy Planning.
■ Edition
■ Identification and tax numbers
■ Enable Period End Journal Entries state
■ Country
■ Elimination state
■ Currency
■ Edition
■ Enable Period End Journal Entries state
Warning: If you use the Subsidiary Hierarchy Modification general preference, the
Subsidiary Of field becomes a list, rather than a read-only field. If you must modify the
subsidiary hierarchy structure, you may corrupt your data and instigate significant legal
or financial consequences. For information about using this preference and its related
consequences, see Modifying Your Subsidiary Hierarchy Structure.
Note: The subtabs that appear reflect the features enabled in your system. For example,
if you use autogenerated numbering by subsidiary for specific transactions, the Numbers
subtab is available. Please see the appropriate help topics for these feature-specifc subtabs,
or use the field level help on each subtab.
4. To define the subsidiary’s shipping label and return addresses, click the Addresses subtab, and
then click the Edit links next to the Shipping Address and Return Address fields.
When you complete these address fields, the system uses these addresses rather than the
shipping and return addresses defined at Setup > Company > Setup Tasks > Company Information.
Note: You can also edit the company address on this subtab.
5. To add or remove tax nexuses associated with the subsidiary, click the Nexuses subtab.
See Adding or Removing Nexuses from a Subsidiary.
6. To set preferences for the subsidiary, click the Preferences subtab and select or check the options
for this subsidiary.
For information about setting preferences, see Set Subsidiary Preferences.
7. To define alternate subsidiary names to display in other languages, click the Languages subtab.
8. To view changes made to this record, click the System Notes subtab.
9. Click Save.
The subsidiary-specific preferences set on this subtab take precedence over company preferences in the
event that they conflict.
Any user preferences set at Home > Set Preferences take precedence over subsidiary-specific and
company preferences. For more information, see the help topic Setting Personal Preferences.
The Preferences subtab is divided into additional subtabs. Select or check the options for this subsidiary.
General
■ Default Check Type - Select the type of check you print by default for this subsidiary.
■ Select the email templates you want used to send email to employees, customers, and partners when
you grant them access to your NetSuite account. You grant them access from the User Access Email
Template, Customer Center Email Template, and Partner Center Email Template fields.
For more information, see the help topic Working with Email Templates.
■ Select the date, time, and number formats used by this subsidiary from the various format fields.
■ Phone Number Format - Choose the format used for phone numbers in this subsidiary.
■ Time Zone - Select the time zone for this subsidiary.
■ First Day of Week - Select the first day of the week for this subsidiary.
■ Search Sorting - Select the alphabetical order to use for search results.
■ Round Time Entry Duration - Select how you want time transactions rounded for this subsidiary.
■ Default Payable Account for Expense Reports - Select a default payable account for expense
reports for this subsidiary.
■ Default Account for Corporate Card Expenses - Select a default payable account for corporate card
expenses for this subsidiary.
■ Default Advance to Apply Account for Expense Reports - Select a default account for advances to
apply on expense reports for this subsidiary.
■ Vendor Prepayment Account – Select a default account for vendor prepayments. You can also
configure a default vendor prepayment account at company level. For more information, see the help
topic Configuring a Default Vendor Prepayment Account.
■ Check Default Chart Type - Select the check layout used when printing checks for this subsidiary.
Support
■ Default Case Profile – Select which case profile is used by default when a new support case is
created.
Issues
■ Send Customer Notifications When – Select default criteria for when customers of this subsidiary
that have cases associated with an issue should be notified by email.
■ Allow Customer Override – Check this box if you want customers of this subsidiary to be able to
change their issue notification email settings in the Customer Center.
■ Customer Template – Select the template you want to use for the issue notification email sent to
customers of this subsidiary.
■ Employee Template – Select the template you want to use for the issue notification email sent to
employees of this subsidiary.
CSV
■ CSV Column Delimiter – Select the symbol to be used as a column separator in the CSV data you
import. This option overrides the settings specified at the company level.
■ CSV Decimal Delimiter – Select the symbol to be used as a decimal mark in the CSV data you import.
This option overrides the settings specified at the company level.
■ This read-only subtab appears only when the Period End Journal Entries feature is enabled for your
account. This feature’s settings are configured and edited through the Subsidiary Settings Manager
page. For information about the Subsidiary Settings Manager page, see Subsidiary Settings Manager.
For more information about this feature, see the help topic Period End Journal Entries.
□ Create Balance Sheet Closing and Opening Journals – If checked, the system adds a step to
the Create Period End Journals task on the Period Close Checklist. The Balance Sheet Closing step
follows the Income Closing step at the fiscal year end of the subsidiary.
□ If you use the GL Audit Numbering feature and Exclude Balance Sheet Closing Journals from GL
Numbering is checked, the system skips numbering for the balance sheet closing journals.
□ Create Income Summary Journals – If checked, the system creates two period end journals in
the Income Statement Closing step of the Create Period End Journals task on the Period Close
Checklist. The first journal reduces the income and expense accounts to zero and posts the net
income to the account defined for income summary profit or loss. The second journal moves
the balance from the income summary account used in the first journal to the retained earnings
account.
□ Require Memo on Period End Journals – If checked, period end journals cannot be submitted
without a value in the Memo field. The value in the Memo field during the journal creation process
populates the Memo fields in the header and lines of the period end journal.
□ Group by These Segments – This multi-select list displays all the segment types that impact the
general ledger. Possible segment types are class, department, location, and all custom segments
with general ledger impact. The system generates separate period end journals for each selected
segment type combination included in the source transactions for this subsidiary. For more
information about custom segments, see the help topic Custom Fields and Segments on Period
End Journals.
You can also delete a subsidiary if the only action you performed is to add tax agency addresses.
Remove a nexus from a subsidiary only if the subsidiary does not have any transactions associated with
the nexus. If the subsidiary has transactions associated with the nexus, the system displays an error
message containing a list of those transactions. To remove the nexus from the subsidiary, you must
delete or modify those transactions. Click each transaction in the error message to view the transaction
record.
■ GL Impact Locking - This feature locks transactions for subsidiaries located in countries where the
general ledger impact of a transaction must be locked to the general ledger. For more information,
see the help topic GL Impact Locking.
■ Transaction Locking SuiteApp (Bundle ID 8791) - This SuiteApp is available at no cost from the
NetSuite bundle repository. Contact NetSuite Customer Support to request access to the Transaction
Locking SuiteApp. For more information, see the help topic Transaction Locking SuiteApp.
Numbering transactions by subsidiary is useful for users with access to only one subsidiary because they
do not encounter numbering gaps for another subsidiary’s transactions.
Be aware that some countries require unique numbering without gaps for each legal entity.
Note: A transaction inherits its subsidiary from its entity (customer or vendor). See Associate
Subsidiaries with Entities and Items.
4. If you have enabled auto-generated numbering by subsidiary for specific transactions, click the
Numbers subtab to specify the initial number for each transaction type.
5. Click Save.
The Role page also includes the Allow Cross-Subsidiary Record Viewing option. Check this box to permit
users logged in with that role to see data from subsidiaries other than those selected in the Subsidiaries
list.
Note: Users with the Book Record Restriction option enabled override permissions granted by
the Allow Cross-Subsidiary Record Viewing option.
Important: The records and transactions that employees can view and edit for subsidiaries
are limited by the complete set of permissions defined for their assigned roles. For example,
by default, employees of a specific subsidiary are able to view and edit data only for the that
subsidiary. If you customize a role to include multiple subsidiaries (Subsidiaries list), employees
assigned this role can view and edit data for these subsidiaries. If you also checked the Allow
Cross-Subsidiary Record Viewing box for the customized role, employees assigned this role can
view data for all subsidiaries.
Note: Employees with access to all active subsidiaries but not to one or more inactive
subsidiaries are considered to have access to all subsidiaries.
The following choices are dependent on the subsidiaries selected for the user's assigned role, or on the
subsidiary assigned to the employee record:
■ Available subsidiaries in the Subsidiary field when the user creates new entity and item records
See Associate Subsidiaries with Entities and Items and Associate Subsidiaries with Items.
■ Available entities when the user creates new transactions
Generally, users can create transactions only for entities associated with subsidiaries to which they
have access. Time and expense entry forms are exceptions to this general rule. These forms they
permit creation of transactions for customers or projects associated with other subsidiaries, as long as
they are not billable.
■ Available subsidiaries in Subsidiary Context list when the user runs reports
■ Available classes, departments, and locations in footer filters on reports
A user can restrict the records displayed in NetSuite to those for a single subsidiary. Go to the Restrict
View subtab at Home > Set Preferences. See Restrict Your Subsidiary View.
If you are assigned a role with access to multiple subsidiaries, you may want to limit the data with which
you are working. For example, you may want to restrict data to one subsidiary. For many reports, you can
select a subsidiary after you run the report from the Subsidiary Context list in the footer of the results
page. These reports support consolidation, or rollup of subsidiary results. See Subsidiary Context for
Reports. However, for reports that do not support consolidation, you must set your user preferences to
view a single subsidiary before you run the report.
You can restrict the data shown in the current login session including the user interface, searches, and
reports. Go to the Restrict View subtab at Home > Set Preferences.
To restrict the view to a parent subsidiary and its children, select the parent subsidiary from the
Subsidiary list and check the Include Sub-Subsidiaries box.
To restrict the view to a single subsidiary, select it from the Subsidiary list and do not check the Include
Sub-Subsidiaries box.
When you restrict your subsidiary view, the departments, locations, and classes available to you are
limited to those associated with the selected subsidiary.
The view restrictions you set apply only to the current login session for current role. The next time you log
in with this role, your normal settings are applied.
Note: It you select your root subsidiary in the Subsidiary list, all subsidiaries are included.
Therefore, you need not check the Include Sub-Subsidiaries box.
For more information about restricting subsidiary viewing, see the following help topics:
1. Ensure that you have a thorough understanding of how subsidiaries, including elimination
subsidiaries are organized in OneWorld. See Subsidiaries in OneWorld and Elimination
Subsidiaries.
2. Plan your subsidiary hierarchy and create a visual representation of this structure. See Subsidiary
Hierarchy Planning.
3. Ensure that currencies to be used by subsidiaries are set up in your account.
For an overview of how OneWorld uses multiple currencies, see Multiple Currencies in OneWorld.
For details about setting up currencies and exchange rates, see the help topics Creating Currency
Records and Currency Exchange Rates.
4. Ensure that tax jurisdictions (nexuses) to be used by subsidiaries and related tax items are set up
in your account.
■ For an overview of how OneWorld uses nexuses, see Nexuses and Taxes in OneWorld.
■ For details about setting up taxes, see the help topic Enabling and Setting Up Taxation
Features.
5. Create subsidiary records. Start from the top-level or root subsidiary, and work your way down
through child and grandchild subsidiaries.
■ You can create subsidiaries representing both legal entities and elimination subsidiaries. For
instructions, see Creating Subsidiary Records.
■ After you save each subsidiary record, you can edit its nexuses and set preferences, as needed.
See Editing Subsidiary Records.
■ You can delete a subsidiary if there are no associated transactions or records. See Deleting
Subsidiary Records.
6. Complete the following, as needed:
■ Account Setup in OneWorld
■ Setting Up Automated Intercompany Management
■ Payroll Setup in OneWorld
■ Inventory Setup in OneWorld
■ Multiple Vendors Setup in OneWorld
■ Associate Subsidiaries with Entities and Items
■ Associate Subsidiaries with Items
■ Associate Subsidiaries with Shipping Items
■ Control Employee Access to Subsidiaries
■ Locking Transactions by Subsidiary
Note: Bank accounts and credit card accounts are restricted to one subsidiary. When you create
a bank account or credit card account, you can select only one subsidiary for the account.
■ General Rate Type - This rate type is used for the income statement, balance sheet, and other
general purposes.
■ Cash Flow Rate Type - This rate type is used for the cash flow statement.
Go to Setup > Accounting > Manage G/L > Chart of Accounts. Click an Edit link next to account. Set up the
account record as follows:
1. In the General Rate Type field, select Current, Average, or Historical to determine which
consolidated rate to use in all cases except cash flow.
Tip: Current – Also referred to as “ending rate,” the system uses this rate for all balance
sheet accounts that do not use historical rates.
Average – The system uses this rate for all income statement accounts.
Historical – The system uses this rate for equity accounts and fixed asset accounts on the
balance sheet.
2. In the Cash Flow Rate Type field, select Current, Average, or Historical to determine which
consolidated rate to use.
For example, long-term assets use the Historical rate type on the cash flow statement. Balance
sheet uses the Current rate type on the cash flow statement.
3. If necessary, select one or more subsidiaries in the Subsidiaries field.
■ If the root subsidiary is selected and the Include Children box is checked, then all subsidiaries
can access the account.
■ If one or more subsidiaries are selected, then the account can be selected for records and
transactions associated with those subsidiaries.
For more details about rate types, see the help topic Consolidated Exchange Rate Types.
For more information about setting up accounts, see the help topic Creating Accounts.
Note: If the Intercompany Time and Expense feature is enabled in your account, an
intercompany clearing account is automatically created when there is an associated transaction.
For more information, see the help topic Intercompany Clearing Account.
■ Unique Employer Identification Number (EIN) from the U.S. Internal Revenue Service (IRS)
■ Unique NetSuite vendor record per tax agency
For example, if your organization includes two subsidiaries located in California, you must set up the
following vendor records:
□ two differently named NetSuite vendor records for the IRS
□ two differently named vendor records for the California Franchise Tax Board
Only employees assigned to a U.S. subsidiary designated to process payroll can be included in payroll
processing. Employees assigned to subsidiaries other than the one designated for payroll cannot be
processed for payroll. See the following help topics for more information:
■ Payroll Preferences
■ Updating Payroll Information
■ Processing Payroll Batches
■ Advanced Taxes
After you enable the Inventory feature, you must associate each location with only one subsidiary. If you
do not use the Inventory feature, you have the option to associate each location with no subsidiary, one
subsidiary, or multiple subsidiaries.
In OneWorld, you cannot enter initial quantities on hand when you create an item record. You must first
create the item record, and then afterward, you must enter an inventory adjustment to specify the initial
quantities in each location. See the help topics Creating Item Records and Adjusting Inventory for more
details.
When you use Multiple Vendors, on each item record you must specify a preferred vendor for each
subsidiary. The preferred vendor enables you to drop ship or special order items for that subsidiary.
When you use the Order Items form, the preferred vendor associated with the subsidiary defaults on the
form for each line.
When you view the item list, the preferred vendor associated with the root subsidiary (highest-level
parent) shows by default.
If an item has a preferred vendor, the purchase price shows on the item record in the root subsidiary's
preferred vendor currency.
For more information about vendor records, see the help topic Vendor Records Overview.
Logos in OneWorld
When you set up subsidiaries in OneWorld, you can choose the logo that displays for each subsidiary
when viewing pages or printing transactions. Each subsidiary can use an individual logo to distinguish
itself from the others.
To use the subsidiary logo and address from the transaction record when you print, use advanced
templates. For more information, see the help topic Advanced PDF/HTML Templates. If you print
transactions using basic layouts, the logo and address are sourced from the vendor’s primary subsidiary.
On each subsidiary record, use the following fields to determine which logos display on pages and which
are printed on transactions.
If logo options are not configured for a subsidiary, NetSuite checks each parent subsidiary in hierarchical
order to find a subsidiary with logo options configured. If no subsidiary has logo settings configured,
NetSuite pages display logos based on the company settings at Setup > Company > Setup Tasks >
Company Information.
Intercompany Framework
The Intercompany Framework feature includes a variety of components to help you manage your
intercompany workflows. For example, this feature includes the cross charge generation functionality.
Cross charge generation is a task that you perform at period end close. This task generates charges
for subsidiaries that performed services for each other during the accounting period. One such service
would be when you source and fulfill inventory items from different subsidiaries. When subsidiaries fulfill
orders or accept returns on behalf of other subsidiaries, NetSuite creates open intercompany payable and
receivable balances. NetSuite reconciles these balances through the cross charge generation task.
The Intercompany Framework feature also includes the intercompany netting functionality. This
functionality enables you to settle mutual intercompany open balances across subsidiaries, and then
automatically generate intercompany settlements statements. When you use this functionality throughout
the accounting period, you reduce the number of open intercompany transactions. Fewer open
intercompany transactions means less manual effort spent reconciling, revaluing, and eliminating these
balances. It also simplifies the period close process and decreases the time spent on payment processing
and bank reconciliation.
Tip: You should create a custom role with all of the following permissions to ensure proper use
of the Intercompany Framework feature.
On the Permissions subtab, click ■ You must have access to all subsidiaries.
the Transactions subtab.
■ You must have access to all classes, departments, and locations.
■ You must have full level Cross Charge Journal permission to generate cross
charges during period close.
■ You must have full level Manage Cross Charge Automation permission to use
the Cross Charge Workbench.
On the Permissions subtab, click You must have view level Income Statement permission to run the Intercompany
the Reports subtab. Elimination Report.
On the Permissions subtab, click ■ You must have full level Accounting Preferences permission to define
the Setup subtab. intercompany preferences.
■ You must have full level Subsidiary Settings Manager permission to configure
class, department, and location defaults for cross charge transactions.
■ You must have full level of the following permissions to access the Cross
Charge Workbench:
□ Manage Accounting Periods
□ Period Closing Management
□ Override Period Restrictions
You should configure your intercompany elimination accounts to include the children of the subsidiaries
you select in the account. Check the Include Children box to ensure that all subsidiaries of the selected
subsidiaries can use the intercompany elimination accounts.
An administrator can enable the following features at Setup > Company > Enable Features
(Administrator):
■ Accounting, A/R, A/P, and Accounting Periods - These features are located on the Accounting subtab
under the Basic Features section.
For information about general accounting and links to specific help topics, see the help topic NetSuite
Accounting Overview.
■ Intercompany Framework and Automated Intercompany Management - These features are located on
the Accounting subtab under the Advanced Features section. You cannot disable these features after
you enable them
For information about the Automated Intercompany Management feature, see Automated
Intercompany Management.
■ Intercompany Cross-Subsidiary Fulfillment - This feature is located on the Items & Inventory subtab
under the Inventory section.
For information about the Intercompany Cross-Subsidiary Fulfillment feature, see the help topic
Intercompany Cross-Subsidiary Fulfillment.
Important: You can generate cross charges for fulfilment and receipt lines only if they have
a GL impact.
In addition to the preceding requirements, you should enable the following features for optimal use of
the Intercompany Framework feature:
■ Currency Exchange Rate Types - See the help topic Currency Exchange Rate Types
Intercompany Preferences
When an administrator enables the Intercompany Framework feature or the Automated Intercompany
Management feature, NetSuite provides access to the Intercompany Preferences page. If you have
the Setup Accounting permission, you can define intercompany preferences at Setup > Accounting >
Preferences > Intercompany Preferences.
If you use the Intercompany Framework feature, the Intercompany Preferences page includes the
following four subtabs.
■ Accounting - This subtab enables you to define the default accounts for the Intercompany Framework
and Automated Intercompany Management features. The Intercompany Framework feature uses the
default accounts to generate cross charges during period end close. The Automated Intercompany
Management feature uses the default accounts to record and post intercompany purchase and sale
transactions across subsidiaries.
Important: You must first set up intercompany elimination accounts before you can define
default intercompany accounts. For information, see Creating Intercompany Elimination
Accounts.
You can specify the currency that your subsidiaries use when they do business with each other. You
can also choose how to group the cross charges generated at period close. Finally, you can define
default cross charge classification preferences by subsidiary. These settings are not available if you use
only the Automated Intercompany Management feature.
■ Transfer Price Methods - This subtab does not appear if you use only the Automated Intercompany
Management feature. This subtab enables you to define the markup percentage when one subsidiary
fulfills an order or accepts a returned order for another subsidiary.
■ Intercompany Entities - This subtab is for users that have previously enabled and set up
representing entities for the Automated Intercompany Management feature. When you first
enabled that feature, you were required to customize the vendor and customer records to include
the Represents Subsidiary field. This field indicates that the entity acts as an agent for a selected
subsidiary. After you customized the entity records, you then manually created intercompany vendors
and intercompany customers to represent your non-elimination subsidiaries. If you changed a
subsidiary record, you were required to manually update the representing vendor and customer
records.
There are prerequisites to use the Intercompany Entities subtab. Current users of the Automated
Intercompany Management feature must also enable the Multi-Subsidiary Customer feature. In
addition, if you use the Multiple Currencies feature, you must also enable the Multi-Currency Vendor
and Multi-Currency Customer features. If you meet these prerequisites, NetSuite can generate and
maintain representing entities for all of your non-elimination subsidiaries.
Note: If you are new to the Intercompany Framework and Automated Intercompany
Management features, NetSuite automatically generates and maintains representing entities
for your non-elimination subsidiaries.
■ System Notes - This subtab displays the definition of intercompany preferences, as well as any
changes. It displays the date and time of the definition or any change, and the name of the user who
saved the record.
If you use both features, you can define default intercompany accounting preferences and markup rates
for cross-subsidiary transactions. If you use only the Automated Intercompany Management feature, you
define fewer accounting preferences.
Important: You must create intercompany elimination accounts before you can set
preferences for the Intercompany Framework and Automated Intercompany Management
features. See Creating Intercompany Elimination Accounts.
Note: You must have the Setup Accounting permission to define intercompany preferences.
Important: If you edit an account or currency selected for cross charge generation, it
remains selected even if it is no longer valid for selection. If you inactivate an account or
currency selected for cross charge generation, it remains selected even when inactivated. If
you delete an account or currency selected for cross charge generation, NetSuite removes
it from selection.
4. In the Transaction section, the Cross Charge Output Type defaults to journal.
Choose how to group cross charges. Summarized grouping is the default.
5. In the Classification section, click the link to open the Subsidiary Settings Manager page. Specify
default cross charge classification preferences by subsidiary on the Intercompany Framework
subtab. For information, see Subsidiary Settings Manager.
6. Click the Transfer Price Methods subtab.
The default transfer price method to support intercompany cross-subsidiary fulfillment and
return is cost plus, an expense (price amount). NetSuite bases the transfer price on a markup rate
(expense plus a percentage of the expense).
Enter a percentage value in Markup Rate % for both cross-subsidiary fulfillment and cross-
subsidiary fulfillment return.
Note: The percentage value must be 0% or higher with 2 decimal precision. The
percentage determines the system-calculated markup over the original transaction
expense. A 0% would not generate a markup over the original expense. The rate cannot be
a negative percentage.
Note: If you are new to the Intercompany Framework and Automated Intercompany
Management features, NetSuite automatically generates and maintains representing
entities for all non-elimination subsidiaries.
8. Click Save.
After you save your preferences, the Intercompany Entities subtab provides a link to the
Processed Records page. This page provides the status of the representing entity creation process.
See Processed Records. From the Processed Records page you can open the Process Status page.
See Process Status.
9. Click the System Notes subtab to view the saved or changed values.
Important: When there is at least one cross charge journal in any open accounting period,
NetSuite disables the preferences related to cross charges. NetSuite also disables related options
in the Subsidiary Settings Manager. To modify the related preferences, you must first delete
all cross charges in all open periods. You can delete the cross charges on the Cross Charge
Workbench page. For more information, see Generating Intercompany Cross Charges.
Note: Your user role must have both Admin Accounting and List Account permissions to
create new accounts.
Representing Entities
The Intercompany Framework feature requires the Automated Intercompany Management feature.
When you enable the Automated Intercompany Management feature, NetSuite creates and updates
representing entities for all active and inactive non-elimination subsidiaries when you enable it.
Representing entities are vendors and customers that act as agents for a selected subsidiary. The default
entity name is a combination of the subsidiary name and subsidiary ID, reduced in length to the field
length. The primary currency is the base currency of the subsidiary. NetSuite adds all of the subsidiary’s
currencies, and all of the subsidiary’s secondary subsidiaries to the representing entities’ records. The
default primary subsidiary for the representing entities is the parent (root) subsidiary, but you can select
another subsidiary as the primary subsidiary. The exception to this is the representing entities for the
parent subsidiary, where the primary subsidiary is the first child subsidiary.
If you currently use the Automated Intercompany Management feature, NetSuite does not automatically
create representing entities. However, you can set the Automatically Create Representing Entities
preference to let NetSuite create and maintain representing entities. You can also set a prefix to quickly
distinguish system-generated representing entities from manually generated representing entities.
The preference and prefix field are located on the Intercompany Entities subtab of the Intercompany
Preferences page.
After you enable the required features and then save, the Setup Manager page displays an Information
bar at the top. The message states that your account meets the prerequisites to use the Automatically
Generate Representing Entities intercompany preference. The message provides a link to the
Intercompany Preferences page where you can set the preference. When you save the preference,
another Information message appears at the top of the page. This message states that NetSuite is
creating and updating representing entities, and provides a link to the Processed Records page. See
Processed Records.
Note: If you use SuiteTax, the subsidiary record includes the representing entities’ tax
information on the Tax Registrations subtab.
In the header of the representing entity record is the Is Autogenerated Representing Entity box. It is
checked by default, and dimmed. You can customize the forms, as needed.
You cannot create or delete a system-generated representing entity record. When you create a new
subsidiary, NetSuite generates the representing entity records. When you delete a subsidiary record,
NetSuite deletes the representing entity records.
Below are the subsidiary record fields that NetSuite syncs with the non-editable representing entities
fields:
■ Company Name
■ Inactivity
■ Subsidiary list
■ Currency list
■ Address - Main and Shipping
1. Go to Reports > Saved Searches > All Saved Searches > New.
2. Click Subsidiary.
3. On the Criteria subtab, on the Standard subtab, select User Fields from the Filter list.
4. In the popup window, select Represents Subsidiary from the User Filter list.
5. Select the subsidiaries to include in the saved search, and then click Set.
6. Click OK.
7. Add other filters, as needed.
8. Click Save or Preview.
Processed Records
The Processed Records page displays the generation status of the representing entities as NetSuite
generates them. This page provides a link to the subsidiary records and their respective intercompany
customer and intercompany vendor records. The generate representing entities process also updates
records that are missing subsidiaries and currencies to ensure that subsidiary, customer, and vendor
records are synced. If you click Return to Status Page in the top right corner of the Processed Records
page, you can open the Process Status page. See Process Status.
Process Status
The Process Status page provides the status of the intercompany entity generation process, and its
percentage complete. It provides a link to any system-generated message about the submission, such
as error messages. It also provides the date and time of the submission, and the name of the user who
created the submission.
The Generate Intercompany Cross Charges task generates a pair of automatically approved cross
charges as read-only intercompany transactions. NetSuite generates one transaction for the selling
subsidiary, and one for the buying subsidiary. These cross charges create open intercompany payable
and receivable balances, and appear in the trading currency specified on the Intercompany Preferences
page. You can settle mutual open intercompany balances with intercompany netting. For information
about intercompany netting, see Intercompany Netting.
Note: You must set intercompany preferences before you can generate cross charges. For
information, see Intercompany Preferences.
1. On the period close checklist, run the tasks that precede the Generate Intercompany Cross
Charges task.
For details about closing accounting periods and using the period close checklist, see the help
topics Accounting Period Close and Using the Period Close Checklist.
2. Click the Go To Task icon next to Generate Intercompany Cross Charges.
3. On the Task: Generate Intercompany Cross Charges page, click Generate Intercompany Cross
Charges.
4. On the Cross Charge Workbench page, click Generate Transactions.
Note: When you click Generate Transactions, NetSuite does not delete or modify
existing cross charge transactions. It generates cross charges only for the unprocessed
business services between subsidiaries.
5. Click Refresh to view the updated status of the cross charge generation process.
If the cross charge generation process successfully completes, NetSuite lists the generated cross
charges on the Cross Charges subtab. With the exception of the Amount column, the other
columns provide links so that you can drill down to supporting records. For example, if you click a
link in the Selling Subsidiary column, that subsidiary’s record opens.
If you click a link in the A/R Transaction column, the read-only intercompany transaction page
opens. This page provides links to the trade currency record, posting period, subsidiary record,
default cross charge elimination accounts, and the intercompany entity record. The page also
provides system notes, general ledger impact, links to a list of intercompany transactions, and to
the Transaction Search page.
If the cross charge generation process discovered errors, messages about these errors display on
the Message Log subtab. You should address any error and re-run the Generate Intercompany
Cross Charges task. If the error is Internal Error, click Actions, and then Reset Automation. If you
receive another internal error, menu contact Technical Support.
Important: When there is at least one cross charge journal in any open accounting
period, NetSuite disables the intercompany preferences related to cross charges. To modify
the related preferences, you must first delete all cross charges in all open periods. You can
delete the cross charges when you click Delete Transactions. For more information about
intercompany preferences, see Intercompany Preferences.
The Audit Log subtab provides a history of tasks run, run number, and status. It also provides the
user who ran the task, and the date and time of the run.
6. When you are satisfied with the generated cross charges, click Back to Period Close.
7. On the Task: Generate Intercompany Cross Charges page, click Mark Task Complete.
8. Proceed with period end close.
Intercompany Netting
The Intercompany Framework feature includes the intercompany netting functionality. Intercompany
netting enables you to settle mutual intercompany open balances across subsidiaries set up as
represented customers and vendors. Intercompany netting automatically generates settlements, which
reduces inaccuracies made through manually generated settlements.
When you use intercompany netting throughout an accounting period, you reduce the number of open
intercompany transactions and receive the following benefits:
■ Less manual effort spent in reconciling, revaluing, and eliminating open intercompany balances
■ Reduced exposure to foreign exchange rates
■ Decreased time spent on payment processing and bank reconciliation
■ Reduced international payment fees because of fewer payments
■ Simplified period close process
The Balance Overview report shows the open balances between subsidiaries in a specific transaction
currency. You can use this report to view the open balances before or after netting.
Note: You must have access to the subsidiaries for which you want to settle intercompany open
balances.
The following graphic illustrates open balances between two subsidiaries. Subsidiary A owes Subsidiary
B $1000 and Subsidiary B owes Subsidiary A $5000. Before intercompany netting, the open balances
generate four transactions. A vendor bill and customer invoice for $1000, and a vendor bill and customer
invoice for $5000.
The following graphic illustrates how intercompany netting eliminates open mutual balances, and reduces
the number of open intercompany transactions. Notice in the transaction workflow, the $1000 that
Subsidiary A owes Subsidiary B is deducted from the $5000 that Subsidiary B owes Subsidiary A. After
deducting the mutual open balances, Subsidiary B owes Subsidiary A $4000, and there are only two open
balance transactions.
The following graphic illustrates the basic intercompany netting workflow. You review the open balances
on Balance Overview page. NetSuite identifies the balances that are available for netting. You choose
from the available balances for netting, which opens the Netting Workbench page where you select the
transactions for netting. Alternatively, you can let NetSuite select the transactions for you.
On the Permissions subtab, click the ■ You must have the Netting Settlement permission to view and create
Transactions subtab. intercompany netting. This permission defaults to Full level.
■ Use the Automated Intercompany Management feature to generate intercompany transactions. The
intercompany netting functionality fully supports that transaction workflow. For information about this
feature, see Automated Intercompany Management.
■ Use the filters to reduce the display of open intercompany balance transactions. The intercompany
netting user interface provides dynamically loaded filters with all existing values. It also provides
sorting on every column. One click sorts a column in ascending order . A second click sorts the
column in descending order . A third click resets the column to the default sort order.
■ On the Netting Workbench page, use Suggest Netting. This option lets NetSuite apply and select
nettable transactions from the top down, respecting the current display order.
Note: You can use Suggest Netting even if you sort and filter the display order.
■ The Netting Settlement permission is limited to Full permission level. The Netting Settlement Approval
permission is limited to Edit permission level.
■ The Corporate Exchange Rate type is not supported.
■ Classification other than subsidiary is not supported.
■ Intercompany zero payment is not supported. You cannot clear accounts payable or accounts
receivable if there is no mutual balance between two entities. For example, if you have a vendor bill
and a vendor credit but no accounts receivable transaction, you cannot net it using intercompany
netting.
■ Intercompany netting supports only matched and linked intercompany transactions with the same
amounts on the payable and receivable sides of the general ledger. The following examples describe
supported intercompany transactions:
□ Intercompany Journal Entries – There must be only one AP and AR line for each subsidiary-
subsidiary-currency to ensure that the lines are nettable.
□ Intercompany Invoice and Intercompany Bill – These transactions are linked through their related
purchase order and sales order (arm’s length process inventory transfers). However, these
transactions must be matched by having only one invoice and one bill for the same amount, and
both must have intercompany entities.
Note: If you do not use the intercompany purchase order and sales order workflow, you
can pair (link) standalone intercompany invoices and bills. For information about pairing
invoices and bills, see Pairing Intercompany Transactions.
□ Intercompany Vendor Credit and Intercompany Credit Memo – This limitation is similar to the
Intercompany Invoice and Intercompany Bill limitation provided above. These transactions are
linked through their related purchase order and sales order. They must be matched through only
one vendor credit and one credit memo with intercompany entities and of the same amount.
Tip: Use the filters above the grid to reduce the balance overview list. The Subsidiary list is
a multi-select list and displays all of the values in the Subsidiary or Due to/From columns. Use
column sorting to view data in an order different from the default order. For information about
filters and sorting, see Best Practice for Using Intercompany Netting.
Note: When there are nettable amounts for a subsidiary-subsidiary-currency group, each
row displays a New link. The row in which you click the link displays that subsidiary’s open
financials on the Main subtab on the Netting Workbench page. For information about using
the Netting Workbench page, see Creating Netting Transaction Details.
If the Netting column displays a zero value on a row, and there is no New link, there is no mutual
balance to settle.
■ Suggest Netting lets NetSuite apply and select nettable transactions from the top down, respecting
the current display order.
■ The document number. NetSuite generates this number when you save the data on the Netting
Workbook page. It is the document number of the netting statement.
■ The date of the netting transaction. The default date is the system date, but you can change it, as
required. This date determines the accounting period in which the netting statement appears.
■ The Subsidiary field displays the subsidiary initiating the netting process. All of the transactions on the
Main subtab belong to this subsidiary.
■ The currency used in the accounts payable and accounts receivable transactions. It is also the currency
used when you create the netting settlements.
■ The status of the netting statement, which is Pending Approval or Approved.
■ The Due To/From field displays the subsidiary involved in the intercompany transactions for the
initiating subsidiary. You can find the transactions that belong to this subsidiary in the Pair column on
the Main subtab.
■ The Summary grid provides a synopsis of the settings on the Main subtab. The amounts applied to
accounts payable must match the amounts applied to accounts receivable.
■ You can access the Netting Statement list page and Balance Overview page through the links at the
top right corner of the header.
Main Subtab
The accounts payable and accounts receivable sides of the Main subtab provide the same options. You
can filter the transactions on the Main subtab by the as of date of the transaction and the transaction
type. Use column sorting to view data in an order other than the default order. For information about
filters and sorting, see Best Practice for Using Intercompany Netting.
If you check the Applied Only box, only transactions that have a value in the Applied column appear. If you
check the Nettable box, only those transactions with a nettable amount appear.
Note: Multiple invoices linked to one bill, and multiple bills linked to one invoice appear on the
Main subtab but are not nettable. These transactions appear only when the Nettable box is clear.
These transactions do not have a related transaction in the Pair column.
Netting Statement
After you save the netting workbench, the Netting Statement page appears. It contains the same
information that you used in the netting workbench, and more. The netting statement displays the
Netting Settlements and System Notes subtabs next to the Main and Exchange Rate subtabs.
The Netting Settlements subtab provides the names of the subsidiaries associated with the netting
statement. It also provides the account type, document number, and whether the transaction is a posting
transaction. The document number links open the respective Netting Settlement page. See Netting
Settlement.
You can delete the netting statement, if required. The accounting period must be open to delete the
netting statement.
You can approve the netting statement if you have appropriate permissions.
Netting Settlement
The netting statement automatically generates four netting settlements (two for each subsidiary). One
netting settlement closes the accounts payable side of the general ledger. The other netting settlement
closes the accounts receivable side of the general ledger. These netting settlements represent the
general ledger impact of netting on each subsidiary.
If the netting exchange rate is different from the selected transactions exchange rate, NetSuite calculates
realized gain and loss and rounding gain and loss. For information, see the help topic Foreign Currency
Revaluation.
Note: NetSuite uses the system-generated IC Netting Clearing Account to book intercompany
netting transactions. It is an other current asset type account, and is associated with all
subsidiaries. NetSuite balances this account to zero after each netting. NetSuite also balances this
account to zero at the consolidated subsidiary level.
For example, the Subsidiary A netting settlement for accounts payable books a $100 debit to the
IC Accounts Payable account. It books a $100 credit to the IC Netting Clearing Account.
The Subsidiary A netting settlement for accounts receivable books a $100 credit to the IC Accounts
Receivable account. It books a $100 debit to the IC Netting Clearing Account.
NetSuite uses those exact bookings for the two netting settlements for Subsidiary B.
The netting settlement provides the creation date, currency, posting period, and the due to or from
subsidiary. It also provides the approval status, the netting statement from which it was created, and any
memo.
■ The Lines subtab provides the accounts to which the credit and debit was booked for the subsidiary
and the associated entity.
■ The Applied To subtab provides a link to the related transaction and the amount applied to that
transaction.
■ The System Notes subtab lists the details associate with the netting settlement created from the
netting statement.
■ The GL Impact subtab provides details specific to the debit and credit applied to the subsidiary’s
intercompany accounts. Click the account link to see the transaction register for that account.
Tip: You cannot edit netting settlements, however, you can delete them by deleting the
associated netting statement.
The Netting Statement list page provides the netting statement date and number, status, the subsidiary-
subsidiary-currency group, netted amount, and currency.
Use the filters to reduce the nettings transactions list. Use column sorting to view data in an order other
than the default order. For information about filters and sorting, see Best Practice for Using Intercompany
Netting.
The links in the Netting Statement column open the respective netting statement where you can view the
details associated with the netting statement.
Note: The field values on the Netting Statement list page are available to SuiteAnalytics
Workbook and the Transaction saved search. For information about SuiteAnalytics Workbook, see
the help topic SuiteAnalytics Workbook Overview. For information about saved searches, see the
help topic Defining a Saved Search.
With this feature enabled, NetSuite automatically generates elimination journal entries based on the
intercompany transaction lines and intercompany journal lines marked to be eliminated. As part of the
period close process, NetSuite evaluates the activity in your intercompany accounts. It then creates the
journal entries to eliminate artificial profit and loss amounts. Without this feature enabled, you must
manually create and track all intercompany transactions and then manually create and post elimination
journal entries.
■ Create intercompany purchase orders per subsidiary, as needed. See the help topic Entering a
Purchase Order.
■ Generate intercompany sales orders from intercompany purchase orders. See Manage Intercompany
Orders.
■ Manage intercompany inventory transfers. See Managing Intercompany Inventory Transfers - Arm's
Length.
■ Enter advanced intercompany journal entries for other intercompany transactions. See the help topic
Making Advanced Intercompany Journal Entries
■ Reconcile intercompany transactions. See Intercompany Reconciliation Report.
■ Run Intercompany Elimination from the Period Close Checklist. See Intercompany Elimination
Overview.
■ View the Intercompany Elimination report. See Intercompany Elimination Report.
For information about how to run intercompany elimination, see Using Automated Intercompany
Management for Elimination.
When you enable this feature, NetSuite adds the following fields, accounts, and more:
■ NetSuite adds the system-generated Cumulative Translation Adjustment-Elimination (CTA-E)
account to your chart of accounts after a user enters a qualifying transaction. For example,
a user must first run the elimination process so that NetSuite creates an elimination journal
entry that uses this account. See Cumulative Translation Adjustment-Elimination (CTA-E).
■ NetSuite adds the Eliminate Intercompany Transactions task as the last task in the Period
Close Checklist.
■ An Eliminate box displays for journal lines on standard and advanced intercompany journal
entries.
Note: You can use journal entries rather than advanced intercompany journal entries
to record intercompany transactions. However, you must customize the standard
journal entry form to display the Eliminate box. See Customizing Standard Journal
Entries for Intercompany Elimination.
■ NetSuite creates the Standard Intercompany Vendor Form and the Standard Intercompany
Customer Form records. These new records include the Represents Subsidiary field, which
does not display on the standard vendor and customer records.
■ NetSuite adds the Intercompany Status and Paired Intercompany Transactions fields
to the Sales Order, Purchase Order, Return Authorization, and Vendor Return Authorization
pages.
■ NetSuite adds the Eliminate Intercompany Transactions box to the Account record.
3. Create intercompany accounts. See Intercompany Accounts.
4. If you are new to the Automated Intercompany Management feature, NetSuite automatically
generates intercompany entities to represent all non-elimination subsidiaries. See Representing
Entities.
If you already use the feature, you can continue to create intercompany customers and vendors
that represent your non-elimination subsidiaries. See Creating Intercompany Customers and
Vendors.
5. Review the guidelines for inventory items for intercompany transfers. See Intercompany Inventory
Items Guidelines.
6. For arm's length intercompany inventory transfers, verify that the Use Item Cost as Transfer Cost
preference is not enabled. Go to Setup > Accounting > Preferences >Accounting Preferences .
Click the Order Management subtab. Under the Transfer Orders section, ensure the preference
is not enabled.
7. Optionally, enable the Automated Intercompany Drop Ship feature to manage intercompany drop
ship orders. Go to Setup > Company > Enable Features. Click the Accounting subtab. Under the
Advanced Features section, check the Automated Intercompany Drop Ship box, and then save.
See Intercompany Inventory Drop Ship.
Intercompany Accounts
Intercompany accounts are general ledger accounts used to record transactions such as intercompany
payments, loans, and funds transfers between subsidiaries. These accounts track the intercompany
amounts to be eliminated. When you run the intercompany elimination period end close task, amounts
posted to intercompany accounts eligible for elimination are eliminated for consolidated financial
statements. Posting occurs during the period close process.
An intercompany account is an account that has the Eliminate Intercompany Transactions box
checked. For accounts that cannot be used for intercompany transactions, the field is dimmed. You
can post both intercompany transactions and non-intercompany transactions to most intercompany
accounts. Intercompany Accounts Receivable and intercompany Accounts Payable accounts, however,
can be used only for recording amounts that are candidates for eliminations. NetSuite requires an
intercompany customer or intercompany vendor for intercompany A/R and A/P accounts.
Double-Entry Bookkeeping
NetSuite enforces double-entry bookkeeping, so journal entries post changes to accounts using offsetting
debits and credits. Each posting transaction in NetSuite posts to at least two accounts. Each journal entry
includes at least one debit amount and at least one credit amount. For information about journal entries,
see the help topic Journal Entries.
Important: When NetSuite released the Intercompany Time and Expenses feature, the first
set of accounts created were named Intercompany Payable/Receivable XXX, where XXX denoted
the currency ISO code. In 2013.1, NetSuite OneWorld introduced the Intercompany Clearing
XXX account. This account replaced the Intercompany Payable/Receivable XXX account for new
implementations. In 2014.1, NetSuite OneWorld introduced new intercompany clearing accounts
for payable and receivable that are not currency locked. NetSuite uses these clearing accounts
for intercompany transactions. All existing currency-locked intercompany clearing accounts (the
Intercompany Payable/Receivable accounts) are now child accounts of the clearing account.
For more information, see the help topics Enabling Intercompany Time and Expenses and
Intercompany Elimination Overview.
Account Groups
You can create an intercompany account for the following groups of accounts:
You cannot create intercompany accounts for the following system-generated accounts:
For more information about features and system-generated accounts, see the help topic Feature-Specific,
System-Generated Accounts.
Account Types
You can create more than one intercompany account for each account type. For a list of account types
and accounts that you cannot use for elimination, see Other Account Types and Exceptions.
Best practice is to create new intercompany A/R and intercompany A/P accounts for intercompany
transactions. Existing A/R and A/P accounts have accumulated balances from non-intercompany
transactions that cannot be combined with future intercompany transactions to be eliminated.
To use existing item income and expense accounts for new intercompany transactions, check the
Eliminate Intercompany Transactions box. You must check this box for all income and expense
accounts associated with items used in intercompany transactions.
Note: For arm's length intercompany inventory transfers, the Eliminate Intercompany
Transactions task on the Period Close Checklist does not return intercompany clearing accounts
to zero. Reporting at the subsidiary level displays the intercompany clearing account with an
accumulated balance.
Note: If an existing A/R or A/P account has balances from non-intercompany transactions, you
cannot make it eligible for intercompany transactions.
Open balances for foreign currency transactions posted to these accounts are never revalued.
Inventory accounts, created by checking the Inventory box for an Other Current Asset account belong
to this group. However, you should use advanced intercompany journal entries to record intercompany
inventory transfers. For information on advanced intercompany journal entries, see the help topic Making
Advanced Intercompany Journal Entries.
When the Advanced Revenue Management and Automated Intercompany Management features are
enabled, the Eliminate Intercompany Transactions box is automatically checked on the system deferred
revenue and unbilled receivable accounts. You must check the Eliminate Intercompany Transactions box
on these accounts if you are using the Revenue Recognition and Revenue Commitment features. You can
clear the Eliminate Intercompany Transactions box if no intercompany transactions use these accounts.
■ Bank
■ Credit Card
■ Nonposting
■ Fixed Asset
In addition, the balances for the following system-generated accounts can never be eliminated. The
Eliminate Intercompany Transactions box is disabled for these accounts. NetSuite creates these
accounts for a specific feature or type of user account after. For more information about features and
system-generated accounts, see the help topic Feature-Specific, System-Generated Accounts.
■ Realized Gain/Loss
■ Unrealized Gain/Loss
■ Rounding Gain/Loss
■ Unrealized Matching Gain/Loss
■ Undeposited Funds
■ Intercompany Clearing XXX (for Intercompany Time and Expense feature)
■ Cumulative Translation Adjustment (for NetSuite OneWorld using the Multiple Currencies feature)
■ Cumulative Translation Adjustment - Elimination (for Automated Intercompany Management feature)
■ Exchange Rate Variance
Non-inventory items must be a Resale item type and also have the Can Be Fulfilled/Received setting
enabled for intercompany transactions.
Users with the Setup Accounting permission can set intercompany preferences at Setup > Accounting >
Preferences > Intercompany Preferences. These preferences should be defined after an administrator
enables the Automated Intercompany Management feature. For information about these preferences,
see Intercompany Preferences.
■ Expense Account
■ Income Account
■ Receivables Account
■ COGS Account
■ Deferred Revenue Account
An intercompany account is an account with the Eliminate Intercompany Transactions box checked.
For more information, see Intercompany Accounts.
If any of these intercompany account values are blank, NetSuite uses the Use Default Account option for
items.
Important: NetSuite uses these accounts for all intercompany transactions. You can make
new account selections at any time, but NetSuite does not change the accounts of historical
transactions.
You cannot create intercompany accounts for the following system-generated accounts:
For more information about features and system-generated accounts, see the help topic Feature-Specific,
System-Generated Accounts.
At a minimum, to properly account for and eliminate intercompany transactions, you need the following
accounts:
■ Expense Account
■ Income Account
■ Receivables Account
■ Payables Account
■ Deferred Revenue Account
1. Go to Setup > Accounting > Manage G/L > Chart of Accounts > New.
2. Select the type of account to create based on the account purpose.
The values for General Rate Type and Cash Flow Rate Type default based on the type of account
selected.
3. Enter a name for the account.
4. Check the Eliminate Intercompany Transaction box.
5. Complete other fields, as needed.
6. For Subsidiaries, select the parent or top level subsidiary and then check Include All Children.
7. Click Save.
Important: Prior to 2020.2, the Automated Intercompany Management feature required users
to customize the vendor and customer records to include the Represents Subsidiary field. This
field indicates that the entity acts as an agent for a selected subsidiary. After you customized the
entity forms, you then manually created intercompany vendors and intercompany customers to
represent your non-elimination subsidiaries. When you changed a subsidiary record, you were
required to manually update the representing entity records.
However, there are prerequisites for current users of the feature to take advantage of this
functionality. You must enable the Multi-Subsidiary Customer feature. In addition, if you use
the Multiple Currencies feature, you must also enable the Multi-Currency Vendor and Multi-
Currency Customer features. If you meet these prerequisites, NetSuite can generate and maintain
representing entities for all of your non-elimination subsidiaries. For more information, see
Intercompany Preferences and Representing Entities.
You enter intercompany entities on sales orders and purchases orders to create intercompany
transactions. You can also identify an intercompany customer or vendor on journal lines when you create
an advanced intercompany journal entry. You must enter an intercompany entity for lines that include an
intercompany receivable or intercompany payable account. For information on setting up intercompany
accounts, see Intercompany Accounts.
Example 1. Intercompany Customer and Corresponding Intercompany Vendor
Example
You can manually create an intercompany customer and corresponding intercompany vendor for each
subsidiary-to-subsidiary relationship that has intercompany transactions. For example, if Subsidiary U.K.
purchases a product from Subsidiary U.S., create the following entities to represent the subsidiaries:
■ Create a customer record in Subsidiary U.S. to represent Subsidiary U.K. (the buyer).
□ Subsidiary = U.S. Subsidiary
□ Represents Subsidiary = Subsidiary U.K.
■ Create a vendor record in Subsidiary U.K. to represent Subsidiary U.S. (the seller).
□ Subsidiary = Subsidiary U.K.
□ Represents Subsidiary = Subsidiary U.S.
An entity record can act as an agent for only one subsidiary. If Subsidiary U.K. also purchases from
Subsidiary EU, you must:
Before you can manually create intercompany customers and vendors, you must customize the customer
and vendor forms to include the Represents Subsidiary field. To customize forms, go to Customization
> Forms > Entry Forms ( Administrator ). Add the Represents Subsidiary field to the standard customer
and standard vendor forms. For information on customizing forms, see the help topics Creating Custom
Entry and Transaction Forms and Configuring Fields or Screens.
For information multiple subsidiaries assigned to a customer record, see Assigning Subsidiaries to a
Customer.
For information multiple subsidiaries assigned to a vendor record, see Assigning Subsidiaries to a Vendor.
■ Arm's length Inventory Transfers - Use the purchase order/sales order workflow for arm's length
transfers. Both the source and destination subsidiaries must have access to the inventory item.
■ Non-Arm's Length Inventory Transfers - (Transactions > Inventory > Enter Intercompany Transfer
Orders) On the Accounting subtab of the Item record, check the Eliminate Intercompany Transactions
box for the account selected as the Gain/Loss Account. When the item cost is not used as the transfer
cost, any difference between the cost and the transfer price posts to this account. NetSuite eliminates
the gain/loss amount when you run intercompany elimination at period close.
■ Intercompany Drop Ship - If you use the Automated Intercompany Drop Ship feature, the Dropship
Expense Account on item record defaults to a value. The value is the account specified in the Default
Expense Account field on the Accounting Preference page, Items/Transactions subtab. You can
override this account on an item record, if needed. The account used for the DropShip Expense
Account must have the Eliminate Intercompany Transactions box checked.
You can perform these tasks, except creating purchase orders, from the Manage Intercompany Sales
Order page. See Manage Intercompany Orders.
For information about creating intercompany purchase orders per subsidiary, see the help topic Entering
a Purchase Order.
■ Pending indicates that the intercompany order has not been paired with a corresponding order in
another subsidiary. Order pairs are Sales Order/Purchase Order and Vendor Return Authorization/
Return Authorization.
Note: Intercompany orders that are pending approval do not appear on this page.
■ Rejected indicates that the intercompany purchase order or vendor return authorization cannot
be paired with a sales order or return authorization. Usually this is because it contains incorrect
information such as subsidiary, currency, amount, or other detail.
■ Linked indicates that the intercompany order has been paired with an intercompany order in another
subsidiary. Order pairs are Sales Order/Purchase Order and Vendor Return Authorization/Return
Authorization. The Manage Intercompany Sales Order page does not display linked orders.
Intercompany Order Status appears only on intercompany sales orders, intercompany purchase orders,
intercompany return authorizations, and intercompany vendor return authorizations.
Select a customer and a currency on the Manage Sales Order page to filter the list of displayed purchase
orders. This is the list of intercompany purchase orders not paired with intercompany sales orders.
Setting the filter also determines the customer, subsidiary, and currency for the sales order to be created.
Access to subsidiary data is controlled by your user role. If you are not an administrator, you can use
the Manage Intercompany Sales Order page if you have been granted the required permission. To view
a Purchase Order in another subsidiary, your user role must have the Allow Cross-Subsidiary Record
Viewing enabled option enabled. Your user role also must have view access to Purchase Order. To
automatically generate and create a Sales Order, you must have create or full access to Sales Order. For
more information, see Control Employee Access to Subsidiaries.
From the Manage Intercompany Sales Orders page, you can:
If Classes, Departments, or Locations values are mandatory, you cannot auto generate sales orders or
return authorizations. Set these values at Setup > Accounting > Accounting Preferences > General >
Classifications.
Tip: You can delete the paired transactions after generating the intercompany sales order if
the order does not contain an inventory item. First, edit the sales order by clearing the Paired
Transaction box. Save the sales order. Then, delete the purchase order and sales order as you
would delete any transaction record. On the transaction record, from the Actions menu, click
Delete. Note that this option appears only if the Void Transactions Using Reversing Journals
preference is not enabled. For more information, see the help topic Voiding, Deleting, or Closing
Transactions.
You can review rejected intercompany transactions by choosing Rejected for the Intercompany Status
filter on the Manage Intercompany Sales Order page. After you review rejected purchase orders and
make changes as necessary, you can generate or manually create intercompany sales orders.
If you use stand-alone intercompany invoices and bills, you can create a link between the two documents
through the Paired Intercompany Transaction field. After you pair the documents, you can use
SuiteAnalytics for reports that display intercompany documents. If the intercompany documents were
incorrectly paired, you can correct the pairings.
You can run reports on paired documents throughout the accounting period or at period end close. If
you make corrections throughout the accounting period, you decrease the manual effort associated with
intercompany transaction reconciliation at period end close.
NetSuite lets you pair invoices with bills of a different amount and in a different accounting period. If you
use the Intercompany Framework feature, the netting functionality lets you net paired intercompany
invoices and bills of the same amount. For information about the intercompany netting functionality, see
Intercompany Netting.
Important: The Paired Intercompany Transaction field is not intended to be used in the
purchase order to sales order workflow. To reconcile intercompany invoices and bills generated
through intercompany purchase orders and sales orders, see Intercompany Reconciliation
Report.
Important: You must have permission to access an invoice or a bill to customize the
forms.
Tip: You can place the field anywhere on the form, but you may find it useful to place it in
the InterCompany Management section. You can also mark the field as mandatory.
5. Click Save.
A link to the customized invoice form appears on the Custom Transaction Forms page.
6. Go to Transactions > Payables > Enter Bills.
7. Follow steps 2 through 5.
A link to the customized bill form appears on the Custom Transaction Forms page.
8. Return to the customized invoice or bill form.
Note: NetSuite lets you pair invoices with bills or bills with invoices. When you save the
pairing, NetSuite updates the respective paired record.
For information about creating invoices, see the help topic Creating an Invoice.
For information about entering vendor bills, see the help topic Vendor Bills.
9. Complete the fields as required, and then select the relevant transaction to pair from the Paired
Intercompany Transaction list.
The list displays document numbers for relevant transactions. NetSuite lists the numbers in
ascending order by character, number, and then letter. Transactions that are pending approval or
voided do not appear in this list.
Tip: If you set your general preferences to reduce the number of items in a list, NetSuite
changes the standard list to an advanced search list. Limiting the items in the list is useful
if the list contains hundreds of items. Advanced search lists enable you to type in the field
to filter the lists to display matching items. You can click the double list icon and type in the
Search field to filter the list. For more information about general preferences, see the help
topic General Personal Preferences.
In the Search field, type the % sign before and after your search string to display only those
items that include your string. For example, the bill transaction you want to pair includes a
# sign followed by a 1. Type %#1% to retrieve only those bills where the document number
includes #1.
Important: NetSuite lists only those transactions with the proper combination of
subsidiary, entity, currency, and document status. The list is empty if you have not set one
of those criteria, or if the criteria is not available.
You must first select the subsidiary, followed by the entity, and then the currency. NetSuite
displays relevant transactions based on your selections, in that order. If you make your
selections in an incorrect order, NetSuite may display transactions for an incorrect
combination.
Important: You cannot delete a paired transaction. If you must delete a previously
paired transaction, set the Paired Intercompany Transaction list to blank, and then save.
Then, in edit mode on the transaction, select Actions, and then Delete.
You cannot set an approved transaction to pending approval.
■ Automate the end-to-end intercompany inventory workflow. Use intercompany inventory purchase
and sales orders, intercompany item fulfillments and receipts, and inventory sales invoices and vendor
bills.
■ Use intercompany auto-elimination to automatically revalue the period-end inventory and Cost of
Goods Sold (COGS) balances.
Important: For arm's length intercompany inventory transfer, do not mark the COGS
account as Elimination.
Automated Intercompany Management supports month end elimination for arm's length and non-arm's
length intercompany inventory transfers.
■ Create intercompany purchase orders and sales orders to manage intercompany arm's length
inventory transfers, returns, and intercompany inventory drop shipments. See:
□ Intercompany Inventory Transfers - Arm's Length
Note: For arm's length intercompany inventory transfers, intercompany clearing accounts are
not returned to zero when you eliminate intercompany transactions at period end close. Reporting
at the subsidiary level displays the intercompany clearing account with an accumulated balance.
and vendors to represent the subsidiaries involved in the transaction. See Creating Intercompany
Customers and Vendors.
The purchasing subsidiary is the destination for the transfer. The selling subsidiary is the source for the
transfer. All intercompany transactions related to the inventory transfer must be in the base currency of
the purchasing subsidiary (destination). Inventory items must be accessible by both subsidiaries involved
with the transfer.
Important: For arm's length intercompany inventory transfer, do not mark the COGS account
as Elimination.
For information about the general ledger impact for the posting transactions involved in arm's length
intercompany inventory transfers, see Arm's Length Intercompany Inventory Transfer Example.
vendor return authorization for the original purchase order. The original source subsidiary (the subsidiary
that sold the item) cannot create a credit memo to initiate the return of an intercompany inventory
transfer. Instead, the source subsidiary automatically generates a return authorization for the vendor
return authorization. Then, each subsidiary completes their part of the return process. NetSuite does
not process changes made to any line item.
The transaction currency for the return is the base currency of the vendor return authorization. The
currency for the return authorization matches the currency for the vendor return authorization. It is
the same currency used for the paired intercompany sales order and purchase order for the original
inventory transfer.
You cannot manually create a vendor return for an intercompany inventory transfer order.
The workflow for arm's length inventory returns involves the following steps. In this diagram, the
Destination Subsidiary is the subsidiary that originally ordered the item. The Source Subsidiary is the
subsidiary that originally shipped the item.
1. Destination subsidiary, the subsidiary that initially purchased the item, creates an intercompany
vendor return authorization to return an item.
2. Source subsidiary generates an intercompany return authorization through the Manage
Intercompany Return Authorizations page. Go to Transactions > Customers > Manage
Intercompany Return Authorizations.
3. Destination subsidiary fulfills the vendor return and creates an item fulfillment.
4. Source subsidiary receives the order and creates an item receipt. The quantity received cannot be
greater than the quantity shipped.
5. After the return is fulfilled and received, the subsidiaries can generate the credit memo and
vendor credit.
6. At period end, run the intercompany elimination process to automatically revalue inventory and
inventory costing balances.
For information about the general ledger impact for the posting transactions involved in an intercompany
inventory return, see Arm's Length Intercompany Inventory Return Example.
Note: NetSuite does not support returns for intercompany drop-ship orders. You must complete
the following:
* Create a standalone return authorization between the external customer and the purchasing
subsidiary.
* Create an intercompany transfer order between the purchasing subsidiary and the selling
subsidiary. See Intercompany Inventory Transfers - Arm's Length.
Important: If you use the Intercompany Cross-Subsidiary Fulfillment feature, the system
uses the Intercompany Cost of Goods Sold account when you fulfill an external item. You must
manually set the account to the regular COGS account. For information about the Intercompany
Cross-Subsidiary Fulfillment feature, see the help topic Intercompany Cross-Subsidiary Fulfillment.
To manage intercompany drop ship orders, you must enable Automated Intercompany Drop Ship. Go
to Setup > Company > Enable Features. Click the Accounting subtab. The following features are also
required to use the Intercompany Drop Ship feature:
When you enable the Automated Intercompany Drop Ship feature, NetSuite automatically sets the
following accounting preferences. Go to Setup > Accounting > Preferences > Accounting Preferences.
These preferences are on the Order Management subtab, under Drop Shipments. The intercompany
drop ship workflow must have these preferences to properly function. You cannot change these
preferences.
■ Update Drop Ship Order Quantities Automatically Prior to Shipment - The quantities, prices, and
amounts on linked transactions for intercompany drop ship orders must match.
■ Drop Ship Fulfillment Quantity Validation - set to Do not allow unequal quantities. This
preference enforces matching quantities for intercompany drop ship transactions.
■ Allow Both Mark Shipped Fulfillments and Receipts on a Drop Shipment Line - set to Do not
allow. For intercompany drop ship orders, you must mark the order the sales subsidiary as shipped
(dummy fulfillment).
The workflow for intercompany drop ship orders follows these steps:
1. Sales subsidiary creates a sales order for an external customer, and specifies an intercompany
vendor that represents the warehouse subsidiary.
2. Sales subsidiary creates an intercompany purchase order for the sale with an intercompany
vendor that represents the warehouse subsidiary.
3. Warehouse subsidiary generates an intercompany sales order through the Manage Intercompany
Sales Orders page. Go to Transactions > Sales > Manage Intercompany Sales Orders.
4. Warehouse subsidiary fulfills the order and sends the item to the external customer.
5. Warehouse subsidiary creates an intercompany sales invoice, and bills the Sales subsidiary. This
intercompany sales invoice debits Intercompany A/R and credits Intercompany Revenue.
6. Sales subsidiary marks the external sales order as shipped, and creates a dummy item fulfillment,
completing the order.
7. Sales subsidiary bills the intercompany purchase order. This intercompany vendor bill debits
Intercompany Dropship Expense and credits Intercompany A/P.
8. Sales subsidiary invoices the external customer for the item shipped.
For information about the general ledger impact for the posting transactions involved in intercompany
drop ship orders, see Intercompany Drop Ship Example.
Note: NetSuite does not support returns for intercompany drop-ship orders. You must complete
the following:
* Create a standalone return authorization between the external customer and the purchasing
subsidiary.
* Create an intercompany transfer order between the purchasing subsidiary and the selling
subsidiary. See Intercompany Inventory Transfers - Arm's Length.
■ The EU subsidiary is the destination subsidiary and submits a purchase order for inventory item with
transfer price of EUR 200. The base currency of the EU subsidiary is EUR.
■ The U.K. subsidiary is the source subsidiary and creates a corresponding sales order throught the
Manage Intercompany Sales Orders page. The inventory item is accessible by both subsidiaries. In the
U.K. subsidiary, the Cost of Goods Sold (COGS) amount for the item is GBP 100.
■ The U.K. subsidiary (source) fulfills the order and ships the item.
■ The EU subsidiary (destination) receives the item into inventory. On the Item Receipt, the receiving
standard cost is EUR 160.
■ The EU subsidiary records a vendor bill.
■ The U.K. subsidiary creates a sales invoice.
The following table presents the general ledger impact for each of the posting transactions involved in
the inventory transfer.
Note: In this example, the general ledger impact for COGS and Inventory lines post in the
currency of the source subsidiary (GRP). All of the transactions for the transfer are in the currency
of the destination subsidiary (EUR).
However, the currency that impacts the GL is the currency used in the transaction. This
currency is from source subsidiary.
Item Fulfillment
Item Receipt
Sales Invoice
Vendor Bill
For more information about arm's length inventory transfers, see Intercompany Inventory Transfers -
Arm's Length.
■ The EU subsidiary creates a vendor return authorization to initiate the return. The vendor return
authorization must be created from the original purchase order and be linked to it. It must be in the
same currency as the original intercompany purchase order and sales order pair.
■ The U.K. subsidiary creates the return authorization through the Manage Intercompany Return
Authorizations page.
■ The EU subsidiary returns the item and records an item fulfillment.
■ The U.K. subsidiary receives the item and records an item receipt. The U.K. subsidiary restock the item
or discard it as an expense.
■ The EU subsidiary records a vendor credit.
■ The U.K. subsidiary issues a credit memo.
The following table presents the general ledger impact for each of the posting transactions involved in
the inventory return.
Note: The general ledger impact for Cost of Goods Sold (COGS) and inventory lines post in the
currency of the source subsidiary (GRP). All of the transactions for the transfer are in the currency
of the destination subsidiary (EUR).
Item Fulfillment
Item Receipt
Vendor Credit
Credit Memo
For more information about intercompany inventory returns, see Intercompany Inventory Returns - Arm's
Length.
■ The EU subsidiary is the sales subsidiary selling an item to Customer that is to be shipped from a
warehouse in the U.K. subsidiary. The base currency of the EU subsidiary is EUR. The EU subsidiary
creates a sales order in the amount of EUR 200 and identifies the U.K. subsidiary as the vendor for the
transaction.
■ The EU subsidiary submits a purchase order for inventory item with transfer price of EUR 200.
■ The U.K. subsidiary is the warehouse subsidiary and creates a corresponding intercompany sales
order through the Manage Intercompany Sales Orders page. The inventory item is accessible by both
subsidiaries. In the U.K. subsidiary the Cost of Goods Sold (COGS) amount for the item is GBP 100.
■ The U.K. subsidiary fulfills the order and ships the order directly to Customer.
■ The U.K. subsidiary creates a sales invoice to bill the EU subsidiary.
■ The EU subsidiary marks the dummy fulfillment for the intercompany purchase order as Marked
Shipped.
■ The EU subsidiary creates a vendor bill from the intercompany purchase order to bill the U.K.
subsidiary.
The following table presents the general ledger impact for each of the transactions involved in the
intercompany drop shipment.
Note: The general ledger impact for COGS and Inventory lines post in the currency of the sales
subsidiary (GRP). All of the transactions for the transfer are in the currency of the destination
subsidiary (EUR).
Non-posting
Sales Invoice
Vendor Bill
■ Intercompany Reconciliation Report - Use this report to identify and reconcile any mismatched
intercompany transactions. This report displays unlinked orders, mismatched orders, mismatched
fulfillments and receipts, mismatched billing, and standalone transactions. Run this report before
completing month-end elimination at period end close. For information on using this report, see
Intercompany Reconciliation Report.
■ Inventory Activity Detail Report - This report displays the activity associated with your inventory
items and the quantity per transaction of inventory items. Use this report to facilitate manual
adjustment of the inventory balance at the end of a period. For intercompany inventory transfers,
ownership of the item is considered transferred when the order is fulfilled. If the transferred item is
not fully consumed (being sold to an external customer or used in an assembly), you must manually
adjust inventory balances. Run this report as part of the period close process to review inventory
balances and identify items that must be adjusted. See the help topic Inventory Revenue Detail Report.
■ Intercompany sales and billing transaction lines are identified by default, based on the intercompany
account with which the line is associated. An intercompany sales order is a nonposting transaction, a
transaction that has no general ledger impact. However, when the sales order is invoiced, the system
identifies the transaction lines that require elimination for posting to intercompany accounts. The
same is true for intercompany purchase orders. An intercompany purchase order is a nonposting
transaction. However, when the purchase order is billed, the system identifies transaction lines that
require elimination for posting to intercompany accounts.
■ Intercompany inventory transfers and intercompany drop shipments are identified by default. They
are based on the intercompany account associated with the line on related purchase orders and sales
orders.
■ Journal lines that require elimination at period end are identified either by default. They are based on
the intercompany account entered for the line, or by manually checking the line for elimination.
At the end of the accounting period, complete the tasks in your Period Close Checklist. The last task on
the checklist is Eliminate Intercompany Transactions. You can complete this task only after completing
the Revalue Open Foreign Currency Balances and Calculate Consolidated Balances tasks. You must
complete these two tasks first to ensure that foreign currency adjustment amounts have been calculated
for transactions in the period. See the help topic Using the Period Close Checklist.
When you run intercompany elimination, NetSuite creates elimination journal entries for all intercompany
transaction journal lines that have the Elimination box checked. Adjustments that result from the
difference in the foreign currency exchange rates post to the Cumulative Translation Adjustment-
Elimination (CTA-E) account. These differences occur from the originating intercompany journal entry and
the elimination journal entry. NetSuite also creates a reversing journal entry for all intercompany journal
lines that post to Intercompany Receivables and Intercompany Payables. See Cumulative Translation
Adjustment-Elimination (CTA-E).
If you use Multi-Book Accounting, you can run intercompany elimination on any accounting book.
Note: If you use the Use Journal Entry Summarization on Intercompany Elimination
accounting preference, similar elimination journal entries are grouped into a single,
summarized journal entry. See Summarized Intercompany Elimination Journal Entries.
■ You must have the administrator role or a financial user role with period closing privilege at the
parent-level to run intercompany elimination.
■ When you run intercompany elimination, the system runs the process for all subsidiaries in your
organization. You cannot eliminate intercompany transactions by subsidiary.
■ In hierarchies with multiple levels and elimination subsidiaries, NetSuite posts elimination journal
entries to the elimination subsidiary for the least common parent node of both subsidiaries.
□ If one subsidiary is a parent subsidiary of another, NetSuite uses the elimination subsidiary under
the parent subsidiary.
□ If two subsidiaries do not have a parent-child relationship, NetSuite uses the elimination subsidiary
for the first level parent they have in common.
■ NetSuite eliminates reversal advanced intercompany journal entries (AICJE) in the same period in
which they post. If you post an AICJE and its reversal AICJE in the same period, the net amount from
the pair of elimination journal entries is 0.
During intercompany eliminations, gains and losses from currency exchange rate fluctuation between the
originating advanced intercompany journal and elimination journal entries automatically post to CTA-E.
You cannot delete the CTA-E account. The account has the following attributes:
■ Type - Equity
■ General Rate Type - Historical
■ Cash Flow Rate Type - Historical
■ Subsidiaries - Parent, including children
If the accounting preference is enabled, elimination journal entries are grouped into a single journal entry
if they meet the following conditions:
Note: The CTA-E line consists of a single detail line with a link to the History associated with the
account.
The state of the accounting preference determines the information accessible on the Lines subtab of the
journal entry record. When you use the accounting preference, the Source Transactions column provides
the number of rows that contributed to the single journal entry line. Click the Rows link to open a details
page that displays all of the journal entries that were grouped into the single journal entry. On the details
page, click a journal entry link in the Created From column to open the related source transaction. The
details page also provides the Consolidated Exchange Rate column. If you do not use the accounting
preference, this information is not available because the journal entries are not grouped.
The hierarchy is based on geography and represents the following organizational relationships:
In this example, the U.K. subsidiary transfers funds to the EU subsidiary using the following parameters:
When the funds transfer occurred, the currency exchange rate was 1.5 EUR to 1.0 GBP. The base currency
of the U.S. Elimination subsidiary is USD. At the end of the month, the currency rate is 2 USD to 1 GBP.
Because the foreign currency exchange rate fluctuated during the period, the resulting gain or loss posts
to the cumulative translation adjustment - elimination (CTA-E) account. When you run the intercompany
elimination process at period close, NetSuite eliminates the revenue and expense directly to the CTA-E
account. The consolidated exchange rates used by the income statement accounts are different from the
consolidated exchange rates used by the balance sheet accounts:
Note: Not all balance sheet accounts use current rates. Most asset and liability accounts use
current rates.
Equity accounts use historical rates.
1. The elimination journal entries post to the U.S. Elimination subsidiary to eliminate revenue and
expense from the consolidated financials.
2. The original and elimination journal entries roll up to the Global HQ-US subsidiary. Any
unbalanced currency adjustment gain and loss amounts accumulate in the CTA-E account.
U.S. Elimination Intercompany Revenue Dr 150 EUR Dr 300 USD (Eliminate revenue at
HQ)
U.S. Elimination Intercompany Expense Cr 100 GBP Cr 250 USD (Eliminate expense at
HQ)
After running intercompany elimination, the CTA-E account has a translation adjustment balance of 50
USD.
Warning: Setting different exchange rate types for different accounts can result in balance
sheet discrepancies, particularly discrepancies in consolidated reports.
1. Enter intercompany transactions as intercompany sales invoices and vendor bills. These
transactions automatically post to intercompany accounts, and have transaction lines marked as
candidates for intercompany elimination.
You can also enter advanced intercompany journal entries (AICJE) for transactions during a period,
and identify the journal lines that require elimination.
2. Run intercompany elimination to during period close to automatically generate elimination journal
entries. NetSuite creates elimination journal entries for all flagged transaction and journal entry
lines. NetSuite also creates auto-reversing journal entries in the next period for all flagged journal
lines posted to the Intercompany Receivables and Intercompany Payables accounts.
Note: NetSuite does not generate elimination journal entries for any AICJEs posted to future
periods (periods after the period being closed).
See the following help topics for information about eliminating intercompany transactions using
Automated Intercompany Management:
Create intercompany vendor bills and sales invoices from paired intercompany purchase orders and
sales orders. Intercompany vendor bills and sales invoices are transactions for intercompany entities.
Intercompany entities use intercompany A/R and intercompany A/P accounts as their default A/R and A/P
accounts. The income, expense, A/R, and A/P lines on the intercompany vendor bills and sales invoices are
automatically marked for elimination. There is no Elimination flag on the these transactions lines.
The following account types should be used only for elimination purposes:
Warning: Regular journal entries used for intercompany transaction activity do not
automatically balance lines to be eliminated. If you do not balance the lines, NetSuite posts the
journal lines without validating the accounts used and the elimination flags.
Advanced intercompany journal entries require balanced debits and credits across subsidiaries for journal
line pairs that use balance sheet accounts (A/R, A/P). These journal entries also require balanced debits
and credits for lines using income statement accounts (Income, Expense, Cost of Goods Sold (COGS)).
NetSuite validates the journal lines when you save an AICJE and displays an error if the debit and credits
do not balance for the line pairs.
You cannot check the Eliminate Intercompany Transactions box on AICJE lines posting to non
intercompany accounts or to equity type accounts.
You can specify a class, department, and location on the Intercompany Eliminations page when you run
intercompany eliminations. The class, department, and location you select populates the corresponding
fields on the elimination journal entries.
Important: If you use the Make Locations Mandatory accounting preference, Location is a
mandatory field on the Intercompany Eliminations page. The Location list defaults to the Default
Elimination Subsidiary Location option, but you can select any location that has been associated
with elimination subsidiaries.
If you use the Multi-Location Inventory feature, Location is a mandatory field on the
Intercompany Eliminations page.
The location you select on this page overrides the location entered on the source transaction, and
becomes the location specified on the elimination journal entry.
If you do not use the Make Locations Mandatory accounting preference or the Multi-Location
Inventory feature, the Location list defaults to the blank option. You can, however, select the
Default Elimination Subsidiary Location option, or any location that has been associated with
elimination subsidiaries.
Currency Balances and Calculate Consolidated Exchange Rates determine the gains and losses to post to
the Cumulative Translation Adjustment - Elimination (CTA-E) account.
When you run elimination, NetSuite posts elimination journal entries. You can run intercompany
elimination for a period multiple times, as needed. NetSuite does not support running multiple the
intercompany elimination process at the same time.
1. From the Period Close Checklist, click the Eliminate Intercompany Transactions icon.
2. Verify the Period is correct.
3. Click Run Intercompany Elimination.
Select a class, department, and location, if used. Optionally, add a memo.
If you use the Automated Intercompany Management and Multi-Location Inventory features and
the Make Location Mandatory accounting preference, assign a default elimination location to each
elimination subsidiary. Then, on the Task: Eliminate Intercompany Transactions page, select the
elimination subsidiary from the Location list. The default value is the Default Elimination Subsidiary
Location. NetSuite assigns the elimination subsidiary to each intercompany elimination journal
entry generated through completing this task.
If you use the Multi-Book Accounting feature, the read-only Accounting Book field displays the
accounting book for which you are running intercompany transaction elimination.
4. Click Save to run intercompany elimination and post the elimination journal entries for the period.
Note: If there is an amount not eliminated due to a currency delta, make a manual journal
entry to eliminate the amount.
When the process completes, the Task: Eliminate Intercompany Transactions page appears. To return to
the task page during the time in which the process is running, click Back to Period Close.
The Task: Eliminate Intercompany Transactions page has the following subtabs:
■ Notes - displays system and user notes for all eliminations run for the period
■ Results - displays a line for each intercompany elimination process run (number of runs)
Information displayed includes the elimination subsidiary, currency, amount, and a link to elimination
journal. You can drill down to view the elimination journal entry created. See View Intercompany
Elimination Results.
■ Status - displays the date submitted, submitted by, submission status, any message, and percent
complete of each intercompany elimination request
When the submission status is in the initializing state, the Message column shows the number of lines
processing. This number increases as the initialization detects more lines that require processing.
In the Submission Status column, click the Complete link to open the Processed Records page. This
page provides the results of that elimination request. For information about this page, see Processed
Intercompany Elimination Records.
Important: If you use the Use Journal Entry Summarization for Intercompany
Elimination accounting preference, the Records column does not display values for
summarized Other Current Asset and Other Current Liabilities accounts.
Note: The percent complete is an estimate of overall elimination progress. It does not
represent progress in terms of time.
Note: Balance Sheet accounts that are not AR and AP are summarized. Therefore, there is no
link to the source transaction.
The Processed Records page also lists the elimination journal entry for each line. If you re-run
intercompany elimination for the period, the process deletes all of the existing elimination journal entries
and creates new journal entries.
If you use the Multi-Book Accounting feature, you can run the Intercompany Reconciliation report for any
accounting book enabled for consolidation.
Before you run elimination for the period, run this report as part of your period end process to identify
any problems associated with intercompany transactions. You can then correct the discrepancies to
synchronize sales and billing information across subsidiaries before you run intercompany elimination.
You can also drill down from the report to edit the source sales and billing transactions, as needed.
Best practices is to run the report periodically to catch problems with transactions before the month end
process.
The Intercompany Reconciliation report has five sections and lists the mismatched intercompany
transactions for:
1. Unlinked Orders and Returns - intercompany transactions not paired with a corresponding
intercompany transaction in another subsidiary
This section includes purchase orders, sales orders, return authorizations and vendor return
authorizations.
2. Mismatched Amount - paired intercompany transactions with amounts that do not match
This section includes purchase orders, sales orders, return authorizations, and vendor return
authorizations.
3. Mismatched Inventory Item Quantities - paired intercompany transactions with item quantities
that do not match
This section includes only item quantities that do not match. Item rates on paired intercompany
inventory orders are always the same.
The Inventory Item Quantity columns identify the differences in quantities per item for the
following:
■ Item Fulfillment and Sales Invoice - the quantity fulfilled for an item on a sales order is
different from the quantity billed for the item on the sales invoice
NetSuite creates the sales invoice from the sales order.
■ Item Receipt and Vendor Bill - the quantity received for an item on a purchase order is
different from the item quantity on the vendor bill
NetSuite creates the vendor bill from the purchase order.
■ Item Receipt and Item Fulfillment - the quantity fulfilled for an item on a sales order is
different from the quantity received for the paired purchase order
Note: The Inventory Item: Display Name column displays the Item's Display Name
for any item that appears in the Mismatched Inventory Item Quantities section. If the
Item's Display Name is blank, the column does not display anything.
4. Mismatched Billing - paired intercompany transactions with billed amounts that do not match
The amount billed (vendor bill) for the purchase order does not match the amount billed (invoice)
for a sales order.
5. Standalone Transactions - billing and payment transactions that are not associated with a sales
order or purchase order
This section includes vendor bills, invoices, credit memos, vendor credits, customer payments, and
vendor payments.
Note: The Period filter is not available for this report because it can include nonposting
transactions. To run this report, set your Report by Period preference to Financials Only or
Never. See, Analytics Personal Preferences.
A message appears indicating that your report is loading. The status bar in the footer of the report
indicates the progress as your report loads. You can click Cancel Report next to the status bar to stop the
report from loading.
■ Purchasing Subsidiary
■ Vendor
■ Purchasing Trans - transaction number with drill down to source record
■ Purchasing Trans Type - purchase order, return authorization, vendor bill, vendor credit
If you use the Multi-Book Accounting feature, you can run the Intercompany Elimination report for any
accounting book enabled for consolidation.
■ Date Range - view results for transactions in a date range or period range
■ Subsidiary Context - view results for all subsidiaries or one subsidiary
To filter the report by subsidiary, select an elimination subsidiary with posted elimination journal
entries.
A message appears indicating that your report is loading. The status bar in the footer of the report
indicates the progress as your report loads. You can click Cancel Report next to the status bar to stop the
report from loading.
The Intercompany Elimination report displays source transactions and elimination lines. It groups the
data by elimination subsidiary, then by sales order and purchase order pair. Source transactions include
sales invoice, vendor bill, credit memo, vendor credit, journal entry, advanced intercompany journal entry.
Transactions from the same paired transaction are grouped. For example, all invoices and vendor bills
that originate from the same sales order, purchase order pair are grouped together.
Tip: The Subsidiary list is a multi-select list that displays all of the values in the Subsidiary
and Due to/From columns.
Depending on the feature, you must enable the feature at the subsidiary level before you define
additional settings for specific subsidiaries. For example, the Period End Journal Entries feature must be
enabled at the subsidiary level after you enable it at the company level.
Another example is the Intercompany Framework feature. When you enable this feature on the Enable
Features page, it is automatically enabled for all subsidiaries. From the Subsidiary Settings Manager page,
you define default cross charge classification preferences for this feature.
On the Subsidiary Settings Manager page, you can also view the state of subsidiary-specific features
relative to the list of subsidiaries.
To access the Subsidiary Settings Manager page, go to Setup > Company > Setup Tasks > Subsidiary
Settings Manager.
Tip: If you have permission to enable features, you can also access the Subsidiary Settings
Manager page from the Enable Features page. Go to Setup > Company > Enable Features. At the
top of the page is a message about subsidiary–specific features. This message includes a link to
the Subsidiary Settings Manager page.
■ Filters
■ Column Sorting
■ Settings Icons
■ Subsidiary Settings Manager Permissions
Filters
The Subsidiary Settings Manager page lists the active and inactive subsidiaries to which you have
access, and their respective country and currency. You can filter the subsidiaries that display in the list
by searching for a subsidiary name in the Subsidiary field. The Subsidiary field supports a partial name
search. You can also filter the subsidiaries list by selecting a country, currency, and whether the subsidiary
is inactive.
Column Sorting
You can sort the subsidiaries list by clicking the Subsidiary, Country, Currency, Inactive, and feature
column headers. One click sorts a column in ascending order . A second click sorts the column in
descending order . A third click resets the column to the default sort order. The Inactive column
appears when the Inactive filter does not contain a value.
Settings Icons
The Settings column displays a settings icon for each subsidiary. When you click a settings icon, the
Subsidiary Settings page for that subsidiary opens. Each subsidiary-specific feature appears on its own
subtab, where you can enable the feature and define its additional settings. For example, the Period End
Journal Entries subtab enables you to define the additional settings for that feature.
NetSuite lists subsidiary-specific features in individual columns. The feature columns display a settings
icon in the column header. When you click a feature’s settings icon, the Subsidiary Settings page for
that feature opens. You can enable that feature for one or more subsidiaries, and then define unique
settings for each selected subsidiary. Each subsidiary-specific feature opens its own page. For example,
the Subsidiary Settings for Period End Journal Entries page.
Note: Feature columns do not appear on the Subsidiary Settings Manager page until you enable
a subsidiary-specific feature at the company level. If you have permission to enable features, go
to Setup > Company > Enable Features. Enable a subsidiary-specific feature, and then save. For
information about enabling features, see the help topic Enabling Features.
After you enable a subsidiary-specific feature at the company level, you might have to enable the
feature at the subsidiary level. If you enable a subsidiary-specific feature for at least one subsidiary,
you cannot disable that feature on the Enable Features page.
Some subsidiary-specific features cannot be disabled after they have been enabled. For example,
you cannot disable the Intercompany Framework feature. However, when the Intercompany
Framework feature is enabled, it is enabled for all subsidiaries.
You cannot define a subsidiary-specific feature’s additional settings for elimination subsidiaries.
■ The Subsidiary Settings Manager Edit level permission is assigned to the standard CFO role.
■ The Subsidiary Settings Manager View level permission is assigned to the standard Accountant role.
Note: The Subsidiary Settings Manager permission is independent from the Subsidiary
permission located on the Permissions > Lists subtab. These two permissions support the
separate responsibilities for maintaining subsidiary information and configuring features on the
subsidiary level.
NetSuite displays the Change Role page if you attempt to use the Subsidiary Settings Manager page
without adequate permission.
NetSuite displays a permission violation if you attempt to access a subsidiary record to which you are not
granted access.
Each subsidiary-specific feature appears on its own subtab. On each subtab you define that feature’s
additional settings. For example, the Period End Journal Entries subtab enables you to define the
additional settings for that feature.
Important: The Subsidiary Settings page has a one-to-one relationship with its subsidiary
record. When you create a subsidiary, NetSuite creates a Subsidiary Settings page for that
subsidiary. When you delete a subsidiary, NetSuite deletes its corresponding Subsidiary Settings
page.
The Subsidiary Settings page displays the subsidiary name, country, currency, and whether the subsidiary
is active. The subsidiary name is a link to the subsidiary record. The subsidiary record provides a link back
to the Subsidiary Settings page. At any time you can return to the Subsidiary Settings Manager page by
clicking the List link in the top right corner of the page.
The System Notes subtab tracks any change made to the Subsidiary Settings page. It also tracks changes
made to this subsidiary from the Subsidiary Settings for feature pages. For example, NetSuite tracks
changes made to a subsidiary on the Subsidiary Settings for Period End Journal Entries page.
To ensure you have permission to access the Subsidiary Settings Manager page, see Subsidiary Settings
Manager Permissions.
You can configure additional settings for a single subsidiary for the following features:
Important: If you enable the Period End Journal Entries feature for at least one subsidiary, you
cannot disable that feature on the Enable Features page.
To enable Period End Journal Entries for one subsidiary and define additional
settings:
1. Go to Setup > Company > Setup Tasks > Subsidiary Settings Manager.
2. In the Settings column for a specific subsidiary, click the settings icon .
If you have permission to edit this Subsidiary Settings page, you can define the feature’s additional
settings.
3. Click Edit.
Note: If you use Workflows, the Workflow subtab is the default subtab.
Important: If you use Multi-Book Accounting, you can enable Period End Journal Entries
for each accounting book and subsidiary combination to which you have access. When you
enable the Period End Journal Entries feature for a subsidiary, you can edit the accounting
books assigned to that subsidiary. However, you may not be able to disable Period End
Journal Entries for the subsidiary. If you cannot, it is because another user selected an
accounting book that you cannot access. Accounting books that you cannot access do not
appear for selection or exclusion.
When you save changes to one of your subsidiary’s settings, NetSuite applies the changes
across all accounting books, including those you cannot access.
Note: You can enable the use of primary and secondary accounting books with this
feature through the Subsidiary Settings page for a specific subsidiary. You can also enable
secondary accounting books on the accounting book’s record, and on the subsidiary record
on the Accounting Books subtab. NetSuite updates the Subsidiary Settings Manager
pages, subsidiary record, and accounting book record with any change. NetSuite tracks
any changes in system notes on the Subsidiary Settings for subsidiary page, and both
records. The Subsidiaries list page and the subsidiary record in edit mode provide a link to
the Subsidiary Settings Manager page.
6. Check the Create Balance Sheet Closing and Opening Journals box.
When you check this box, NetSuite adds a step to the Create Period End Journals task on the
Period Close Checklist. The Balance Sheet Closing step follows the Income Closing step at the
fiscal year end of the subsidiary. This step creates a balance sheet closing journal. This journal
reduces the balance of balance sheets accounts to zero and posts any necessary balance amount
to the account you specify. This balance sheet closing journal is the last period end journal in the
fiscal year. Unless you have selected segments in the Group by These Segments list, the amount
posted to the balance sheet closing account should be zero. To reopen the balance sheet, NetSuite
reverses the balance sheet closing journal on the first day of the next fiscal year. For information
about the Period Close Checklist, see the help topic Using the Period Close Checklist.
When you check this box, you must select values for Balance Sheet Closing Account and Balance
Sheet Opening Account.
Note: The accounts that you can select must be of Equity account type.
a. In the Balance Sheet Closing Account list, select the appropriate account.
b. In the Balance Sheet Opening Account list, select the appropriate account.
7. Check the Create Income Summary Journals box.
When you check this box, NetSuite creates two period end journals in the Income Statement
Closing step. This step is part of the Create Period End Journals task on the Period Close Checklist.
(NetSuite creates more journals when you create period end journals by segment.) The first journal
(or journals) reduces the income and expense accounts to zero. It posts the net income to the
account defined for income summary profit or loss. If the net income is a gain, the offset posts
to the income summary profit account. If the net income is a loss, the offset posts to the income
summary loss account. The second journal (or journals) moves the balance from the income
summary account used in the first journal, to the retained earnings account.
When you check this box, you must select values for Income Summary Profit Account and
Income Summary Loss Account.
Note: The accounts that you can select must be of Equity account type.
a. In the Income Summary Profit Account list, select the appropriate account.
b. In the Income Summary Loss Account list, select the appropriate account.
8. Check the Require Memo On Period End Journals box.
When you check this box, period end journals cannot be created or saved without a value in the
Memo fields in the header and lines. The value entered in the Memo field during the journal
creation process automatically populates the Memo fields in the header and lines of the period
end journal.
9. In the Group By These Segments list, select the appropriate segment.
This multi-select list displays all the segment types that impact the general ledger. Possible
segment types are class, department, location, and all custom segments with general ledger
impact. Select the segment types for which you want to generate separate period end journals, if
any. NetSuite generates separate period end journals for each selected segment type combination
included in the source transactions for this subsidiary. For more information about custom
segments, see the help topic Custom Fields and Segments on Period End Journals.
10. When the GL Audit Numbering feature is enabled, the Exclude Balance Sheet Closing Journals
from GL Numbering box appears. Check this box to skip numbering for the balance sheet closing
journals.
11. Click Save.
Note: On the subsidiary record, the Preferences subtab includes the read-only Period
End Journal Entries subtab. NetSuite automatically updates this subtab with the values you
define on the Subsidiary Settings page.
The values you define on the Subsidiary Settings for a subsidiary page are available to
SuiteAnalytics Workbook. Search for the Subsidiary Settings record type. For information
about SuiteAnalytics Workbook, see the help topic SuiteAnalytics Workbook Overview.
Note: If you use Workflows, the Workflow subtab is the default subtab.
Note: Feature columns do not appear on the Subsidiary Settings Manager page until you enable
a subsidiary-specific feature at the company level. If you have permission to enable features, go
to Setup > Company > Enable Features. Enable a subsidiary-specific feature, and then save. For
information about enabling features, see the help topic Enabling Features.
After you enable a subsidiary-specific feature at the company level, you might have to enable the
feature at the subsidiary level. If you enable a subsidiary-specific feature for at least one subsidiary,
you cannot disable that feature on the Enable Features page.
Some subsidiary-specific features cannot be disabled after they have been enabled. For example,
you cannot disable the Intercompany Framework feature. However, when the Intercompany
Framework feature is enabled, it is enabled for all subsidiaries.
You cannot define a subsidiary-specific feature’s additional settings for elimination subsidiaries.
To ensure you have permission to access the Subsidiary Settings Manager page, see Subsidiary Settings
Manager Permissions.
You can configure additional settings for multiple subsidiaries for the following features:
■ Defining Subsidiary Settings for the Period End Journal Entries Feature
■ Defining Default Cross Charge Classification Preferences for Multiple Subsidiaries
To ensure you have permission to access the Subsidiary Settings Manager page, see Subsidiary Settings
Manager Permissions.
To enable Period End Journal Entries for subsidiaries and define additional settings:
1. Go to Setup > Company > Setup Tasks > Subsidiary Settings Manager.
2. Click the settings icon in the Period End Journal Entries column header.
If you have permission to edit the Subsidiary Settings for Period End Journal Entries page, you can
enable the feature for multiple subsidiaries. You can then define unique settings for each selected
subsidiary.
3. Click Edit.
4. The state of the accounting preference Use Consolidation With Period End Journal Entries is set
on the Accounting Preferences page. If you have the Set Up Accounting permission, you can alter
the state of this preference.
a. Go to Setup > Accounting > Accounting Preferences.
b. Click the General subtab.
c. Check the Use Consolidation With Period End Journal Entries box.
d. Click Save.
e. Return to the Subsidiary Settings for Period End Journal page.
When you check the Use Consolidation With Period End Journal Entries box, NetSuite
creates consolidation journals each period for each parent subsidiary that uses the Period
End Journal Entries feature. NetSuite consolidates each subsidiary in the enabled parent
subsidiary’s hierarchy to the parent. For example, in a grandparent-parent-child hierarchy,
NetSuite creates consolidation journals for grandparent-parent and for grandparent-child.
5. (Optional.) You can filter the subsidiaries that display in the list by those that have Period End
Journal Entries enabled. You can also filter by a specific subsidiary, country, currency, and whether
the subsidiary is inactive. For information about filtering, see Filters.
6. (Optional.) You can sort columns to find specific data. For information about column sorting, see
Column Sorting.
7. Complete or view the following information, as needed.
a. In the Enable Period End Journal Entries column, check the boxes next to the subsidiaries
for which you want to enable the feature.
When you check a box, the row becomes editable.
For details about the Period End Journal Entries feature, see the help topic Period End
Journal Entries.
b. If you use Multi-Book Accounting, select one or more accounting books from the
Accounting Books column.
Important: If you use Multi-Book Accounting, you can enable Period End Journal
Entries for each accounting book and subsidiary combination to which you have
access. When you enable the Period End Journal Entries feature for a subsidiary, you
can edit the accounting books assigned to that subsidiary. However, you may not
be able to disable Period End Journal Entries for the subsidiary. If not, it is because
another user selected an accounting book that you cannot access. Accounting books
that you cannot access do not appear for selection or exclusion.
When you save changes to one of your subsidiary’s settings, NetSuite applies
changes across all accounting books, including those you cannot access.
Note: You can enable the use of primary and secondary accounting books with this
feature through the Subsidiary Settings for Period End Journal page. You can also
enable secondary accounting books on the accounting book’s record, and on the
subsidiary record on the Accounting Books subtab. NetSuite automatically updates
the Subsidiary Settings page for a subsidiary, subsidiary record, and accounting book
record with any change. NetSuite tracks changes in system notes for the Subsidiary
Settings page for a subsidiary, and both records. The Subsidiaries list page and the
subsidiary record in edit mode provide a link to the Subsidiary Settings Manager
page. The Accounting Books list page and the accounting book record in view and
edit modes provide a link to Subsidiary Settings for Period End Journal page.
c. The Subsidiary column provides a link to the subsidiary record. The subsidiary record
provides a link to the Subsidiary Settings page for that subsidiary. Values you define for
a subsidiary automatically update the read-only Period End Journal Entries subtab. This
subtab appears on the Preferences subtab on the subsidiary record.
d. The Country and Currency columns display values specific to the subsidiary row.
e. The last column displays the status of the row.
■ A check mark displays when there are no errors in the fields on the row.
Note: The accounts that you can select must be of Equity account type.
a. In the Balance Sheet Closing Account list, select the appropriate account.
b. In the Balance Sheet Opening Account list, select the appropriate account.
When the GL Audit Numbering feature is enabled, an additional column lets you skip GL
numbering for balance sheet closing journals. Check the Exclude Balance Sheet Closing Journals
from GL Numbering box to skip numbering for the balance sheet closing journals.
9. Check the Create Income Summary Journals box.
When you check this box, NetSuite creates two period end journals in the Income Statement
Closing step. This step is part of the Create Period End Journals task on the Period Close Checklist.
(NetSuite creates more journals when you create period end journals by segment.) The first journal
(or journals) reduces the income and expense accounts to zero. It posts the net income to the
account defined for income summary profit or loss. If the net income is a gain, the offset posts
to the income summary profit account. If the net income is a loss, the offset posts to the income
summary loss account. The second journal (or journals) moves the balance from the income
summary account used in the first journal to the retained earnings account.
When you check this box, you must select values for Income Summary Profit Account and
Income Summary Loss Account.
Note: The accounts that you can select must be of Equity account type.
a. In the Income Summary Profit Account list, select the appropriate account.
b. In the Income Summary Loss Account list, select the appropriate account.
10. In the Group By These Segments list, select the appropriate segment.
This multi-select list displays all the segment types that impact the general ledger. Possible
segment types are class, department, location, and all custom segments with general ledger
impact. Select the segment types for which you want to generate separate period end journals, if
any. NetSuite generates separate period end journals for each selected segment type combination
included in the source transactions for this subsidiary. For more information about custom
segments, see the help topic Custom Fields and Segments on Period End Journals.
11. In the Require Memo On Period End Journals column, check the box to require a memo on
period end journals.
When you check this box, you cannot create or save period end journals without a value in the
Memo fields in the header and lines. The value entered in the Memo field during the journal
creation process automatically populates the Memo fields in the header and lines.
12. Click Save.
Note: NetSuite tracks changes made to a subsidiary’s defined values on the System
Notes subtab of the Subsidiary Settings page for that specific subsidiary. For information
about the Subsidiary Settings page for a subsidiary, see Subsidiary Settings for a Single
Subsidiary.
If you have permission to edit the Subsidiary Settings for Intercompany Framework page, you can
define default cross charge classification preferences for each selected subsidiary.
For details about the Intercompany Framework feature, see Intercompany Framework.
3. (Optional.) You can filter the subsidiaries that display in the list. You can also filter by whether the
subsidiary is inactive. For information about filtering, see Filters.
4. Click Edit.
5. In the Class, Department, and Location column lists, select the default cross charge classification
preferences.
6. Click Save.
Note: NetSuite tracks changes made to a subsidiary’s defined values on the System Notes
subtab of the Subsidiary Settings page for that specific subsidiary. For information about the
Subsidiary Settings page for a subsidiary, see Subsidiary Settings for a Single Subsidiary.
To assign an entity to a subsidiary, open the record, and select a subsidiary in the Subsidiary field. The
selected subsidiary determines the fields visible on the form, the address format, tax fields, and other
information.
You can assign a single subsidiary to employee and partner entities. If these entities have relationships
with multiple subsidiaries, you must create a record for each subsidiary relationship. You can assign a
primary and multiple secondary subsidiaries to vendor and customer entities.
You can associate entities from one subsidiary to an entity associated with a different subsidiary in these
cases:
Note: After a transaction is posted for the entity, you cannot change the primary subsidiary
selected on the entity record.
For more information associating subsidiaries with entities, see the following help topics:
■ Customers
■ Adding a Vendor Record
■ Entering an Address for an Employee
■ Creating a Partner Record
■ Enabling Intercompany Time and Expenses
In OneWorld, you can add fields to item records so that items can be shared by several subsidiaries.
You can also assign a shipping item to a subsidiary so that it can be used for transactions. See Associate
Subsidiaries with Items and Associate Subsidiaries with Shipping Items.
2. In the Classification section, select from the Subsidiary list, and click Save.
When you view a multi-subsidiary vendor record, you can see the vendor’s total outstanding balance. You
can also see the total unbilled balance (sum of all of the assigned subsidiaries’ balances) in the primary
subsidiary’s currency.
You can designate a credit limit for the primary subsidiary and each of the secondary subsidiaries on the
vendor record. You can also associate vendors and multiple subsidiaries with items, assigning a specific
item price for each subsidiary purchasing from the vendor.
For tax agency vendor records, it is important to set the subsidiary to match the subsidiary linked to the
nexus using that tax agency.
You specify the tax code at the line-level on the Subsidiaries subtab. Tax code is not available in the US
edition for accounts that are not OneWorld.
Important: You can define multiple secondary subsidiaries through the user interface and
SuiteScript. To use SuiteScript to define secondary subsidiaries on a vendor record, use the
Vendor-Subsidiary Relationship record type. To mass create and update vendor records through
CSV files, see the help topic Vendor-Subsidiary Relationship Import.
If you have enabled the Multi-Subsidiary Customer feature, you can share a vendor record that
is also paired with a customer record. Such pairings display on the Relationships subtab on the
vendor record.
To use the subsidiary logo and address from the transaction record when printing, use advanced
templates. For more information, see the help topic Advanced PDF/HTML Templates. If you print
transactions using basic layouts, the logo and address are sourced from the vendor’s primary subsidiary.
You can also create simple and saved searches for vendor-subsidiary information. The new search type,
Vendor-Subsidiary Relationship, is based on a record type of the same name. The vendor-subsidiary
relationship record is not visible in the user interface, however, the fields on this record are available to
search.
To create a simple search, go to Reports > New Search. For information about simple searches, see the
help topic Defining a Simple Search.
To create a new saved search, go to Reports > Saved Searches > All Saved Searches > New, or Lists
> Search > Saved Searches > New. For information about saved searches, see the help topic Saved
Searches.
To use the Import Assistant to create or update multi-subsidiary vendors, go to Setup > Import/Export
> Import Tasks > Import CSV Records. Choose the Relationships import type, and then the Vendor-
Subsidiary Relationship record type. After you upload your file and choose import options, you can begin
file and then field mapping, and finally import your file.
Tip: Upload a simple CSV file, and then refine that file when you map fields.
For information about using the Import Assistant, see the help topic Importing CSV Files with the Import
Assistant. For information about the Vendor-Subsidiary Relationship import record type, see the help
topic Vendor-Subsidiary Relationship.
On the Other Record Fields page, select the Vendor-Subsidiary Relationship record type. Define the fields
to be added to the Subsidiaries subtab. When the vendor record is in Edit mode, you can modify the
values in those fields.
The Custom Records and Custom Segments features must be enabled to customize the Subsidiaries
subtab. If you use the Multiple Currencies feature, you can add currency-specific fields to the Subsidiaries
subtab.
For information about custom record fields, see the help topics Other Record Fields and Creating a
Custom Field.
Note: Users must have permission to edit vendor records to customize the Subsidiaries subtab.
When you create intercompany transactions, the Subsidiaries list on the transaction provides all of the
subsidiaries assigned to the vendor.
For information about the Automated Intercompany Management feature, see Automated Intercompany
Management.
Note: The vendor and customer records must share the same primary subsidiary to create a
multi-subsidiary vendor customer relationship.
For information about creating relationships between record types, see the help topic Records as Multiple
Types.
Allocation Schedules Specify that the source account and destination Creating Expense Allocation
account belong to any of the vendors to which Schedules
the selected subsidiaries are assigned
Creating Intercompany Allocation
Schedules
Bill Purchase Orders View all unbilled purchase orders associated with Billing Purchase Orders
the subsidiaries assigned to the selected vendor
Company Credit Card Select any subsidiary assigned to the selected Entering Company Credit Card
entity in the Vendor field Charges
Deposits For Other Deposits, choose from all of the Making Deposits
vendors assigned to the subsidiary associated
with the selected bank account
Drop Shipment Create a sales order for an assigned secondary Drop Shipment and Special Order
subsidiary that includes an item marked for Purchases
drop ship and NetSuite automatically creates a
purchase order based on the preferred vendor Mark an Item for Drop Shipment
for that drop shipped item
Item Pricing Specify a different item price per subsidiary for Associating Vendors with Items
the same item record
Associating Multiple Vendors with an
Item
Entering Purchasing/Inventory
Information on Items and then see
the help topic Vendors
Journal Entries Make general, statistical, intercompany, book Making Journal Entries
specific general, and book specific intercompany
journal entries for any of the vendors to which a Making Statistical Journal Entries
selected subsidiary is assigned Making Intercompany Journal Entries
Order Requisitions Create purchase orders for requisitions, selecting Order Requisitions
a subsidiary and any shared vendor to which that
subsidiary is assigned
Purchase Orders and Select any subsidiary assigned to the selected Entering a Purchase Order
Intercompany Purchase entity in the Vendor field
Orders
At the Items line level, select any vendor
assigned to the subsidiary associated with the
selected entity
Reconciliation For New Charges on bank statements, selecting Reconciling Bank Statements
a shared vendor payee enables you to enter line
items for all of the vendor’s open transactions Reconciling Credit Card Statements
and the open transactions belonging to the
selected subsidiary
Vendor Bill Variances Post item records that belong to the combination Posting Vendor Bill Variances
of the selected vendor and assigned subsidiary
Vendor Bills Select any subsidiary associated with a vendor Vendor Bills
bill
Vendor Blanket Purchase Select any assigned subsidiary to associate with a Blanket Purchase Orders
Order vendor blanket purchase order
Creating a Blanket Purchase Order
Vendor Credit Associate a vendor credit with any of the To entering a vendor credit manually:
subsidiaries assigned to a shared vendor
Creating a Vendor Credit Directly
from a Vendor Bill
Vendor Payments Associate a vendor payment with a vendor bill Vendor Payments Overview
from an assigned subsidiary
Pay Bills to a Single Vendor
Vendor Purchase Contract Select any assigned subsidiary to associate with a Creating Purchase Contracts
vendor purchase contract
Using Purchase Contracts on
Purchase Orders
Vendor Return Select the vendor who should receive the return Entering a Vendor Return
Authorization authorization Authorization
The Multi-Subsidiary Customer feature enables you to save a multi-subsidiary customer as a multi-
subsidiary vendor to create a single entity. It is useful when you want to have one entity represent both a
customer and a vendor. You can also view a multi-subsidiary customer’s hierarchy (primary subsidiary, any
assigned secondary subsidiary, and any subcustomer).
Note: In the customer hierarchy, users can view only those subsidiaries to which they are
granted access.
The Multi-Subsidiary Customer feature also enables you to view the following:
When a lead or contact is generated from an online form, the country associated with the form is
matched to the country of the subsidiary, and that subsidiary is associated with the new record. If multiple
subsidiaries are related to a country or no country is entered, the root subsidiary is the primary subsidiary
with the new entity.
Note: If you use the Accept Payment Through Top Level Customer preference, parent customers
and their sub-customers must be associated with the same subsidiaries and must both use the
same currencies.
Important: You can define multiple secondary subsidiaries though the user interface and
SuiteScript. To define secondary subsidiaries in SuiteScript, use the Customer-Subsidiary
Relationship record type. To mass create and update customer records through CSV files, see the
help topic Customer-Subsidiary Relationship Import.
If you have shared multiple subsidiaries with a vendor record, you can share a customer record
that is also paired with a vendor record. Such pairings display on the Relationships subtab on the
customer record.
To use the subsidiary logo and address from the transaction record when printing, use advanced
templates. For more information, see the help topic Advanced PDF/HTML Templates. If you print
transactions using basic layouts, the logo and address are sourced from the customer’s primary
subsidiary.
■ Incompatible Features:
□ Consolidated Payments
□ Mini EU One Stop Shop (MOSS)
■ Unsupported Functionality:
□ Bank Account (supports data related to the primary subsidiary only)
□ Credit Limit per Subsidiary
□ Customer Center (supports data related to the primary subsidiary only)
□ Customer Dashboard
Note: The PST Exempt (Taxable) field is visible on the customer record only when the
customer falls under a Canadian nexus.
■ Unsupported Transactions:
□ Issue Tegata
□ Pay Tegata
■ Technical Limitations:
To ensure that dynamic mode scripts and workflows perform as expected, the selected entity or
customer (depending on the transaction) determines the default subsidiary.
■ If you use anonymous customers with Web Store workflows, assign only one subsidiary to the
anonymous customer record.
■ Set up tax rounding at the Nexus level rather than for individual customers with multiple different
subsidiaries. For details, see the help topic Setting Tax Preferences.
2. In the ERP General section, check the Multi-Subsidiary Customer box and click Save.
For example, you have a customer where the primary subsidiary is in Canada. Two secondary subsidiaries,
one in the U.S. and one in Germany are assigned to this customer. The respective subsidiary currencies
are CAN as the primary currency, and USD and euro as secondary subsidiary currencies. There is an
invoice for the U.S. subsidiary for 1000 euro. Based on the daily foreign exchange rate, it posts as 1200
USD in the U.S. subsidiary. The value in the Balance field on the customer record is 1500 CAN (1000 euro
translated into CAN through a 1.5 Direct rate).
■ Balance – The value in the Balance field represents the total customer balance for the subsidiary.
An approved customer invoice in an open status increases the value in the Balance field. A customer
payment decreases the value in the Balance field. A customer credit also decreases the value in the
Balance field. A cash sale does not alter the value in the Balance field.
■ Unbilled Orders – The value in the Unbilled Orders field represents the sum of the orders not yet
billed for the subsidiary. The tax on a sales order increases the value in the Unbilled Orders field
because the tax does not have to be approved. When the sales order becomes a customer invoice, the
tax value in the Unbilled Orders field is moved into the Balance field.
■ Deposit Balance – The value in the Deposit Balance field represents the unapplied deposit amount
from a customer deposit transaction.
The customer balance information on the Financials subtab appears in the customer’s primary currency.
For information about the Financials subtab, see the help topic Entering Customer Financial Information.
You can also create simple and saved searches for customer-subsidiary information. The new search type,
Customer-Subsidiary Relationship, is based on a record type of the same name. The customer-subsidiary
relationship record is not visible in the user interface, however, the fields on this record are available to
search.
To create a simple search, go to Reports > New Search. For information about simple searches, see the
help topic Defining a Simple Search.
To create a new saved search, go to Reports > Saved Searches > All Saved Searches > New, or Lists
> Search > Saved Searches > New. For information about saved searches, see the help topic Saved
Searches.
Note: Before you publish a saved search to Webshop, you should validate the results by clicking
any linked data content. The default Webshop user is not restricted from viewing subsidiary data,
and may have access to unintended or irrelevant data. You must adjust user restrictions to limit
data viewing.
To use the Import Assistant to create and update multi-subsidiary customers, go to Setup > Import/
Export > Import Tasks > Import CSV Records. Choose the Relationships import type, and then the
Customer-Subsidiary Relationship record type. After you upload your file and choose import options, you
can begin file and then field mapping, and finally import your file.
Tip: Upload a simple CSV file, and then refine that file when you map fields.
For information about using the Import Assistant, see the help topic Importing CSV Files with the Import
Assistant. For information about the Customer-Subsidiary Relationship import record type, see the help
topic Customer-Subsidiary Relationship.
On the Other Record Fields page, select the Customer-Subsidiary Relationship record type. Define the
fields to be added to the Subsidiaries subtab. When the customer record is in Edit mode, you can modify
the values in those fields.
The Custom Records and Custom Segments features must be enabled to customize the Subsidiaries
subtab. If you use the Multiple Currencies feature, you can add currency-specific fields to the Subsidiaries
subtab.
For information about custom record fields, see the help topics Other Record Fields and Creating a
Custom Field.
Note: Users must have permission to edit customer and vendor records to customize the
Subsidiaries subtab.
Note: The customer and vendor records must share the same primary subsidiary to create a
multi-subsidiary customer vendor relationship.
For information about creating relationships between record types, see the help topic Records as Multiple
Types.
Note: In the customer hierarchy, users can view only those subsidiaries to which they are
granted access.
Cash Refund Select any subsidiary assigned to the Refunding a Cash Sale
customer record
Cash Sale Select any subsidiary assigned to the Entering a Cash Sale
customer record
Commission Partner has been configured in NetSuite Creating a Partner Commission Plan
(Partner) to receive commission
Assigning Partners to a Commission Plan
Commission plan with a commission
schedule is assigned to the partner Partner Commission Schedules
Company Credit Select any subsidiary assigned to the Entering Company Credit Card Charges
Card selected entity in the Vendor field
Credit Card Select any subsidiary assigned to the Refunding an Open Balance
Refund customer record
Customer Credit Select any subsidiary assigned to the Issuing a Customer Credit Memo
Memo customer record
Customer Deposit Select any subsidiary assigned to the Recording a Customer Deposit
customer record
Customer Select any subsidiary assigned to the Applying a Payment on the Customer Payment Page
Payment customer record
Customer Refund Select any subsidiary assigned to the Refunding an Open Balance
customer record
Expense Report At the Expenses line level, select any Entering an Expense Report
customer assigned to the subsidiary
associated with the selected employee
Fulfillment The subsidiary is derived from the Sales Creating Fulfillment Requests
Request Order
Gift Certificate Click the New Gift Certificates button at Gift Certificates
Lists > Accounting > Gift Certificates
Purchase Orders Select any subsidiary assigned to the Entering a Purchase Order
and Intercompany selected entity in the Vendor field
Purchase Orders
At the Items line level, select any
customer assigned to the subsidiary
associated with the selected entity
Return Select any subsidiary assigned to the Entering a Standalone Return Authorization
Authorization customer record
Entering a Linked Return Authorization
The subsidiary cannot be changed after
the transactions is saved
Revenue Supports Multi-Subsidiary Customer Using the Generate Revenue Commitment Page Using
Commitment the Generate Revenue Commitment Reversals Page
and Revenue
Commitment
Reversal
Sales Order Select any subsidiary assigned to the Creating Sales Orders
customer record
■ Drop Shipment from Sales Order - An approved
Confirm the prompt to change Nexus, if sales order that contains a drop shipment item
required automatically generates a purchase order for the
item. Vendor ships item to the selected customer.
The subsidiary cannot be changed after
Selling a Drop Ship Item
the transaction is saved
■ Drop Shipment Intercompany Sales Order -
Warehouse subsidiary generates an intercompany
sales order at Transactions > Sales > Manage
Intercompany Sales Orders (Administrator).
Warehouse subsidiary fulfills the order and sends
the item to the customer. Intercompany Inventory
Drop Ship
Sales Order Supports Multi-Subsidiary Customer Using Sales Order Revenue Forecasting
Revenue
Forecasting
Vendor Credit Select the vendor who should receive Entering a Vendor Credit Manually
the credit
Vendor Return Select the vendor who should receive Entering a Vendor Return Authorization
Authorization the return authorization
Work Order Select the customer and any assigned Entering an Individual Work Order
subsidiary associated with the work
order
Note: When you share items with multiple subsidiaries, the options selected on the item record
must be compatible with the subsidiaries sharing the items. For example, when you enter an
inventory item to share with multiple subsidiaries, you must select income and asset accounts that
are assigned to those same subsidiaries.
You must associate a subsidiary with an item to add that item to a transaction related to that subsidiary.
For example, you enter a sales order and select a customer associated with the Wolfe US subsidiary
on the transaction. When you select an item to add to the sales order, you can add only those items
associated with Wolfe US.
Important: When you create a Gift Certificate item record, the Income Account and the Liability
Account fields display a list of accounts assigned to the selected subsidiary. If you select multiple
subsidiaries, only those accounts common to all of the selected subsidiaries appear in the list.
In NetSuite that is not OneWorld, when you create an item record, you can enter initial quantities on hand
in each location. However, in NetSuite OneWorld, when you create an item record, you cannot enter initial
quantities on hand in each location. You must first create the item record and save. Then you must enter
an inventory adjustment to specify the initial quantities in each location.
Shipping items for the same service have a unique Ship Name but share the same Display/Code name.
Shipping items use real-time rates and shipping label integration features associated with the carrier.
For example, you have two subsidiaries, one for your operations in the United States and one for
operations in Canada. You use UPS Ground service for shipping needs in both subsidiaries. Create a
shipping item for each subsidiary with a Ship Name that identifies the subsidiary where it is to be used:
Subsidiaries US Canada
When you select a customer on a transaction, only shipping items for the subsidiary attached to that
customer display in the list for Shipping Method.
In the Web store, an unregistered shopper without a customer record can choose shipping items
associated with the subsidiary website being viewed. When a registered customer logs in to your Web
store, the shopper can see only those shipping items associated with the customer's record. For example,
a shopper in Canada sees only those shipping items associated with the Canadian subsidiary.
For information about shipping items, see the help topic Shipping Items.
Important: Some reports do not support consolidation and can return results for only one
subsidiary at a time. Before you can run one of these reports, you must set your user preferences
to restrict your view to a single subsidiary, at Home > Set Preferences on the Restrict View subtab.
If a report can show consolidated information, the Subsidiary Context field in the footer of the report
includes options appended with (Consolidated). For example, the report titled HEADQUARTERS
(Consolidated). When you select a consolidated subsidiary on a report, the data displayed is for the
selected subsidiary and its child subsidiaries including elimination subsidiaries. For example, if you choose
Subsidiary Context HEADQUARTERS (Consolidated), the report displays consolidated data for the UK and
its child subsidiaries, Germany and Italy.
When you select a subsidiary that is not consolidated, the data displayed is for that selected subsidiary.
For example, selecting Subsidiary Context UK displays only the UK subsidiary data. For more description
and examples of the Subsidiary Context filter, see Subsidiary Context for Reports.
Note: If you are using Multi-Book Accounting, you can run consolidated reporting on any
accounting book enabled for consolidation.
When the data displayed is for a single subsidiary, the system uses the base currency of that subsidiary
for amounts. When the data displayed is consolidated for multiple related subsidiaries, the system uses
the base currency of the parent subsidiary for amounts. Consolidated reports use the Consolidated
Exchange Rates table to translate child subsidiaries' amounts to roll up into consolidated parent
subsidiary amounts. See the help topic Consolidated Exchange Rates.
Reports that include budget and actual amounts, such as some financial statements, use a separate
Budget Exchange Rates table for translation of budget amounts. See the help topic Subsidiary-Specific
Budget Reports.
Financial statements have other specialized capabilities in OneWorld, including subsidiary-specific layouts.
See the help topic OneWorld Financial Statements.
Consolidated balance sheet and cash flow statement reports use a special account called Cumulative
Translation Adjustment (CTA). The CTA account achieves balance when there is more than one currency.
This account is necessary because the rate types of accounts may differ, which results in different rates
being used that can cause an imbalance. The CTA account is also used wherever consolidation across
accounts with different rate types occurs, such as the consolidated trial balance. See the help topic
Cumulative Translation Adjustment (CTA) Overview.
Note: If you use Multi-Book Accounting, you can run consolidated reports for any accounting
book enabled for consolidation. Use the Accounting Book list to choose the primary or secondary
accounting book that correlates with the selected subsidiary context.
When you select a subsidiary, including elimination subsidiaries, the system filters the report data
to display data only from the selected subsidiary. In the case of consolidated subsidiaries, the data
that displays is for all child subsidiaries of the consolidated parent subsidiary, including elimination
subsidiaries.
Wolfe US (Consolidated)
Wolfe US
Wolfe Germany
Wolfe UK (Consolidated)
Wolfe UK
Wolfe Japan
Wolfe Singapore
The system inserts a virtual consolidated node for each parent. When you select a consolidated node,
the data returned is a summary of all transactions associated with the node’s child subsidiaries, including
elimination subsidiaries.
If you use a role that is restricted to specific subsidiaries, the data returned is based on your level of
access.
Using the preceding example hierarchy, if you have access to only the Japan subsidiary, the Subsidiary
Context filter would be organized as follows:
Wolfe US (Context)
Wolfe UK (Context)
Wolfe Japan
Because this role is restricted to a single subsidiary, the results do not include consolidated data.
However, you can still see the data in Wolfe Japan as it would appear in the currencies and layouts of
parent subsidiaries.
Important: Some reports do not support consolidation and return results for only one
subsidiary at a time. These reports do not include the Subsidiary Context filter in the report footer.
Before you can run one of these reports, you must set your user preferences to restrict your view
to a single subsidiary. Go to Home > Set Preferences > Restrict View subtab. See Restrict Your
Subsidiary View.
For example, a user with access to the Singapore and Japan subsidiaries runs a search. The search results
display all currency amounts in UK pounds because Wolfe UK is the LCA for these subsidiaries. If the user
had access to Japan and Germany, currency amounts would display in US dollars.
You can limit the data returned to a single subsidiary. Go to Home > Set Preferences > Restrict View
subtab. See Restrict Your Subsidiary View.
Tip: You can select the type of exchange rate applied to and advanced search or saved search of
transactions. Choose the Consolidated Exchange Rate option for search results. See the help topic
Consolidated Exchange Rate Types for Transaction Searches.
Subsidiary Navigator
Subsidiary Navigator enables you to limit the information displayed on your dashboard, searches, and
reports to a specific subsidiary or group of subsidiaries. The portlet contains a chart from which you can
select the subsidiary whose records you want to display. Choosing a subsidiary is equivalent to setting the
Restrict View to a subsidiary option in Home > Set Preferences.
■ Client SuiteScript
■ Server SuiteScript
■ Subsidiary
Subsidiary Navigator is a managed SuiteApp and is automatically updated whenever there are changes.
These issue fixes and enhancements are available after the SuiteApp is updated in your account.
For information on installing SuiteApps, see the help topic Installing a Bundle.
Note: Dashboard SuiteApps are available only from the home page dashboard.
1. On the Subsidiary Navigator portlet, click Settings on the upper left corner.
2. Set values for the following:
■ Enable Tooltip – Click to enable or disable the company information tooltip for each subsidiary.
When you point your mouse on a subsidiary, the tooltip displays the country, currency, and
address of the subsidiary.
■ Show Logo – You can choose to display or hide the company logos on the Subsidiary Navigator
portlet. Check the box to display subsidiary logos on the current user's account. Click the slider
to show or hide company logos for all users on this account.
Note: The Enable Tooltip setting and the Show Logo slider option is available only on the
Administrator’s account.
Changes to these settings are applied immediately. Click anywhere outside the settings area to hide the
settings.
The system highlights the selected subsidiary and all of the sub-subsidiaries. Portlets on the dashboard
update automatically to show records for the selected subsidiaries.
Note: The settings apply for the duration of your current session. Normal settings are restored
on the next login.
When logged in using a custom role, the Subsidiary Navigator Portlet displays the subsidiaries assigned
for that particular role.
For this example, the Subsidiary Navigator displays the selected sub-subsidiaries and the parent
subsidiary only.
Note: Users must have access to more than one subsidiary for Subsidiary Navigator to work.
If a custom role has no subsidiary selected for it, the restriction defaults to the subsidiary of the
user.
If a custom role has only sub-subsidiaries selected for it, the Subsidiary Navigator displays the sub-
subsidiaries. It also displays its parent subsidiary and any other subsidiaries that connect it to the
root subsidiary. Users can click the parent subsidiary but doing so does not affect the behavior of
the portlets on the dashboard. The portlets display only records for the sub-subsidiaries selected
for the role.
Important: If a custom role has the Allow Cross-Subsidiary Record Viewing option enabled,
clicking a subsidiary node in the Subsidiary Navigator portlet displays all relevant records.
Included in these records are those to which the role is not granted access. Users with the role
can open all displayed records, but can edit only those to which the user has edit rights.
OneWorld CRM
NetSuite OneWorld enables you to run your global sales force within a single NetSuite account.
Each customer, or other entity, is associated with a single subsidiary, enabling you to track forecasts and
quotas on a subsidiary basis.
Consolidated Quotas
When establishing a sales quota, you must select a subsidiary or a consolidated subsidiary. This subsidiary
or consolidated subsidiary determines which sales count towards the quota.
To create a quota, go to Transactions > Quota/Forecast > Establish Quotas, and select a sales rep. In the
Subsidiary field, select the subsidiary or consolidated subsidiary on which you want to base this quota.
If you select a consolidated subsidiary, sales made by this sales rep for the parent subsidiary and all of its
child subsidiaries are counted toward the quota. If you select a single subsidiary, only the sales made for
that subsidiary count toward the quota.
When you select a subsidiary, the sales forecast represents the rep's forecast for the parent subsidiary
and all of its child subsidiaries. The sales rep's quota for that subsidiary is shown in the Quota field.
Commission schedules have a subsidiary field. Commission plans can include any commission schedules
regardless of the subsidiary chosen on those schedules.
If you base a commission schedule on a quota, you must have a quota entered for the selected
subsidiary.
Transactions made for the selected subsidiary, or for any child subsidiaries, are used to calculate
commissions for sales reps assigned to the commission schedule. Commission schedule amounts are
entered in the base currency of the selected subsidiary. The consolidated exchange rates table is used to
calculate values for transactions for other subsidiaries with different base currencies.
When employees or partners make sales for an unassigned subsidiary, the system generates commission
based on the following:
■ You have a commission schedule in the currency of one subsidiary. A sales rep makes a sale for one
of the child subsidiaries. The system converts the commission calculation to the sales rep's currency
through the consolidated exchange rate table.
■ The system performs the commission calculation based on the currency of the subsidiary assigned
to the commission schedule. All values on reports and KPIs display the commission in that currency,
regardless of the currency assigned to the partner or employee's subsidiary.
■ The generated commission transaction is always in the base currency of the subsidiary assigned to the
employee or partner (partner's vendor record). If necessary, the system converts a commission for a
schedule assigned to another subsidiary. The system uses the exchange rates on the transaction to
the currency of the employee or partner.
■ After a commission is approved, the commission expense and payable impact the accounting books
of the subsidiary assigned to the employee or partner. This impact is true even if the transaction that
generated the commission is related to a subsidiary different from the employee or partner. It is also
true if the commission schedule is assigned to another subsidiary.
Sales reps from different subsidiaries can be assigned to sales managers from the same or other
subsidiaries. The sales for subordinate sales reps roll up to the sales manager. The system uses the
consolidated exchange rates between the subsidiaries for the period in which the sales transaction is
booked.
For more information about employee and partner commissions in NetSuite OneWorld, see the following
help topics:
■ Commissions
■ Partner Commissions & Royalties
■ Consolidated Exchange Rates
The estimated commission reports, commission plan, and commission transaction display the
commission amounts converted to USD. This conversion is based on the consolidated exchange rates
table for the period in which each transaction was booked:
Note: The system stores the exchange rates used for commission calculations. If the rate on
the consolidated exchange rates table changes, the schedule must be recalculated to reflect the
change.
A quota for a sales rep associated with the U.S. subsidiary would include sales made for the U.S.
subsidiary and its child subsidiaries.
If you establish a quota for the U.S. parent subsidiary and for Wolfe U.K.:
■ Sales made for the U.S., U.K., or Germany subsidiaries are included toward the U.S. quota.
■ The U.K. quota would include only sales made on behalf of the U.K. subsidiary.
Following this example, a rep is assigned a commission plan with a schedule that is associated with the
U.S. subsidiary. This schedule pays 10% of all sales exceeding quota.
The rep has a quota of $3000 for this period, and makes the following sales:
The rep exceeded his quota by $500 and receives a commission payout equal to 10% of $500, or $50
USD.
Note: If changes are made to the consolidated exchange rates, the commission schedule must
be recalculated.
The accounts you select on this page must be accessible to the chosen subsidiary.
When you authorize commission in bulk, the currency rate used is the most recent transaction currency in
the currency exchange rate table. For example, if a Canadian rep earns commission on a U.S. commission
schedule, the schedule generates the commission transaction in U.S. dollars. This commission must be
posted to the Canadian subsidiary's books in Canadian dollars. The rate used for this conversion is based
on the rate stored in the consolidated exchange rate table.
The currency rates used during authorization are the most recent exchange rates in the currency
exchange rate table. To view currency exchange rates, so to Lists > Accounting > Currency Exchange
Rates.
The By Transaction and By Period subtabs on the individual commission pages include the following
columns:
■ Currency – This is the currency of the commission transaction (which is the same as the currency of
the subsidiary assigned to the employee or partner).
■ Subsidiary – This is the subsidiary to which the commission transaction is posted.
■ Exchange Rate – This column appears only for partner commission. It determines the rate from the
base currency of the subsidiary assigned to the partner to the partner's transaction currency.
For example, assume that you have a partner that is paid in Canadian dollars. The partner is assigned
to a U.K. subsidiary that sells for a U.S. subsidiary. The commission schedule would be in U.S. dollars.
The exchange rate on each line of the commission transaction would use a rate to convert the amount
from USD to GBP. The exchange rate in the header would convert the amount from GBP to the
partner's currency, CAD.
The Subsidiary field is always considered when determining if the records created by a form is a duplicate.
You cannot clear the box in the Search column for this field. This field is also hidden by default.
If a customer fills out an online form and the information matches a customer record for another
subsidiary, the system creates a new record. A customer is considered a duplicate if there is a customer
record with the same subsidiary as the one selected on the online form.
You can set the subsidiary on an online form in the following ways. If you use more than one method,
subsidiary selection follows the order of precedence below:
■ Add the Subsidiary field to the form, and allow those that fill out the form to select a subsidiary.
■ Pass the subsidiary through the URL with the &subsidiary parameter. This parameter lets you hide
the field on the form.
■ Select the subsidiary included in the visitor ID of the person submitting the form. The system tracks
the visitor ID in the cookie issued when someone visits your website.
■ Set the default subsidiary in the Default Subsidiary field on the Set Up Workflow subtab of the online
form record.
If you use online customer forms to create contact records, the system assigns the contact the subsidiary
associated with the customer record.
For more information about linking credit card gateways with subsidiaries for web orders, read the help
topic Selecting a Credit Card Gateway for a Subsidiary Website.
For more information about setting up credit card processing gateways in NetSuite, read the help topic
Setting Up Customer Credit Card Processing.