Payment Reminders

[theitd]

Is it possible to set up a user-defined email reminder based on an invoice approaching the limit for payment terms?

I apply a 28-day time limit on payments, and these apply to invoices which don't usually have an associated order - so the 'Payment Due' reminder doesn't process them.

The help file suggests that a user-defined reminder doesn't check the invoice records - but would it allow for custom SQL to check the due date and payment status?
If so - has anyone else tried this?

I have tried various combinations of reminder/criteria - and the only one that generates an email at the correct time is the Invoice Overdue. Ideally, I'd just like to customise the title to remove the word 'Over' - but I'm not sure how this could be done ??

[netshine]

You can call a reminder whatever you like - it sounds like the reminder type you want is 'invoice overdue', but you don't have to call it that - you can type in your own name for it. The client will never see the reminder type. If you are really fussy, you can always amend the language file and change 'overdue' to 'due' in the file /administrator/components/com_nbill/language/en-GB/xref.en-GB.php.

[theitd]

Thanks for getting back to me.

I did try the Overdue, with a new name - but it used the type for the subject 'Reminder: Invoice Overdue'.
I wanted to avoid changing the language files, as this would've affected the real overdue messages.

I can test again - but as there are no logs for the CRON generated messages, it makes it difficult to debug/provide more info.

[netshine]

The email subject is taken from line 67 of /administrator/components/com_nbill/language/en-GB/reminders.en-GB.php. If you are using it for both due and overdue invoices, I suggest using a generic subject such as 'Invoice Reminder'. At present, the only other solution would involve writing some custom code in the email_presend event to change the subject depending on the content (which goes beyond the scope of support).

[theitd]

Line 67 will do the job - thanks.

If I wanted to be fussy (!), though,  I'd ideally customise the presend function. Is this possible in the file: /administrator/components/com_nbill/framework/classes/nbill.email.class.php (from what I can see, this is used for manual sending only)

Or is the function in the encrypted file here?
/administrator/components/com_nbill/framework/nbill.reminder.sender.php

If it's the second one, is there an extension/override which could achieve the same result?