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"
- apmuthu
- Moderator
- Offline
- apmuthu
- Moderator
- Offline
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.
Re: Sales reference field size
Yes we will increase the field a bit.
Joe
Re: Sales reference field size
All Reference Edit Boxes has been extended to show 16 chars instead of 10.
/Joe
- apmuthu
- Moderator
- Offline
Re: Sales reference field size
The commit has not appeared as yet in the GitHub repo.
@Rmendez confirms that this commit solves his issue.