Bug 303976 - Process scheduled transactions on the last day of the month
Summary: Process scheduled transactions on the last day of the month
Status: RESOLVED FIXED
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: git (master)
Platform: unspecified Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-23 19:11 UTC by Thomas Baumgart
Modified: 2019-08-29 01:10 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 4.8.1,5.0.0


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Thomas Baumgart 2012-07-23 19:11:28 UTC
Subject:  Feature request: Last day of the month
Date:   Sat, 07 Jul 2012 11:21:47 -0500
From:   Drew Keller <drew@drewkeller.com>
To:   kmymoney2-developer@lists.sourceforge.net



I've found a few requests for this, but several years old. I'm not sure
how to do a search of the email archive. So...

My bank processes some credits and fees on the last day of the month. I 
have the schedule set for 1 time per month, but I have to adjust it to
either the 30th or the 31st every time I enter data, which is kind of
annoying.

For a while, I tried to approximate it by setting to the first day of
the month. However, the problem with that is my bank statements are
monthly from the first day to the last day of the month. So when I 
reconcile accounts using my bank statements, I have to go in and adjust
the date, which is even more of a pain.

Any chance this can be fixed?

Thanks
-drew


Reproducible: Always
Comment 1 Cristian Oneț 2014-07-29 10:32:33 UTC
This should be looked at, it does not sound that complicated.
Comment 2 Thomas Baumgart 2014-07-29 12:00:50 UTC
I agree, it does not sound complicated. The problem I see is, that we currently only have QDate objects to store the dates. We can setup the schedule to monthly, but we cannot store meta information about the specific date (yet). So it is a bit more complicated than you might have thought. Or am I missing something?
Comment 3 Cristian Oneț 2014-07-29 12:11:57 UTC
No, you are right the way schedules are stored might need to be changed to implement this.
Comment 4 Ralf Habacker 2017-08-13 10:37:19 UTC
Git commit 6bce2ac059f1921ead3362687e48ce84367238d2 by Ralf Habacker.
Committed on 13/08/2017 at 10:36.
Pushed by habacker into branch '4.8'.

Fix 'Process scheduled transactions on the last day of the month'

This commit includes a fix for MyMoneyDbTable::columnList() creating
invalid sql statement.

FIXED-IN:4.8.1
Test Plan: tested on 4.8 branch
Differential Revision: https://phabricator.kde.org/D7269

M  +24   -0    kmymoney/dialogs/keditscheduledlg.cpp
M  +7    -0    kmymoney/dialogs/keditscheduledlgdecl.ui
M  +15   -0    kmymoney/mymoney/mymoneyschedule.cpp
M  +22   -0    kmymoney/mymoney/mymoneyschedule.h
M  +18   -0    kmymoney/mymoney/mymoneyscheduletest.cpp
M  +1    -0    kmymoney/mymoney/mymoneyscheduletest.h
M  +6    -1    kmymoney/mymoney/storage/mymoneydbdef.cpp
M  +1    -0    kmymoney/mymoney/storage/mymoneystoragedump.cpp
M  +22   -0    kmymoney/mymoney/storage/mymoneystoragesql.cpp
M  +1    -0    kmymoney/mymoney/storage/mymoneystoragesql.h

https://commits.kde.org/kmymoney/6bce2ac059f1921ead3362687e48ce84367238d2
Comment 5 Ralf Habacker 2017-08-13 13:25:48 UTC
Git commit 0836d385d0a849aca74ceabf23498632a0b59cb4 by Ralf Habacker.
Committed on 13/08/2017 at 13:25.
Pushed by habacker into branch '4.8'.

Google translator has found something better

M  +1    -1    kmymoney/dialogs/keditscheduledlgdecl.ui

https://commits.kde.org/kmymoney/0836d385d0a849aca74ceabf23498632a0b59cb4
Comment 6 Thomas Baumgart 2017-11-05 19:25:18 UTC
Git commit ee24bbff8e72d3af6a9bddf365509eb9dcc02efb by Thomas Baumgart.
Committed on 05/11/2017 at 19:21.
Pushed by tbaumgart into branch 'master'.

Fix 'Process scheduled transactions on the last day of the month'

This commit includes a fix for MyMoneyDbTable::columnList() creating
invalid sql statement.

FIXED-IN:4.8.1
Test Plan: tested on 4.8 branch
Differential Revision: https://phabricator.kde.org/D7269

(cherry picked from commit 6bce2ac059f1921ead3362687e48ce84367238d2)

M  +13   -0    kmymoney/dialogs/keditscheduledlg.cpp
M  +7    -0    kmymoney/dialogs/keditscheduledlgdecl.ui
M  +26   -1    kmymoney/mymoney/mymoneyschedule.cpp
M  +18   -0    kmymoney/mymoney/mymoneyschedule.h
M  +2    -1    kmymoney/mymoney/storage/mymoneydbdef.cpp
M  +1    -0    kmymoney/mymoney/storage/mymoneystoragedump.cpp
M  +59   -2    kmymoney/mymoney/storage/mymoneystoragesql.cpp
M  +4    -0    kmymoney/mymoney/storage/mymoneystoragesql.h
M  +18   -0    kmymoney/mymoney/tests/mymoneyschedule-test.cpp
M  +1    -0    kmymoney/mymoney/tests/mymoneyschedule-test.h

https://commits.kde.org/kmymoney/ee24bbff8e72d3af6a9bddf365509eb9dcc02efb