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 to create a Saved Search to Show Group Member Items with Mismatched Fields?
Good day all. I need the wisdom of the community.
We use group items to "package" inventory items with additional non-inventory or service items (i.e. Tariff Cost or Storage Fees). Separately, we have a custom field of "revision" that we have used in inventory items for some time, but need to extend this field to the associated non-inventory and service items when they are in a group. I'm working on a exception report to show me when the Revision field on the group doesn't match ALL of the Revision fields of the member items.
The image below is just the groups and member items. No error criteria is in please to show the base data and I've deliberately chosen examples with no mismatch (and this list is a lot longer).