Many users often encounter the error “XXX table not found” or something similar when they run a query, or they cannot find the table they need despite seeing it in SuiteAnswers or Records Catalog. Most of the time, this is simply caused by a missing permission.
But did you know that you can check what permissions are required to view tables in SuiteAnalytics Connect? To do this, you must follow these steps:
1. Login using the Administrator role or a custom role that has access to Records Catalog.
2. Navigate to Setup > Records Catalog
3. Expand the drop-down for the table you’re looking for and under it, click the SuiteScript and REST Query API.
4. Click on the Overview subtab. Under it, you should be able to see if it is Available, Feature, and what permission is required to access that table.
In this example, I used the transaction table. Find Transaction permission is often missed when setting up a new role for SuiteAnalytics Connect. Despite having several transaction permissions such as Sales Order, Cash Sale, and Item Fulfillment, you will not be able to view the transaction table without Find Transaction permission.
------
Found this article helpful? Let us know by leaving a comment or a reaction!