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.
Item - Transaction joins
I've often faced this problem but don't think ever found a good solution. Let's say I need an item search that also brings in information about open purchase orders related to those items. As soon as I add the joined field, of course it only brings back rows for items that have open purchase orders. How can I keep a row for every item while also bringing in information about the PO? In other words, I want the base list to include items that have no related purchase orders.
0