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.