I've used UT-K-B to do a global replace on cycle codes to make them all blank as we want to assign completely new codes.
 
In maintain database the Cycle field in MTIMCSTR is now showing blank on everything as I woul expect.
 
But in Inventory Inquiry and Enter Inventory screens I can still see the old codes in the 'Cycle Code' field.
 
If I go in through Enter Inventory and change the code it comes out correctly.
 
Do I need to do a global replace somewhere else as well to blank them all out?
 
Help!
 
(Using EVO update 1/22/10, PSQL10)

Thanks - that worked

We imported all new cycle codes in July using DE-B. Has this been broken by an update since then? I thought the move from 1 to 4 characters was further back.

using DE-B you utilize the Cycle Code field reference to your import. the programmer should have already fixed this program to have that data then be stored in the MTIC.PROD.VEND[8] field.  
 
you could as a back up, if you are not using #3 Vendor Part# is put your cycle codes there, and then run a SQL statement, to copy those values into their proper place.
 
but i do believe, the DE-B will already have the Cycle Code field going to the Vend[8] field for you and you don't need to do anything different.
 
hth

Now I get it -   if I'd just used DE-B to update the whole lot (including blanks) instead of wiping them all out in the first place I would never have even realised it was stored in VEND[8] rather than the cycle code field and I would've been less confused.
 
So now, when I get a chance to get everyone out of EVO, I will just carry on with DE-B to do the update (putting the cycle code in what appears to be the cycle code field in DE-B but really will update VEND[8]) and all will be right with the world.
 
Thanks for all your help