Dynamics GP 2013 - Assign item to site script

This was taken from the sql profiler, and can be used to mass generate scripts to assign items to sites.
Using an excel sheet with this script and all items and sites, you can specifically assign items to sites as required for an integration.


EXEC zDP_IV00102SI '256RAM', 'WAREHOUSE', '', 2, '', 0, 0.00000, 0.00000, 0.00000, '1900.01.01', '', '1900.01.01', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '1900.01.01', '00:00:00', '1900.01.01', '00:00:00', 0, '', '', '', 1, 0.00000, 0.00000, 1, 0.00000, 0.00000, 1.00000, 2, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0, 0, 1, 0, 0, 0, 3, 0.00000, 0.00000, 0.00000, '', '', '', '', '', '', '', '', 1, 1, '', 1, 1, 0.00000, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0


If it requires a count date

EXEC zDP_IV00102SI '11025-H', 'MW102', '', 2, '', 0, 0.00000, 0.00000, 0.00000, '1900.01.01', '', '1900.01.01', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '1900.01.01', '00:00:00', '1900.01.01', '00:00:00', 0, '', '', '', 1, 0.00000, 0.00000, 1, 0.00000, 0.00000, 1.00000, 2, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0, 0, 1, 0, 0, 0, 3, 0.00000, 0.00000, 0.00000, '', '', '', '', '', '', '', '', 1, 1, '', 1, 1, 0.00000, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0