In Microsoft Dynamics GP, if you want to remove an inventory location from your system, one of the things you’ll need to do is remove any stock count schedule lines that include the inventory site. Otherwise you won’t be able to remove the association between the item number and the inventory site that are on the stock count.

Another piece of the puzzle falls into place

Another piece of the puzzle falls into place

You can find stock count schedules that include the inventory site like this. In the following query we’re looking for the inventory site named DRAIN.

select distinct stckcntid
from dbo.IV30701
where locncode='DRAIN'
order by stckcntid;

And this will find any unposted stock counts that contain the inventory site. Again we’re looking for DRAIN, you need to substitute the name of the inventory site you are seeking.

select distinct stckcntid
from dbo.IV10301
where locncode='DRAIN'
order by stckcntid;

Once you’ve found the stock count schedule(s) you can delete or edit them as you see fit, and one of the obstacles to removing an unwanted inventory site from GP will be gone.

Hope this helps!

Leave a Reply

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

 characters available