Im trying to a create a multi location stock enquiry where a user can enter a reference for an item, which returns the items stock at different locations.
I have managed to achieve this, however i would like to now add a field to display the total sales for the item at the different locations.
Does anyone have any ideas on how i can achieve this?
Thanks.