User_C5N4B Newbie

I discovered what was causing this issue, the primary table used in the subquery did not satisfy the test case where a customer had multiple managers. Left joining the customer table to salesInvoiced showed all customer data that I though was missing from the back-end.

Still looking for a solution

Hello, It isn't possible to edit the field IDs in the Records Catalog or editing field IDs is not supported on NetSuite?

Hello, The Records Catalog is extremely helpful, is it possible to make edits to the field ID there?

Also, we can't match or find the field names that we see in the front using SQL. Another word, I presume the field names on the frontend GUI should be the same as in the SQL queries? How can find the same field names as shown on the frontend? Please advise.

Hello, We've added the permissions to the role, but still the table is either empty (or isn't showing in Dbeaver). It is difficult to track if the permissions we're adding to the role is making a change.

Hi, Please see attached screenshot. Please advise.

Hi Nicole, Here's the screenshots for my role and permission. I see the permissions you have many don't seem to apply for what we're doing. Anything missing from mine that you think could cause my issue?

I am using a JDBC connection to connect with Dbeaver. I wasn't able to open the connection configuration (I am already connected), so I pasted the JDBC url below. JDBC Url:…

I searched up "transaction", "transactionline", "transactionaccountingline", and "entity" in the navigator and could not find the table that contains the data I'm looking for. I went to the records catalog and found a record of "transactions", this might be what I'm looking for, but I do not see an instance of…

I understand that pulling pre-made reports from ODBC/JDBC connection isn't possible, but in order to write a query, I need to know the name of the table that contains sales data. So there isn't a default name for the table that contains all sales data?

I've copied the permissions from the role I need to view sales reports, but I still can't seem to find the table. I'm assuming there isn't a default name for the table that contains sales reports? I ditched using Excel and connected to NetSuite via DBeaver, so I am now using a JDBC driver, does that change anything…

I followed @Nicole Mendoza-Oracle instructions, it gave me access to tables that weren't viewable - but finding the relevant table is still a struggle. Is there a default name for all sales data?