Re: Manufacturers Number(s)

Thanks Jon

So far I think adding tables and code is going to be the only solution.  I'm
a little surprised as this is common in the electronics industry, but I've
not run into these specific requirements before now.

Kevin
-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]]
On Behalf Of Jon Le Roi
Sent: Thursday, October 29, 2009 12:16 PM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Manufacturers Number(s)

Hi Kevin,

We are at 5.5 and have created a custom program for supporting the many
to one relationship. We have a new table that associates an unlimited
number of vendor parts to a single Tegal part. The Buyer can select any
of the records from this new table when placing a PO. From the
maintenance screen for this table, the user can also select one entry as
the Preferred supplier and that information will be written to the Item
Master. I noticed that we also use this when we have multiple sources
for a single Manufacturers item; the MFG part number is the same but
they list the supplier as the manufacturer.

Jon Le Roi
Tegal Corporation
707.765.5620




-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]
[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Kevin Fox
Sent: Thursday, October 29, 2009 10:47 AM
To: 'MAPICS ERP System Discussion'
Subject: [MAPICS-L] Manufacturers Number(s)

All,

 

We are at R7.8 PTF Level 9955.

 

Here is the issue: We have a requirement to enable the selection of
manufacturers part number during purchase order entry.  The relationship
of
the data is:

 

Item Revision (one to many) >> Manufacturers Part Number.

 

For example:  I have a resister with part number 1234.  I have 4
different
manufacturers that make a comparable item:  Sanyo 749-ksj, Samsung
8y3nk,
Toyo 873-83e-hd and Sony mvnd76-jdhu783

 

XA supports a relationship as follows:

 

Item Revision (one to one) >> Vendor Item (Vendor Catalog Number) >>(one
to
one)  Alternate Item

 

Which would require us to create a unique part number for the 4 items
and
then create a unique vendor item for each.  Each would only have 1
possible
alternate instead of the 3 possible alternates.

 

This solution is not acceptable.

 

In addition, the selected manufacturers part number must print on the
purchase order AND show the 3 alternate items.

 

It is really the inverse of the Item Industry Class/ Industry Item
number
issue in COM.  

 

To complicate matters further, these PO's need to be passed through the
ESB
to Supply Web.

 

Questions:

1.       Has anyone had a similar issue with the item/mfg number
relationship requirement?

2.       Any ideas or solutions.

 

Thanks

 

Kevin D.  Fox

Fox Enterprises and Professional Services. LLC.

131 E. Holly Street   Unit 218

Pasadena, CA 91103-3936

1.909.762.1384 mobile

 

 

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


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


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