Discussions
custom field to show item totals qty across all locations.. and more
Hi,
It would be very helpful to us to be able to have the following custom fields on our items (on the inventory tab).
1. Total Qty on hand (summary of all locations on hand)
2. Average sales price
3. Average GP %
Is it possible using formulas and or filters to get custom fields to display this kind of thing?
Any help appreciated.. I had a go at this for a while but not much luck thus far. Even if you might know this is not possible that response would be good.
Thanks!