Re: CMF - how could it be possible? -- BPCS-L




Hi,

    1.I use runqry and also strdfu-5 to check the records, so there is really 2
only.
    2.In the experiment you suggested I did get SW,1,blank as 10050 after I have
changed
      SW,1,1 to 8050.
    3.Only 'O' in previous level, I have checked as well.

Looking forward of your future commends and best regards,
Hqin




owner-bpcs-l@midrange.com on 2000-05-11 02:51:09

Please respond to BPCS-L@midrange.com

To:   BPCS-L@midrange.com
cc:
Subject:  Re: CMF - how could it be possible?


from Al Macintyre

  Item  fac     Cstset    CSTbkt  CSTthislvl
  ABC   SW        1                 10000
  ABC   SW        1        1         8000
  ABC                 1

In answer to your question ,,, total cost in bucket 0-blank for a facility
can only come from the same item & facility & cost set combination ... when
your user is in INV300 looking at the cost for an item ... try blanking out
the facility filter & seeing if the cost is any different for no facility as
for SW ... also try this in CST300

If you have any globally coded BOM or routings, that will cause you to have
records with no facility in your CIC which in turn will populate CMF at time
of cost roll-up, then you will get cost bucket 0-blank that is the total of
all cost buckets that are no facility ... we do our costing by facility, but
we have had human error creating records where we did not intend to create
them & this usually shows up when trying to delete an obsolete item & we
cannot, because there are cost records where we did not expect to find them.

We have had recent discussions in this forum regarding cost glitches when an
item got changed between purchased & manufactured, and there were remnants of
cost in the system from the other method.

How do you know that there are no other CMF records on this item cost bucket
combination ... the system can generate them in addition to any you created,
so it is essential to look in CST300 or Query or other tools to take an
inventory of any that are out there.

Try an experiment.  Temporarily change bucket 1 a little bit

  Item  fac     Cstset    CSTbkt  CSTthislvl
  ABC   SW        1        1         8050

Now check bucket 0 ... has it changed by the same amount?

  ABC   SW        1                 10050

This would tell me that it is getting the 2000 from some other record that
you are not seeing.  Is there anything unusual in the other cost fields for
this item?

>  From:    Qin_Huang@schindler.com (Qin Huang)

>  hi kusman,
>
>  I know what you mean but for records with 'SW' there are only two records,
> one is SW,1,1 the other is SW,1,blank, no SW,1,2 or SW,1,3 for sure.
> Do I have to check records which is 1,2,--1,3 without 'SW' as well?
>
>  best regards,
>  hqin

>
>  Dear Qin;
>
>  The blank bucket is the total from all bucket use have.  If your use
>  actual cost. I think you need to check your bucket 2, 3 and so on.
>
>  Regards
>  KUSMAN
>

Al Macintyre


���
http://www.cen-elec.com MIS Manager Programmer & Computer Janitor
+---
| 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
+---