Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.
SuiteQL: Missing Customer Invoices from the transaction table in NetSuite2.com
The SO has the following transactions in the related records
When attempting to get the data via a REST Query, we get no results for INV3353 and INV3421
{"q": "select id, tranid from transaction where tranid in ('INV3421', 'INV3353')"}
{"q": "select id, tranid from transaction where id in (40898, 41434)"} // INV3353 and INV3421
Any thoughts on why that would be the case?
Appreciate in advance for any help/pointers.
0