# transactionStatus table not loading CData Sync

**URL:** <https://community.cdata.com/t/transactionstatus-table-not-loading-cdata-sync/622>\
**Category:** CData Sync\
**Tags:** question, odbc, netsuite, cdata-sync\
**Created:** [January 31, 2024, 1:44pm UTC](https://community.cdata.com/t/transactionstatus-table-not-loading-cdata-sync/622 "2024-01-31T13:44:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aniruddhmaitra](https://avatars.discourse-cdn.com/v4/letter/a/7feea3/32.png) [@aniruddhmaitra](https://community.cdata.com/u/aniruddhmaitra)\
**Post date:** [January 31, 2024, 1:44pm UTC](https://community.cdata.com/t/transactionstatus-table-not-loading-cdata-sync/622/1 "2024-01-31T13:44:14Z")

</div>

Hi!

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.** _”

 ![e4cec85a-0ab3-46c1-9d52-c5e12f03aba3.png](https://us1.discourse-cdn.com/cdata/original/1X/74ffb38f9b7c0591836e210954fbfd5f51484c37.png)

Please help me load this table.​​​​​​​

---

<div class="post-metadata">

**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\
**Post date:** [January 31, 2024, 10:11pm UTC](https://community.cdata.com/t/transactionstatus-table-not-loading-cdata-sync/622/2 "2024-01-31T22:11:16Z")

</div>

Hi @aniruddhmaitra

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](https://cdn.cdata.com/help/DNJ/odbc/pg_permissions.htm)

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](mailto:support@cdata.com) for further investigation.

---

<div class="post-metadata">

**Author:** ![aniruddhmaitra](https://avatars.discourse-cdn.com/v4/letter/a/7feea3/32.png) [@aniruddhmaitra](https://community.cdata.com/u/aniruddhmaitra)\
**Post date:** [February 1, 2024, 7:55am UTC](https://community.cdata.com/t/transactionstatus-table-not-loading-cdata-sync/622/3 "2024-02-01T07:55:28Z")

</div>

Hi! Thank you for the&nbsp;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.  
https://embed.reddit.com/r/Netsuite/comments/1868ic9/transaction_status_list_not_available_to/?embed=true&ref_source=embed&ref=share  
I had to give the **Setup →&nbsp;Set up Company** permission in NetSuite and was finally able to load the transactionStatus table.
