Discussions
Report Filtered by Multi-Select Custom Item Field Inaccurate
We have a multi-select type custom item field. When creating a Sales Order Transaction Report that filters by these selections, we get inconsistent results. When filtering by some selections in this multi-select custom item field, reports return no items. Other selection filters return only a couple of the items when 165 items have that option selected on the multi-select field. We have reviewed the Multi-Select Custom Item Field, the Custom List for this field, and the items trying to find a pattern.
One pattern we found was that if we filter a report by the items first or only selection from this multi-select field, it returns the item. For example, it an item has Blue, Green, and Red selected in this field. Our report filtered by Blue seems to work because its always the items first selection in the list. If we filter the report by Green, we only get the items where blue is not selected so that Green is the first or only item in the list. Because all items with red selected also have either blue or green selected,