A custom list will be created to store the values related to Product specifications. A new Custom Item field will be created to store the Product specification value (Length). For the customisation, we would set up functionality to highlight the Transaction lines of the Sales Order for all NetSuite roles when an item is added,… Continue reading Sales Order Line Highlighting for certain Item type/Item configuration
Author: Geordy Cleetus
How to Remove Kit Item Components from certain Transaction PDF
To hide the components of a Kit Item, we can create a transaction line level field ‘Not Component. We should disable the “No Component” checkbox and provide a default value true for the field. If we have historical transactions, we can also deploy functionality to mark the ‘Not Component’ checkbox in the Transaction line level.… Continue reading How to Remove Kit Item Components from certain Transaction PDF
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
Highlighting Transaction line fields based on the various conditions
To setup highlighting for certain line fields, use JQuery to change the background colour. For example, if (quantity > 10) { document.querySelector(`[data-label=’Quantity’]`).style.backgroundColor = “yellow”; } else { document.querySelector(`[data-label=’Quantity’]`).style.backgroundColor = “white”; … Continue reading Highlighting Transaction line fields based on the various conditions
How to Handle WSDL Changes in NetSuite SOAP Web Services
NetSuite periodically updates its WSDL (Web Services Description Language) file with new features, fields, and schema changes. If you’re using SuiteTalk SOAP Web Services, you need to update your integration when NetSuite releases a new version. 1. Check the Current WSDL Version To verify the currently used WSDL version: Go to: Setup > Integration >… Continue reading How to Handle WSDL Changes in NetSuite SOAP Web Services
NetSuite tips for REST webservices
1. Optimize RESTlet Performance Use RESTlets for custom business logic or complex workflows. Minimize response payloads by: Returning only necessary fields. Structuring responses for lightweight processing. 2. Use JSON for Payloads Both SuiteTalk REST and RESTlets use JSON for requests and responses. Ensure payloads conform to the correct structure: Example payload for creating a customer… Continue reading NetSuite tips for REST webservices
NetSuite tips for REST webservices
1. Choose the Right REST API NetSuite offers two REST options, each with specific use cases: SuiteTalk REST Web Services: Provides standardized REST API endpoints. Ideal for CRUD operations on standard NetSuite records. RESTlets: Customizable scripts for specific business logic. Use when you need flexibility beyond standard CRUD operations. 2. Enable Required Features Make sure… Continue reading NetSuite tips for REST webservices
NetSuite tips for Soap webservices
1. Pagination for Large Data Sets For search operations returning large results: Use the searchMoreWithId operation to paginate through results. Set the searchPreferences.pageSize property to control the number of records returned per page. 2. Error Handling Implement robust error handling: Use try-catch blocks for SOAP responses. Log all SOAP requests and responses for debugging. Pay… Continue reading NetSuite tips for Soap webservices
Tips while using SOAP Webservices
When working with NetSuite SOAP web services, several best practices and tips can improve development efficiency and ensure reliable integration. Here are some essential tips: 1. Use Correct WSDL Version Ensure you are using the WSDL that matches your NetSuite account version. Go to Setup > Company > General Preferences > Web Services Preferences to… Continue reading Tips while using SOAP Webservices