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



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@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
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@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] 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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
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@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.



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.