In the Vendor records, we could see that there is no option to set up a parent for the Vendor but names are appearing like Name 1 : Charity Name A. The name shown usually comes when a Parent record is associated with the NetSuite records. In this case, as Vendor records don’t have a… Continue reading Extra text of prefix appearing before Vendor names (like a parent relationship)
Author: Geordy Cleetus
Web Services Concurrent Users with SuiteCloud Plus
Any user can be designated as concurrent web services user if one or more SuiteCloud Plus license has been purchased. Generally, you can purchase one SuiteCloud Plus license per NetSuite account. Contact your sales representative to discuss any need for additional licenses. Web services and RESTlet concurrency is also governed per account. The new account… Continue reading Web Services Concurrent Users with SuiteCloud Plus
SOAP Cache clearing time for the preferences
Preferences, customizations, and custom fields are cached by SOAP web services sessions, in Create, Read, Update, Delete and search operations. For example, if you enable or disable an accounting preference at Setup > Accounting > Preferences > Accounting Preferences, your current SOAP web services session still retains the previous setting of the preference. To have… Continue reading SOAP Cache clearing time for the preferences
Request level preferences of SOAP
The available preferences are: disableMandatoryCustomFieldValidation disableSystemNotesForCustomFields ignoreReadOnlyFields runServerSuiteScriptAndWorkflowTriggers warningAsError bodyFieldsOnly pageSize returnSearchColumns
SOAP guidelines when working with both standard and custom fields
If a standard field is set as mandatory in a custom form, the “requiredness” of the field is honored in SOAP web services. If you do not provide value in your SOAP web services request for a field that is set as mandatory in a custom form, an error message is returned. For more information on NetSuite… Continue reading SOAP guidelines when working with both standard and custom fields
REST Query to fetch the transactions created between two time intervals
POST https://{ACCOUNT_ID}.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=100&offset=0 { “q” : “SELECT BUILTIN_RESULT.TYPE_STRING(TRANSACTION.id) AS internalid FROM TRANSACTION, transactionLine WHERE TRANSACTION.ID = transactionLine.TRANSACTION AND ((transactionLine.subsidiary IN (‘x’) AND TRANSACTION.TYPE IN (‘<transactiontype> ex:PurchOrd‘) AND TRANSACTION.createddate BETWEEN TO_TIMESTAMP(‘2024-05-15 23:00:00’, ‘YYYY-MM-DD HH24:MI:SS’) AND TO_TIMESTAMP(‘2024-05-16 23:00:00’, ‘YYYY-MM-DD HH24:MI:SS’) AND transactionLine.mainline = ‘T’)) ORDER BY TRANSACTION.id DESC” }
Where to find the response of a successful REST call to NetSuite
REST web services help to directly create, fetch, update and delete most of the NetSuite records. This mainly supports POST, GET, PUT and DELETE requests. While sending REST API responses, the successful execution results in returning a 204 code, which sometimes is treated as a failure as no response is returned in the body from… Continue reading Where to find the response of a successful REST call to NetSuite
Oath 2.0 Machine to Machine flow not working with Code Grant flow checkbox unchecked and client credentials checked
OAuth 2.0 access is based on the authorization code grant flow for the generation of access tokens and refresh tokens, or the client credentials flow. The client credentials flow is a machine-to-machine flow for the generation of access tokens. If we only require client credentials, still the authorization code grant flow should be checked and… Continue reading Oath 2.0 Machine to Machine flow not working with Code Grant flow checkbox unchecked and client credentials checked
How to return Items for an Order as a Credit memo in case of damaged Items
In the context where the Customer orders are created as Invoice records, the returns can be tracked by creating Credit memos and the amount can be later applied in the next payment. So returns can be tracked to the warehouse locations in such circumstances. In case of a damaged product returned from a Customer for… Continue reading How to return Items for an Order as a Credit memo in case of damaged Items
REST Query to fetch the transactions created in the last n hours
POST https://{ACCOUNT_ID}.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql?limit=100&offset=0 { “q” : “SELECT BUILTIN_RESULT.TYPE_STRING(TRANSACTION.id) AS internalid FROM TRANSACTION, transactionLine WHERE TRANSACTION.ID = transactionLine.TRANSACTION AND ((transactionLine.subsidiary IN (‘x’) AND TRANSACTION.TYPE IN (‘<transactiontype> ex:PurchOrd‘) AND TRANSACTION.createddate > BUILTIN.RELATIVE_RANGES(‘hago<n>’, ‘END’, ‘DATETIME_AS_DATE’) AND transactionLine.mainline = ‘T’)) ORDER BY TRANSACTION.id DESC” }