I am using suiteQL, I am fetching purchase order and sales order using query Select * from PurchaseOrder, but I am getting error. Search error occurred: Record ‘PurchaseOrder’ was not found. I have tried using suiteql rest web services as well SuiteQL tool.

AI generated answer (using internal Slack threads):

It seems like you are trying to fetch data from the

PurchaseOrder

and

SalesOrder

records using SuiteQL but encountering an error. The error message indicates that the

PurchaseOrder

record was not found. This could be due to a few reasons: 1. The

PurchaseOrder

record does not exist in your NetSuite account. Please verify if the record exists and you have the necessary permissions to access it. 2. The record name is case sensitive. Make sure you are using the correct case. For example, it should be

PurchaseOrder

and not

purchaseOrder

. 3. The role you are using to execute the SuiteQL query might not have the necessary permissions to access the

PurchaseOrder

record. Please ensure that your role has the required permissions. 4. If you are using REST web services, make sure you are using the correct endpoint and the correct HTTP method (GET, POST, etc.). Here is an example of how you can fetch data from the

PurchaseOrder

record using SuiteQL:

sql
SELECT * FROM PurchaseOrder

And here is an example of how you can fetch data from the

SalesOrder

record using SuiteQL:

sql
SELECT * FROM SalesOrder

Please replace

*

with the actual fields you want to fetch from the records. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

@tuli its SELECT FROM transaction not purchase order

thank you @Bryan Miller, It was in record catalog so thought of that. This worked. “SELECT * FROM transaction WHERE type = ‘SalesOrd’”