RE: Pulling BOM data from BPCS into MS Word Document

["Damon, Mitch" <MDamon@xxxxxxxxxxxxxxxxx>]

Al Mac,
That's great!! We've been struggling with our case printing documentation
and this could be just the answer.

Mitch Damon, CPIM
Planning Systems Manager
Agrilink Foods, Rochester NY
(716) 383-1070 ext. 250



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

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.