RE: KBC "Where used"

["Chris Caparon" <ccaparon@xxxxxxxxxxxxxxxxxxxx>]

Bud,

This is actually very straight forward.  There are two KBC BOM files that
contain that information.  They are KBOPTA and KBOPTB.  You have to join
them and select for all records that have a BOM flag set to YES.  The result
of that set is a list of all BOM items in all of your dialogues.  Run a
query against that and the output will tell you where the items are used
across all of your dialogues.

The same is true in the open order files.  They are different names
obviously, the process is the same.

Happy hunting!

Regards,

Chris Caparon
Crimson Software Technologies
866-859-1054 - Office
909-560-1909 - Cell
909-498-7349 - Fax
www.crimson-software.com



-----Original Message-----
From: mapics-l-admin@midrange.com [mailto:mapics-l-admin@midrange.com]On
Behalf Of Bud Roble
Sent: Monday, May 20, 2002 12:36 PM
To: 'mapics-l@midrange.com'
Subject: KBC "Where used"

We want to create a "Where Used" cross reference file of Item Numbers for
inquiry purposes.     This inquiry would be used for example when we want to
replace an item with another one.      A cross reference like this was very
easy in PDM.    KBC does not easily lend itself to this because of the rule
structure.    I was wondering if anyone else has come up with something to
handle this.

Bud Roble
broble@CharlesRobleConsulting.com <mailto:broble@CharlesRobleConsulting.com>


_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.