× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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.