Skip to main content

I imported inventories against a default warehouse an location. However, decided to remove it later on before entering any transactions.

 

Bulk removed default warehouse and locations from ‘inventory card’ and ‘Item Warehouse Details’ screen.

Now when creation purchase order and using ‘Add Items’ button, system still holds this information in inventory lookup as a siteID value.

If adding lines manually using + button it’s all goof. Only when using below Add Items button.

 

How can I remove warehouses from here?

 

 

Have you checked the Item-Warehouse Details Records.  It also contains the default issue from and default issue to fields.


@Chris Hackett Hi Chris, unfortunately not yet. we found out there is a hidden table adds the warehouse ID to stock items once you add it to the item card in system. removing it does not remove it from that table, but if you have access to database you should be able to remove it. 

Hi @Foujan 

Yes, once a transaction has been created with the warehouse, it will keep it in the tables. Even though it was an import scenario, it still creates a transaction. 


@Chris Hackett Hi Chris, unfortunately not yet. we found out there is a hidden table adds the warehouse ID to stock items once you add it to the item card in system. removing it does not remove it from that table, but if you have access to database you should be able to remove it. 


Hi @Foujan were you able to find a solution? Thank you!


Looks like you have the warehouse and location defaulted to several stock items.  You could import over the location (change the default location).  


You might have to use a SQL script to remove them from this table but proceed with caution


@dcomerford Yes. but still no results. I tried to create a GI using INSiteStatus table, and found this table holds this information, but I cannot use import scenario to remove data from it.
 

 


Have you tried Recalculating Inventory IN505000 also check the Replenishment tab on the item 


Reply