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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and 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.
0