Inventory -> Profiles -> Stock Items
Does anyone perhaps know how to change the Default view (by editing the underlying generic inquiry) so that in the view of
Inventory->Profiles-Stock Items: we can see the Inventoy Code, Description, Qty on Hand, Last Cost, Average Cost, and most importantly instead of the "default selling prices", the effective selling price from the Sales Price Worksheet?
Subqueries would be best for this, but they aren't available yet:
A SQL View could be used, but that method might not work in future versions:
You might be able to pull it off with grouping.
For effective customer pricing, see this Discussion Topic: