Bob,
I do this with a series of queries that run each night. We do not change
the bills too often, so running the job this way is OK for us.
The queries do something like this:
Query1: Uses PSTRUC & ITEMASA (for SBQTY) to produce PINBR,
CINBR, LVL1, QTY1 (Level is defined as 1, QTY is QTYPR/SBQTY)
This is output to a file (FLATPS, member
FLATPS01)
Query2: Uses FLATPS(member FLATPS01) & PSTRUC & ITEMASA to
produce PINBR, CINBR, LVL2, QTY2 (Level is defined as 2, QTY2 is
QTY1*QTYPR/SBQTY)
Joins are FLATPS/CINBR = ITNBR,
FLATPS/CINBR=PSTRUC/PINBR, select where PSTRUC/CINBR <> ' '
Output is to FLATPS member FLATPS02
This repeats for 8 queries, dropping to a lower level each time (we have
maximum of 6 levels, but I built in a bit of safety!), and results in a
file FLATPS with 8 members FLATPS01 to FLATPS08
The queries are grouped in a CL programme, and the last part of the CL
programme is just a CPYF copying all members to one new file.
This gives a file that can be queried, and selecting the parent item
will give an output as in the following example:
Component LVL QTY
Item number
EM018004 1 .000100
EM038003 1 .000500
7112100 1 1.020000
7113200 1 2.040000
28620LLF 1 1.020000
90065 2 1.086300
90107PHLF 2 1.086300
90192PHLF 2 1.101600
90408 2 .010771
90410 2 .000023
90756C 2 1.091400
91680 2 .000071
92987 2 .000102
90138PHLF 3 .000362
90300 3 .093849
94102 3 .008015
These quantities match the standard MAPICS Inquiry AMEC72, although I
still have the minor problem (same as Tom), that they are not listed in
the AMEC72 order.
Kind regards
David Unwin
Systems Manager
CML Innovative Technologies
DDL +44 (0)1284 714710
FAX +44 (0)1284 754406
Email dunwin@xxxxxxxxxx <mailto:dunwin@xxxxxxxxxx>
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob Voltz
Sent: 14 May 2009 19:22
To: 'MAPICS ERP System Discussion'
Subject: Re: [MAPICS-L] BOM Explosion
Cork:
Guide Technologies wants $5,000.00 for that program.
Thanks anyway,
Bob Voltz
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Gindlesperger, Dale
Sent: Tuesday, May 12, 2009 1:31 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] BOM Explosion
Bob,
Did you contact Pete O. from Guide Technologies? He developed an
excellent
solution for me at my prior job - tied out exactly as required, and the
output was accessible through Browser, or downloadable into Excel if
required. I'm sure he probably kept a copy of the program - I paid him
to
develop it and he's more than welcome to share it.
Dale "Cork" Gindlesperger, CPIM
Senior Business Analyst
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Bob Voltz
Sent: Tuesday, May 12, 2009 1:03 PM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] BOM Explosion
I realize I have posted this request before, but I did not receive a
satisfactory response.
I am looking for a program that will do a BOM Explosion and produce
results
that match MAPICS Inquiry AMEC72.
It needs to output to a file.
Someone did send me a program that will blow through the BOM, but the
quantities don't match the MAPICS Inquiry AMEC72.
Thanks!
Robert N. Voltz
Information Systems Manager
Zhongding USA
bob.voltz@xxxxxxxxxx
330-878-7800 x214
_______________________________________________
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.
_______________________________________________
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.
midrange.com
