--- title: Mass Updates vs. CSV Imports – Updating Records in NetSuite description: In this post, Senior NetSuite Consultant Sarah Emery shares key differences between Mass Updates and CSV Imports along with a few practical use cases for each. image: https://blog.concentrus.com/hubfs/pexels-photo-357514.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/) # Mass Updates vs. CSV Imports – Updating Records in NetSuite Posted by [Sarah Emery, Senior Consultant](https://blog.concentrus.com/author/sarah-meehan-senior-consultant) on Apr 5, 2021 1:46:24 PM ![Sarah Emery, Senior Consultant](https://blog.concentrus.com/hubfs/Team%20Headshots/SarahMeehan.jpg) Find me on: [LinkedIn](https://www.linkedin.com/in/sarahameehan/) - [Tweet](https://twitter.com/share) ![pexels-photo-357514](https://blog.concentrus.com/hs-fs/hubfs/pexels-photo-357514.jpeg?width=300&name=pexels-photo-357514.jpeg) When making bulk updates to existing records in NetSuite, there are two approaches that are typically used – mass updates and CSV imports. Depending on the specific updates being made and the frequency with which the updates will be performed, you may find that one approach is better than the other. In this post, I’ll share key differences between the approaches along with a few practical use cases for each. Mass Updates To access the mass updates user interface in NetSuite, navigate to Lists > Mass Update > Mass Updates. Once you have selected your desired update and record type, you can define the criteria for the records to update. The list of records that will be impacted by the mass update is determined by the specific fields and values that are set up on the Criteria tab, which is identical to setting criteria for saved searches: ![](https://blog.concentrus.com/hubfs/image-png-Apr-05-2021-08-40-43-41-PM.png)   Once you’ve identified which records should be updated on the Criteria tab, you must next define what updates will be made on the Mass Update Fields tab. You can make updates to more than one field at a time and can either set a static value or use a formula to set a dynamic value: ![](https://blog.concentrus.com/hubfs/image-png-Apr-05-2021-08-41-17-94-PM.png) After setting up the Mass Update fields, set a name for your mass update and click Save. A list of all qualifying results will load, which gives you an opportunity to review the records and validate the results prior to running the update. If the results appear as expected, click the “Perform Update” button to initiate the mass update. One of the biggest benefits of using a mass update is that there is no need to create a template. You are able to indicate which records need to be updated at the same time as defining the changes to be made without using an external file. Additionally, mass updates can be saved and run automatically on a schedule, which makes them ideal for managing changes that need to occur at a regular interval. Mass updates are allowed on header-level fields only and not all fields are accessible for updates. This is a key distinction between the two methods for updating, as any line-level updates and/or updates to fields not accessible via mass update will require the use of a CSV import. Practical Examples of Mass Updates - Inactivating customers with a Last Purchase Date of over two years ago - Reassigning customers to different sales reps - Updating approval limits on employee records - Changing supervisors on employee records - Setting newly-added custom fields on existing records of any type - Updating class on item records CSV Imports To access CSV imports, navigate to Setup > Import/Export > Import CSV Records. Select the Import Type and Record Type, then upload your prepared CSV file. ![](https://blog.concentrus.com/hubfs/image-png-Apr-05-2021-08-42-41-34-PM.png) CSV imports can be used for adding new data, updating existing data, or adding new data and updating existing data simultaneously from a single file. For the purposes of this post, we’ll focus solely on updating existing data. Select the Update option: ![](https://blog.concentrus.com/hubfs/image-png-Apr-05-2021-08-42-53-73-PM.png) Finally, create the mappings between the columns in your CSV file and the corresponding fields in NetSuite. You can also set default or null values for fields not included in your CSV file within the mapping UI. ![](https://blog.concentrus.com/hubfs/image-png-Apr-05-2021-08-43-04-68-PM.png) Upon completion of the mapping, you have the option to save and run or simply run the import without saving. Saving the import allows you to reuse the mapping and/or share it with other users, which is convenient for recurring updates. The major benefit of CSV imports is the ability to make changes that are not supported by the Mass Update tool, specifically line-level changes and fields that are not accessible via Mass Update. Another advantage of CSV imports is that CSV files can be created using VLOOKUP and other formulas in Excel. This makes preparing files for even the most complex updates considerably easier and reduces the risk for errors in your data. The downside of using a CSV import is that it does require an external file, which means that it cannot be scheduled like a mass update. A user will need to prep the template and trigger the CSV import manually each time it needs to run. Additionally, creating the initial template and CSV mapping often takes a bit of trial and error, especially for users who are new to NetSuite. Practical Examples of CSV Imports for Updates - Updates without consistent logic that cannot be defined using a formula (i.e. changing item numbers, changing purchase or sales prices on item records, updating customer email addresses, etc.) - Changing prices on open sales or purchase transactions - Setting transaction lines to closed - Replacing component items on assemblies, kits, or item groups Both mass updates and CSV imports are extremely powerful tools that will save you hours compared to manual updates. Leveraging these automated tools also reduces the risk for human error when used carefully, though it is highly recommended to run small tests before triggering large updates to ensure that your changes appear as expected before proceeding. Do you have questions about running mass updates or CSV imports in NetSuite? Contact Concentrus today to discuss your needs with one of our NetSuite experts.   **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: [Project Management](https://blog.concentrus.com/tag/project-management), [NetSuite How To's](https://blog.concentrus.com/tag/netsuite-how-tos) ### 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.