Thanks for coming back, I think I follow that but I’m unsure how that will work in my case as I have 12 records in si_preferences.
I have three businesses in the database and over the years I have created a few invoice types to distinguish between such as monthly service charges and one-off invoices. The record in si_preferences where pref_id == 1 seems to relate to my sole trader business which doesn’t do much these days whereas pref_id == 7 and == 9 relate to most of my invoicing transactions.
Should I set all of the si_invoices records to last_activity_date to “2020-01-02 00:00:00” and the aging_date to “2020-01-01 00:00:00”? Would that cause all invoice types to be triggered for owing and aging?