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.
midrange.com
