Category: NetSuite Connector

Setting up Workato sync to connect BigQuery and NetSuite

1. Prerequisites Before you start, ensure you have: ✅ Workato Account with access to Google BigQuery and NetSuite connectors. ✅ Google BigQuery Project with service account credentials (.json file). ✅ NetSuite Integration Role with Web Services and REST API permissions. 2. Connect Workato to BigQuery Go to: Apps in Workato. Click New Connection and select… Continue reading Setting up Workato sync to connect BigQuery and NetSuite

SuiteAnalytics Connect (ODBC/JDBC/ADO.NET) – Tips

NetSuite provides SuiteAnalytics Connect (ODBC/JDBC/ADO.NET) for external reporting and data analysis. Below are some key tips to ensure a smooth and efficient ODBC connection. Since SuiteAnalytics Connect runs on a read-only replicated database, optimizing queries is important. ✅ Use Saved Searches for Large Data Sets NetSuite’s ODBC database is not real-time. For large datasets, use… Continue reading SuiteAnalytics Connect (ODBC/JDBC/ADO.NET) – Tips

Amazon Inventory Adjustments

You can use the Amazon Inventory Adjustments feature to adjust the inventory of items in NetSuite at a specific location to reflect the inventory for these items in Amazon warehouses. When you enable this feature, you have the option to either only receive inventory adjustment reports and then make the manual adjustment yourself, or also… Continue reading Amazon Inventory Adjustments

Amazon Seller Fulfilled Prime Add-On in NetSuite Connector

Amazon Seller Fulfilled Prime (SFP) is a program that allows qualified sellers to get the Prime badge on their products and to deliver directly to Prime subscribers using their own shipping operation. NetSuite Connector does not require any additional setup to process Amazon SFP orders. SFP orders sync using the same NetSuite Connector process that… Continue reading Amazon Seller Fulfilled Prime Add-On in NetSuite Connector

Switching to NetSuite Connector from an Existing Integration

You may have a live integration outside NetSuite Connector which is syncing your items, orders, or other data. To ensure that there are no duplicate or missing items or orders, you should leave your existing service running during the activation process with NetSuite Connector. You may not use another service and are following manual steps… Continue reading Switching to NetSuite Connector from an Existing Integration

Bank statement import is empty in reconciliation when using financial institution connectors.

When performing bank reconciliations in NetSuite using the match bank data feature, it’s crucial to ensure that the transaction dates in your imported data align correctly with the “as of” date specified during the import process. If this alignment is not maintained, NetSuite will automatically remove the imported data, which can cause confusion and disrupt… Continue reading Bank statement import is empty in reconciliation when using financial institution connectors.

Introduction to NetSuite Application Performance Management (APM)

NetSuite Application Performance Management (APM) is a powerful SuiteApp designed to help NetSuite users monitor and optimize the performance of their custom scripts and workflows. APM provides detailed insights into how your customizations are affecting system performance, allowing you to identify bottlenecks, optimize code, and ensure a smooth user experience. Key Features of APM: Performance… Continue reading Introduction to NetSuite Application Performance Management (APM)

SuiteAnalytic Connector – Do not have permission to use SuiteAnalytics

I’m trying to test the connection to SuiteAnalytic connector. However, I got the issue about the permission. Some information: Error log when I tried connect with JDBC on Data Grid. Enabled SuiteAnalytic feature. 1st tried: Granted directly permission to duong.le@… account. Still get the same the above error log 2nd tried: Created a role, added the permission… Continue reading SuiteAnalytic Connector – Do not have permission to use SuiteAnalytics