In NetSuite, we cannot create an Access token from the Navigation: Setup → Users/Roles → Access Tokens → New Instead of this, if the user trying to create has an Admin role, he/she can create an Access Token from the Home Page, using the Manage Access Tokens
Author: Geordy Cleetus
Effects on Suitescript while applying Journal and Customer payment on Invoices(Write off)
SuiteAnwer ID: 64439. After you have entered a journal entry to write off bad debt, the next task is to accept a customer payment. To accept a zero customer payment amount: Go to Transactions > Customers > Accept Customer Payment. In the Customer field, select the customer with the unpaid invoice. You can change the… Continue reading Effects on Suitescript while applying Journal and Customer payment on Invoices(Write off)
Changes to SOAP Web Services Endpoint Release and Support Policy Starting with NetSuite 2026.1
NetSuite has announced an important change regarding the release and support policy for SOAP Web Services endpoints, effective from 2026.1 release. NetSuite currently releases a new SOAP Web Services endpoint with every major release (usually happens twice a year, e.g., 2024.1, 2024.2, 2025.1, 2025.2, etc.). What’s Changing? From next year, NetSuite will stop providing a… Continue reading Changes to SOAP Web Services Endpoint Release and Support Policy Starting with NetSuite 2026.1
SQL query example that pulls Revenue data and the necessary fields from a BigQuery table containing NetSuite data
The following is an SQL Query that pulls data needed to generate Revenue data. The data is fetched from a BigQuery table that is updated from NetSuite via the FiveTran Connector. SELECT t.id AS transaction_id, t.tranid AS transaction_number, MAX(t.trandate) AS transaction_date, MIN(c.id) AS customer_id, MAX(c.externalid) AS customer_sfid, MAX(c.entityid) AS customer_name, MAX(s.id) AS subsidiary_id, MAX(s.name) AS… Continue reading SQL query example that pulls Revenue data and the necessary fields from a BigQuery table containing NetSuite data
Will NetSuite prevent a map reduce script from running if it encounter time-out errors?
In NetSuite, a Map/Reduce script is not automatically prevented from running again if it encounters a timeout error. Instead, the behavior depends on which stage the timeout occurs: Get Input Data Stage: If a timeout occurs here, the entire script will fail, and no further processing will take place. You will need to reschedule or… Continue reading Will NetSuite prevent a map reduce script from running if it encounter time-out errors?
PostSourcing function in a NetSuite Client Script isn’t working as expected
If your PostSourcing function in a NetSuite Client Script isn’t working as expected, here are some tips to troubleshoot and ensure it functions correctly: 1. Check Script Deployment & Record Type Ensure the script is properly deployed to the correct record type. Verify that the deployment status is set to “Testing” or “Released”. Ensure the… Continue reading PostSourcing function in a NetSuite Client Script isn’t working as expected
Memo (body field) is not showing correct values when sourced on Email template
When an email is sent, the ‘Memo’ field does not have the correct value populated. It shows the tax description or item description values from the last line item. The field sourced in the Email template is by ‘${transaction.createdfrom.memo}’. To fix this, the Email template field should be changed to ${transaction.createdfrom.memomain}. With this change, only… Continue reading Memo (body field) is not showing correct values when sourced on Email template
Method to calculate the Reverse Discount item amount to omit certain line items having tax codes
When a reverse discount item is added to a custom item, the reverse discount item should also contain the tax code of the custom item so that the tax amount applied is reversed. If the functionality is only adding a single reverse discount item for all the Custom items added, it won’t help in reversing… Continue reading Method to calculate the Reverse Discount item amount to omit certain line items having tax codes
Workato configuration to process Transaction line level from an array of Objects in BigQuery
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.