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

Topic: Sales reference field size

@Rmendez asked:

I am using FA version 2.4.3...............
Can you help me with this??............Please................
"Increase size of Reference field in Direct Invoice"

Post's attachments

Spanish_DI_BigRef.png 53.8 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

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

Re: Sales reference field size

The screenshot is self-explanatory. The concerned file is sales/sales_order_entry.php. Whilst the max length of the form field allows 35 characters, the displayed form field is restricted to 10 characters.

In the DB tables, the field sizes are all normally VARCHAR:

reflines.pattern - 35
refs.reference - 100
sales_orders.reference - 100
debtor_trans.reference - 60
purch_orders.reference - TINYTEXT
supp_trans.reference - TINYTEXT
supp_trans.supp_reference - 60
stock_moves.reference - CHAR 40
workorders.wo_ref - 60
wo_manufacture.reference - 100
wo_issues.reference - 100
suppliers_supp_ref - 30 (***less than general form field max of 35***)
cust_branch.branch_ref - 30 (***less than general form field max of 35***)
journal.reference - 60
grn_batch.reference - 60
dimensions.reference - 60
bank_trans.ref - 40

@joe: are there an rationalisations needed amongst these fields and field types.

Post's attachments

Direct_Invoice_Ref_Size.png 121.7 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

apmuthu's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Sales reference field size

Yes we will increase the field a bit.

Joe

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Sales reference field size

All Reference Edit Boxes has been extended to show 16 chars instead of 10.

Committed to 2.4 SF Git Repo.

/Joe

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

Re: Sales reference field size

The commit has not appeared as yet in the GitHub repo.

@Rmendez confirms that this commit solves his issue.

apmuthu's Website