Author: Geordy Cleetus
How to omit certain line items from being applied with the Discount applied in the Transaction Body level.
A discount item can be used to reduce the total amount of a transaction. To apply a discount item to a transaction’s total, select the discount item you want to apply in the Discount field. NetSuite auto-fills the item’s rate and the transaction’s discounted total. In this case, the Discount is equally applied to all… Continue reading How to omit certain line items from being applied with the Discount applied in the Transaction Body level.
Sales Order Line Highlighting for certain Item type/Item configuration
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
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