I am currently encountering a challenge with SuiteQL related to accessing data from the Planned Order table ("plannedOrder"). I have attempted to execute a query with the statement "SELECT * FROM plannedOrder", but it consistently results in an error stating "An unexpected SuiteScript error has occurred".
The Record Catalog and SuiteQL Tables Reference indicates that the table exists, along with details on its columns and join information. Despite trying variations of the query, including specifying column names, the error persists.
Given that the table is recognized in NetSuite documentation, this error is unexpected and I am seeking your expertise to understand the underlying cause. Additionally, any suggestions for a potential workaround or solution would be greatly appreciated.
Here are the details of my attempts for your reference:
- Query tried: "SELECT * FROM plannedOrder"
- Variations: Specified column names in the SELECT statement
- Error encountered: "An unexpected SuiteScript error has occurred"
- Saved Search "Planned Order": "Shows the required result"
Your prompt attention and support in resolving this issue would be invaluable, as it is crucial for our ongoing data management and reporting activities.