---
title: Open Transactions Data Migration at Go Live
description: Are you nearing the end of your NetSuite implementation and diving into the data migration of GL history and open transactions at Go Live? Are you wondering how open Accounts Receivable (AR), open Accounts Payable (AP), Inventory balances and outstanding checks will be migrated into NetSuite without duplicating the GL impact from GL history? As an accountant who implements NetSuite, I’d like to share some best practices on this with you.
image: https://blog.concentrus.com/hubfs/pexels-rodnae-productions-7821702.jpg
---

[![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/)

# Open Transactions Data Migration at Go Live

Posted by [Nicole Watson, Senior NetSuite Consultant](https://blog.concentrus.com/author/nicole-watson) on Nov 24, 2021 12:00:00 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-rodnae-productions-7821702](https://blog.concentrus.com/hs-fs/hubfs/pexels-rodnae-productions-7821702.jpg?width=756&name=pexels-rodnae-productions-7821702.jpg)

Are you nearing the end of your NetSuite implementation and diving into the data migration of GL history and open transactions at Go Live? Are you wondering how open Accounts Receivable (AR), open Accounts Payable (AP), Inventory balances and outstanding checks will be migrated into NetSuite without duplicating the GL impact from GL history? As an accountant who implements NetSuite, I’d like to share some best practices on this with you. 

When you bring over GL history Trial Balance net changes via journal entry, I suggest assigning a fictitious customer, such as ‘Data Migration Customer’, to the AR lines and a fictitious vendor, like ‘Data Migration Vendor’, to the AP lines. This helps isolate the data migration in the aging reports to the fictitious names instead of "no name", which might be used in business if a journal entry isn’t coded to a customer/vendor.

For open AR transactions, first you want to create an ‘Other Charge for Sale’ item and map the income account to a clearing GL account (e.g., 9999 OPEN AR DATA MIGRATION...you can make this the item name too). When you import the open customer invoices and credit memos into NetSuite, you will want to use the item: OPEN AR DATA MIGRATION on the line for the open amount. The GL impact of the invoice then debits AR and credits the 9999 clearing account. This allows you to accumulate the open AR in account 9999, which gives you one place to track what to reverse in the General Ledger for open AR. Once all open AR is in NetSuite and you verified open AR balances by customer, next you create a transaction saved search for account 9999\* to identify the GL data that needs to be reversed to avoid duplication in the ledger. Finally, you use the saved search to do a journal entry by period to reverse the GL impact of open AR (usually by debiting 9999 and crediting AR including any classifications and the fictitious customer). 

For Accounts Payable, it helps if you can pay all vendor bills and take all vendor credits before Go Live, as this will ensure you don’t have any open AP to migrate to NetSuite. However, this may not be possible, so I share with you that open AP follows the same concept as open AR with one exception: you don't need to create an item because vendor bills and credits can be coded directly to a GL account. First, you want to create a clearing GL account 9998 OPEN AP DATA MIGRATION, then import the open vendor bills and credits to the 9998 account on the line for the open amount. This accumulates the open AP in the 9998 account to give you a record of what to reverse from the General Ledger.  Once all open AP is in NetSuite and you verified open AP balances by vendor, then you create a transaction saved search for account 9998\* to determine the GL data that needs to be reversed to avoid duplication in the ledger. Finally, you use the saved search to do a journal entry by period to reverse the GL impact of open AP (usually by debiting AP and crediting 9998 including any classifications and the fictitious vendor).

The same concepts apply for inventory balances and outstanding bank checks. I create and use clearing GL account 9997 INVENTORY DATA MIGRATION for the inventory adjustment to bring in beginning inventory balances and clearing GL account 9996 OUTSTANDING CHECKS AT GO LIVE for a check transaction to represent each outstanding bank check from the last bank reconciliation before Go Live. This is a bit repetitive, but I use the clearing accounts to easily identify the GL impact to reverse with a journal entry to mitigate doubling amounts in the General Ledger.

\*Below is a suggestion for the transaction saved searches:  

- - - Criteria: Account = 9999, Main Line = False (this will give you all line detail) 
          - Results: Date, Period, Account, Name (Customer/Vendor), Subsidiary (for OneWorld users), Class, Department, Location, Amount 

The goal is to get the transaction saved search results similar to what you would need for a journal entry import. This will allow you to export the saved search and have it nearly prepared for import as a journal entry to reverse the GL impacts of the open transactions.

Finally, please note this blog excludes intercompany and multi-currency concepts, as these two factors introduce a complexity with GL history and open transactions during data migration at Go Live. If you’d like to learn more about NetSuite or need any NetSuite support, please reach out to us at Concentrus. Our consultants are ready to assist you. 

 

**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), [Accounting](https://blog.concentrus.com/tag/accounting), [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.