Auto populate service period on reoccurring invoices
90% of our billing is reoccurring, typically monthly or quarterly for services; billed in advance. Our customers prefer to have the service period noted on the invoice. For instance on a quarterly billing we will have in the line item description 'Water treatment services for the period 1/1/2020 thru 3/31/2020."
Currently we have memorized transaction with XX in the month field and have to go through about 600 invoices per month and update the XX for the correct periods.
Is there a way to do this automatically such that we do not have to touch and retouch these invoices every month/quarter?