Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
change inventory item code, CN description not deleted
07-29-2015, 01:19 PM,
#1
change inventory item code, CN description not deleted
recently did some shuffling of part numbers from one stock code to a new one. I found that when I used the change inventory item code utility, the English part number is changed and set up no problem in all records, but the CN description row for the old stock number remains in the stockdescriptiontrans table. If you try to create a new item using the old number, system returns an error. Once I manually edited the table and removed all old descriptions, seems solved this. Anyone had similar with other tables I should check for this same? tks
Reply
07-29-2015, 01:35 PM,
#2
RE: change inventory item code, CN description not deleted
Thanks for the heads up - this functionality came after the part code change utility and has never been modified to change the part codes in stockdescriptionstrans table
Phil Daintree
webERP Admin
Logic Works Ltd
http://www.logicworks.co.nz
Reply
07-30-2015, 07:39 PM,
#3
RE: change inventory item code, CN description not deleted
This is strange as the change to do this was done in the Z_ChangeStockCode.php utility over a year ago (16/5/2014). Can you check that line 158 of the script is this:

ChangeFieldInTable("stockdescriptiontranslations", "stockid", $_POST['OldStockID'], $_POST['NewStockID'], $db);

Thanks
Tim
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)