--- title: "NetSuite Tip: Utilizing Summary Types in Saved Searches" description: Explore the basics of using Summary Types in saved searches (both as criteria and in the results) and see practical examples of how to make use of Summary Types to enhance your searches. image: https://images.pexels.com/photos/2058128/pexels-photo-2058128.jpeg?auto=compress&cs=tinysrgb&h=750&w=1260 --- [![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/) # NetSuite Tip: Utilizing Summary Types in Saved Searches Posted by [Sarah Emery, Senior Consultant](https://blog.concentrus.com/author/sarah-meehan-senior-consultant) on Nov 5, 2019 2:41:06 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) ![Person Typing on Computer Keyboard](https://images.pexels.com/photos/2058128/pexels-photo-2058128.jpeg?auto=compress&cs=tinysrgb&h=750&w=1260)If you’ve read [any of my previous blog posts](https://blog.concentrus.com/author/sarah-meehan-solutions-consultant?hsLang=en-us), you’ve probably gotten a sense of how much I like working with [saved searches in NetSuite](https://blog.concentrus.com/5-ways-to-use-formulas-in-netsuites-saved-searches?hsLang=en-us).  In my opinion, the saved search functionality is one of the most powerful and easy-to-use tools available to NetSuite users; whether you are brand new to NetSuite or are a highly-experienced user with a technical background, you’ll find that saved searches can make accessing data fast and easy.  In this post, we’ll discuss the basics of using Summary Types in saved searches (both as criteria and in the results) and look at a few practical examples that show how you can make use of Summary Types to enhance your searches. ##### Summary Type Basics Summary Types can be used as criteria within a saved search (which determines which results are displayed) or as result columns (which define the data points that are displayed when the criteria is met).  There are six different Summary Types available when entering a summary criteria or result value: - **Group:** Defines the data point(s) by which results are grouped when calculating other summary values (i.e. grouping by document number when counting items per sales order, grouping by customer when summing the total order value by customer). Note: Group is only available in the Results subtab. - **Count:** The number of qualifying results (i.e. number of sales orders per customer, number of line items on a sales order, number of item records belonging to a particular class) - **Sum:** The total of all qualifying values (i.e. total of all sales orders places by a specific customer, total quantity of all line items on a sales order, total quantity sold by item) - **Minimum:**The lowest qualifying result (i.e. the earliest sales order date by customer, the earliest order date for an item) - **Maximum:** The highest qualifying result (i.e. the most recent sales order date by customer, the most recent order date for an item) - **Average:** The average of all qualifying values (i.e. the average sales order amount by customer, the average order quantity by item) ##### Summary Types in Criteria For some applications, it is critical to be able to limit a data set to a subset of results based on summary values.  For example, the accounting team may want to be alerted when a customer has more than one overdue invoice.  Using the Standard criteria subtab, we can define a list of customers with overdue invoices, however we aren’t able to limit the results based on the total number of overdue invoices per customer.  To achieve that, we’ll need to use the Summary criteria subtab to construct the additional logic that looks at the total number of overdue invoices.  Since we’re interested in considering the number of records that meet the criteria entered on the Standard subtab, we will use the Count summary type on the field Document Number.  The accounting team is specifically interested in seeing customers with more than one past due invoice, so we’ll include customers where the count is greater than or equal to two. ![](https://blog.concentrus.com/hubfs/image-80.png) In order for this logic to work correctly, we’ll also need to include summary types on the Results subtab. ##### Summary Types in Results When including summary types in the Results subtab, you need to start by grouping the records to align with how you want the calculations to be performed.  In this example, we are interested in evaluating the total number of overdue invoices relative to the customer, so we will select the Summary Type of Group for the field Name.  For the purposes of validating our summary criteria, we’ll also include a Summary Type of Count for the field Document Number. ![](https://blog.concentrus.com/hubfs/image-81.png) As you’ll notice in the screenshot above, there are a number of fields that do not have a Summary Type selected.  When this saved search is run, only the Name and Document Number fields will be displayed on the initial results page.  The other fields will only be displayed when the user drills down into the summarized results.  **Quick Tip:** When selecting a Summary Type other than Group, the field label will be automatically displayed as “(Summary Type) of (Field Name)” – meaning that the example above would be shown as “Count of Document Number” in the header of the column.  To change this, enter the text that you want to be displayed as the column header in the “Summary Label” section. ##### 10 Practical Applications for Summary Types in Saved Searches Now that we’ve discussed the basics of using Summary Types in both the criteria and results of a saved search, let’s review 10 real-world examples of how Summary Types can be used to improve your reporting in NetSuite. - Display a customer’s most recent invoice date - On the Results subtab, select: - Summary Type = Group for Customer field - Summary Type = Maximum for Date field - Show a customer’s average order size - On the Results subtab, select: - Summary Type = Group for Customer field - Summary Type = Average for Amount field - Create a list of high-volume customers - On the Criteria > Summary subtab, select: - Summary Type = Sum for Amount field and enter greater than or equal to $100,000 (adjust amount as needed) - On the Results subtab, select: - Summary Type = Group for Customer field - Summary Type = Sum for Amount field - Show a list of fast-moving items - On the Criteria > Summary subtab, select: - Summary Type = Sum for Quantity field and enter greater than or equal to 100 (adjust amount as needed) - On the Results subtab, select: - Summary Type = Group for Item field - Summary Type = Sum for Quantity field - Display the lowest selling price for an item - On the Results subtab, select: - Summary Type = Group for Item field - Summary Type = Minimum for Item Rate field - **Tip**: You can show the lowest price by Sales Rep by adding an additional Summary Type = Group for Sales Rep field - Create a report showing the total number of orders and average order value by sales rep - On the Results subtab, select: - Summary Type = Group for Sales Rep field - Summary Type = Count for Document Number field - Summary Type = Sum for Amount field - Show account performance for customers with terms - On the Results subtab, select: - Summary Type = Group for Customer field - Summary Type = Group for Customer (Main Line) > Terms field (shows terms assigned to customer) - Summary Type = Maximum for Days Open field (shows longest days to pay) - Summary Type = Average for Days Open field (shows average days to pay) - Display account distribution by sales rep - On the Results subtab, select: - Summary Type = Group for Sales Rep field - Summary Type = Count for Name field (indicates number of customers assigned to sales rep) - Summary Type = Sum for Transaction > Amount field (displays total order value) - Summary Type = Count for Transaction > Document Number field (displays total number of orders) - Create a report showing order volume by state - On the Results subtab, select: - Summary Type = Group for Shipping State/Province field - Summary Type = Count for Document Number field - Summary Type = Average for Amount field - Show items with a high order defect rate (based on RMAs) - On the Criteria > Summary subtab, select: - Summary Type = Sum for Quantity field and enter greater than or equal to 10 (adjust amount as needed) - On the Results subtab, select: - Summary Type = Group for Item field - Summary Type = Count for Document Number (calculates the total number of returns) - Summary Type = Sum for Quantity (calculates the total quantity of returned items) - Summary Type = Sum for Amount (calculates the total value of returns) For the purposes of introducing the Summary Type concept, I’ve kept the examples limited to standard fields, but NetSuite allows the use of Summary Types on custom fields and formulas as well.  Using [formulas](https://blog.concentrus.com/5-ways-to-use-formulas-in-netsuites-saved-searches?hsLang=en-us) that included SQL expressions, I’ve been able to create incredibly dynamic summary criteria for my [saved searches](https://blog.concentrus.com/how-to-use-email-alerts-with-netsuites-saved-searches?hsLang=en-us) that were then used to trigger [workflows](https://blog.concentrus.com/part-1-an-introduction-to-approval-workflows-in-netsuite?hsLang=en-us) or distribute automated email messages to staff without the need for any scripting or development.  Once you’ve explored the basics of using summary values in your [saved searches](https://blog.concentrus.com/5-ways-to-streamline-case-management-with-netsuites-saved-searches?hsLang=en-us), try expanding into custom fields and/or formulas to see just how effective this functionality can be. Want to learn more about creating complex saved searches in NetSuite, or get guided support on creating one of the saved searches described in this post?  Contact Concentrus today to discuss your reporting needs. [![Contact Us Today! ](https://no-cache.hubspot.com/cta/default/3865431/6cf74717-62aa-43c6-8774-87f6bd4bda04.png)](https://cta-redirect.hubspot.com/cta/redirect/3865431/6cf74717-62aa-43c6-8774-87f6bd4bda04) Tags: [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.