RE: CMFL03 Logical File Corruption

Hi Ho.

        It's warming up outside. Still got 7 inches yesterday(no kidding). 

Finally someone else out there in BPCS land is having the same problem. Well
maybe. Your costs have not disappeared. They still exist in your CMF file.
If you use SQL, type the following command on your command line: Select *
from BPCSXXXF/CMF where CFPROD = 'an item # where cost has disappeared'.

You will notice the following:

ID      Item No.        Fac     Cost Set        Cost Bckt       Cost This
Lvl     Cost Prev Lvl 
CF      XXXXXXX OT      2                               .54990
130.55494 

You will notice the cost bucket (Cost Bckt)is blank. This line never
displays anywhere. You can't even delete it using CST100. Its the calculated
sum of all buckets. The two last columns are your (in this case) standard
cost. These two fields are summed up during CST600 (cost roll up) and then
populated or updated in the CIC file. It is populated or updated in the CIC
file only if the following condition apply. The field that is updated in the
CIC file is the ICSCST. I hope you all new this. 
        1.      Item Number Match, with facility match.

If you do not see this blank bucket someone either SQL'd  them out or DFU'd
them out. If neither is the case, check out MRP140. Them items populated
there maybe out of whack from your Item Master. This will prevent you from
doing proper cost roll ups.

One more thing. The funny thing about CMFL03 is that it pops up just about
anywhere, anytime. If you are ever running a job or you want to know what
objects are being used when in a program. Using  the system request line,
then going to option #14 Display open files, if active. You will notice
CMFL03 being used. Not all the time but some of the time. Know don't
comeback to me and say, Where you in CST100 at the time. I'm talking BOM300,
INV110, INV130, SFC100 etc. Why would the CMFL03 be used there?. Try
explaining that to SSA

 
                

> ----------
> From:         Warren, Rick[SMTP:RWarren@burco.com]
> Reply To:     BPCS-L@MIDRANGE.COM
> Sent:         Friday, March 10, 2000 4:01 PM
> To:   BPCS-L@MIDRANGE.COM
> Subject:      CMFL03 Logical File Corruption
> 
> We are running AS/400 MM 6.02.  We have had actual and standard costs
> disappear from our INV300 screens.  We have also seen costs disappear from
> our invoice process.  The CMF (cost master PF file) had all of the
> appropriate costs in it.  We traced the problem back to a logical file
> (CMFL03) that became corrupted but, we have yet to determine what
> corrupted
> the logical.
> 
> Has anyone else had this type of problem?
> +---
> | 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
> +---
> 
+---
| 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
+---