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

Closed
opened 2026-02-28 19:38:48 -06:00 by GiteaMirror · 4 comments
Owner

Originally created by @savedbygrace19 on GitHub (Aug 1, 2024).

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

Originally created by @savedbygrace19 on GitHub (Aug 1, 2024). ### Verified issue does not already exist? - [X] I have searched and found no existing issue - [X] 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
GiteaMirror added the needs infobug labels 2026-02-28 19:38:48 -06:00
Author
Owner

@MatissJanis commented on GitHub (Aug 3, 2024):

👋 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 commented on GitHub (Aug 3, 2024): 👋 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.
Author
Owner

@MatissJanis commented on GitHub (Sep 8, 2024):

Closing due to inactivity

@MatissJanis commented on GitHub (Sep 8, 2024): Closing due to inactivity
Author
Owner

@blueca commented on GitHub (Oct 27, 2024):

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.

@blueca commented on GitHub (Oct 27, 2024): 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.
Author
Owner

@savedbygrace19 commented on GitHub (Oct 27, 2024):

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.

@savedbygrace19 commented on GitHub (Oct 27, 2024): 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.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#1285