iSolution Partners delivers a SQL Script to Assign ALL GP Items to ALL Warehouses .
SQL Script to Assign ALL GP Items to ALL Warehouses – iSolutions Partners
Sales, Purchasing & InventorySQL & DataDevelopment & Integration
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.