Re: Exploded Bill Info

Jenny

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
structure

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
parts

I LOVE SFC350
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
associated
> with MRP, and I believe it would help if there was an easy way to access
some
> 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.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)