Most NetSuite users remain unaware that their platform functions as a full SQL database accessible through standard ODBC, JDBC, and ADO.NET drivers via SuiteAnalytics Connect. This obscure feature bypasses NetSuite’s traditional web interface entirely, allowing third-party applications like Tableau, Power BI, or custom analytics tools to query live NetSuite data directly using SQL commands. Unlike… Continue reading NetSuite’s Hidden SQL Gateway: SuiteAnalytics Connect
Author: Alphons John
Items were successfully added to the category but were not visible on the website.
Root Cause: The Commerce Category was not configured in the website’s Search Index settings—specifically, it was missing from the Sort Fields and Facet Fields. Resolution Steps: Go to Setup > SuiteCommerce Advanced > Search Index Configuration. Under the relevant website configuration: Add Commerce Category to the Sort Fields. Add Commerce Category to the Facet Fields.… Continue reading Items were successfully added to the category but were not visible on the website.
How to Unlink an SSP Application in SuiteCommerce Advanced (SCA)
SuiteCommerce Advanced (SCA) uses domains and SSP applications to deliver dynamic e-commerce experiences. When you’re cleaning up configurations or shifting setups, properly unlinking these components is key to keeping everything running smoothly. Unlinking an SSP Application Navigate to SSP Applications Go to Commerce > Hosting > SSP Applications. Open the SSP Application Record Click View… Continue reading How to Unlink an SSP Application in SuiteCommerce Advanced (SCA)
NetSuite and the Future of AI in Business Management
NetSuite is integrating Artificial Intelligence (AI) to enhance efficiency in business management. AI automates repetitive tasks like invoice processing and data entry, while generative AI tools such as Text Enhance assist in content creation for product descriptions and communications. Predictive analytics empower businesses to optimize inventory, forecast demand, and make data-driven decisions. AI-driven fraud detection… Continue reading NetSuite and the Future of AI in Business Management
Back Date and Post Date Transactions in NetSuite
In NetSuite, backdating and postdating transactions are important tools used to manage the timing of financial entries. Backdating Transactions Backdating allows users to record a transaction with a date earlier than the current date. This is useful when an invoice or transaction was issued or should be recognized in a prior period. To backdate… Continue reading Back Date and Post Date Transactions in NetSuite
Using SuiteAnalytics to Create Custom KPIs and Trend Graphs in NetSuite
SuiteAnalytics in NetSuite offers powerful tools to create custom KPIs (Key Performance Indicators) and trend graphs that help businesses monitor performance and make data-driven decisions. To get started, navigate to the Analytics > Workbook section and create a new workbook. You can build datasets using real-time data from records like sales, inventory, or financials, and… Continue reading Using SuiteAnalytics to Create Custom KPIs and Trend Graphs in NetSuite
NetSuite Tips for Year-End Close and Financial Reporting
Year-end closing in NetSuite is a critical process that ensures financial records are accurate and ready for reporting. The first step is to reconcile accounts, especially bank and credit card accounts, to ensure all transactions are accurately recorded. Start by reviewing open transactions, such as unbilled sales orders or unreceived purchase orders, and either close… Continue reading NetSuite Tips for Year-End Close and Financial Reporting
Bank Reconciliation in NetSuite
Bank reconciliation in NetSuite is the process of matching your company’s bank account statements with the transactions recorded in NetSuite’s general ledger. This ensures that your cash balances in NetSuite align with the actual balances in your bank account. To start the reconciliation, go to Transactions > Bank > Reconcile Bank Statement. You’ll need to… Continue reading Bank Reconciliation in NetSuite