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.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.