ELN search in inventory retrieves also container from Trash location.Event unflagging the “Exclude special Location” check box was not working.Please suggest any way to permanently exclude this container from the ELN search.

Created
October 08, 2021 23:09

Date Posted: 2020-12-31
Product: E-Notebook Enterprise

Problem:

ELN search in inventory retrieves also container from Trash location.

Event unflagging the “Exclude special Location” check box was not working.

Please suggest any way to permanently exclude this container from the ELN search.

Solution:

Please verify whether the following tag exits in Web.Config file of COWSWebService (default file location is on ELN Application server in ?:\Program Files (x86)\CambridgeSoft\Informatics2005\COWSWebService .NET 2.0\):

<add key="ExcludeLocations" value="2,3,4"></add>

'Exclude Special locations' checkbox in ELN will work only with this tag in Web.Config file. If you have already this tag there, then you need to check if LOCATION_ID for Disposed location is added to tag value. You can verify LOCATION_ID by connecting to your database and executing the following query:

SELECT LOCATION_ID FROM CHEMINVDB2.INV_LOCATIONS WHERE LOCATION_NAME = 'Disposed'

Location numbers by default are: 1 - On Order, 2 - Disposed, 3 - Trash Can and 4 – Missing.