---
title: Tips for Open Balance and Open Transaction Uploads
description: Discover essential tips for a smooth NetSuite go-live with open balances and transactions. Learn how to map, verify, and adapt your data, while ensuring a stress-free transition. Contact Concentrus for expert guidance today.
image: https://lh6.googleusercontent.com/3pYyEPPDOY3Gcx0NLaqczmEiAMNRYkKFW37MthqPxLQiUAQqzqAd6VRXrgguhNP-eeMEt4AWbKxM7ovnQADFejE5fo88xZbWUFlguFjFRoyC6AIedciWYFEmpwndp8ll0ZWpIJQXXk7enrQigGIU0w
---

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

# Tips for Open Balance and Open Transaction Uploads

Posted by [Sara Duong, Consultant](https://blog.concentrus.com/author/sara-duong-consultant) on Oct 12, 2023 11:00:00 AM

![Sara Duong, Consultant](https://blog.concentrus.com/hubfs/Team%20Headshots/Sara%20Duong.jpg)

Find me on:

[LinkedIn](https://www.linkedin.com/in/sara-duong-03415a1/)

- [Tweet](https://twitter.com/share)

![](https://lh6.googleusercontent.com/3pYyEPPDOY3Gcx0NLaqczmEiAMNRYkKFW37MthqPxLQiUAQqzqAd6VRXrgguhNP-eeMEt4AWbKxM7ovnQADFejE5fo88xZbWUFlguFjFRoyC6AIedciWYFEmpwndp8ll0ZWpIJQXXk7enrQigGIU0w)

You're almost ready to take the exciting leap into your new NetSuite implementation, but before you do, it's crucial to get a handle on open balances and transactions. So, what exactly are open balances and transactions?

Open balances represent the initial figures in your General Ledger (GL) accounts, serving as the starting points for your Income Statement and Balance Sheets. Open transactions, on the other hand, encompass your outstanding Accounts Receivable (AR), Accounts Payable (AP), and Inventory Values (IV) – essentially, any unpaid or unused invoices, credits, and bills. The process of transferring this data into NetSuite can be a bit tricky, but don't worry, we've got you covered with some valuable tips to get you ready for the upload.

 

Mapping Matters:  
The concept of mapping is critical and applies to various aspects of your data. You'll need a common identifier to connect transactions from your legacy system to their counterparts in NetSuite. For example, using the legacy system's document number as the NetSuite external ID will come in handy if you ever need to reference the original document when a customer calls.

GL Account Mapping:  
Another key step is mapping old and new GL accounts, ensuring a smooth transition for your open balance data.

Vendor and Customer Mapping:  
Take a close look at your vendors and customers and develop a strategy for mapping them from your legacy system to NetSuite. Sometimes, data cleanup can lead to name or ID changes or the creation of duplicates when loaded into NetSuite. This can make it challenging to match the right transactions to the right vendor or customer.

Balance Verification:  
The individual transaction values for AR, AP, and IV should match the corresponding values in the open balance report. For example, if you've uploaded ten invoices with a total value of $1,000, this total should align with the AR GL account balance in the open balance file. In essence, these individual transactions should replace the total balance.

Adapt to Your Needs:  
It's important to be flexible. Open transactions may not always contain the same data as transactions created from scratch in NetSuite. You can address this by temporarily turning off scripts or mandatory fields, or you might choose to load the data using a different, more standard form.

Practice Makes Perfect:  
Before the go-live, take advantage of your sandbox environment to perform trial runs with the data files. This way, you can identify and mitigate any potential errors in advance.

 

Going live in NetSuite is a thrilling yet potentially stressful endeavor. By proactively addressing data errors, you can minimize the time spent troubleshooting or reworking your data. If you find yourself in need of assistance, whether it's before or after the go-live, don't hesitate to reach out to us. We're here to guide you through this process and ensure your NetSuite journey is as smooth as possible.

For any inquiries or assistance related to this topic, please feel free to contact Concentrus. We're here to help you succeed with your NetSuite implementation.

 

 

**About Us**

Concentrus is a leading provider of innovative cloud-based enterprise resource planning (ERP) solutions, including NetSuite. Our team of NetSuite experts offers a range of services, including NetSuite price analysis, NetSuite training, and NetSuite integration services.  

Our goal is to help businesses of all sizes maximize their investment in NetSuite by providing expert NetSuite cost optimization and implementation strategies. With years of experience as a NetSuite partner, our NetSuite administrators and NetSuite consultants are well equipped to help businesses of all sizes with their NetSuite consulting needs.  

Whether you're looking for a NetSuite consultant to help with your NetSuite implementation or you need ongoing NetSuite support, Concentrus is here to help. 

 

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](https://blog.concentrus.com/tag/netsuite), [ERP](https://blog.concentrus.com/tag/erp), [Reporting](https://blog.concentrus.com/tag/reporting), [NetSuite Partner](https://blog.concentrus.com/tag/netsuite-partner), [NetSuite How To's](https://blog.concentrus.com/tag/netsuite-how-tos), [NetSuite Tips](https://blog.concentrus.com/tag/netsuite-tips), [NetSuite Administrator](https://blog.concentrus.com/tag/netsuite-administrator), [data](https://blog.concentrus.com/tag/data), [Go Live](https://blog.concentrus.com/tag/go-live), [Open Balance Upload](https://blog.concentrus.com/tag/open-balance-upload), [Open Transaction Upload](https://blog.concentrus.com/tag/open-transaction-upload), [Netsuite ERP](https://blog.concentrus.com/tag/netsuite-erp), [Netsuite Updates](https://blog.concentrus.com/tag/netsuite-updates), [Shortcuts](https://blog.concentrus.com/tag/shortcuts)

### 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.