Hello,
We limit our item offerings to selected Customers. Item A can be sold to Customer A, B, C only. Item B can be sold to Customer B, C, and D only.
We added a multi-select custom field on Item record with list of Customers. Then, created an Item Saved Search, added this custom field as Available Filters, and used this Saved Search as item filter on the Sales Order form. But, this didn't work as expected, all of the Items are still showing.
When creating a Sales Order, is it possible to filter the Item dropdown list based on the Customer selected if it matched the Customer/s selected on the Item record? Thank you!