• From: USA
  • Registered: 11/04/2013
  • Posts: 4

Topic: Item Code character limit

Hello,

I have modified my stock_id and item_code database columns as well as the items.php text input to accept and store 40-character item codes/stock id's rather than only 20. I left the datatypes the same; varchar or char.

Imports (with the CSV extenstion) and new items appear to work normally. I can say that a stock check sheet is kind of ugly with codes longer than 20 characters, but this is not too big of a problem.

Does anybody have experience with other parts of the application that should be modified for longer item codes/stock id's? My instinct tells me that the modification is complete, but confirmation or warnings would be very helpful. I am very new with php and mysql.

cheers

  • From: USA, OH, Cincinnati
  • Registered: 11/08/2012
  • Posts: 39

Re: Item Code character limit

Hi randomizer,

Are you, by chance, migrating from QuickBooks?

Scott

swheeler's Website

  • From: USA
  • Registered: 11/04/2013
  • Posts: 4

Re: Item Code character limit

Hi Scott,

Yes. My item naming scheme was devised while using QuickBooks. There are many impacted tables in FA's database but I was careful to alter each of them before importing a portion of my item list.

I'll post again if I have a problem with it and hopefully a veteran can chime in.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Item Code character limit

Changing the FontSize in the report might make the 20 character space fit the 40 characters within it.

apmuthu's Website