Duplicated transaction in the forecast table
Issue #12
new
I have created an income transaction for 2nd May which repeats every 28 days.
The forecaster table shows the transaction correctly for the 2nd but also repeats it for the 3rd May, along with the resulting balance. Eventually after several restarts of MD, the duplicated transaction dissapears. If I delete the reminder and recreate it, the problem reappears.
Thanks John
Comments (23)
-
repo owner
-
Hi Kevin
I have tried several different start dates to see if it is effected by being close to the start or end of a month but it makes no difference. It is 100% repeatable on my system. Since the reminder in question is an income amount, I have tried making it an expense but still the same.
It is such a shame since Forecaster is so useful but this particular transaction is a significant amount of income and gives a very "optimistic" forecast.
Have you had any success?
Kind regards John
-
repo owner
Hi John,
Sorry, I fixed the easy one in the weekend but didn't get time to have a look at this one. I've just had a quick look at it now but I can't get a setup that reproduces the problem.
If you have the time, could you create a new empty account set with a reminder that has the problem and send it to me?
-
- attached root.mdinternal
Hi Kevin
File attached which has a 28 day recurring deposit of £999.00 starting on 1/6/14. Forecaster shows it being deposited on both the1st and then 2nd June, then it repeats correctly every 28 days.
Hope this helps.
Kind regards John
-
Hi
I also have this problem. It seems to be unique to transactions that repeat every 28 days - I have several that repeat monthly and they are fine, but the 28 day ones are repeated the following day, which is making forecaster useless, in fact worse, it's dangerous, as I keep getting the wrong amount of money in my account and have now twice narrowly missed out on bank charges. Please fix this. I am using 2014.5 build 980 and forecaster v37. I am following your thread about 2015 with interest, but I certainly won't be paying for that version if you haven't fixed this one after 8 months!
-
I did a little research on this. On the day that the repeated transaction is entered into the account, the forecaster repeats it again the following day, but if you close MD and reopen it, the duplicate goes away, so perhaps it is something to do with the forecaster refreshing?
-
repo owner
Hi John,
Thanks for doing a bit of digging. This bug is non-deterministic, which makes it very hard to reliably reproduce and fix. Once I have a 2015 version ready to go this is the first bug I'll look at.
Cheers,
Kevin
-
Hi Kevin. I have this issue as well. I have student loans that are tracked with 5 separate transactions repeated monthly. They are currently showing up 3 times each for the next twp months. Let me know if I can help at all with your testing.
UPDATE: It looks like this may have been a glitch with auto commit. I'll monitor and let you know if it recurs next month.
-Julie
-
repo owner
Hi Julie,
Thanks for the info. I'll get back to you on this thread when I start looking at this bug again. I'm currently working on a feature to notify users when updates are available. After that, this is the next thing I'll be focussing on.
Cheers,
Kevin
-
repo owner
Hi folks,
I have started a new BitBucket account for Money Foresight and will be using that in preference to my personal BitBucket account.
I've copied this issue to the new account:
https://bitbucket.org/mahanaroad/moneyforesight/issue/1/duplicate-transaction-for-28-day-reminders
Please keep an eye on that issue for any progress updates. I've got the update notification feature out of the way and now I'm ready to start looking at this bug.
Cheers,
Kevin
-
repo owner
This bug is now fixed in v5 of Money Foresight. See here for more details:
https://bitbucket.org/mahanaroad/moneyforesight/issue/1
John Dingle, let me know if you're still using MD 2014.
Cheers,
Kevin
-
Thanks Kevin, that is really good news. I have made the leap of faith and am now using MD2015, currently on build 1173, which is the one that fixed my security history issues. I have the laptop on which I am watching Windows 10, so I could install MD2014 on that if you need anything checked out.
-
Hi Kevin
Unfortunately I am still using MD 2014. I still see a lot of negative comments about 2015 so will sit on the fence for while untill more positive reports appear.
Is there any chance that a fix can be applied to the 2014 version? I am more than happy to purchase the 2015 version from you but not use it yet.
Kind regards John Dempsey
-
repo owner
Hi guys,
@john_dempsey12 That's no problem at all. It's one of those bugs that takes forever to find the cause but only takes a minute to apply the fix. Thanks for the offer to purchase Foresight but it won't be much trouble to port the fix to the old Forecaster. I'm perfectly happy for you to hold onto your cash. I'll update this thread when it's done.
@johndingle Thanks for the offer but I was just asking in case you still wanted the fix ported to the Forecaster.
Thank you both for your help.
Cheers,
Kevin
-
repo owner
Attached is v38 of the Forecaster, which includes the fix for this duplicated transaction issue.
Let me know if you have any trouble.
Cheers,
Kevin
-
repo owner
- attached forecaster.38.mxt
-
Thank you Kevin.
I will upgrade to MD2015 and purchase Foresight as soon as MD is stable.
Cheers John
-
I was having the problem with duplicated 28-day transactions, and installed v38 of Forecaster which seemed to fix the problem. However, the problem has now re-occurred, just the same as before! I'm not aware that I've made any configuration changes to Moneydance, so am puzzled why the problem has reappeared. I've tried uninstalling the extension, closing Moneydance, then reinstalling the extension, but the duplicated transactions are still there in the table. I will eventually install Moneydance 2015 when stable, but for now am sticking with 2014, and Forecaster is one of the features I use most. Am I alone in seeing reappearance of the bug in Moneydance 2014?
-
repo owner
Hi Ryder,
Sorry to hear you're having trouble again. Could you confirm if the duplicate only appears when you view it in the morning (midnight to noon)?
Cheers,
Kevin
-
Many thanks. The duplicate, actually duplicates as more than one transaction is affected, is there this evening, so definitely noon to midnight. I have also noticed that two transactions dated tomorrow in the account register are NOT showing in the Forecaster table. Does that help at all? I'll look again in the morning and report back.
Ryder Cowan
-
Reporting again as promised. The duplicates have vanished from the table this morning! In addition, the two transactions in the account register for today have been included in the account balance shown in the table for today - as reported before, they were not showing in the Forecaster table at all yesterday. I have made no entries in Moneydance since reporting the problem yesterday.
The chart and table now appear to reflect cashflow correctly. However, there's clearly something that's not working as it should, and I can't rely on the forecast. It would be a great help if you were able to discover the cause of the problem and fix it.
Ryder Cowan
-
repo owner
Hi Ryder,
Thanks for the extra info. I still can't explain the duplicate transactions but I should have recognised the missing future transactions straight away. When I fixed the bug for duplicated transactions initially, I also introduced a new bug that caused future transactions for tomorrow to be ignored. https://bitbucket.org/mahanaroad/moneyforesight/issue/4
That bug is fixed in the 2015 version but not in the 2014 version. I would like to port that bug fix to 2014 but I can't make any promises about when I'll be able to get around to it. My 8 week old daughter kept me busy until 11pm tonight. Spare time feels like a thing of the past.
If you notice anything else that might narrow down the cause of the duplicate transactions please let me know.
Cheers,
Kevin
-
Many thanks for your attention. I'm not sure if this helps, but when I went to Moneydance this morning (i.e. before 1200) the duplicate transactions had reappeared in the table. When I clicked on 'calculate' they disappeared. However, transactions in the register for today were not reflected in the account balance, even after 'calculate'. I closed Moneydance and reopened, and the transactions were then included in the balance.
Strange!
Ryder Cowan
- Log in to comment
Hi John, This is one that has been raised before. https://code.google.com/p/moneydance-forecaster/issues/detail?id=37
I've never been able to reproduce it but I don't doubt that it exists. I can't promise anything but I'll try to have a look at it this weekend to see if I can figure out what is going on.
Thanks for filing.
Cheers, Kevin