BOM300 data is in the MBM file.
You can do a query/400 that basically looks down a level
but query is not well suited to delivering to end users the multi-level BOM

You could create, through query or other programming language,
some intermediate work files to simulate the BOM300 data

I wrote a collection of RPG programs to go through BOM300 data
& build an index of top to bottom
for each end item, how many of which sub-component is needed
because we have a lot of commonality of components

the top end is connected to what customers we make it for
the bottom end is connected to what vendors we order what from

so then we connect end item to customer shipment totals for several months
and we project requirements of various raw material needs BY CUSTOMER
and the reason for this focus is that there are contracts
for pricing based on ordering some raw material for use on a final customer

We order some quantity & get a price break
but we get a better price break because of grand total of whatever
that all of our customer's vendors are using

Took me a goodly while to get that software perfected
is non trivial

Does your version of BPCS have SFC350?
This for us is flip between BOM300 type data & routing CAP equivalent on same

You can enter ... we interested in making some quantity of this part
& in real time it shows you which components you not have enough of to get
the job done & what their lead times are.

> We are trying to find a way to work around some of the limitations
> with MRP, and I believe it would help if there was an easy way to access
> of the information that is available in the BOM300 inquiry showing the full
> indented bill.  Is this info available in one of the files?  Is a query
> necessary?  We have a bill structure that includes 4-6 levels of the bill. (Alister Wm Macintyre) (Al Mac)

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].