ZImmer Biomet Tab - Vendor Number Change [ZB Ribbon]


27
views
1
3 months ago by
SKU 231207000  Returns Vendor Number 1401638 Biomet Manufacturing as Vendor Number and Vendor Name.

The SKU “Belongs to ASL Number 002683 - Paragon Pierceton”.
Community: Zimmer Biomet
This was tested with the 'Biomet Only' option in the ZB Ribbon, also. I confirmed the vendor is 002683 in the amflib.itemasa table. Not sure where the ribbon pulls this field.
written 3 months ago by Michael Zorn  

1 Answer


0
3 months ago by
The vendor number and name were both taken at face value from the JDE Item Branch table.  We changed the logic to look at only vendor number 1401638 to instead pull from XA.  The new logic appears as follows:

case when im.vendor = 1401638 then asa.vndnr else im.vendor::varchar end as vendor,
case when im.vendor = 1401638 then vb.vname else im.vendor_name end as vendor_name,

The results now look as I believe you would expect:

select
  vendor, vendor_name
from mdm.global_item_master
where prod_id = '231207000'

Results:

002683 PARAGON MEDICAL/PIERCETON

This will feed the ZB ribbon, which pulls from the mdm table.
Please login to add an answer/comment or follow this question.

Similar posts:
Search »