RE: CIC.ICACT -- BPCS-L

Maybe a dumb suggestion but...

After doing all you've done to get to about 1000 records with ICACT = 'Y', and 
before any action on the system, make a copy of CIC and clean that flag , using 
sql over the selected records. Then, keep an eye over those records during 
several MRP/MPS runs and other activity in the system. If the flag doesn't 
appear changed for those records, you'll know that they are orphan items. 

We're using the method suggested by Daniel Warthold for years but realize that 
it can be a huge batch job is if  ITH has millions of records...

Best regards,

Manuel Antunes
Laboratorios Azevedos, SA
Lisbon - Portugal



-----Mensagem original-----
De: Daniel Warthold [mailto:daniel.warthold@xxxxxxxxx]
Enviada: segunda-feira, 1 de Novembro de 2004 16:30
Para: 'SSA's BPCS ERP System'
Assunto: RE: CIC.ICACT


Suggestion: why not query on ITH for items with no activity since a selected
date?
We are not sure how CIC.ICACT gest flagged by other various BPCS
transactions. I would prefer make my own "activity" flag  using my own
criterias. You could add to the list of items with no activity from ITH,
items with no forecast, no open ECL, etc. as per your preferred criterias.


Daniel Warthold


-----Original Message-----
From: Alister Wm Macintyre [mailto:macwheel99@xxxxxxxxxxx]
Sent: Sunday, October 31, 2004 16:01
To: BPCS_L discussion
Subject: CIC.ICACT



Under what circumstances would this field still be "Y" after all facilities
have had MRP500 MRP600?

My understanding of the field is that any action to any item in a facility
that would impact MRP or CAP, such as change to customer orders, change in
inventory, change in BOM or Routings, tha causes this flag to go on, then
when MRP full regeneration is completed, the flag is off again.

Right before End Month, I did do MRP500 MRP600.
Right after End Month, we had 18,000 CIC records with ICACT 'Y' ... I was
surprised that End Month jobs would flag MRP needed, so I ran it all
again.  I noticed that after MRP500 but before MPR600 on one facility that
the count rose to 23,000 telling me that MRP500 probably flags children of
relevant master scheduled items as needing attention.
After 100% facilities had MRP500 MRP600 we had 1,000 records in CIC still
with ICACT 'Y'

I recognize some of them as samples and pilots where we have activity
before the engineering is completed, but far too many items in the
condition of ICACT 'Y'
I am wondering if some are master scheduled engineering orphans, children
of parent items such that there is no way for MRP to get to them, so they
get flagged but never reached.  For example, perhaps there was activity
right before an engineering change that made a sub-component such that it
has no parents any more.  We might have conversion artifacts that became
"Y" permanently.  I am just trying to get a handle on all possible reasons
... I suspect most of these items are some kinds of data errors we ought to
clean up.

The reason I got interested in this field.
We want to identify whether we have dead inventory ... such as children of
customer parts whose orders have dried up.  Perhaps Safety Stock needs a
review, but on which items?
Most reports that list cost variances, items in more than one facility
whose costs inconsistent, etc. list all items that have ever been
engineered in a facility.
We have people who only want to be researching items with cost
discrepancies when we have on-hand or those items are recently active, so I
been looking into fields that define activity, that are relatively easy to
combine in query/400.  Since CIC has standard & actual cost by item by
facility & also this field, it seemed like a good choice, except I thought
it meant only those items active today, since we do MRP500 MRP600 every
evening.

-
Al Macintyre  http://www.ryze.com/go/Al9Mac
Find BPCS Documentation Suppliers
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html
BPCS/400 Computer Janitor at http://www.globalwiretechnologies.com/
Replacement company web site (same company, new
domain)  http://www.globalwti.com/
_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: daniel.warthold@xxxxxxxxx