FrontAccounting forum — Sales reference field size

Re: Sales reference field size

2018-03-16T08:41:57Z

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

@Rmendez confirms that this commit solves his issue.

Re: Sales reference field size

2018-03-16T07:36:20Z

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

Committed to 2.4 SF Git Repo.

/Joe

Re: Sales reference field size

2018-03-16T06:00:58Z

Yes we will increase the field a bit.

Joe

Re: Sales reference field size

2018-03-16T04:18:39Z

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.

Sales reference field size

2018-03-16T03:58:58Z

@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"