Re: BPCS 4.05CD Question Where is the CIC record created -- BPCS-L

> Where is the most COMMON place that the CIC records are created. I have 
found 
> a few programs that update records and a couple that create records.
>  Some of them are Assetized RPG programs even in BPCS 4.05CD and are 
> difficult to follow. Can anyone help.   Thanks in advance Kevin W.

CIC file is used by both MRP & Costing.

There have been enormous volumes of discussions regarding cost implications & 
the role of the CIC file.  I suggest you also check BPCS_L archives.
http://archive.midrange.com/bpcs-l/index.htm

One easy way to check this is to create a query to list, for some range of 
item #s, where there is a NO MATCH (no CIC), then do various things with some 
of those item#s & rerun, or the opposite - list all CIC in some range, then 
do some things that we think should create new CIC & then run the list again.

Let's suppose you have an item master defined & then you created routings & 
BOM for that item in some facility ... you should get CIC.

Let's suppose an item gets changed, like to a different item class.
THIS WILL HAVE NO EFFECT a lot of places where CIC has the old class & 
perhaps needs MRP140 update also.
We have had some items that used to be purchased now manufactured & vica 
versa ... I think we need a check list of all the places that need to be 
updated when this happens, because there are an enornous number of nuances 
easy to overlook.

Let's suppose there is activity that would affect MRP ... orders created, 
inventory changed ... you should get corresponding CIC.

I suspect that if there is activity that would affect CAP but not MRP, this 
might not impact CIC, although perhaps it should, since labor time is part of 
costs.

Let's suppose someone MAKES A MISTAKE ... you will get CIC that you do not 
want, such as CIC with no facility, then in your next cost roll-up CMF copies 
the error.  If the oops is not discovered right away & fixed, you could end 
up with the engineering & inventory being correct, but bogus costs thanks to 
the accumulation of historical errors.  

Human beings make mistakes.  This is unavoidable.  Usually when we find a 
mistake, we fix the obvious & do not realize the implications on other files 
such as costs, MRP, general ledger.  There are also bugs in our software & 
abnormal terminations of update jobs, that add to the mix of bad data.

I think I could use a flow chart of files.
Suppose we discovered a mistake involving application X
What are all the places that need to be checked/fixed in addition to X
like customer order to wrong warehouse profit center combination
or wrong customer order line picked - we shipped right stuff billed wrong line
or customer schedule changed after production started on it
or JIT620 mishap where "R" duplicated unwanted inventory transactions

We are working on tools (programs) to help us audit where costs are coming 
from that do not look right.  It is slow going.

We do have the occasional item with a negative cost, or other impossibility, 
but I think our main challenge now is not that we need CIC records created & 
not getting them, but rather we get CIC records that we did not want & not 
even know these bad records exist, which have the potential to contaminate 
cost accuracy precision, & this usually does not turn up until we are 
removing an item from production & it will not let them remove because there 
are costs out there some place where they had no business being, and of 
course we did not find out about the bogus cost ingredients until the life of 
the item was over.

With 405 CD we have an advantage over V6 in that SSA GT lets us have a copy 
of the source code, even as you say Assetized is an invitation to P/A mind 
explosion, but thanks to a tip on MIDRANGE_L - you know that GO CMDREF where 
we can drill down what program touches what objects?  I did that for *ALL to 
an *OUTFILE & have a query/400 for the end objects ... what programs call or 
use it?  This does not catch cases where something is called via variable 
insertion, but yet is still a big help.  I created this as a tool to help 
with a research project & now I find myself using query X_TRACE (where I key 
in the name of the object to be traced) several times every week.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
AS/400 Data Manager & Programmer for BPCS 405 CD Rel-02 mixed mode (twinax 
interactive & batch) @ http://www.cen-elec.com Central Industries of 
Indiana--->Quality manufacturer of wire harnesses and electrical 
sub-assemblies - fax # 812-424-6838

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---