Join Kit/Package Fields into Inventory Item Search
# beginners
t
Join Kit/Package Fields into Inventory Item Search
Hi there! I would like to build a search that shows the sum of a particular price level / currency of Inventory items (Level = “Special Price”, Currency = “USA”) grouped by the Kit/Package item that this item is a Member Of, but I only want to see specific Kit/Package items based on criteria (e.g. “only Kits that have Custom Checkbox checked”). In short: What is the sum of “Special Price” in USD for all components of Kit/Package Items where Custom Checkbox is checked on the Kit/Package Item? Since I have to join the “Pricing Fields…” on the Inventory Item, I have to start with the Inventory Item level (because you can’t daisy-chain joins like that). However, then I need to join the Kit/Package fields to be able to set criteria on that Custom Checkbox. There is a “Member Of” available as a field, but no corresponding “Member Of Fields…” join. Am I missing something, or is this not currently available?
a
You can do multi level joins in SuiteAnalytics. Go from Kit Item to Component Item to Component Item Pricing fields OR You could try to set the Special Price as a custom field {custitem_specialprice} on the Component Item Record using a workflow or script. Then your saved search could pull that custom field using a member item join