Skip to content

V1.8.3: Creating a new transaction using the "Add Recurring Transaction" button creates a transaction with wrong Account ID #255

@Bucket1616

Description

@Bucket1616

I created a recurring transaction and then tried to "add" it. It created the transaction however, the Account that was saved as part of the "Recurring Transaction" was not how the data was saved. It shows up as an "(Inactive)" account.

Using phpMyAdmin, I was able to find the newly created transaction, and it appears that when the new entry is made in the "Bank Transaction" table, the Value for AccountID is not being set correctly. Here is what the entry looks like when first created:

image

After correcting the Account field using the regular interface to point to the correct account, here is what the entry looks like in phpMyAdmin.

image

If I look at my Accounts Table, I see this:
image

So it appears that when I try to Add Recurring Transaction, it is using the "IsActive=0" account that is directly before the intended account.

I then tried to change the Account used for the Recurring Transaction, to see what that would cause in the Database.

It was then that I found out that every time an "Add Recurring Transaction" is used, a new Account is created in the Accounts Database.

Here is what the Accounts Database looks look after adding two new Recurring Transactions (notice the increase in Accounts):

image

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    Status

    ✅ Released

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions