Re:Product Structure SQL

We have had to do this same thing because MAPICS does not support Reference
designators(BOM callouts)
for placement of components on FABS.

We have an offline Access Database that gets updated by MAPICS and all of our
BOMS
that we send to our Contract Manufacturers get generated from this "Home Grown"
app.

We originally purchased MAGIK (now a MAPICS offering) so that we would not have
to do this,
but it was not ready for prime-time when we went live 2 years ago, and had to do
this last minute.

We still own MAGIK, but have NEVER even been able to use it, as it was all smoke
and mirrors,
still gives us NO VALUE WHATSOEVER, just a glorified workflow tool!  At the
time, it was touted as 
doing everything that AGILE would do for us as far as BOMS and communication
with our CM's.

(Wow, guess I'm venting a bit, hope someone at MAPICS reads this!!!???)


Lloyd H. Degnon
I. S. Manager
Ampro Computers Inc.
5215 Hellyer Ave
San Jose, CA 95138
408.360.4365
Ldegnon@ampro.com
http://www.ampro.com


____________________Reply Separator____________________
Subject:    Product Structure SQL
Author: "Tom Wood" <TomW@fortrecoveryindustries.com>
Date:       1/23/03 2:40 PM

Content-Type: text/plain;
Content-Transfer-Encoding: quoted-printable
Hello All,

 

Anyone have a  pc app (excel or access) that uses ODBC, etc. and has  a
SQL query that successfully will produce an indented bill of material?
We're working on a little project where we want to throw the BOM into
Access or Excel and can't seem to put together the proper joins to
accomplish this.  Probably something simple. Any hints, examples, etc.
appreciated.

 

Thanks,

 

Tom Wood

Fort Recovery Industries Inc.


Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


Received: from linux.midrange.com ([207.224.38.113]) by NIXON.AMPRO.COM with
SMTP
  (IMA Internet Exchange 3.14) id 000E3535; Thu, 23 Jan 2003 11:43:07 -0800
Received: from linux.midrange.com (localhost [127.0.0.1])
    by linux.midrange.com (8.12.5/8.12.5) with ESMTP id h0NJfBML028248;
    Thu, 23 Jan 2003 13:41:12 -0600
Received: from wall (mail.fortrecoveryindustries.com [209.143.62.180])
    by linux.midrange.com (8.12.5/8.12.5) with SMTP id h0NJehon028222
    for <mapics-l@midrange.com>; Thu, 23 Jan 2003 13:41:04 -0600
Received: from 192.168.1.6 by wall (InterScan E-Mail VirusWall NT);
    Thu, 23 Jan 2003 14:42:52 -0500
MIME-Version: 1.0
Content-Type: multipart/mixed;
X-MimeOLE: Produced By Microsoft Exchange V6.0.5762.3
Date: Thu, 23 Jan 2003 14:40:37 -0500
Message-ID: <7C07746C01FAB448AD96C335CD0785FD348455@klingon>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
From: "Tom Wood" <TomW@fortrecoveryindustries.com>
To: <mapics-l@midrange.com>
X-MailScanner: Found to be clean
X-Content-Filtered-By: Mailman/MimeDel 2.1
cc: Shawn Thobe <ShawnT@fortrecoveryindustries.com>
Subject: Product Structure SQL
X-BeenThere: mapics-l@midrange.com
X-Mailman-Version: 2.1
Precedence: list
Reply-To: MAPICS ERP System Discussion <mapics-l@midrange.com>
Sender: mapics-l-bounces@midrange.com
X-Spamscreen: Protected by WatchGuard SpamScreen (TM)
    v6.1.B1000 Copyright (C) 1996-2002 WGTI WGTI