We have a custom record that we use to create a list of items that need to be pulled from our backstock location to be put on our retail store's floor to sell. This is done by creating a new record, then scanning pegs on the store's aisles that need to be restocked.
We need to display the quantity on hand at each specific store location as they are scanned. Currently I am able to pull the total quantity on hand for all locations, but cannot figure out a way to pull only a specific location. Any ideas how this may be accomplished?