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


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2021 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.