Technical Blog Post
Abstract
Cannot add Items to Storeroom using Item Master application
Body
Problem:
While trying to add Items to Storeroom using Item Master application, the Add Items to Storeroom dialog is opened empty.
Steps to replicate:
1. Go to Item Master application.
2. Create a new Item.
3. Select action > Add Items to Storeroom.
The Add Items to Storeroom dialog is opened empty.
Resolving the problem:
Run the query below to check if the maxvar 'DFLTINVSTATUS' has a value which does not exist in the synonymdomain table under domainid 'ITEMSTATUS'. This maxvar is site-level.
SELECT * FROM MAXVARS WHERE VARNAME = 'DFLTINVSTATUS' AND VARVALUE IS NOT NULL AND VARVALUE NOT IN (SELECT MAXVALUE FROM SYNONYMDOMAIN WHERE DOMAINID = 'ITEMSTATUS');
The recommendation is to either set the varvalue for the maxvar 'DFLTINVSTATUS' to null, or to a value with exists in the synonymdomain table under domainid 'ITEMSTATUS'.
UID
ibm11112445