--- title: Steps to Create the Chart of Accounts in NetSuite description: I hope you find the information below helpful when thinking about and creating your chart of accounts in NetSuite. image: https://blog.concentrus.com/hubfs/pexels-photo-7821548.jpeg --- [![logo-concentrus-blog](https://blog.concentrus.com/hs-fs/hubfs/logo-concentrus-blog.png?width=341&name=logo-concentrus-blog.png)](http://www.concentrus.com/)   - Our Services - ERP Services - [Implementation & Configuration](http://concentrus.com/implementation-methodology/) - [NetSuite Rescue & Optimization](http://concentrus.com/netsuite-rescue-optimization/) - [Customization & Integrations](http://concentrus.com/customization-methodology/) - [NetSuite Consulting & Support](http://concentrus.com/netsuite-optimization-assessment/) - [NetSuite Health Check](http://concentrus.com/netsuite-optimization-assessment/) - NetSuite Solutions - [Parent Level Credit](http://concentrus.com/parent-level-credit/) - [China Tariff Calculator](http://concentrus.com/china-tariff-calculator/) - [Item Authorization](http://concentrus.com/item-authorization/) - [The Concentrus Toolkit](http://concentrus.com/the-concentrus-toolkit/) - Platforms - [NetSuite](https://concentrus.staphaus.net/what-is-netsuite/) - [Wholesale Distribution](http://concentrus.com/wholesale-distribution-erp-cloud-erp-netsuite/) - [Manufacturing](http://concentrus.com/netsuite-for-manufacturing/) - [Retail & Ecommerce](https://concentrus.staphaus.net/netsuite-for-retailers/) - [Medical Device](https://concentrus.staphaus.net/netsuite-medical-device/) - [Food & Beverage](https://concentrus.staphaus.net/netsuite-for-food-beverage/) - [Software](https://concentrus.staphaus.net/netsuite-for-software/) - [Non-Profit](https://concentrus.staphaus.net/netsuite-for-non-profit/) - [Service Industries](https://concentrus.staphaus.net/netsuite-for-service-industries/) - [Acumatica](https://concentrus.staphaus.net/acumatica/) - [Wholesale Distribution](https://concentrus.staphaus.net/acumatica-for-wholesale-distribution/) - [Manufacturing](https://concentrus.staphaus.net/acumatica-for-manufacturing/) - [Retail & Ecommerce](https://concentrus.staphaus.net/acumatica-for-retailers/) - [Food & Beverage](https://concentrus.staphaus.net/acumatica-for-food-beverage/) - [Non-Profit](https://concentrus.staphaus.net/acumatica-for-non-profit/) - [Construction](https://concentrus.staphaus.net/acumatica-for-construction/) - [Service Industries](https://concentrus.staphaus.net/acumatica-for-service-industries/) - [Industries](https://concentrus.staphaus.net/industries/) - [Why Concentrus](http://www.concentrus.com/why-concentrus/) - [About Us](http://www.concentrus.com/about-us/) - [Our Team](http://www.concentrus.com/our-team/) - [Pricing](http://concentrus.com/pricing/) - Resources - [Resources & Testimonials](http://concentrus.com/resources/) - [Blog](https://blog.concentrus.com/) - [Contact us](http://concentrus.com/contact-us/) - [Talk to an Expert](https://concentrus.staphaus.net/free-assessment/) - [Client Support](http://concentrus.com/support-2/) - [Careers](http://concentrus.com/careers/) - [Events](http://concentrus.com/events/) # Steps to Create the Chart of Accounts in NetSuite Posted by [Nicole Watson, Senior NetSuite Consultant](https://blog.concentrus.com/author/nicole-watson) on Oct 12, 2021 12:38:19 PM ![Nicole Watson, Senior NetSuite Consultant](https://blog.concentrus.com/hubfs/Nicole-3bc7056e.png) Find me on: [LinkedIn](https://www.linkedin.com/in/ncwatson79/) - [Tweet](https://twitter.com/share) ![pexels-photo-7821548](https://blog.concentrus.com/hs-fs/hubfs/pexels-photo-7821548.jpeg?width=324&name=pexels-photo-7821548.jpeg) Before NetSuite consulting, I worked in corporate accounting for several years as a CPA. From my NetSuite implementation experience, I have come to find it helpful to share the following information when thinking about and configuring a chart of accounts in NetSuite for the first time – or even if you are re-designing your chart of accounts. I hope you find the information below helpful when thinking about and creating your chart of accounts in NetSuite. 1. **Export** the chart of accounts from your legacy system into an Excel-type format. *Suggested fields in Excel to gear-up for import include account number, account type, account name, subaccount of, summary, description, and the following if applicable: currency, inventory, subsidiaries, include children subsidiaries, and intercompany elimination.* 1. Review and discuss the ‘**Best Practices to Consider When Creating GL Accounts in NetSuite**’ at the bottom of this blog; revise the exported legacy-system chart of accounts file as needed. 1. *Goal of this step is to have a COA Excel/CSV file ready for import into NetSuite.* 1. **System configuration** in NetSuite: 1. Enable Accounting Preference to use account numbers. 2. Enable NetSuite Features that are known to be required. 1. System-generated GL Accounts in NetSuite are created automatically when features are enabled. 2. The following table provides some of the features and their respective system-generated accounts: ![coa 1](https://blog.concentrus.com/hs-fs/hubfs/coa%201.png?width=652&name=coa%201.png)![coa 2](https://blog.concentrus.com/hs-fs/hubfs/coa%202.png?width=657&name=coa%202.png) - - - Configure the subsidiary structure in NetSuite, if applicable. - Configure currency in NetSuite, if applicable. 1. 1.   1. **Configure Chart of Accounts** in NetSuite 1. In your COA Excel file, insert before Column A for a field called “***External ID***”. Copy the account numbers into this field. 2. ***Compare*** your legacy system accounts with the NetSuite system-generated GL accounts 1. It is recommended that you use the NetSuite system-generated GL accounts where possible due to native functionality built within NetSuite. 2. You will need to ‘edit’ the system-generated GL accounts in NetSuite to revise the account number and/or name, if necessary, to match your legacy account number/name. - Note: It is recommended that you remove these accounts from your import file, so you don’t accidentally import/create them again. 1. ***Create Summary GL Accounts*** in NetSuite 1. This can be done manually if there are a few accounts; otherwise, this can be a separate CSV import. 2. ***Create remaining GL accounts*** in NetSuite via CSV import. 3. ***Review and verify COA list*** in NetSuite. There are a few other ancillary considerations, like classification restrictions and 1099-MISC Categories, that you might need when setting-up a chart of accounts in NetSuite; however, the information above should be sufficient to get your initial setup. If you need any NetSuite support, are in the middle of a NetSuite implementation, or are deciding if NetSuite is your next ERP system, please reach out to us at Concentrus. Our consultants are ready to support you. **Best Practices to Consider When Creating GL Accounts in NetSuite** - **ONE-WORLD/MULTIPLE SUBSIDIARIES (if applicable)** - The OneWorld NetSuite environment is designed to have **one** chart of accounts to be used across all subsidiaries. It is best practice to allow all subsidiaries to share GL accounts; however, we understand that there are some instances where this might not be feasible. When designing your chart of accounts for NetSuite, some things to consider regarding subsidiaries: - Can you share GL accounts across all subsidiaries? - ***Exception: Bank and Credit Card account types can only be assigned to one subsidiary!*** - Do you have any business reasons to allow one subsidiary to use a GL account but not another subsidiary? - **GL ACCOUNT TYPES** - Paying careful attention to account types when setting up the chart of accounts will result in more useful financial reports. - Account types in NetSuite are as follows: ![](https://blog.concentrus.com/hubfs/image-png-Oct-12-2021-07-32-16-03-PM.png) - **B*ank accounts and credit card accounts are restricted to one subsidiar****y* in NetSuite OneWorld. When you create a bank account or credit card account, you can select only one subsidiary for the account - ***Accounts Receivable*** type will reflect in AR Aging reports. - ***Accounts Payable*** type will reflect in AP Aging reports. - **GL ACCOUNT NAMES** - Duplicate account names are not allowed in NetSuite. - **SUMMARY GL ACCOUNTS FOR REPORTING PURPOSES** - NetSuite enables you to create an account record solely for reporting purposes. These accounts are called summary accounts and are useful when you want to create a non-posting, inactive parent account that has active child accounts. Take advantage of summarizing similar accounts by using Parent-Child relationships. - Parent “Summary” GL Accounts can act as subtotals for natural accounts that are similar in nature. - As an example: Telecom & Data (PARENT, Summary, Non-posting), Telephone & Conferencing (CHILD, posting), Cellular Phone (CHILD, posting), Internet (CHILD, posting) - In your COA Excel file, make sure - “Children” accounts have the ‘Subaccount of’ field populated with the Parent account number. - “Parent” accounts have the ‘Summary’ field populated with “TRUE”. - *Note: Summary accounts for parent/children relationships must be of the same account type.* - **USING NETSUITE CLASSIFICATIONS (SEGMENTS)** - **Financial Segments** – class, department, location, and subsidiary - NetSuite native financial segments are optional to enable. The requirement to use financial segments is determined based on how the organization is structured, what type or reporting is required and the desired level of visibility into business transactions. - NetSuite offers the flexibility to have additional custom GL segments if necessary. - **Eliminate embedding logic into the GL account structure; avoid the following if possible:** - Try to avoid creating unique GL accounts for each unique subsidiary – NetSuite OneWorld has a single chart of accounts (excluding bank GL accounts and credit card GL accounts) - Try to avoid creating revenue accounts for each type of product/service sold, instead consider using a Class financial segment/classification - Example: ![](https://blog.concentrus.com/hubfs/image-png-Oct-12-2021-07-33-20-10-PM.png) - Try to avoid creating GL accounts to record expenses for each unique department, instead consider using a Department financial segment/classification - Example: ![](https://blog.concentrus.com/hubfs/image-png-Oct-12-2021-07-33-55-25-PM.png)   - Try to avoid creating GL accounts to record financial transactions by location, instead consider using a Location financial segment/classification - Example: ![](https://blog.concentrus.com/hubfs/image-png-Oct-12-2021-07-34-21-10-PM.png) - **Use-case scenarios for the different classifications/segments in NetSuite:** **![](https://blog.concentrus.com/hubfs/image-png-Oct-12-2021-07-34-41-36-PM.png)** - **ACCOUNT NUMBERING** - NetSuite best practice is to use GL account numbers to group accounts similar in nature. This helps keep the COA organized and easier to maintain. Review the legacy account number to determine if best practice rules are followed; if account numbers are all mixed up, then opportunity to discuss re-numbering. - Typical number scheme: ![](https://blog.concentrus.com/hubfs/image-png-Oct-12-2021-07-34-56-19-PM.png)    - Assign General Ledger Account Numbers, if not already assigned - Duplicate account numbers are not allowed in NetSuite. - Organize your account hierarchies, naming, and numbering to simplify the future addition of new accounts. - For example: - Bank Account numbers 1000, 1010, 1020, 1030, 1050 – leaving space in between to add future accounts - Current Asset account numbers 1200, 1210, 1220, 1230 – leaving space in between to add future accounts - Revenue account numbers 4000, 4010, 4020, 4030 – leaving space in between to add future accounts - Expense account numbers 6000, 6005, 6010, 6015, 6020 – leaving space in between to add future accounts **About Us**   Concentrus is a complete NetSuite solutions provider that guides organizations through how to use NetSuite to reach highly focused business goals and objectives. We provide NetSuite implementation, developer, integration, and customization services to ensure that you have a long-term solution that is tailored to fit your systems, people, and processes.   Read About Our [Implementation Methodology](https://www.concentrus.com/implementation-methodology/)   Want more NetSuite Tips and Tricks? Check out our [Short & 'Suite ](https://www.youtube.com/watch?v=HRe7GRtT_-M)[videos](https://www.youtube.com/watch?v=HRe7GRtT_-M)       Tags: [NetSuite How To's](https://blog.concentrus.com/tag/netsuite-how-tos), [NetSuite Tips](https://blog.concentrus.com/tag/netsuite-tips) ### Subscribe to our blog! ### Recent Posts ### Posts by Topic - [NetSuite How To's (334)](https://blog.concentrus.com/tag/netsuite-how-tos) - [NetSuite (290)](https://blog.concentrus.com/tag/netsuite) - [NetSuite Tips (273)](https://blog.concentrus.com/tag/netsuite-tips) - [ERP (245)](https://blog.concentrus.com/tag/erp) - [NetSuite Partner (191)](https://blog.concentrus.com/tag/netsuite-partner) - [Reporting (187)](https://blog.concentrus.com/tag/reporting) - [Project Management (120)](https://blog.concentrus.com/tag/project-management) - [Netsuite ERP (69)](https://blog.concentrus.com/tag/netsuite-erp) - [NetSuite Administrator (59)](https://blog.concentrus.com/tag/netsuite-administrator) - [Netsuite Updates (53)](https://blog.concentrus.com/tag/netsuite-updates) - [Accounting (43)](https://blog.concentrus.com/tag/accounting) - [NetSuite Integrations (43)](https://blog.concentrus.com/tag/netsuite-integrations) - [NetSuite Features (35)](https://blog.concentrus.com/tag/netsuite-features) - [Acumatica ERP (28)](https://blog.concentrus.com/tag/acumatica-erp) - [Acumatica (27)](https://blog.concentrus.com/tag/acumatica) - [Cloud ERP (27)](https://blog.concentrus.com/tag/cloud-erp) - [NetSuite Support (27)](https://blog.concentrus.com/tag/netsuite-support) - [cloud-based ERP (27)](https://blog.concentrus.com/tag/cloud-based-erp) - [Shortcuts (23)](https://blog.concentrus.com/tag/shortcuts) - [Inventory Management (21)](https://blog.concentrus.com/tag/inventory-management) - [SuiteScript (20)](https://blog.concentrus.com/tag/suitescript) - [dashboard (17)](https://blog.concentrus.com/tag/dashboard) - [Financial (16)](https://blog.concentrus.com/tag/financial) - [Warehouse Management System (WMS) (16)](https://blog.concentrus.com/tag/warehouse-management-system-wms) - [Saved Search (15)](https://blog.concentrus.com/tag/saved-search) - [Business Benefits (14)](https://blog.concentrus.com/tag/business-benefits) - [Project Managing (14)](https://blog.concentrus.com/tag/project-managing) - [eCommerce (14)](https://blog.concentrus.com/tag/ecommerce) - [Retail (13)](https://blog.concentrus.com/tag/retail) - [Transactions (13)](https://blog.concentrus.com/tag/transactions) - [People Management (12)](https://blog.concentrus.com/tag/people-management) - [Troubleshoot (12)](https://blog.concentrus.com/tag/troubleshoot) - [WMS (12)](https://blog.concentrus.com/tag/wms) - [Customize (11)](https://blog.concentrus.com/tag/customize) - [Netsuite WMS (11)](https://blog.concentrus.com/tag/netsuite-wms) - [Shipping (11)](https://blog.concentrus.com/tag/shipping) - [Customer Service (10)](https://blog.concentrus.com/tag/customer-service) - [Digital Mailroom Services (10)](https://blog.concentrus.com/tag/digital-mailroom-services) - [Document Capture Software (10)](https://blog.concentrus.com/tag/document-capture-software) - [ERP Projects (10)](https://blog.concentrus.com/tag/erp-projects) - [Mailroom Automation (10)](https://blog.concentrus.com/tag/mailroom-automation) - [Project (10)](https://blog.concentrus.com/tag/project) - [data (10)](https://blog.concentrus.com/tag/data) - [electronic mailroom (10)](https://blog.concentrus.com/tag/electronic-mailroom) - [Pros Cons (9)](https://blog.concentrus.com/tag/pros-cons) - [Supply Chain Management (9)](https://blog.concentrus.com/tag/supply-chain-management) - [CSV Import (8)](https://blog.concentrus.com/tag/csv-import) - [Customization (8)](https://blog.concentrus.com/tag/customization) - [Manufacturing (8)](https://blog.concentrus.com/tag/manufacturing) - [New User (8)](https://blog.concentrus.com/tag/new-user) - [Self Implementation (8)](https://blog.concentrus.com/tag/self-implementation) - [Wholesale Distribution (8)](https://blog.concentrus.com/tag/wholesale-distribution) - [Implementation (7)](https://blog.concentrus.com/tag/implementation) - [Items (7)](https://blog.concentrus.com/tag/items) - [Sales Order (7)](https://blog.concentrus.com/tag/sales-order) - [Virtual Mailroom (7)](https://blog.concentrus.com/tag/virtual-mailroom) - [Customer Records (6)](https://blog.concentrus.com/tag/customer-records) - [Fixed Asset (6)](https://blog.concentrus.com/tag/fixed-asset) - [Pricing Groups (6)](https://blog.concentrus.com/tag/pricing-groups) - [Purchase Order (6)](https://blog.concentrus.com/tag/purchase-order) - [Training (6)](https://blog.concentrus.com/tag/training) - [Transaction Lines (6)](https://blog.concentrus.com/tag/transaction-lines) - [Bank Account (5)](https://blog.concentrus.com/tag/bank-account) - [Bank Reconciliation (5)](https://blog.concentrus.com/tag/bank-reconciliation) - [Costing (5)](https://blog.concentrus.com/tag/costing) - [Custom Fields (5)](https://blog.concentrus.com/tag/custom-fields) - [Fixed Asset Management (5)](https://blog.concentrus.com/tag/fixed-asset-management) - [Go Live (5)](https://blog.concentrus.com/tag/go-live) - [Group Pricing (5)](https://blog.concentrus.com/tag/group-pricing) - [Inventory (5)](https://blog.concentrus.com/tag/inventory) - [Inventory Costing (5)](https://blog.concentrus.com/tag/inventory-costing) - [Open Balance Upload (5)](https://blog.concentrus.com/tag/open-balance-upload) - [Open Transaction Upload (5)](https://blog.concentrus.com/tag/open-transaction-upload) - [Prices (5)](https://blog.concentrus.com/tag/prices) - [Pricing (5)](https://blog.concentrus.com/tag/pricing) - [Project Time Entry (5)](https://blog.concentrus.com/tag/project-time-entry) - [User Access (5)](https://blog.concentrus.com/tag/user-access) - [Work Order (5)](https://blog.concentrus.com/tag/work-order) - [Bill Payment (4)](https://blog.concentrus.com/tag/bill-payment) - [Bill of Materials (4)](https://blog.concentrus.com/tag/bill-of-materials) - [COGS (4)](https://blog.concentrus.com/tag/cogs) - [Company News (4)](https://blog.concentrus.com/tag/company-news) - [Financial Report (4)](https://blog.concentrus.com/tag/financial-report) - [Integrations (4)](https://blog.concentrus.com/tag/integrations) - [Netsuite Language (4)](https://blog.concentrus.com/tag/netsuite-language) - [Promotions (4)](https://blog.concentrus.com/tag/promotions) - [Roles (4)](https://blog.concentrus.com/tag/roles) - [Segmentation (4)](https://blog.concentrus.com/tag/segmentation) - [ShipCentral (4)](https://blog.concentrus.com/tag/shipcentral) - [SuiteApp (4)](https://blog.concentrus.com/tag/suiteapp) - [SuitePromotion (4)](https://blog.concentrus.com/tag/suitepromotion) - [Support (4)](https://blog.concentrus.com/tag/support) - [Third-party (4)](https://blog.concentrus.com/tag/third-party) - [Users (4)](https://blog.concentrus.com/tag/users) - [Workflow (4)](https://blog.concentrus.com/tag/workflow) - [Accounting Periods (3)](https://blog.concentrus.com/tag/accounting-periods) - [Amortization (3)](https://blog.concentrus.com/tag/amortization) - [Bank Statements (3)](https://blog.concentrus.com/tag/bank-statements) - [Changing Schedules (3)](https://blog.concentrus.com/tag/changing-schedules) - [Customer Preference (3)](https://blog.concentrus.com/tag/customer-preference) - [Customer Returns (3)](https://blog.concentrus.com/tag/customer-returns) - [Discounts (3)](https://blog.concentrus.com/tag/discounts) - [Document Management Software (3)](https://blog.concentrus.com/tag/document-management-software) - [Document Scanning (3)](https://blog.concentrus.com/tag/document-scanning) - [Email Archiving (3)](https://blog.concentrus.com/tag/email-archiving) - [Errors (3)](https://blog.concentrus.com/tag/errors) - [Excel (3)](https://blog.concentrus.com/tag/excel) - [FAM (3)](https://blog.concentrus.com/tag/fam) - [General Ledger (3)](https://blog.concentrus.com/tag/general-ledger) - [Income Statement (3)](https://blog.concentrus.com/tag/income-statement) - [Insider (3)](https://blog.concentrus.com/tag/insider) - [Invoice Processing Automation (3)](https://blog.concentrus.com/tag/invoice-processing-automation) - [Item Pricing (3)](https://blog.concentrus.com/tag/item-pricing) - [Item Receipt (3)](https://blog.concentrus.com/tag/item-receipt) - [Item Returns (3)](https://blog.concentrus.com/tag/item-returns) - [Journal Entry (3)](https://blog.concentrus.com/tag/journal-entry) - [Order Fulfillment (3)](https://blog.concentrus.com/tag/order-fulfillment) - [Pack Station (3)](https://blog.concentrus.com/tag/pack-station) - [Paperless Office Solutions (3)](https://blog.concentrus.com/tag/paperless-office-solutions) - [Record Management (3)](https://blog.concentrus.com/tag/record-management) - [Return Costings (3)](https://blog.concentrus.com/tag/return-costings) - [Subsidiary (3)](https://blog.concentrus.com/tag/subsidiary) - [SuiteScript 2.1 (3)](https://blog.concentrus.com/tag/suitescript-2-1) - [TroubleShooting (3)](https://blog.concentrus.com/tag/troubleshooting) - [Vendor (3)](https://blog.concentrus.com/tag/vendor) - [Vendor Bill (3)](https://blog.concentrus.com/tag/vendor-bill) - [Vendor Payments (3)](https://blog.concentrus.com/tag/vendor-payments) - [Warehouse (3)](https://blog.concentrus.com/tag/warehouse) - [Work-In-Process (3)](https://blog.concentrus.com/tag/work-in-process) - [API (2)](https://blog.concentrus.com/tag/api) - [Administrator (2)](https://blog.concentrus.com/tag/administrator) - [Amount Due (2)](https://blog.concentrus.com/tag/amount-due) - [Assemblies (2)](https://blog.concentrus.com/tag/assemblies) - [Assembly Items (2)](https://blog.concentrus.com/tag/assembly-items) - [BOM (2)](https://blog.concentrus.com/tag/bom) - [Bank Feeds (2)](https://blog.concentrus.com/tag/bank-feeds) - [Billable Time (2)](https://blog.concentrus.com/tag/billable-time) - [Bills (2)](https://blog.concentrus.com/tag/bills) - [CSV (2)](https://blog.concentrus.com/tag/csv) - [Change Order (2)](https://blog.concentrus.com/tag/change-order) - [Changing Subsidiary (2)](https://blog.concentrus.com/tag/changing-subsidiary) - [Charges (2)](https://blog.concentrus.com/tag/charges) - [Client Script (2)](https://blog.concentrus.com/tag/client-script) - [Connectors (2)](https://blog.concentrus.com/tag/connectors) - [Create (2)](https://blog.concentrus.com/tag/create) - [Currency (2)](https://blog.concentrus.com/tag/currency) - [Data Migration (2)](https://blog.concentrus.com/tag/data-migration) - [Date Mismatch (2)](https://blog.concentrus.com/tag/date-mismatch) - [Email Management (2)](https://blog.concentrus.com/tag/email-management) - [Engineering (2)](https://blog.concentrus.com/tag/engineering) - [Food (2)](https://blog.concentrus.com/tag/food) - [GL (2)](https://blog.concentrus.com/tag/gl) - [Global Search (2)](https://blog.concentrus.com/tag/global-search) - [HTML (2)](https://blog.concentrus.com/tag/html) - [Hard Assets (2)](https://blog.concentrus.com/tag/hard-assets) - [History Record (2)](https://blog.concentrus.com/tag/history-record) - [Implementing (2)](https://blog.concentrus.com/tag/implementing) - [Implementing Subsidiary (2)](https://blog.concentrus.com/tag/implementing-subsidiary) - [International Shipping (2)](https://blog.concentrus.com/tag/international-shipping) - [Inventory Status (2)](https://blog.concentrus.com/tag/inventory-status) - [Item Fulfillment (2)](https://blog.concentrus.com/tag/item-fulfillment) - [Kits and Packages (2)](https://blog.concentrus.com/tag/kits-and-packages) - [Layout (2)](https://blog.concentrus.com/tag/layout) - [Lease Payments (2)](https://blog.concentrus.com/tag/lease-payments) - [Marketing (2)](https://blog.concentrus.com/tag/marketing) - [NetSuite Scripts (2)](https://blog.concentrus.com/tag/netsuite-scripts) - [New or Adding Subsidiary (2)](https://blog.concentrus.com/tag/new-or-adding-subsidiary) - [Not Calculating (2)](https://blog.concentrus.com/tag/not-calculating) - [On-Premise ERP (2)](https://blog.concentrus.com/tag/on-premise-erp) - [Pack (2)](https://blog.concentrus.com/tag/pack) - [Price Levels (2)](https://blog.concentrus.com/tag/price-levels) - [Product Review (2)](https://blog.concentrus.com/tag/product-review) - [Purchase Request (2)](https://blog.concentrus.com/tag/purchase-request) - [Reconciliation (2)](https://blog.concentrus.com/tag/reconciliation) - [Release 2025.1 (2)](https://blog.concentrus.com/tag/release-2025-1) - [Routing (2)](https://blog.concentrus.com/tag/routing) - [Sales (2)](https://blog.concentrus.com/tag/sales) - [Sales Tax (2)](https://blog.concentrus.com/tag/sales-tax) - [Standard Cost (2)](https://blog.concentrus.com/tag/standard-cost) - [T&M (2)](https://blog.concentrus.com/tag/tm) - [Time and Material (2)](https://blog.concentrus.com/tag/time-and-material) - [User Event Script (2)](https://blog.concentrus.com/tag/user-event-script) - [Warehouse Management (2)](https://blog.concentrus.com/tag/warehouse-management) - [Warehousing (2)](https://blog.concentrus.com/tag/warehousing) - [Wave (2)](https://blog.concentrus.com/tag/wave) - [Wave Release (2)](https://blog.concentrus.com/tag/wave-release) - [Workflow Instance (2)](https://blog.concentrus.com/tag/workflow-instance) - [Zone (2)](https://blog.concentrus.com/tag/zone) - [asset management (2)](https://blog.concentrus.com/tag/asset-management) - [suitelet (2)](https://blog.concentrus.com/tag/suitelet) - [2FA (1)](https://blog.concentrus.com/tag/2fa) - [AI (1)](https://blog.concentrus.com/tag/ai) - [AP Aging (1)](https://blog.concentrus.com/tag/ap-aging) - [Account Center (1)](https://blog.concentrus.com/tag/account-center) - [Accounting Preferences (1)](https://blog.concentrus.com/tag/accounting-preferences) - [Accounts Payable (1)](https://blog.concentrus.com/tag/accounts-payable) - [Advanced BOM (1)](https://blog.concentrus.com/tag/advanced-bom) - [Alias (1)](https://blog.concentrus.com/tag/alias) - [Aliases (1)](https://blog.concentrus.com/tag/aliases) - [Artificial Intelligent (1)](https://blog.concentrus.com/tag/artificial-intelligent) - [Asset Record (1)](https://blog.concentrus.com/tag/asset-record) - [Asset Transfer (1)](https://blog.concentrus.com/tag/asset-transfer) - [Authentication (1)](https://blog.concentrus.com/tag/authentication) - [Authorized Contacts (1)](https://blog.concentrus.com/tag/authorized-contacts) - [Auto-Expansion (1)](https://blog.concentrus.com/tag/auto-expansion) - [Automated Emails (1)](https://blog.concentrus.com/tag/automated-emails) - [Automation (1)](https://blog.concentrus.com/tag/automation) - [AvaTax (1)](https://blog.concentrus.com/tag/avatax) - [Avalara (1)](https://blog.concentrus.com/tag/avalara) - [BIN (1)](https://blog.concentrus.com/tag/bin) - [Balance Sheet (1)](https://blog.concentrus.com/tag/balance-sheet) - [Bank Data (1)](https://blog.concentrus.com/tag/bank-data) - [Bank Reconciliation Errors (1)](https://blog.concentrus.com/tag/bank-reconciliation-errors) - [Basic PDF Print (1)](https://blog.concentrus.com/tag/basic-pdf-print) - [Beverages (1)](https://blog.concentrus.com/tag/beverages) - [Billing (1)](https://blog.concentrus.com/tag/billing) - [Bin Transfer (1)](https://blog.concentrus.com/tag/bin-transfer) - [Bounced Emails (1)](https://blog.concentrus.com/tag/bounced-emails) - [Bulk Updates (1)](https://blog.concentrus.com/tag/bulk-updates) - [CASE (1)](https://blog.concentrus.com/tag/case) - [COA (1)](https://blog.concentrus.com/tag/coa) - [CSV Import Mappings (1)](https://blog.concentrus.com/tag/csv-import-mappings) - [Calculate Total (1)](https://blog.concentrus.com/tag/calculate-total) - [Carton (1)](https://blog.concentrus.com/tag/carton) - [Case Studies (1)](https://blog.concentrus.com/tag/case-studies) - [Cash Sale (1)](https://blog.concentrus.com/tag/cash-sale) - [Cell Phone Industry (1)](https://blog.concentrus.com/tag/cell-phone-industry) - [Chart of Accounts (1)](https://blog.concentrus.com/tag/chart-of-accounts) - [Classification (1)](https://blog.concentrus.com/tag/classification) - [Components (1)](https://blog.concentrus.com/tag/components) - [Concurrency (1)](https://blog.concentrus.com/tag/concurrency) - [Configuration (1)](https://blog.concentrus.com/tag/configuration) - [Consolidated Exchange Rates (1)](https://blog.concentrus.com/tag/consolidated-exchange-rates) - [Copy to Account (1)](https://blog.concentrus.com/tag/copy-to-account) - [Correct Depreciation (1)](https://blog.concentrus.com/tag/correct-depreciation) - [Cost Accounting (1)](https://blog.concentrus.com/tag/cost-accounting) - [Costed BOM (1)](https://blog.concentrus.com/tag/costed-bom) - [Country List (1)](https://blog.concentrus.com/tag/country-list) - [Coupons (1)](https://blog.concentrus.com/tag/coupons) - [Credit Hold (1)](https://blog.concentrus.com/tag/credit-hold) - [Credit Memo (1)](https://blog.concentrus.com/tag/credit-memo) - [Cumulative Depreciation (1)](https://blog.concentrus.com/tag/cumulative-depreciation) - [Customer Refund (1)](https://blog.concentrus.com/tag/customer-refund) - [Cycle Count (1)](https://blog.concentrus.com/tag/cycle-count) - [Data Analysis (1)](https://blog.concentrus.com/tag/data-analysis) - [Database Connectivity (1)](https://blog.concentrus.com/tag/database-connectivity) - [Defective Inventory (1)](https://blog.concentrus.com/tag/defective-inventory) - [Docusign (1)](https://blog.concentrus.com/tag/docusign) - [Dynamic Allocations (1)](https://blog.concentrus.com/tag/dynamic-allocations) - [EBITDA (1)](https://blog.concentrus.com/tag/ebitda) - [Edit (1)](https://blog.concentrus.com/tag/edit) - [Electronic Signature (1)](https://blog.concentrus.com/tag/electronic-signature) - [Employee Center (1)](https://blog.concentrus.com/tag/employee-center) - [Enhancement (1)](https://blog.concentrus.com/tag/enhancement) - [Entity/Use Code (1)](https://blog.concentrus.com/tag/entity-use-code) - [Environment Variables (1)](https://blog.concentrus.com/tag/environment-variables) - [Estimates Feature (1)](https://blog.concentrus.com/tag/estimates-feature) - [Expenses (1)](https://blog.concentrus.com/tag/expenses) - [FTP (1)](https://blog.concentrus.com/tag/ftp) - [Fees (1)](https://blog.concentrus.com/tag/fees) - [Field Mapping (1)](https://blog.concentrus.com/tag/field-mapping) - [Field Service Management (1)](https://blog.concentrus.com/tag/field-service-management) - [Financial Data Management (1)](https://blog.concentrus.com/tag/financial-data-management) - [Fixed Asset Module (1)](https://blog.concentrus.com/tag/fixed-asset-module) - [Food Industry (1)](https://blog.concentrus.com/tag/food-industry) - [Food and Service (1)](https://blog.concentrus.com/tag/food-and-service) - [Formula (1)](https://blog.concentrus.com/tag/formula) - [Gift Certificates (1)](https://blog.concentrus.com/tag/gift-certificates) - [Governance (1)](https://blog.concentrus.com/tag/governance) - [Grant (1)](https://blog.concentrus.com/tag/grant) - [Handling (1)](https://blog.concentrus.com/tag/handling) - [Help Desk (1)](https://blog.concentrus.com/tag/help-desk) - [If-Then (1)](https://blog.concentrus.com/tag/if-then) - [Inline Editing (1)](https://blog.concentrus.com/tag/inline-editing) - [Installments (1)](https://blog.concentrus.com/tag/installments) - [Intelligent Item Recommendations (1)](https://blog.concentrus.com/tag/intelligent-item-recommendations) - [Intercompany Accounts (1)](https://blog.concentrus.com/tag/intercompany-accounts) - [Internal Case Support (1)](https://blog.concentrus.com/tag/internal-case-support) - [Internal IDs (1)](https://blog.concentrus.com/tag/internal-ids) - [Invalid Key (1)](https://blog.concentrus.com/tag/invalid-key) - [Inventory Allocation (1)](https://blog.concentrus.com/tag/inventory-allocation) - [Inventory Commitment (1)](https://blog.concentrus.com/tag/inventory-commitment) - [Inventory Control (1)](https://blog.concentrus.com/tag/inventory-control) - [Inventory Cost Revaluation (1)](https://blog.concentrus.com/tag/inventory-cost-revaluation) - [Inventory Counts (1)](https://blog.concentrus.com/tag/inventory-counts) - [Invoicing (1)](https://blog.concentrus.com/tag/invoicing) - [Item Alias (1)](https://blog.concentrus.com/tag/item-alias) - [Item Alternatives (1)](https://blog.concentrus.com/tag/item-alternatives) - [Item Substitution (1)](https://blog.concentrus.com/tag/item-substitution) - [Item Types (1)](https://blog.concentrus.com/tag/item-types) - [KPI (1)](https://blog.concentrus.com/tag/kpi) - [KPI Scorecard (1)](https://blog.concentrus.com/tag/kpi-scorecard) - [Kit/Package Items (1)](https://blog.concentrus.com/tag/kit-package-items) - [Landed Cost (1)](https://blog.concentrus.com/tag/landed-cost) - [Language (1)](https://blog.concentrus.com/tag/language) - [Language Preference (1)](https://blog.concentrus.com/tag/language-preference) - [Lease (1)](https://blog.concentrus.com/tag/lease) - [Limitation (1)](https://blog.concentrus.com/tag/limitation) - [Location (1)](https://blog.concentrus.com/tag/location) - [Locked Period (1)](https://blog.concentrus.com/tag/locked-period) - [Lot Number (1)](https://blog.concentrus.com/tag/lot-number) - [Lot Trace (1)](https://blog.concentrus.com/tag/lot-trace) - [Mass Email Management (1)](https://blog.concentrus.com/tag/mass-email-management) - [Mass Updates (1)](https://blog.concentrus.com/tag/mass-updates) - [Mobile Access (1)](https://blog.concentrus.com/tag/mobile-access) - [Multi-Match (1)](https://blog.concentrus.com/tag/multi-match) - [Multicurrency (1)](https://blog.concentrus.com/tag/multicurrency) - [NAFTA (1)](https://blog.concentrus.com/tag/nafta) - [Net Book Value (1)](https://blog.concentrus.com/tag/net-book-value) - [NetSuite Best Practices (1)](https://blog.concentrus.com/tag/netsuite-best-practices) - [NetSuite CRM/Support (1)](https://blog.concentrus.com/tag/netsuite-crm-support) - [NetSuite Error Handling (1)](https://blog.concentrus.com/tag/netsuite-error-handling) - [NetSuite Gift Card (1)](https://blog.concentrus.com/tag/netsuite-gift-card) - [NetSuite to NetSuite (1)](https://blog.concentrus.com/tag/netsuite-to-netsuite) - [Netsuite Fees (1)](https://blog.concentrus.com/tag/netsuite-fees) - [Netsuite Tier (1)](https://blog.concentrus.com/tag/netsuite-tier) - [Non-GL Changes (1)](https://blog.concentrus.com/tag/non-gl-changes) - [Not Exist When Save (1)](https://blog.concentrus.com/tag/not-exist-when-save) - [OCI Database (1)](https://blog.concentrus.com/tag/oci-database) - [ODBC (1)](https://blog.concentrus.com/tag/odbc) - [OneWorld (1)](https://blog.concentrus.com/tag/oneworld) - [Online Case Form (1)](https://blog.concentrus.com/tag/online-case-form) - [Online Customer Forms (1)](https://blog.concentrus.com/tag/online-customer-forms) - [Overdue Issue (1)](https://blog.concentrus.com/tag/overdue-issue) - [Oversized Items (1)](https://blog.concentrus.com/tag/oversized-items) - [PDF Formatting (1)](https://blog.concentrus.com/tag/pdf-formatting) - [PM (1)](https://blog.concentrus.com/tag/pm) - [PO Rate (1)](https://blog.concentrus.com/tag/po-rate) - [Pay Bills (1)](https://blog.concentrus.com/tag/pay-bills) - [Performance (1)](https://blog.concentrus.com/tag/performance) - [Permissions (1)](https://blog.concentrus.com/tag/permissions) - [Pick (1)](https://blog.concentrus.com/tag/pick) - [Popup (1)](https://blog.concentrus.com/tag/popup) - [Postman (1)](https://blog.concentrus.com/tag/postman) - [Pricing Schedules (1)](https://blog.concentrus.com/tag/pricing-schedules) - [Print Offsets (1)](https://blog.concentrus.com/tag/print-offsets) - [Purchase Price (1)](https://blog.concentrus.com/tag/purchase-price) - [Purchase Requisitions (1)](https://blog.concentrus.com/tag/purchase-requisitions) - [Quality Assurance (1)](https://blog.concentrus.com/tag/quality-assurance) - [Quantity Pricing (1)](https://blog.concentrus.com/tag/quantity-pricing) - [RESTlet (1)](https://blog.concentrus.com/tag/restlet) - [RMA (1)](https://blog.concentrus.com/tag/rma) - [Reclass (1)](https://blog.concentrus.com/tag/reclass) - [Record (1)](https://blog.concentrus.com/tag/record) - [Record Lock (1)](https://blog.concentrus.com/tag/record-lock) - [Release 2025.2 (1)](https://blog.concentrus.com/tag/release-2025-2) - [Release Preview (1)](https://blog.concentrus.com/tag/release-preview) - [Request Different Dates (1)](https://blog.concentrus.com/tag/request-different-dates) - [Reseller Permit (1)](https://blog.concentrus.com/tag/reseller-permit) - [Return Authorizations (1)](https://blog.concentrus.com/tag/return-authorizations) - [Revaluation (1)](https://blog.concentrus.com/tag/revaluation) - [Revenue Management (1)](https://blog.concentrus.com/tag/revenue-management) - [Revenue Recognition (1)](https://blog.concentrus.com/tag/revenue-recognition) - [Reverse Void (1)](https://blog.concentrus.com/tag/reverse-void) - [SCM Mobile (1)](https://blog.concentrus.com/tag/scm-mobile) - [SFTP (1)](https://blog.concentrus.com/tag/sftp) - [SOAP Logs (1)](https://blog.concentrus.com/tag/soap-logs) - [SOC (1)](https://blog.concentrus.com/tag/soc) - [Sage (1)](https://blog.concentrus.com/tag/sage) - [Sage ERP (1)](https://blog.concentrus.com/tag/sage-erp) - [Sales Order Form (1)](https://blog.concentrus.com/tag/sales-order-form) - [Schedule Saved Searches (1)](https://blog.concentrus.com/tag/schedule-saved-searches) - [Script Configuration (1)](https://blog.concentrus.com/tag/script-configuration) - [Scripted Records (1)](https://blog.concentrus.com/tag/scripted-records) - [Search (1)](https://blog.concentrus.com/tag/search) - [Segmentation Dependencies (1)](https://blog.concentrus.com/tag/segmentation-dependencies) - [Semicolon (1)](https://blog.concentrus.com/tag/semicolon) - [Set Preferences (1)](https://blog.concentrus.com/tag/set-preferences) - [Shared Library (1)](https://blog.concentrus.com/tag/shared-library) - [Shipping Form (1)](https://blog.concentrus.com/tag/shipping-form) - [Single Vendor (1)](https://blog.concentrus.com/tag/single-vendor) - [Special Order (1)](https://blog.concentrus.com/tag/special-order) - [State List (1)](https://blog.concentrus.com/tag/state-list) - [State Tax (1)](https://blog.concentrus.com/tag/state-tax) - [Statement (1)](https://blog.concentrus.com/tag/statement) - [Statistical Account (1)](https://blog.concentrus.com/tag/statistical-account) - [Statistical Journals (1)](https://blog.concentrus.com/tag/statistical-journals) - [Statistics (1)](https://blog.concentrus.com/tag/statistics) - [SuiteBundle (1)](https://blog.concentrus.com/tag/suitebundle) - [SuiteCloud (1)](https://blog.concentrus.com/tag/suitecloud) - [System Notes (1)](https://blog.concentrus.com/tag/system-notes) - [TBA (1)](https://blog.concentrus.com/tag/tba) - [Tax Codes (1)](https://blog.concentrus.com/tag/tax-codes) - [Tax Exemption (1)](https://blog.concentrus.com/tag/tax-exemption) - [Terms (1)](https://blog.concentrus.com/tag/terms) - [Time Entry (1)](https://blog.concentrus.com/tag/time-entry) - [Timing Out (1)](https://blog.concentrus.com/tag/timing-out) - [Traceability (1)](https://blog.concentrus.com/tag/traceability) - [Transaction Forms (1)](https://blog.concentrus.com/tag/transaction-forms) - [Transaction IDs (1)](https://blog.concentrus.com/tag/transaction-ids) - [Transaction Update (1)](https://blog.concentrus.com/tag/transaction-update) - [Transaction Usage (1)](https://blog.concentrus.com/tag/transaction-usage) - [Transform (1)](https://blog.concentrus.com/tag/transform) - [Traveler (1)](https://blog.concentrus.com/tag/traveler) - [Trend (1)](https://blog.concentrus.com/tag/trend) - [Trial Balances (1)](https://blog.concentrus.com/tag/trial-balances) - [UI Customization (1)](https://blog.concentrus.com/tag/ui-customization) - [UPC (1)](https://blog.concentrus.com/tag/upc) - [UPS (1)](https://blog.concentrus.com/tag/ups) - [Undeposited Funds (1)](https://blog.concentrus.com/tag/undeposited-funds) - [Unit (1)](https://blog.concentrus.com/tag/unit) - [Unit Types (1)](https://blog.concentrus.com/tag/unit-types) - [User Preference (1)](https://blog.concentrus.com/tag/user-preference) - [Vendor Name/Code (1)](https://blog.concentrus.com/tag/vendor-name-code) - [Void Check (1)](https://blog.concentrus.com/tag/void-check) - [WIP (1)](https://blog.concentrus.com/tag/wip) - [Warehouse Distribution (1)](https://blog.concentrus.com/tag/warehouse-distribution) - [Work Instructions (1)](https://blog.concentrus.com/tag/work-instructions) - [Zone Picking (1)](https://blog.concentrus.com/tag/zone-picking) - [compliance (1)](https://blog.concentrus.com/tag/compliance) - [esignature (1)](https://blog.concentrus.com/tag/esignature) - [file upload (1)](https://blog.concentrus.com/tag/file-upload) - [functionality (1)](https://blog.concentrus.com/tag/functionality) - [log (1)](https://blog.concentrus.com/tag/log) - [payment method (1)](https://blog.concentrus.com/tag/payment-method) - [save to file (1)](https://blog.concentrus.com/tag/save-to-file) - [snippet (1)](https://blog.concentrus.com/tag/snippet) see all ### Request a quote ![logo-h-white-1a7c2dfb](https://blog.concentrus.com/hubfs/Logos/logo-h-white-1a7c2dfb.png "logo-h-white-1a7c2dfb") Our values - Honesty, Humility, Collaboration and Innovation- define who we are. They drive us to deliver world class solutions that are results-driven and mutually profitable to both our clients and our team. We are a complete NetSuite Solutions Provider. That means that we provide NetSuite implementation, customization, integration, support, and training and help our clients get sustainable, long-term solutions to meet their business needs. ![O-NetSuite-SolutionProvider-horiz-wht-copy-035c932f](https://blog.concentrus.com/hubfs/O-NetSuite-SolutionProvider-horiz-wht-copy-035c932f.png "O-NetSuite-SolutionProvider-horiz-wht-copy-035c932f") #### [What is NetSuite](https://concentrus.com/what-is-netsuite) - [Role Based](https://concentrus.com/role-based) - [Industry](https://concentrus.com/industry) #### [Why Concentrus](https://concentrus.com/why-concentrus) - [About Us](https://concentrus.com/about-us/) - [Implementation Methodology](https://concentrus.com/implementation-methodology/) - [Customization, Development & Integrations](https://concentrus.com/customization-methodology/) - [Resources](https://concentrus.com/resources/) - [Blog](https://blog.concentrus.com/) ##### Customer Center - [My Account](https://4546731.app.netsuite.com/app/login/secure/privatelogin.nl?c=4546731) - [Support](https://concentrus.com/support-2) - [NetSuite Tips & Tricks](https://concentrus.com/short-and-suite) 1550 Valley Vista Drive, Diamond Bar, CA 91765   |   [877 348 1165](tel:+18773481165)   |   [Email Us](http://www.concentrus.com/contact)   |   [www.concentrus.com](http://www.concentrus.com)   |   [Privacy Policy](http://concentrus.staphaus.net/privacy-policy/) Copyright 2020. Concentrus. All rights reserved.