|
midrange.com
Mon,
11/MDE points out the Top level parent item.
-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of
system21-request@xxxxxxxxxxxx
Sent: Friday, September 08, 2006 1:00 PM
To: system21@xxxxxxxxxxxx
Subject: SYSTEM21 Digest, Vol 4, Issue 93
Send SYSTEM21 mailing list submissions to
system21@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/system21
or, via email, send a message with subject or body 'help' to
system21-request@xxxxxxxxxxxx
You can reach the person managing the list at
system21-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of SYSTEM21 digest..."
Today's Topics:
1. [SYSTEM21] Top level parent (Mon M. Ferriols - IT Mgr)
2. Re: [SYSTEM21] Top level parent (Ellsworth, Bob)
3. Re: [SYSTEM21] Top level parent (jroesch@xxxxxxxxxxxxxxx)
4. Re: [SYSTEM21] Top level parent (Santos, Fred)
5. Re: [SYSTEM21] Top level parent (Roy Luce)
6. Re: [SYSTEM21] Top level parent (Roy Luce)
----------------------------------------------------------------------
message: 1
date: Fri, 8 Sep 2006 16:37:27 +0800
from: "Mon M. Ferriols - IT Mgr" <mon.ferriols@xxxxxxxxxxxxxx>
subject: [SYSTEM21] Top level parent
Hi to all. Does anyone know of a direct way to query what an item's top
level parent is? assuming you have an indented BOM?
Mon M. Ferriols
Information Technology Department
Software & Systems Section
Ionics EMS, Inc.
) (49) 543-0552 (Plant 5/6)
* mon.ferriols@xxxxxxxxxxxxxx
: www.ionicsgroup.com <http://www.ionicsgroup.com/>
------------------------------
message: 2
date: Fri, 8 Sep 2006 07:57:03 -0400
from: "Ellsworth, Bob" <Bob.Ellsworth@xxxxxxxxxx>
subject: Re: [SYSTEM21] Top level parent
It's actually kind of embarrassing that System21 doesn't come with an
end-item report.
We had to write a custom program to make recursive calls to MSP28 to
"climb" up the BOMs to get a listing.
Query/400 can do it, too, but you need a series of them called with a CL
program.
Use the output of one Query as the input to another, and so on. You end
up with a list of parts with components but no parents (I.e. "top level"
parts)
HTH,
-BobE
Pollak Engineered Products
Canton, MA
-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Mon M. Ferriols - IT
Mgr
Sent: Friday, September 08, 2006 4:37 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Top level parent
Hi to all. Does anyone know of a direct way to query what an item's top
level parent is? assuming you have an indented BOM?
Mon M. Ferriols
Information Technology Department
Software & Systems Section
Ionics EMS, Inc.
) (49) 543-0552 (Plant 5/6)
* mon.ferriols@xxxxxxxxxxxxxx
: www.ionicsgroup.com <http://www.ionicsgroup.com/>
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list To post a message
email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/system21.
This electronic mail transmission contains confidential information
intended only for the person(s) and/or organization named. Any use,
distribution, copying or disclosure by or to any other person
outside your organization is strictly prohibited. If you received
this transmission in error, please send an electronic mail message
to postmaster@xxxxxxxxxx so we may instruct you regarding its
disposition.
------------------------------
message: 3
date: Fri, 8 Sep 2006 08:30:46 -0400
from: jroesch@xxxxxxxxxxxxxxx
subject: Re: [SYSTEM21] Top level parent
We needed a single table of fully indented structures for many reasons.
We
based our modification off of an existing System 21 program to create
the
table nightly that can be queried against as needed.
-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Mon M. Ferriols - IT Mgr
Sent: Friday, September 08, 2006 4:37 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Top level parent
Hi to all. Does anyone know of a direct way to query what an item's top
level parent is? assuming you have an indented BOM?
Mon M. Ferriols
Information Technology Department
Software & Systems Section
Ionics EMS, Inc.
) (49) 543-0552 (Plant 5/6)
* mon.ferriols@xxxxxxxxxxxxxx
: www.ionicsgroup.com <http://www.ionicsgroup.com/>
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
------------------------------
message: 4
date: Fri, 8 Sep 2006 08:56:09 -0400
from: "Santos, Fred" <Fred.Santos@xxxxxxxxxxxxxxx>
subject: Re: [SYSTEM21] Top level parent
Mon, you should be able to use the 10/MDE option with a "3" or "4"
option for the "Inquiry Type".
You will see all the parents the component is used in, in an indented
where used list.
-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Mon M. Ferriols - IT
Mgr
Sent: Friday, September 08, 2006 4:37 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Top level parent
Hi to all. Does anyone know of a direct way to query what an item's top
level parent is? assuming you have an indented BOM?
Mon M. Ferriols
Information Technology Department
Software & Systems Section
Ionics EMS, Inc.
) (49) 543-0552 (Plant 5/6)
* mon.ferriols@xxxxxxxxxxxxxx
: www.ionicsgroup.com <http://www.ionicsgroup.com/>
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
------------------------------
message: 5
date: Fri, 8 Sep 2006 08:59:12 -0500
from: "Roy Luce" <lwl@xxxxxxxxxxxxx>
subject: Re: [SYSTEM21] Top level parent
System 21 isn't the only ERP system without the feature. Nearly all the
ERP
variants operating on the AS/400 don't have the capability.
Roy Luce
Systems Plus - Midwest
Direct: 847-540-9635
800-913-7587
Cell: 847-910-0884
Fax: 847-620-2799
Email: rluce@xxxxxxxxxxxxxxxxxxx
-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Ellsworth, Bob
Sent: Friday, September 08, 2006 6:57 AM
To: System 21 Users
Subject: Re: [SYSTEM21] Top level parent
It's actually kind of embarrassing that System21 doesn't come with an
end-item report.
We had to write a custom program to make recursive calls to MSP28 to
"climb" up the BOMs to get a listing.
Query/400 can do it, too, but you need a series of them called with a CL
program.
Use the output of one Query as the input to another, and so on. You end
up with a list of parts with components but no parents (I.e. "top level"
parts)
HTH,
-BobE
Pollak Engineered Products
Canton, MA
-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx] On Behalf Of Mon M. Ferriols - IT
Mgr
Sent: Friday, September 08, 2006 4:37 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Top level parent
Hi to all. Does anyone know of a direct way to query what an item's top
level parent is? assuming you have an indented BOM?
Mon M. Ferriols
Information Technology Department
Software & Systems Section
Ionics EMS, Inc.
) (49) 543-0552 (Plant 5/6)
* mon.ferriols@xxxxxxxxxxxxxx
: www.ionicsgroup.com <http://www.ionicsgroup.com/>
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list To post a message
email: SYSTEM21@xxxxxxxxxxxx To subscribe, unsubscribe, or change list
options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/system21.
This electronic mail transmission contains confidential information
intended only for the person(s) and/or organization named. Any use,
distribution, copying or disclosure by or to any other person
outside your organization is strictly prohibited. If you received
this transmission in error, please send an electronic mail message
to postmaster@xxxxxxxxxx so we may instruct you regarding its
disposition.
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
------------------------------
message: 6
date: Fri, 8 Sep 2006 08:56:23 -0500
from: "Roy Luce" <lwl@xxxxxxxxxxxxx>
subject: Re: [SYSTEM21] Top level parent
There is a way to do it but the process requires a third party ERP "bolt
on".
Roy Luce
Systems Plus - Midwest
Direct: 847-540-9635
800-913-7587
Cell: 847-910-0884
Fax: 847-620-2799
Email: rluce@xxxxxxxxxxxxxxxxxxx
-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of Mon M. Ferriols - IT Mgr
Sent: Friday, September 08, 2006 3:37 AM
To: system21@xxxxxxxxxxxx
Subject: [SYSTEM21] Top level parent
Hi to all. Does anyone know of a direct way to query what an item's top
level parent is? assuming you have an indented BOM?
Mon M. Ferriols
Information Technology Department
Software & Systems Section
Ionics EMS, Inc.
) (49) 543-0552 (Plant 5/6)
* mon.ferriols@xxxxxxxxxxxxxx
: www.ionicsgroup.com <http://www.ionicsgroup.com/>
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
------------------------------
_______________________________________________
This is the System 21 Users (SYSTEM21) digest list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.
End of SYSTEM21 Digest, Vol 4, Issue 93
***************************************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
