RE: Customer Item Cross Reference and Engineering Changes

Bonnie -

If you are using EPDM (rel 4 or above), you don't need to create a new item
number, but an new revision (B) with a start date (and put an end date on
the A revision). This does not "mess up" on hand/on order, etc., since the
start and end dates control which version is used for what.

       -- Joan

Joan McCready, IS Manager      phone:  636-479-4499
MetalTek International         fax:  636-479-3399
The Carondelet Division        www.metaltekint.com
8600 Commercial Blvd
Pevely, MO  63070


-----Original Message-----
From: Bonnie_Lokenvitz@epcmolding.com
[mailto:Bonnie_Lokenvitz@epcmolding.com]
Sent: Wednesday, January 09, 2002 11:00 AM
To: mapics-l@midrange.com
Subject: Customer Item Cross Reference and Engineering Changes




How are others handling this situation?

Our customer has an item number 78-1234 with an EC level of A.  Our item
number is 0123001
The engineering level changes to B.  We create a new item 0123002 for
various reasons (on hand/on order for
prior EC,material change,etc.).

The Customer Item Cross Reference (file MBBIREP) is keyed unique on
Company, Customer # and  Customer Item Number (field BIHJTX)  which hasn't
changed in the above scenario.

Currently industrial engineering tech enters a second record into MBBIREP
with the Customer Item Number plus
an extension to create a unique key.

Our problem is when our EDI inbound orders and outbound invoices pick up
the customer's part number we don't
have match or we send an incorrect  customer part number.

The customer service staff review the incoming orders but we have had some
bounced 810's.

Suggestions welcomed!
Thanks,
Bonnie Lokenvitz


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