Author: Christo Johns

Sample Query to fetch Pricing per Customer with itemtype and Customer ID as filter

SELECT     BUILTIN_RESULT.TYPE_INTEGER(pricingWithCustomers.internalid) AS internalid,       BUILTIN_RESULT.TYPE_PERCENT(priceLevel.discountpct) AS discountpct,     BUILTIN_RESULT.TYPE_CURRENCY(pricingWithCustomers.unitprice, BUILTIN.CURRENCY(pricingWithCustomers.unitprice)) AS netprice     FROM     pricingWithCustomers LEFT JOIN     item ON pricingWithCustomers.item = item.ID LEFT JOIN     priceLevel ON pricingWithCustomers.pricelevel = priceLevel.ID LEFT JOIN     Customer ON pricingWithCustomers.customer = Customer.ID WHERE     (… Continue reading Sample Query to fetch Pricing per Customer with itemtype and Customer ID as filter

How to Share OAuth 2.0 Integration Credentials in NetSuite Without Granting Account Access

When setting up OAuth 2.0 integrations in NetSuite, there may be scenarios where you need to share the integration credentials with someone who does not have direct access to the NetSuite account. To securely enable this, NetSuite provides an OAuth 2.0 Consent Policy during the creation of the integration record. By selecting the appropriate consent… Continue reading How to Share OAuth 2.0 Integration Credentials in NetSuite Without Granting Account Access

How to Avoid Using a Saved Search on Field Change in a NetSuite Client Script

Using a saved search within the fieldChanged function of a NetSuite client script can lead to performance issues and script delays. Every time a field is modified, the saved search is triggered, which may cause unnecessary load on the system, especially when handling large datasets or frequent field changes. To improve script efficiency and avoid… Continue reading How to Avoid Using a Saved Search on Field Change in a NetSuite Client Script

How to add a delay to a Dell Boomi flow using data process

When making API calls within a Boomi flow, if multiple requests are triggered simultaneously and the API does not support concurrent calls, resulting in errors, you can mitigate this by using a combination of a flow control block and a data process block. By adjusting the delay in the script, you can ensure an appropriate… Continue reading How to add a delay to a Dell Boomi flow using data process

How to Resolve SFTP Connection Timeout Issues

When connecting to an SFTP server from NetSuite, you may encounter connection timeout errors, preventing successful file transfers. These issues can arise due to network restrictions, incorrect configurations, or authentication problems. This article outlines common causes and solutions to resolve SFTP connection timeout issues in NetSuite. Common Causes of SFTP Connection Timeout Issues Incorrect Hostname… Continue reading How to Resolve SFTP Connection Timeout Issues

How to Create a Memorized Transaction in NetSuite

Memorized Transactions in NetSuite allow users to automate recurring transactions, reducing manual data entry and ensuring consistency. Whether you need to set up recurring invoices, bills, or journal entries, this feature helps streamline financial processes. What is a Memorized Transaction? A Memorized Transaction is a template for frequently used transactions that can be scheduled for… Continue reading How to Create a Memorized Transaction in NetSuite