Hi Nia
We had the exact request and these are answers we received. But I hope your question help us to see if any other way is possible. We do not use Warehouse modules in BC.
Our suggestions were:
1) Run MRP for the location and generate transfer order. We are using this method now.
2) Consider development for this task. The suggestion was at the time of "Release" BC checked Location/item then what is on hand and what is needed then generate Transfer Order. The process is easier if we have one central location to send items to required location. Otherwise, some logics require. For instance, check all locations and see which one has extra items to transfer, or build a relationship table and tell system location B can receive item from which other locations.
Thanks