I found that as I receive inventory it adds a supplier multiple times (once for each price with a effective date start and end). I think that's great to have a history of prices paid. So It does update last paid, but adds a new record (I was confused why this did not get updated when the P.O. was entered, but now I understand its better in receiving).
My problem is the lookup for product when entering a P.O. uses lookupsupplierproduct, which returns the same information several times (as price is not in the returned set). Since it is only looking for a productid, it really does not have to be tied to a vendor here? At a minimum it should be distinct based on the returned values.
I found findoptions.setdistinct but am not sure how to implement it.
Can it be put in actions?
If not I am not sure what is supplying the data to the find.
I imagine I just need a distinct = "true" but I tried in a few places with no luck.
Joel Fradkin
Locked
