Here’s a quick SQL query to show which items are assigned to any inventory site in Microsoft Dynamics GP, and how many of each item are on hand in the site.

select itemnmbr, qtyonhnd
from iv00102
where locncode='EACH'
order by 1
;

In our case the inventory site was named ‘EACH’. Replace that with the name of your site.

Hope this helps!

Leave a Reply

Your email address will not be published. Required fields are marked *

 characters available