Re: Component Where-Used and Where-Used End item

[MacWheel99@xxxxxxx]

>  From:    Dick_Bailey@MCFA.COM (Bailey, Dick)
>  
>   Anyone have suggestions as to the best way to get a Where-Used and
>  Where-Used End Item display for parts that are purchased and therefore only
>  children on bills of material?
>  
>   Dick Bailey
>   MCFA 

What is unsatisfactory in BOM300 diversity of function keys for you? ... for 
my people they want more options & they want combination of SFC350 & BOM300 
data on combined screen & they want all fields to key in grouped together so 
less likely to miss a filter.

I have been working on a bunch of variations of this lately due to the 
project to connect on what end customers parts are used raw materials from 
selected vendors when inter-facility is part of the picture.

We use Planner Code 7 for raw materials that need to be ordered for a 
facility.
When Item type is 7 it means purchased from outside vendor.
When Item type is other it means inter-facility

There is a field in item master related to count of BOM usages for a part 
that is not at the bottom of the product structure ... when that field is 
zero you know it has no children.

I have recently written a program BOMHR0 in which user keys in item # & 
facility # ... it uses a lot of code from SFC350 & BOM200 & others ... goes 
down BOM & tracks quantity sub-assemblies needed & when routings involved, 
computes decimal hours to make one part & this is printed in chart form ... 
cumulative lead time & decimal hours, which customers & vendors involved ... 
which ends up in new file ECIF ... which is a capacity planning tool for the 
customer service department so as not to promise what we cannot possibly make 
in the time period of interest.

BOM300 has a bunch of commands to view various items from perspective of BOM 
or Where-Used ... we had a request to be able to offer the Where-Used 
perspective without all the intervening parts ... I looked at the program & 
decided that a hot shot programmer could put in another command key but I did 
not want serious modifications here to have to mess with at BMR time, so I 
cloned BOM300 to a similar program & stripped code to not display intervening 
parts.

Al Macintyre  ©¿©
http://www.cen-elec.com MIS Manager Programmer & Computer Janitor

Y2K is not the end of my universe, but a re-boot of that old Chinese curse.
The road to success is always under construction.
Accept that some days you are the pigeon and some days the statue.
Murphy's Mom brought wrong baby home from hospital so it should be Kelly's 
Law.
If consistency is the hobgoblin of little minds, only geniuses work here.
When you want it cheap - you get what you paid for.
When in doubt, read the manual, assuming you can find the right one.
+---
| 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
+---