Re: 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.