By using this website, you agree to our Terms of Use (click here)
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?
Kind regards
JP
Subqueries would be best for this, but they aren't available yet:
https://feedback.acumatica.com/ideas/ACU-I-1190
A SQL View could be used, but that method might not work in future versions:
https://www.augforums.com/an-acumatica-sql-query-idea
You might be able to pull it off with grouping.
For effective customer pricing, see this Discussion Topic:
https://www.augforums.com/forums/everything-else/pricing-inquiry