• From: Canada
  • Registered: 07/03/2014
  • Posts: 24

Topic: Item Number field length

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

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

Re: Item Number field length

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

apmuthu's Website

  • Registered: 12/11/2015
  • Posts: 1

Re: Item Number field length

Hello,

Nice information,
thanks