Create "Next Invoice Date" field in SalesOrders
In SalesOrders there is a Recurring Invoice function which allows to create invoices automatically with a given frequency:
There is a table called vtiger_invoice_recurring_info
where some of the fields in the previous image are stored:
I've found myself in numerous situations where users wonder when the next invoice is going to be generated and I have to go to the above table to figure it out. You cannot rely on the Start Period
field because it can be modified and no longer reflect the date when the first invoice was created.
I think there should be a read-only field called Next invoice date
and display the last_recurring_date
column of the above table. By the name of the column you could believe it's the date of when the last invoice was generated, but it's the date of when the next invoice is going to be generated.
I have successfully added the field in a Vtiger instance and it's really useful. The column already exists, so it's a matter of generating the field entry in vtiger_fields
;