Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Join assembly item to work order query (SuiteQL)
When I try this query:
SELECT t.tranid, t.id, i.itemid, i.description from transaction t INNER JOIN item i ON t.item = i.id WHERE recordtype = 'workorder'
I get:
Invalid search query. Detailed unprocessed description follows. Search error occurred: Field 'item' for record 'transaction' was not found.
I've looked at the Records Catalog and tried item, assembly and assemblyitem. No luck. I know the item can be joined to the work order transaction because I have existing SuiteScript that does that. Names are all different in SuiteQL, though.
edited to remove distracting details