--- title: "NetSuite Saved Searches: What is the 'TO_CHAR' Formula?" description: Learn about the functions of the 'TO_CHAR' formula in NetSuite saved searches and how it can help you transform data to different formats. image: https://blog.concentrus.com/hubfs/pexels-photo-106344.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/) # NetSuite Saved Searches: What is the 'TO\_CHAR' Formula? Posted by [Jesse Guzman, Consultant](https://blog.concentrus.com/author/jesse-guzman-consultant) on Dec 31, 2019 5:00:00 PM ![Jesse Guzman, Consultant](https://blog.concentrus.com/hubfs/Team%20Headshots/Jesse%20Guzman.jpg) Find me on: [LinkedIn](https://www.linkedin.com/in/jesse-guzman-54a3905a/) - [Tweet](https://twitter.com/share) ![pexels-photo-106344](https://blog.concentrus.com/hs-fs/hubfs/pexels-photo-106344.jpeg?width=300&name=pexels-photo-106344.jpeg)As you may have caught on by our previous blog posts, we really love NetSuite saved searches at Concentrus.  Saved searches have many uses and are one of the easiest tools to learn and use in NetSuite.  It doesn’t matter if you are an everyday user or log in occasionally to get the information you need, saved searches give you the tools to get the data you need, how you need it and when you need it. My colleague [Sarah Meehan](https://blog.concentrus.com/author/sarah-meehan-solutions-consultant?hsLang=en-us) has a great article on “[5 Ways to Use Formulas in NetSuite’s Saved Searches](https://blog.concentrus.com/5-ways-to-use-formulas-in-netsuites-saved-searches?hsLang=en-us)”. In this post, we’re going to talk about  specific formula used to transform data to many different formats, and for this blog we’ll focus on dates and times. Each user has the option to set date and time format under “User Preferences” which is a great tool that allows for personalization of your environment.  ![](https://blog.concentrus.com/hubfs/image-82.png)   However, your preferred date/time format may not be the preferred format to a customer or vendor; fortunately NetSuite provides an easy way to format dates/times. Before we jump into TO\_CHAR, we’ll briefly explain the difference between that and another very common formula called TO\_DATE which has a similar result but under different circumstances. TO\_DATE is used to convert date/time formats when the original input of data is a text/numeric version and now you want it to be a date format. TO\_CHAR, on the other hand, is used to take a system date and convert is as you please.  For the purpose of this blog we’ll focus on TO\_CHAR. I’ve included a simple table that is available on SuiteAnswers ID 50499.  The table provides the parameters that can be used on the TO\_CHAR formula to convert to the desired output. For the purposes of this example we’ll use the following data: Date: Monday, December 30, 2019 Time: 02:26:54 PM | **Parameter** | **Formula** | **Sample Result** | **Explanation** | | --- | --- | --- | --- | | DL | To\_Char({today},'DL') | Monday, December 30, 2019 | Long version of the date including day of the week, month, day and year. | | YEAR | To\_Char({today},'YEAR') | TWENTY NINETEEN | The Year spelled out | | YYYY | To\_Char({today},'YYYY') | 2019 | 4-digit year | | YYY | To\_Char({today},'YYY') | 019 | Last 3, 2, or 1 digit(s) of year. | | YY | To\_Char({today},'YY') | 19 | | | Y | To\_Char({today},'Y') | 9 | | | IYY | To\_Char({today},'IYY') | 020 | Some organizations use an ISO week date system, this formula returns the year according to ISO standard. | | IY | To\_Char({today},'IY') | 20 | | | I | To\_Char({today},'I') | 0 | | | IYYY | To\_Char({today},'IYYY') | 2020 | 4-digit year based on the ISO standard | | Q | To\_Char({today},'Q') | 4 | Quarter of year (1, 2, 3, 4; JAN-MAR = 1). | | MM | To\_Char({today},'MM') | 12 | Month (01-12; JAN = 01). | | MON | To\_Char({today},'MON') | DEC | Abbreviated name of month. | | MONTH | To\_Char({today},'MONTH') | DECEMBER | Name of month, padded with blanks to length of 9 characters. | | RM | To\_Char({today},'RM') | XII | Roman numeral month (I-XII; JAN = I). | | WW | To\_Char({today},'WW') | 52 | Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year. | | W | To\_Char({today},'W') | 5 | Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh. | | IW | To\_Char({today},'IW') | 1 | Week of year (1-52 or 1-53) based on the ISO standard. | | D | To\_Char({today},'D') | 2 | Day of week (1-7). Note the first day of the week is setup at the time of implementation.  For this example, Sunday is the first day of the week. | | DAY | To\_Char({today},'DAY') | MONDAY | Name of day. | | DD | To\_Char({today},'DD') | 30 | Day of month (1-31). | | DDD | To\_Char({today},'DDD') | 364 | Day of year (1-366). | | DY | To\_Char({today},'DY') | MON | Abbreviated name of day. | | J | To\_Char({today},'J') | 2458848 | Julian day; the number of days since January 1, 4712 BC. | | HH | To\_Char({today},'HH') | 02 | Hour of day (1-12). | | HH12 | To\_Char({today},'HH12') | 02 | Hour of day (1-12). | | HH24 | To\_Char({today},'HH24') | 14 | Hour of day (0-23). | | MI | To\_Char({today},'MI') | 26 | Minute (0-59). | | SS | To\_Char({today},'SS') | 54 | Second (0-59). | | SSSSS | To\_Char({today},'SSSSS') | 52014 | Seconds past midnight (0-86399). | The important things to consider when using the TO\_CHAR formula is the format the source data is in.  For example, you cannot reference the ‘TRANSDATE’ field if you want to include a time value in the results as the field ‘TRANSDATE’ does note store time values and will therefore return zeros. Assuming the date is 12/30/19 and 2:26:54 PM - TO\_CHAR({TRANSDATE} ,'YYYYMMDD HH24MISS') would return 20191230 000000 - TO\_CHAR({custbody\_timestamp} ,'YYYYMMDD HH24MISS') would return 20191230 142654 To include separators, simplely include them in the formula as so: - TO\_CHAR({custbody\_timestamp} ,'YYYY-MM/DD HH24:MI.SS') would return 2019-12/30 14:26.54  \*Note: the time changed since the first execution. Want to learn more about “TO-CHAR” formula, or get guided support on saved searches? Contact Concentrus today to discuss your reporting needs. [![Contact Us Today! ](https://no-cache.hubspot.com/cta/default/3865431/02b7a109-19cf-4ae0-bcb8-3de8e712a1a0.png)](https://cta-redirect.hubspot.com/cta/redirect/3865431/02b7a109-19cf-4ae0-bcb8-3de8e712a1a0) Tags: [NetSuite](https://blog.concentrus.com/tag/netsuite), [NetSuite How To's](https://blog.concentrus.com/tag/netsuite-how-tos), [NetSuite Tips](https://blog.concentrus.com/tag/netsuite-tips) ### Subscribe to our blog! ### Recent Posts ### Posts by Topic - [NetSuite How To's (334)](https://blog.concentrus.com/tag/netsuite-how-tos) - [NetSuite (290)](https://blog.concentrus.com/tag/netsuite) - [NetSuite Tips (273)](https://blog.concentrus.com/tag/netsuite-tips) - [ERP (245)](https://blog.concentrus.com/tag/erp) - [NetSuite Partner (191)](https://blog.concentrus.com/tag/netsuite-partner) - [Reporting (187)](https://blog.concentrus.com/tag/reporting) - [Project Management (120)](https://blog.concentrus.com/tag/project-management) - [Netsuite ERP (69)](https://blog.concentrus.com/tag/netsuite-erp) - [NetSuite Administrator (59)](https://blog.concentrus.com/tag/netsuite-administrator) - [Netsuite Updates (53)](https://blog.concentrus.com/tag/netsuite-updates) - [Accounting (43)](https://blog.concentrus.com/tag/accounting) - [NetSuite Integrations (43)](https://blog.concentrus.com/tag/netsuite-integrations) - [NetSuite Features (35)](https://blog.concentrus.com/tag/netsuite-features) - [Acumatica ERP (28)](https://blog.concentrus.com/tag/acumatica-erp) - [Acumatica (27)](https://blog.concentrus.com/tag/acumatica) - [Cloud ERP (27)](https://blog.concentrus.com/tag/cloud-erp) - [NetSuite Support (27)](https://blog.concentrus.com/tag/netsuite-support) - [cloud-based ERP (27)](https://blog.concentrus.com/tag/cloud-based-erp) - [Shortcuts (23)](https://blog.concentrus.com/tag/shortcuts) - [Inventory Management (21)](https://blog.concentrus.com/tag/inventory-management) - [SuiteScript (20)](https://blog.concentrus.com/tag/suitescript) - [dashboard (17)](https://blog.concentrus.com/tag/dashboard) - [Financial (16)](https://blog.concentrus.com/tag/financial) - [Warehouse Management System (WMS) (16)](https://blog.concentrus.com/tag/warehouse-management-system-wms) - [Saved Search (15)](https://blog.concentrus.com/tag/saved-search) - [Business Benefits (14)](https://blog.concentrus.com/tag/business-benefits) - [Project Managing (14)](https://blog.concentrus.com/tag/project-managing) - [eCommerce (14)](https://blog.concentrus.com/tag/ecommerce) - [Retail (13)](https://blog.concentrus.com/tag/retail) - [Transactions (13)](https://blog.concentrus.com/tag/transactions) - [People Management (12)](https://blog.concentrus.com/tag/people-management) - [Troubleshoot (12)](https://blog.concentrus.com/tag/troubleshoot) - [WMS (12)](https://blog.concentrus.com/tag/wms) - [Customize (11)](https://blog.concentrus.com/tag/customize) - [Netsuite WMS (11)](https://blog.concentrus.com/tag/netsuite-wms) - [Shipping (11)](https://blog.concentrus.com/tag/shipping) - [Customer Service (10)](https://blog.concentrus.com/tag/customer-service) - [Digital Mailroom Services (10)](https://blog.concentrus.com/tag/digital-mailroom-services) - [Document Capture Software (10)](https://blog.concentrus.com/tag/document-capture-software) - [ERP Projects (10)](https://blog.concentrus.com/tag/erp-projects) - [Mailroom Automation (10)](https://blog.concentrus.com/tag/mailroom-automation) - [Project (10)](https://blog.concentrus.com/tag/project) - [data (10)](https://blog.concentrus.com/tag/data) - [electronic mailroom (10)](https://blog.concentrus.com/tag/electronic-mailroom) - [Pros Cons (9)](https://blog.concentrus.com/tag/pros-cons) - [Supply Chain Management (9)](https://blog.concentrus.com/tag/supply-chain-management) - [CSV Import (8)](https://blog.concentrus.com/tag/csv-import) - [Customization (8)](https://blog.concentrus.com/tag/customization) - [Manufacturing (8)](https://blog.concentrus.com/tag/manufacturing) - [New User (8)](https://blog.concentrus.com/tag/new-user) - [Self Implementation (8)](https://blog.concentrus.com/tag/self-implementation) - [Wholesale Distribution (8)](https://blog.concentrus.com/tag/wholesale-distribution) - [Implementation (7)](https://blog.concentrus.com/tag/implementation) - [Items (7)](https://blog.concentrus.com/tag/items) - [Sales Order (7)](https://blog.concentrus.com/tag/sales-order) - [Virtual Mailroom (7)](https://blog.concentrus.com/tag/virtual-mailroom) - [Customer Records (6)](https://blog.concentrus.com/tag/customer-records) - [Fixed Asset (6)](https://blog.concentrus.com/tag/fixed-asset) - [Pricing Groups (6)](https://blog.concentrus.com/tag/pricing-groups) - [Purchase Order (6)](https://blog.concentrus.com/tag/purchase-order) - [Training (6)](https://blog.concentrus.com/tag/training) - [Transaction Lines (6)](https://blog.concentrus.com/tag/transaction-lines) - [Bank Account (5)](https://blog.concentrus.com/tag/bank-account) - [Bank Reconciliation (5)](https://blog.concentrus.com/tag/bank-reconciliation) - [Costing (5)](https://blog.concentrus.com/tag/costing) - [Custom Fields (5)](https://blog.concentrus.com/tag/custom-fields) - [Fixed Asset Management (5)](https://blog.concentrus.com/tag/fixed-asset-management) - [Go Live (5)](https://blog.concentrus.com/tag/go-live) - [Group Pricing (5)](https://blog.concentrus.com/tag/group-pricing) - [Inventory (5)](https://blog.concentrus.com/tag/inventory) - [Inventory Costing (5)](https://blog.concentrus.com/tag/inventory-costing) - [Open Balance Upload (5)](https://blog.concentrus.com/tag/open-balance-upload) - [Open Transaction Upload (5)](https://blog.concentrus.com/tag/open-transaction-upload) - [Prices (5)](https://blog.concentrus.com/tag/prices) - [Pricing (5)](https://blog.concentrus.com/tag/pricing) - [Project Time Entry (5)](https://blog.concentrus.com/tag/project-time-entry) - [User Access (5)](https://blog.concentrus.com/tag/user-access) - [Work Order (5)](https://blog.concentrus.com/tag/work-order) - [Bill Payment (4)](https://blog.concentrus.com/tag/bill-payment) - [Bill of Materials (4)](https://blog.concentrus.com/tag/bill-of-materials) - [COGS (4)](https://blog.concentrus.com/tag/cogs) - [Company News (4)](https://blog.concentrus.com/tag/company-news) - [Financial Report (4)](https://blog.concentrus.com/tag/financial-report) - [Integrations (4)](https://blog.concentrus.com/tag/integrations) - [Netsuite Language (4)](https://blog.concentrus.com/tag/netsuite-language) - [Promotions (4)](https://blog.concentrus.com/tag/promotions) - [Roles (4)](https://blog.concentrus.com/tag/roles) - [Segmentation (4)](https://blog.concentrus.com/tag/segmentation) - [ShipCentral (4)](https://blog.concentrus.com/tag/shipcentral) - [SuiteApp (4)](https://blog.concentrus.com/tag/suiteapp) - [SuitePromotion (4)](https://blog.concentrus.com/tag/suitepromotion) - [Support (4)](https://blog.concentrus.com/tag/support) - [Third-party (4)](https://blog.concentrus.com/tag/third-party) - [Users (4)](https://blog.concentrus.com/tag/users) - [Workflow (4)](https://blog.concentrus.com/tag/workflow) - [Accounting Periods (3)](https://blog.concentrus.com/tag/accounting-periods) - [Amortization (3)](https://blog.concentrus.com/tag/amortization) - [Bank Statements (3)](https://blog.concentrus.com/tag/bank-statements) - [Changing Schedules (3)](https://blog.concentrus.com/tag/changing-schedules) - [Customer Preference (3)](https://blog.concentrus.com/tag/customer-preference) - [Customer Returns (3)](https://blog.concentrus.com/tag/customer-returns) - [Discounts (3)](https://blog.concentrus.com/tag/discounts) - [Document Management Software (3)](https://blog.concentrus.com/tag/document-management-software) - [Document Scanning (3)](https://blog.concentrus.com/tag/document-scanning) - [Email Archiving (3)](https://blog.concentrus.com/tag/email-archiving) - [Errors (3)](https://blog.concentrus.com/tag/errors) - [Excel (3)](https://blog.concentrus.com/tag/excel) - [FAM (3)](https://blog.concentrus.com/tag/fam) - [General Ledger (3)](https://blog.concentrus.com/tag/general-ledger) - [Income Statement (3)](https://blog.concentrus.com/tag/income-statement) - [Insider (3)](https://blog.concentrus.com/tag/insider) - [Invoice Processing Automation (3)](https://blog.concentrus.com/tag/invoice-processing-automation) - [Item Pricing (3)](https://blog.concentrus.com/tag/item-pricing) - [Item Receipt (3)](https://blog.concentrus.com/tag/item-receipt) - [Item Returns (3)](https://blog.concentrus.com/tag/item-returns) - [Journal Entry (3)](https://blog.concentrus.com/tag/journal-entry) - [Order Fulfillment (3)](https://blog.concentrus.com/tag/order-fulfillment) - [Pack Station (3)](https://blog.concentrus.com/tag/pack-station) - [Paperless Office Solutions (3)](https://blog.concentrus.com/tag/paperless-office-solutions) - [Record Management (3)](https://blog.concentrus.com/tag/record-management) - [Return Costings (3)](https://blog.concentrus.com/tag/return-costings) - [Subsidiary (3)](https://blog.concentrus.com/tag/subsidiary) - [SuiteScript 2.1 (3)](https://blog.concentrus.com/tag/suitescript-2-1) - [TroubleShooting (3)](https://blog.concentrus.com/tag/troubleshooting) - [Vendor (3)](https://blog.concentrus.com/tag/vendor) - [Vendor Bill (3)](https://blog.concentrus.com/tag/vendor-bill) - [Vendor Payments (3)](https://blog.concentrus.com/tag/vendor-payments) - [Warehouse (3)](https://blog.concentrus.com/tag/warehouse) - [Work-In-Process (3)](https://blog.concentrus.com/tag/work-in-process) - [API (2)](https://blog.concentrus.com/tag/api) - [Administrator (2)](https://blog.concentrus.com/tag/administrator) - [Amount Due (2)](https://blog.concentrus.com/tag/amount-due) - [Assemblies (2)](https://blog.concentrus.com/tag/assemblies) - [Assembly Items (2)](https://blog.concentrus.com/tag/assembly-items) - [BOM (2)](https://blog.concentrus.com/tag/bom) - [Bank Feeds (2)](https://blog.concentrus.com/tag/bank-feeds) - [Billable Time (2)](https://blog.concentrus.com/tag/billable-time) - [Bills (2)](https://blog.concentrus.com/tag/bills) - [CSV (2)](https://blog.concentrus.com/tag/csv) - [Change Order (2)](https://blog.concentrus.com/tag/change-order) - [Changing Subsidiary (2)](https://blog.concentrus.com/tag/changing-subsidiary) - [Charges (2)](https://blog.concentrus.com/tag/charges) - [Client Script (2)](https://blog.concentrus.com/tag/client-script) - [Connectors (2)](https://blog.concentrus.com/tag/connectors) - [Create (2)](https://blog.concentrus.com/tag/create) - [Currency (2)](https://blog.concentrus.com/tag/currency) - [Data Migration (2)](https://blog.concentrus.com/tag/data-migration) - [Date Mismatch (2)](https://blog.concentrus.com/tag/date-mismatch) - [Email Management (2)](https://blog.concentrus.com/tag/email-management) - [Engineering (2)](https://blog.concentrus.com/tag/engineering) - [Food (2)](https://blog.concentrus.com/tag/food) - [GL (2)](https://blog.concentrus.com/tag/gl) - [Global Search (2)](https://blog.concentrus.com/tag/global-search) - [HTML (2)](https://blog.concentrus.com/tag/html) - [Hard Assets (2)](https://blog.concentrus.com/tag/hard-assets) - [History Record (2)](https://blog.concentrus.com/tag/history-record) - [Implementing (2)](https://blog.concentrus.com/tag/implementing) - [Implementing Subsidiary (2)](https://blog.concentrus.com/tag/implementing-subsidiary) - [International Shipping (2)](https://blog.concentrus.com/tag/international-shipping) - [Inventory Status (2)](https://blog.concentrus.com/tag/inventory-status) - [Item Fulfillment (2)](https://blog.concentrus.com/tag/item-fulfillment) - [Kits and Packages (2)](https://blog.concentrus.com/tag/kits-and-packages) - [Layout (2)](https://blog.concentrus.com/tag/layout) - [Lease Payments (2)](https://blog.concentrus.com/tag/lease-payments) - [Marketing (2)](https://blog.concentrus.com/tag/marketing) - [NetSuite Scripts (2)](https://blog.concentrus.com/tag/netsuite-scripts) - [New or Adding Subsidiary (2)](https://blog.concentrus.com/tag/new-or-adding-subsidiary) - [Not Calculating (2)](https://blog.concentrus.com/tag/not-calculating) - [On-Premise ERP (2)](https://blog.concentrus.com/tag/on-premise-erp) - [Pack (2)](https://blog.concentrus.com/tag/pack) - [Price Levels (2)](https://blog.concentrus.com/tag/price-levels) - [Product Review (2)](https://blog.concentrus.com/tag/product-review) - [Purchase Request (2)](https://blog.concentrus.com/tag/purchase-request) - [Reconciliation (2)](https://blog.concentrus.com/tag/reconciliation) - [Release 2025.1 (2)](https://blog.concentrus.com/tag/release-2025-1) - [Routing (2)](https://blog.concentrus.com/tag/routing) - [Sales (2)](https://blog.concentrus.com/tag/sales) - [Sales Tax (2)](https://blog.concentrus.com/tag/sales-tax) - [Standard Cost (2)](https://blog.concentrus.com/tag/standard-cost) - [T&M (2)](https://blog.concentrus.com/tag/tm) - [Time and Material (2)](https://blog.concentrus.com/tag/time-and-material) - [User Event Script (2)](https://blog.concentrus.com/tag/user-event-script) - [Warehouse Management (2)](https://blog.concentrus.com/tag/warehouse-management) - [Warehousing (2)](https://blog.concentrus.com/tag/warehousing) - [Wave (2)](https://blog.concentrus.com/tag/wave) - [Wave Release (2)](https://blog.concentrus.com/tag/wave-release) - [Workflow Instance (2)](https://blog.concentrus.com/tag/workflow-instance) - [Zone (2)](https://blog.concentrus.com/tag/zone) - [asset management (2)](https://blog.concentrus.com/tag/asset-management) - [suitelet (2)](https://blog.concentrus.com/tag/suitelet) - [2FA (1)](https://blog.concentrus.com/tag/2fa) - [AI (1)](https://blog.concentrus.com/tag/ai) - [AP Aging (1)](https://blog.concentrus.com/tag/ap-aging) - [Account Center (1)](https://blog.concentrus.com/tag/account-center) - [Accounting Preferences (1)](https://blog.concentrus.com/tag/accounting-preferences) - [Accounts Payable (1)](https://blog.concentrus.com/tag/accounts-payable) - [Advanced BOM (1)](https://blog.concentrus.com/tag/advanced-bom) - [Alias (1)](https://blog.concentrus.com/tag/alias) - [Aliases (1)](https://blog.concentrus.com/tag/aliases) - [Artificial Intelligent (1)](https://blog.concentrus.com/tag/artificial-intelligent) - [Asset Record (1)](https://blog.concentrus.com/tag/asset-record) - [Asset Transfer (1)](https://blog.concentrus.com/tag/asset-transfer) - [Authentication (1)](https://blog.concentrus.com/tag/authentication) - [Authorized Contacts (1)](https://blog.concentrus.com/tag/authorized-contacts) - [Auto-Expansion (1)](https://blog.concentrus.com/tag/auto-expansion) - [Automated Emails (1)](https://blog.concentrus.com/tag/automated-emails) - [Automation (1)](https://blog.concentrus.com/tag/automation) - [AvaTax (1)](https://blog.concentrus.com/tag/avatax) - [Avalara (1)](https://blog.concentrus.com/tag/avalara) - [BIN (1)](https://blog.concentrus.com/tag/bin) - [Balance Sheet (1)](https://blog.concentrus.com/tag/balance-sheet) - [Bank Data (1)](https://blog.concentrus.com/tag/bank-data) - [Bank Reconciliation Errors (1)](https://blog.concentrus.com/tag/bank-reconciliation-errors) - [Basic PDF Print (1)](https://blog.concentrus.com/tag/basic-pdf-print) - [Beverages (1)](https://blog.concentrus.com/tag/beverages) - [Billing (1)](https://blog.concentrus.com/tag/billing) - [Bin Transfer (1)](https://blog.concentrus.com/tag/bin-transfer) - [Bounced Emails (1)](https://blog.concentrus.com/tag/bounced-emails) - [Bulk Updates (1)](https://blog.concentrus.com/tag/bulk-updates) - [CASE (1)](https://blog.concentrus.com/tag/case) - [COA (1)](https://blog.concentrus.com/tag/coa) - [CSV Import Mappings (1)](https://blog.concentrus.com/tag/csv-import-mappings) - [Calculate Total (1)](https://blog.concentrus.com/tag/calculate-total) - [Carton (1)](https://blog.concentrus.com/tag/carton) - [Case Studies (1)](https://blog.concentrus.com/tag/case-studies) - [Cash Sale (1)](https://blog.concentrus.com/tag/cash-sale) - [Cell Phone Industry (1)](https://blog.concentrus.com/tag/cell-phone-industry) - [Chart of Accounts (1)](https://blog.concentrus.com/tag/chart-of-accounts) - [Classification (1)](https://blog.concentrus.com/tag/classification) - [Components (1)](https://blog.concentrus.com/tag/components) - [Concurrency (1)](https://blog.concentrus.com/tag/concurrency) - [Configuration (1)](https://blog.concentrus.com/tag/configuration) - [Consolidated Exchange Rates (1)](https://blog.concentrus.com/tag/consolidated-exchange-rates) - [Copy to Account (1)](https://blog.concentrus.com/tag/copy-to-account) - [Correct Depreciation (1)](https://blog.concentrus.com/tag/correct-depreciation) - [Cost Accounting (1)](https://blog.concentrus.com/tag/cost-accounting) - [Costed BOM (1)](https://blog.concentrus.com/tag/costed-bom) - [Country List (1)](https://blog.concentrus.com/tag/country-list) - [Coupons (1)](https://blog.concentrus.com/tag/coupons) - [Credit Hold (1)](https://blog.concentrus.com/tag/credit-hold) - [Credit Memo (1)](https://blog.concentrus.com/tag/credit-memo) - [Cumulative Depreciation (1)](https://blog.concentrus.com/tag/cumulative-depreciation) - [Customer Refund (1)](https://blog.concentrus.com/tag/customer-refund) - [Cycle Count (1)](https://blog.concentrus.com/tag/cycle-count) - [Data Analysis (1)](https://blog.concentrus.com/tag/data-analysis) - [Database Connectivity (1)](https://blog.concentrus.com/tag/database-connectivity) - [Defective Inventory (1)](https://blog.concentrus.com/tag/defective-inventory) - [Docusign (1)](https://blog.concentrus.com/tag/docusign) - [Dynamic Allocations (1)](https://blog.concentrus.com/tag/dynamic-allocations) - [EBITDA (1)](https://blog.concentrus.com/tag/ebitda) - [Edit (1)](https://blog.concentrus.com/tag/edit) - [Electronic Signature (1)](https://blog.concentrus.com/tag/electronic-signature) - [Employee Center (1)](https://blog.concentrus.com/tag/employee-center) - [Enhancement (1)](https://blog.concentrus.com/tag/enhancement) - [Entity/Use Code (1)](https://blog.concentrus.com/tag/entity-use-code) - [Environment Variables (1)](https://blog.concentrus.com/tag/environment-variables) - [Estimates Feature (1)](https://blog.concentrus.com/tag/estimates-feature) - [Expenses (1)](https://blog.concentrus.com/tag/expenses) - [FTP (1)](https://blog.concentrus.com/tag/ftp) - [Fees (1)](https://blog.concentrus.com/tag/fees) - [Field Mapping (1)](https://blog.concentrus.com/tag/field-mapping) - [Field Service Management (1)](https://blog.concentrus.com/tag/field-service-management) - [Financial Data Management (1)](https://blog.concentrus.com/tag/financial-data-management) - [Fixed Asset Module (1)](https://blog.concentrus.com/tag/fixed-asset-module) - [Food Industry (1)](https://blog.concentrus.com/tag/food-industry) - [Food and Service (1)](https://blog.concentrus.com/tag/food-and-service) - [Formula (1)](https://blog.concentrus.com/tag/formula) - [Gift Certificates (1)](https://blog.concentrus.com/tag/gift-certificates) - [Governance (1)](https://blog.concentrus.com/tag/governance) - [Grant (1)](https://blog.concentrus.com/tag/grant) - [Handling (1)](https://blog.concentrus.com/tag/handling) - [Help Desk (1)](https://blog.concentrus.com/tag/help-desk) - [If-Then (1)](https://blog.concentrus.com/tag/if-then) - [Inline Editing (1)](https://blog.concentrus.com/tag/inline-editing) - [Installments (1)](https://blog.concentrus.com/tag/installments) - [Intelligent Item Recommendations (1)](https://blog.concentrus.com/tag/intelligent-item-recommendations) - [Intercompany Accounts (1)](https://blog.concentrus.com/tag/intercompany-accounts) - [Internal Case Support (1)](https://blog.concentrus.com/tag/internal-case-support) - [Internal IDs (1)](https://blog.concentrus.com/tag/internal-ids) - [Invalid Key (1)](https://blog.concentrus.com/tag/invalid-key) - [Inventory Allocation (1)](https://blog.concentrus.com/tag/inventory-allocation) - [Inventory Commitment (1)](https://blog.concentrus.com/tag/inventory-commitment) - [Inventory Control (1)](https://blog.concentrus.com/tag/inventory-control) - [Inventory Cost Revaluation (1)](https://blog.concentrus.com/tag/inventory-cost-revaluation) - [Inventory Counts (1)](https://blog.concentrus.com/tag/inventory-counts) - [Invoicing (1)](https://blog.concentrus.com/tag/invoicing) - [Item Alias (1)](https://blog.concentrus.com/tag/item-alias) - [Item Alternatives (1)](https://blog.concentrus.com/tag/item-alternatives) - [Item Substitution (1)](https://blog.concentrus.com/tag/item-substitution) - [Item Types (1)](https://blog.concentrus.com/tag/item-types) - [KPI (1)](https://blog.concentrus.com/tag/kpi) - [KPI Scorecard (1)](https://blog.concentrus.com/tag/kpi-scorecard) - [Kit/Package Items (1)](https://blog.concentrus.com/tag/kit-package-items) - [Landed Cost (1)](https://blog.concentrus.com/tag/landed-cost) - [Language (1)](https://blog.concentrus.com/tag/language) - [Language Preference (1)](https://blog.concentrus.com/tag/language-preference) - [Lease (1)](https://blog.concentrus.com/tag/lease) - [Limitation (1)](https://blog.concentrus.com/tag/limitation) - [Location (1)](https://blog.concentrus.com/tag/location) - [Locked Period (1)](https://blog.concentrus.com/tag/locked-period) - [Lot Number (1)](https://blog.concentrus.com/tag/lot-number) - [Lot Trace (1)](https://blog.concentrus.com/tag/lot-trace) - [Mass Email Management (1)](https://blog.concentrus.com/tag/mass-email-management) - [Mass Updates (1)](https://blog.concentrus.com/tag/mass-updates) - [Mobile Access (1)](https://blog.concentrus.com/tag/mobile-access) - [Multi-Match (1)](https://blog.concentrus.com/tag/multi-match) - [Multicurrency (1)](https://blog.concentrus.com/tag/multicurrency) - [NAFTA (1)](https://blog.concentrus.com/tag/nafta) - [Net Book Value (1)](https://blog.concentrus.com/tag/net-book-value) - [NetSuite Best Practices (1)](https://blog.concentrus.com/tag/netsuite-best-practices) - [NetSuite CRM/Support (1)](https://blog.concentrus.com/tag/netsuite-crm-support) - [NetSuite Error Handling (1)](https://blog.concentrus.com/tag/netsuite-error-handling) - [NetSuite Gift Card (1)](https://blog.concentrus.com/tag/netsuite-gift-card) - [NetSuite to NetSuite (1)](https://blog.concentrus.com/tag/netsuite-to-netsuite) - [Netsuite Fees (1)](https://blog.concentrus.com/tag/netsuite-fees) - [Netsuite Tier (1)](https://blog.concentrus.com/tag/netsuite-tier) - [Non-GL Changes (1)](https://blog.concentrus.com/tag/non-gl-changes) - [Not Exist When Save (1)](https://blog.concentrus.com/tag/not-exist-when-save) - [OCI Database (1)](https://blog.concentrus.com/tag/oci-database) - [ODBC (1)](https://blog.concentrus.com/tag/odbc) - [OneWorld (1)](https://blog.concentrus.com/tag/oneworld) - [Online Case Form (1)](https://blog.concentrus.com/tag/online-case-form) - [Online Customer Forms (1)](https://blog.concentrus.com/tag/online-customer-forms) - [Overdue Issue (1)](https://blog.concentrus.com/tag/overdue-issue) - [Oversized Items (1)](https://blog.concentrus.com/tag/oversized-items) - [PDF Formatting (1)](https://blog.concentrus.com/tag/pdf-formatting) - [PM (1)](https://blog.concentrus.com/tag/pm) - [PO Rate (1)](https://blog.concentrus.com/tag/po-rate) - [Pay Bills (1)](https://blog.concentrus.com/tag/pay-bills) - [Performance (1)](https://blog.concentrus.com/tag/performance) - [Permissions (1)](https://blog.concentrus.com/tag/permissions) - [Pick (1)](https://blog.concentrus.com/tag/pick) - [Popup (1)](https://blog.concentrus.com/tag/popup) - [Postman (1)](https://blog.concentrus.com/tag/postman) - [Pricing Schedules (1)](https://blog.concentrus.com/tag/pricing-schedules) - [Print Offsets (1)](https://blog.concentrus.com/tag/print-offsets) - [Purchase Price (1)](https://blog.concentrus.com/tag/purchase-price) - [Purchase Requisitions (1)](https://blog.concentrus.com/tag/purchase-requisitions) - [Quality Assurance (1)](https://blog.concentrus.com/tag/quality-assurance) - [Quantity Pricing (1)](https://blog.concentrus.com/tag/quantity-pricing) - [RESTlet (1)](https://blog.concentrus.com/tag/restlet) - [RMA (1)](https://blog.concentrus.com/tag/rma) - [Reclass (1)](https://blog.concentrus.com/tag/reclass) - [Record (1)](https://blog.concentrus.com/tag/record) - [Record Lock (1)](https://blog.concentrus.com/tag/record-lock) - [Release 2025.2 (1)](https://blog.concentrus.com/tag/release-2025-2) - [Release Preview (1)](https://blog.concentrus.com/tag/release-preview) - [Request Different Dates (1)](https://blog.concentrus.com/tag/request-different-dates) - [Reseller Permit (1)](https://blog.concentrus.com/tag/reseller-permit) - [Return Authorizations (1)](https://blog.concentrus.com/tag/return-authorizations) - [Revaluation (1)](https://blog.concentrus.com/tag/revaluation) - [Revenue Management (1)](https://blog.concentrus.com/tag/revenue-management) - [Revenue Recognition (1)](https://blog.concentrus.com/tag/revenue-recognition) - [Reverse Void (1)](https://blog.concentrus.com/tag/reverse-void) - [SCM Mobile (1)](https://blog.concentrus.com/tag/scm-mobile) - [SFTP (1)](https://blog.concentrus.com/tag/sftp) - [SOAP Logs (1)](https://blog.concentrus.com/tag/soap-logs) - [SOC (1)](https://blog.concentrus.com/tag/soc) - [Sage (1)](https://blog.concentrus.com/tag/sage) - [Sage ERP (1)](https://blog.concentrus.com/tag/sage-erp) - [Sales Order Form (1)](https://blog.concentrus.com/tag/sales-order-form) - [Schedule Saved Searches (1)](https://blog.concentrus.com/tag/schedule-saved-searches) - [Script Configuration (1)](https://blog.concentrus.com/tag/script-configuration) - [Scripted Records (1)](https://blog.concentrus.com/tag/scripted-records) - [Search (1)](https://blog.concentrus.com/tag/search) - [Segmentation Dependencies (1)](https://blog.concentrus.com/tag/segmentation-dependencies) - [Semicolon (1)](https://blog.concentrus.com/tag/semicolon) - [Set Preferences (1)](https://blog.concentrus.com/tag/set-preferences) - [Shared Library (1)](https://blog.concentrus.com/tag/shared-library) - [Shipping Form (1)](https://blog.concentrus.com/tag/shipping-form) - [Single Vendor (1)](https://blog.concentrus.com/tag/single-vendor) - [Special Order (1)](https://blog.concentrus.com/tag/special-order) - [State List (1)](https://blog.concentrus.com/tag/state-list) - [State Tax (1)](https://blog.concentrus.com/tag/state-tax) - [Statement (1)](https://blog.concentrus.com/tag/statement) - [Statistical Account (1)](https://blog.concentrus.com/tag/statistical-account) - [Statistical Journals (1)](https://blog.concentrus.com/tag/statistical-journals) - [Statistics (1)](https://blog.concentrus.com/tag/statistics) - [SuiteBundle (1)](https://blog.concentrus.com/tag/suitebundle) - [SuiteCloud (1)](https://blog.concentrus.com/tag/suitecloud) - [System Notes (1)](https://blog.concentrus.com/tag/system-notes) - [TBA (1)](https://blog.concentrus.com/tag/tba) - [Tax Codes (1)](https://blog.concentrus.com/tag/tax-codes) - [Tax Exemption (1)](https://blog.concentrus.com/tag/tax-exemption) - [Terms (1)](https://blog.concentrus.com/tag/terms) - [Time Entry (1)](https://blog.concentrus.com/tag/time-entry) - [Timing Out (1)](https://blog.concentrus.com/tag/timing-out) - [Traceability (1)](https://blog.concentrus.com/tag/traceability) - [Transaction Forms (1)](https://blog.concentrus.com/tag/transaction-forms) - [Transaction IDs (1)](https://blog.concentrus.com/tag/transaction-ids) - [Transaction Update (1)](https://blog.concentrus.com/tag/transaction-update) - [Transaction Usage (1)](https://blog.concentrus.com/tag/transaction-usage) - [Transform (1)](https://blog.concentrus.com/tag/transform) - [Traveler (1)](https://blog.concentrus.com/tag/traveler) - [Trend (1)](https://blog.concentrus.com/tag/trend) - [Trial Balances (1)](https://blog.concentrus.com/tag/trial-balances) - [UI Customization (1)](https://blog.concentrus.com/tag/ui-customization) - [UPC (1)](https://blog.concentrus.com/tag/upc) - [UPS (1)](https://blog.concentrus.com/tag/ups) - [Undeposited Funds (1)](https://blog.concentrus.com/tag/undeposited-funds) - [Unit (1)](https://blog.concentrus.com/tag/unit) - [Unit Types (1)](https://blog.concentrus.com/tag/unit-types) - [User Preference (1)](https://blog.concentrus.com/tag/user-preference) - [Vendor Name/Code (1)](https://blog.concentrus.com/tag/vendor-name-code) - [Void Check (1)](https://blog.concentrus.com/tag/void-check) - [WIP (1)](https://blog.concentrus.com/tag/wip) - [Warehouse Distribution (1)](https://blog.concentrus.com/tag/warehouse-distribution) - [Work Instructions (1)](https://blog.concentrus.com/tag/work-instructions) - [Zone Picking (1)](https://blog.concentrus.com/tag/zone-picking) - [compliance (1)](https://blog.concentrus.com/tag/compliance) - [esignature (1)](https://blog.concentrus.com/tag/esignature) - [file upload (1)](https://blog.concentrus.com/tag/file-upload) - [functionality (1)](https://blog.concentrus.com/tag/functionality) - [log (1)](https://blog.concentrus.com/tag/log) - [payment method (1)](https://blog.concentrus.com/tag/payment-method) - [save to file (1)](https://blog.concentrus.com/tag/save-to-file) - [snippet (1)](https://blog.concentrus.com/tag/snippet) see all ### Request a quote ![logo-h-white-1a7c2dfb](https://blog.concentrus.com/hubfs/Logos/logo-h-white-1a7c2dfb.png "logo-h-white-1a7c2dfb") Our values - Honesty, Humility, Collaboration and Innovation- define who we are. They drive us to deliver world class solutions that are results-driven and mutually profitable to both our clients and our team. We are a complete NetSuite Solutions Provider. That means that we provide NetSuite implementation, customization, integration, support, and training and help our clients get sustainable, long-term solutions to meet their business needs. ![O-NetSuite-SolutionProvider-horiz-wht-copy-035c932f](https://blog.concentrus.com/hubfs/O-NetSuite-SolutionProvider-horiz-wht-copy-035c932f.png "O-NetSuite-SolutionProvider-horiz-wht-copy-035c932f") #### [What is NetSuite](https://concentrus.com/what-is-netsuite) - [Role Based](https://concentrus.com/role-based) - [Industry](https://concentrus.com/industry) #### [Why Concentrus](https://concentrus.com/why-concentrus) - [About Us](https://concentrus.com/about-us/) - [Implementation Methodology](https://concentrus.com/implementation-methodology/) - [Customization, Development & Integrations](https://concentrus.com/customization-methodology/) - [Resources](https://concentrus.com/resources/) - [Blog](https://blog.concentrus.com/) ##### Customer Center - [My Account](https://4546731.app.netsuite.com/app/login/secure/privatelogin.nl?c=4546731) - [Support](https://concentrus.com/support-2) - [NetSuite Tips & Tricks](https://concentrus.com/short-and-suite) 1550 Valley Vista Drive, Diamond Bar, CA 91765   |   [877 348 1165](tel:+18773481165)   |   [Email Us](http://www.concentrus.com/contact)   |   [www.concentrus.com](http://www.concentrus.com)   |   [Privacy Policy](http://concentrus.staphaus.net/privacy-policy/) Copyright 2020. Concentrus. All rights reserved.