[Bug]: "Off Budget" category transaction finds its way into filter

[savedbygrace19]

Verified issue does not already exist?

• I have searched and found no existing issue
• I will be providing steps how to reproduce the bug (in most cases this will also mean uploading a demo budget file)

What happened?

Hi!

I noticed this morning that, if I click into a category (in my case, "Food") via clicking on that category's value in the 'Spent' column, the filters correctly reflect that category ("Food") and month ("07/2024"), but the filtered items included an item from a specific off-budget account for that month. Funny thing is, I could click through other categories, and that specific line-item never showed up anywhere else.

Here's where it gets a bit stranger - I recreated the entry, used a different payee name, and deleted the original entry. Originally 'Interest' had been the payee - I used the Payee's (business') actual name, checked again, and the item no longer showed up in the filtered category.

Tried one more thing then: created one more entry, using payee 'Interest' once more, and deleted the entry with the business' name, and voila! The entry appeared once more within the filtered view.

So it doesn't seem to have been something errant when creating the original entry - strangely enough, 'Food' likes to display 'Interest' entries from that particular off-budget account.

I'll try to fiddle with things a bit more later - thanks!

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox

Operating System

Windows 11

[MatissJanis]

👋 Would you mind uploading a sample budget file and providing reproduction instructions? Without having those there is little we can do to debug the issue.

[MatissJanis]

Closing due to inactivity

[blueca]

I have seen this too. I can't intentionally reproduce it but I've seen it over a couple of months, with the same scheduled off budget transaction appearing in the same category. This month seems ok however, maybe something in the latest version has fixed it.

Looking at the SQLite data the off budget transaction has the same category id as the category it's appearing in, instead of NULL.

[savedbygrace19]

I still see it periodically, and I'm on the latest build - I'm ignoring it for now, as it doesn't seem to adversely impact anything. Good catch, though, on finding something in the db...

I don't think it impacts totals, etc., either, though it's been long enough I can't be sure of that.