Re: Pulling BOM data from BPCS into MS Word Document

Mike, this is NOT the whole solution to your challenge but you might find
value in today's CLASSIC TIPS from Club Tech on:

Copying BPCS 5250 Screens into Microsoft Word (Four parts)
Part 1:
<A
HREF="http://www.iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=

viewarticle&CO_ContentID=10185&channel=art">
iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=viewarticle&CO_Co

ntentID=10185&channel=art</A>
Part 2:
<A
HREF="http://www.iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=

viewarticle&CO_ContentID=10182&channel=art">
iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=viewarticle&CO_Co

ntentID=10182&channel=art</A>
Part 3:
<A
HREF="http://www.iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=

viewarticle&CO_ContentID=10162&channel=art">
iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=viewarticle&CO_Co

ntentID=10162&channel=art</A>
Part 4:
<A
HREF="http://www.iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=

viewarticle&CO_ContentID=10160&channel=art">
iseriesnetwork.com/resources/artarchive/index.cfm?fuseaction=viewarticle&CO_Co

ntentID=10160&channel=art</A>

Converting BPCS Spool Files to Adobe Acrobat (PDF) (Four parts)
Part 1:
<A
HREF="http://www.iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewarticl

e&CO_ContentID=10150&channel=art">
iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=10

150&channel=art</A>
Part 2:
<A
HREF="http://www.iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewarticl

e&CO_ContentID=10151&channel=art">
iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=10

151&channel=art</A>
Part 3:
<A
HREF="http://www.iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewarticl

e&CO_ContentID=10425&channel=art">
iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=10

425&channel=art</A>
Part 4:
<A
HREF="http://www.iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewarticl

e&CO_ContentID=10507&channel=art">
iseriesnetwork.com/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=10

507&channel=art</A>

I do not have nice links like the above, but IBM has products & services
through some partner that can send reports from 400 & from PC to CD Rom-W
indexed according to items & other key data in the reports, so that folks
later can use the index to find what reports we might have on a given item or
customer or whatever.

The system is setup so that users on 5250 who do not have GUI capability can
still identify GUI reports like engineering drawings & specify which ones are
to be e-mailed to someone.

I was thinking that this might be useful way to store fiscal month reports to
supplement huge carton of paper, and to serve estimating for how to cost
processes similar to what we have made in the past.

Mitch,

You gave me another idea.
Let's suppose the Word Documents were on a company intranet accessible using
URL links like those we use on the internet.  Those URLs could be placed in
the notes of the BOM & Routings of BPCS.  When the shop packet is on the 400
spool file, you could access that data via PC to extract the URLs & depending
on printer flexibility, intersperse pages of the shop packet with what you
got from the URLs.  You would probably have to move entire shop packet spool
report to PC to split it up & return that way to printer.  Depending on
printer, you could even insert engineering drawings to help inspect final
product.

I hope I do not get in trouble with Dean for straying from topics.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)
BPCS 405 CD Manager / Programmer @ Global Wire Technologies Incorporated
http://www.globalwiretechnologies.com = new name same quality wire
engineering company: fax # 812-424-6838

> From: MDamon@agrilinkfoods.com (Damon, Mitch)
>
>  Why not enter the detailed manufacturing instructions in to the Bill of
>  Materials notes section of BPCS, then set them to be printed with the shop
>  packet by BPCS?
>
>  Mitch Damon, CPIM
>  Planning Systems Manager
>  Agrilink Foods, Rochester NY

> From: mhoffman@crowechizek.com (Mike Hoffman)

>  Business Problem: Detailed process instructions exist in MS Word for
>  products and this is dispatched to the plant for instructions. We want the
>  current BOM (MBM or FMA) from BPCS to be pulled into this document to use
>  as a shop packet. It seems that Mail Merge may be able to accomplish this.
>  Anyone have experience with this or doing something similar with MS Word or
>  MS Access where a user would enter an item number and shop order number and
>  it would retrieve  the records from BPCS?
>
>  Mike Hoffman
>  Senior Manufacturing Specialist
>  Crowe, Chizek & Company, LLP