Author Topic: Find new Product number  (Read 150 times)

DonQuixote

  • Rock Star
  • *****
  • Posts: 200
  • To Dream the Impossible Dream...
Find new Product number
« on: August 07, 2019, 04:25:31 pm »
If you have the old product number can you find the new product number?

precisonline

  • President
  • Administrator
  • Rock Star
  • *****
  • Posts: 1609
    • Precision Solutions
Re: Find new Product number
« Reply #1 on: August 29, 2019, 10:44:17 am »
After a product replacement/merge?  I don't believe so.  PROD.REPLACE.UPD2 could be modified to add the old product number somewhere - like maybe alternates?
-Kevin
Accidents "happen"; success, however, is planned and executed.

DonQuixote

  • Rock Star
  • *****
  • Posts: 200
  • To Dream the Impossible Dream...
Re: Find new Product number
« Reply #2 on: August 29, 2019, 11:47:46 am »
In Inventory Inquiry ( /II ).  If you enter the old part number that was changed to a new part number in the UPR process, the number will change to the new number.  I've tried to trace this logic but with no success.

precisonline

  • President
  • Administrator
  • Rock Star
  • *****
  • Posts: 1609
    • Precision Solutions
Re: Find new Product number
« Reply #3 on: August 29, 2019, 12:26:17 pm »
If it's not in alternates, it might be in PROD.CAT.  This is where the keywords are stored for product lookup.
-Kevin
Accidents "happen"; success, however, is planned and executed.

DonQuixote

  • Rock Star
  • *****
  • Posts: 200
  • To Dream the Impossible Dream...
Re: Find new Product number
« Reply #4 on: November 01, 2019, 09:01:05 am »
fyi.  After the UPR an entry is made in ALT.XREF.   The ID is the old product number and field 1 is the new number.