Re: **HTML** Bill Of Material Exploder! -- MAPICS-L

Lisa Thomas had some source 4/1/2005 for a recursive program... it would be
in the archives.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of David Hayes
Sent: Wednesday, February 01, 2006 8:17 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] **HTML** Bill Of Material Exploder!


If you're running EPDM, I've got a BOM exploder that I can send you.

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of
Michael.Huber@xxxxxxxxxxxxxxxx
Sent: Tuesday, January 31, 2006 7:41 PM
To: MAPICS-L@xxxxxxxxxxxx
Subject: **HTML**[MAPICS-L] Bill Of Material Exploder!

I remember a bit back someone posted about a bill of material exploder,
sorry I forget who did.

What we are trying to do is establish baselines for the demands for raw
materials for our work centers so that we can calculate proper
"mathematical" kanbans for those work centers.

But here is what I am looking to do... (And it might be a tad
complicated)


Step 1:
        Query the IMHIST file for SA transactions for items in a
specific
workcenter from date x to date y.
        Item            SA Qty
        ITEMA           100

Step 2:
        Using the data is Step 1, explode the bill of materials for the
items and compute the component requirements for the sold product
        Item                                            Unit Per
Quantity
        ITEMA                                           1 100
                - L1SUB1                                1 100
                - L1SUB2                                .5
50
                        -L2SUB1                 1               50
                        -L2SUB2                 3               150
                -L1SUB3                         2               200
                        -L2SUB1                 5               1000
                                -L3SUB1         4               4000
                                -L3SUB2         1               1000

The report or the file would contain this information, from the top
level
all the way down to the 1st place that component is used.


Any feedback would be appreciated.

------------------------------------------------------------------------
-----
Michael K. Huber
System Administrator
Pentair Filtration, Inc
502 Indiana Ave - Sheboygan, WI 53081
Phone: (920) 451-9417      FAX: (920) 803-3541

Confidentiality Note: This e-mail message and all attachments to it are
intended only for the named recipients and may contain confidential
information. If you are not one of the intended recipients, please do
not
duplicate or forward this e-mail message and immediately delete it from
your computer.



______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.




_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.