• Registered: 04/15/2010
  • Posts: 16

Topic: How can edit the item code?

I have 1200 items for which i have given codes. Now i need to change them..how do I do it?

regards

  • Registered: 12/25/2007
  • Posts: 2,447

Re: How can edit the item code?

As for now (once used) item codes cannot be changed. You need to write some sql script to change all references to old codes to the new one.
Janusz

  • Registered: 04/15/2010
  • Posts: 16

Re: How can edit the item code?

Thanks...i need then some one to write this code.

regards

  • alvin
  • Senior Member
  • Offline
  • From: USA, Guatemala, Honduras
  • Registered: 05/20/2008
  • Posts: 301

Re: How can edit the item code?

I did this once, but my file was small then...  I made a back file of db, opened it in PSpad used Find and Replace to change the codes.  Then restored to the new file.   But this will be a lot of work for 1200 items...

If you fine a coder let me know, I need some SQL statements myself...

AM

"The roots of education are bitter, but the fruit is sweet."  - Aristotle.
  • Registered: 04/15/2010
  • Posts: 16

Re: How can edit the item code?

Alvin,

Will let you know once i find and get the codes...by the way I also need way of reporting where i can list item movements by "movement type"

Can we do it in FA now?

regards
sheshagiri

  • From: UK, Scotland, Aberdeen
  • Registered: 04/21/2010
  • Posts: 30

Re: How can edit the item code?

Shouldn't be too difficult - do you have a list of old and new?  Are you intending to change the part numbers on existing invoices and other movements or is this a "going-forward" event for invoices/movements from now-on?

W

  • Registered: 04/15/2010
  • Posts: 16

Re: How can edit the item code?

Hi,

It can be going forward...I also needed reporting of movements by "movement type" say for select period.

regards

  • Registered: 02/10/2010
  • Posts: 2

Re: How can edit the item code?

I'm not exactly an expert, but isn't it improper in database design to put meaningful information into a record identifier?  Shouldn't the id field be an auto-increment integer, and the product code be a different field so that it can be edited without throwing off related records?  If I'm correct, the next question--is there any thought to change this at some point?

  • Registered: 12/25/2007
  • Posts: 2,447

Re: How can edit the item code?

No, there is no need for pure technical id here. Item code is changed rarely (if at all), and allowing multiply records with the same item code would provide more problems than advantages. For example changing the item code in database would change the cinvoice content retrospectively.

Janusz