I am trying to set up a Pricing Search so that I can produce a Price List for Customers in a suitable corporate format. (The default functionality for creating a customer price list has very few options for customising) .
Using the Support Help topics, I can create a search that is filtered in the Criteria as 'Customer is' and select a customer and this works fine.
But if I then put the Customer Field in as a Filter on that search, it cannot be changed - in the drop down I only get options for All, Unassigned, Mine, My Team, Mine and Unassigned, My Team and Unassigned, and then the customer I defined in the Criteria is shown at the bottom of the drop down. The field will not allow manual typing, so I cannot select another customer.
If I change the search to use Criteria from the Customer Fields (such as Customer:Name/ID or Customer:InternalID) then I can get the Search Filter to be usable. However, this search then returns multiple prices for certain items (and I have no idea why). Filtering by 'Customer' (as above) returns accurate pricing.
Can anyone explain either:
1 How I can filter by Customer
or
2 How to further filter a search using Customer:Name/ID to show only accurate pricing (I tried using Max or Min but these are not always correct - I cannot see any logic where the multiple pricing is coming from.
This is the search using the 'Customer' filter (name blanked out) - as you can see the drop down filter list is useless. Aslo note the item pricing (in particular ASAC as 3.52
This is the search using 'Customer:InternalID' (and using Customer:Name/ID behaves similarly)
The filter field is a drop down that you can also type in (so can be used), but see the vast number of item prices returned for ASAC (but as you can see at the top of the list, not all items are duplicated). I thought these could be all the various prices paid by the customer, but this is unlikely (especially as 2.07 is listed in there, which is actually the Vendor Purchase Price!)