Sort by custom field on item
One of our employees has setup a custom field on items. He calls that custom field product groups and assigns certain parts into each group. He's wanting to run the Open Purchase order details by item report but to only show a certain product group or to show all product groups he's assigned and sort them by group. So far when we set a filter to either a specific group it blanks out the entire report as if that isn't a usable filter. Also noticed that if I add the column order group no item shows information there like it hasn't been done. Are we doing something wrong? Is there a way to do this?

