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!
How can we have an identifier for Group/Kit Item components in transaction lines via JDBC query?
Hello,
Our BI team uses Workato to get all of our NetSuite information from JDBC.
We use Groups, Kits, and stand-alone items.
In the NetSuite back-end table Transaction_Lines, we need some attribute/flag to easily identify each line if it’s a Stand-Alone item, part of a Group, or part of a Kit.
Is there a certain way to make such a distinction on the line level, using SQL query?
We currently use “DO_NOT_PRINT_LINE” to distinguish between Stand-Alone and Group/Kit items, but this field is not working as expected for items that can be sold as both SA and as part of a Kit/Group.