Recurring expenses on v5?

I’ve just migrated to version 5 (self-hosted, white label) but I can’t find the recurring expenses feature. Has it been removed in this version?

1 Like

Hi,

The feature hasn’t been implemented yet

Thanks for getting back to me. Do you any sort of rough timescale for when it will be ready?

1 Like

Sorry, we aren’t able to provide ETA’s for upcoming features

That said, it is a priority since it is supported in v4

I’m too waiting to see recurring expenses return.

Hi @hillel,

now that recurring expenses are back I created one on Sept 20 (Date), set Frequency to monthly and Start Date to Oct 1, 2021; so it should have fired off tonight, but didn’t. Cron job is running. Any ideas?

Ulf

Hi,

Have you set it to active?

Yes, it’s set active and green.

@david any ideas to debug?

Is the timing determined by the send time setting on Settings > Email Settings?

Not sure why the email settings would have anything to do with it. For recurring invoices I could see, but for recurring expenses it should just clone the recurring expense to a real expense. It’s actually two recurring expenses, that didn’t fire. For those recurring expenses, here is a

select * from recurring_expenses where id in (1,2)

| id | created_at | updated_at | deleted_at | company_id | vendor_id | user_id | status_id | invoice_id | client_id | bank_id | project_id | payment_type_id | recurring_expense_id | is_deleted | uses_inclusive_taxes | tax_name1 | tax_name2 | tax_name3 | date | payment_date | should_be_invoiced | invoice_documents | transaction_id | custom_value1 | custom_value2 | custom_value3 | custom_value4 | category_id | calculate_tax_by_amount | tax_amount1 | tax_amount2 | tax_amount3 | tax_rate1 | tax_rate2 | tax_rate3 | amount | foreign_amount | exchange_rate | assigned_user_id | number | invoice_currency_id | currency_id | private_notes | public_notes | transaction_reference | frequency_id | last_sent_date | next_send_date | remaining_cycles |
| 1 | 2021-09-20 16:07:59.800500 | 2021-10-01 10:13:02.299238 | NULL | 1 | 6 | 1 | 2 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | regular | NULL | NULL | 2021-09-20 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0.000000 | 0.000000 | 0.000000 | 19.000000 | 0.000000 | 0.000000 | 150.000000 | 0.000000 | 1.000000 | NULL | 0001 | 3 | 3 | NULL | :MONTH/:YEAR | NULL | 5 | NULL | 2021-10-01 00:00:00 | -1 |
| 2 | 2021-09-20 16:11:54.875054 | 2021-10-01 10:12:38.779024 | NULL | 1 | 5 | 1 | 2 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | NULL | NULL | NULL | 2021-09-20 | NULL | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 25.000000 | 0.000000 | 1.000000 | NULL | 0002 | 3 | 17 | NULL | :MONTH/:YEAR | NULL | 5 | NULL | 2021-10-01 00:00:00 | -1 |

Interesting is in both entries
last_sent_date: NULL
next_send_date: 2021-10-01 00:00:00

Looking at the schedule I was setting the recurring expenses to generate @ 23:45, i’ve changed this too 00:10 (UTC)

Ah, patience is a virtue. :slight_smile: The expenses got created meanwhile.

Now, variables like :MONTH and :YEAR aren’t resolved and appear literally in the created expenses.

Can you make Payment Type available as a column to be shown in the Expenses overview?

Also, I have a couple of expenses that get paid automatically by SEPA direct debit or recurring bank transactions. I can turn on Mark Paid and select SEPA Direct Debit or Bank Transfer in the recurring expense. But can’t remove the date or set even it to something like “the 5th of the month after the recurring expense fired off”. At least, the payment date of a recurring expense should be disregarded and replaced with something not earlier than the date the recurring expense fired.

Since the last update, trying to change a recurring expense gives me an error in laravel.log:
[2021-10-03 11:19:32] production.ERROR: Call to a member function timezone_offse
t() on null {“userId”:1,“exception”:"[object] (Error(code: 0): Call to a member
function timezone_offset() on null at /var/www/in/v5.3.18/app/Models/RecurringEx
pense.php:207)
[stacktrace]
#0 /var/www/in/v5.3.18/app/Models/RecurringExpense.php(194): App\Models\Recurr
ingExpense->nextDateByFrequency()
#1 /var/www/in/v5.3.18/app/Transformers/RecurringExpenseTransformer.php(108): Ap
p\Models\RecurringExpense->recurringDates()
If you need the full stack trace, let me know.

@xoo

there are fixes for this coming in the next release, i’ll tag one shortly.

@david

The error message in laravel.log has disappeared, but the other three issues remain (unresolved variables like :MONTH and :YEAR in created expenses, payment type not available as a column, and payment date setting in recurring expenses). Any chance to get at least the first two resolved? :slight_smile: