Re: Pulling BOM data from BPCS into MS Word Document

You could create a CL to:
    run a query to extract the data you need to a file
    CPYTOIMPF to the IFS or FTP directly to a directory
    allow your mail merge to pick up the data from that location.

Depends on your total requirement and existing configuration.

Norm

----- Original Message -----
From: "Mike Hoffman" <mhoffman@crowechizek.com>
To: <bpcs-l@midrange.com>
Sent: Thursday, 29 November 2001 13:44
Subject: Pulling BOM data from BPCS into MS Word Document


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
http://www.crowechizek.com/scg
phone: 440.460.1318
fax:       440.460.1302


_______________________________________________
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.