It is common to have an item in more than one location in a store, for instance on the sales floor as well as in backstock. Item properties should support multiple Bin Locations (not just the two in my example). The averaged cost should remain the same across all quantities/locations of the item. Some allowance must be made when inputting physical inventory -- we of course want the overall quantity of items from all locations.
---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.