FrontAccounting forum — Item Code character limit

Re: Item Code character limit

null@example.com (apmuthu) — Thu, 21 Nov 2013 16:19:19 +0000

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

Re: Item Code character limit

null@example.com (randomizer) — Mon, 11 Nov 2013 20:40:10 +0000

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.

Re: Item Code character limit

null@example.com (swheeler) — Mon, 11 Nov 2013 20:18:01 +0000

Hi randomizer,

Are you, by chance, migrating from QuickBooks?

Scott

Item Code character limit

null@example.com (randomizer) — Mon, 11 Nov 2013 20:13:44 +0000

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