FrontAccounting forum — Sales reference field size

Re: Sales reference field size

null@example.com (apmuthu) — Fri, 16 Mar 2018 08:41:57 +0000

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

@Rmendez confirms that this commit solves his issue.

Re: Sales reference field size

null@example.com (joe) — Fri, 16 Mar 2018 07:36:20 +0000

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

null@example.com (joe) — Fri, 16 Mar 2018 06:00:58 +0000

Yes we will increase the field a bit.

Joe

Re: Sales reference field size

null@example.com (apmuthu) — Fri, 16 Mar 2018 04:18:39 +0000

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

null@example.com (apmuthu) — Fri, 16 Mar 2018 03:58:58 +0000

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