SET ITEM # TO NULL IN V9

from tech toolkit sql shell run the following script

update invn_sbs
set item_no=NULL
where active=0

that will remove the item#’s from inactive items so they will not conflict in PI Imports.

That script can also be run at any V9 that previously upgraded that is having problems with dup ALU/Item#