I am working with a client who uses NetSuite ERP. We are trying to get Sales reports for them, which we are doing by using the transaction table from SuiteQL schema.
We also need the transactions’ status, for which we need the transactionStatus table to load through Sync. On doing so, I am getting the following error :
“[0] [INVALID_PARAMETER] Invalid search query. Detailed unprocessed description follows. Search error occurred: Record ‘transactionStatus’ was not found. Bad Request.”
Typically this error message "Error: [INVALID_PARAMETER] Invalid search query. Detailed unprocessed description follows. Search error occurred: Record ‘transactionStatus’ was not found. Bad Request." is thrown because of missing permissions in your Netsuite account. If you haven’t already, please try adding all the permissions on the list found here: CData ODBC Driver for NetSuite - Permission Configurations
This is most evident on the Transactions table, but permissions in Netsuite are somewhat complicated, and occasionally you may need multiple permissions just to access all the data in one table. I believe this most likely affects tables that have fields linked to other tables.
If you’ve already done so, you might need to collect logs for the failing jobs and send them over to the support team at support@cdata.com for further investigation.
Hi! Thank you for the swift response, Ethan.
I checked the permissions documentation you shared with me, and we had all the permissions from NetSuite.
I stumbled upon a thread, that helped me solve this issue.
I had to give the Setup → Set up Company permission in NetSuite and was finally able to load the transactionStatus table.
This website stores cookies on your computer. These cookies are used to collect information about how you interact with our website and allow us to remember you. We use this information in order to improve and customize your browsing experience and for analytics and metrics about our visitors both on this website and other media.
Review section III of our Privacy Policy for more information on cookies.
To opt out of “sale” or “sharing” of non-cookie data, visit our Privacy Rights Request Form.
