Needed to create custom views that included the Invoice ID – seems to make sense.
The user “rexkenley” fixed it and posted here (Thanks!!!)
Just ensure that the field label is blank when inserting this into the vtiger_field table
INSERT INTO `vtiger_field` ( `tabid` , `fieldid` , `columnname` , `tablename` , `generatedtype` , `uitype` ,
`fieldname` , `fieldlabel` , `readonly` , `presence` , `selected` , `maximumlength` , `sequence` , `block` ,
`displaytype` , `typeofdata` , `quickcreate` , `quickcreatesequence` , `info_type` )
VALUES ('23', NULL , 'invoiceid', 'vtiger_invoice', '1', '80', '', 'Invoice ID', '1', '0', '0', '100', '1', '69', '1', 'I~O',
'1', NULL , 'BAS'
Dear Gregg,
Thanks for your interest in vtiger.
In our forthcoming release (v5.0.3), by default we will be providing selection of Invoice Number field while creating a custom view.
We will also provide customization of invoice numbers through user interface.
http://www.vtiger.com/blogs/2007/05/10/vtiger-503-video-customize-your-invoice-no/
Thanks,
Gopal