Customer's Price for Item

Hello,

I'm trying to make a search that will return an item's price for a certain customer but seem to be having trouble. I'd like to supply an item and a customer as a filter and have returned to me the unit price that would be sourced for that item when adding to a sales order for that customer. The customer may have a custom customer specific price level and if they don't have this I'd like the customers normal price level returned.

Does this make sense to anyone, any ideas?

The closest I've come to a solution is to first perform a customer search and specify the customer and Pricing Item then look for the Item Pricing Unit Price in the results, if this is populated I'll use this value. However, If this returns no results then I'll do a second search.