FrontAccounting forum — Item Number field length

Re: Item Number field length

null@example.com (MarkRaymer) — Fri, 11 Dec 2015 12:23:25 +0000

Hello,

Nice information,
thanks

Re: Item Number field length

null@example.com (apmuthu) — Sun, 29 Nov 2015 10:02:08 +0000

Whilst most FA forms specify width of the form field's display, they rarely look at it's length in the php code.

stk_code, item_code and stock_id are found in quite a few tables in FA Core:

debtor_trans_details.stock_id
grn_items.item_code
item_codes.stock_id
item_codes.item_code
prices.stock_id
purch_order_details.item_code
sales_order_details.stk_code
stock_master.stock_id
supp_invoice_items.stock_id
workorders.stock_id

Item Number field length

null@example.com (shbrown100) — Mon, 13 Jul 2015 15:09:02 +0000

Hi,
I need to extend the item number field length from 20 to 25. How easy it this to do? I can amend the database, but know the php needs to be changed. Will all the associated pages that use the item number need to be changed or have you made it easy for this change?
Many thanks,
Steve