Re: CMF - how could it be possible?

[MacWheel99@xxxxxxx]

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
+---