Bug 397094 - Scheduled transaction date keeps incrementing to current date in ledger
Summary: Scheduled transaction date keeps incrementing to current date in ledger
Status: RESOLVED WORKSFORME
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 5.0.0
Platform: Other Linux
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-02 15:51 UTC by George
Modified: 2019-01-27 17:23 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Attachments
attachment-26246-0.html (1.66 KB, text/html)
2019-01-27 00:23 UTC, George
Details
The schedule (54.82 KB, image/png)
2019-01-27 13:48 UTC, Thomas Baumgart
Details
The schedule in the ledger (9.40 KB, image/png)
2019-01-27 13:51 UTC, Thomas Baumgart
Details
Automatic check upon application start (15.79 KB, image/png)
2019-01-27 13:53 UTC, Thomas Baumgart
Details
Restart the application (52.18 KB, image/png)
2019-01-27 13:54 UTC, Thomas Baumgart
Details
Enter the details of the transaction (34.26 KB, image/png)
2019-01-27 13:56 UTC, Thomas Baumgart
Details
Real transaction in ledger (9.14 KB, image/png)
2019-01-27 13:58 UTC, Thomas Baumgart
Details
Updated schedule (8.23 KB, image/png)
2019-01-27 13:59 UTC, Thomas Baumgart
Details

Note You need to log in before you can comment on or make changes to this bug.
Description George 2018-08-02 15:51:08 UTC
Schedule transaction gets entered on the correct date into the ledger (e.g 7/31/18). However, the date for the transaction increments to the current date - the 7/31 transaction will always show with the current date. If I look at the scheduled transaction after 7/31, it still shows the next due date of 7/31. I cannot change the date in the ledger. I need to delete the scheduled transaction from the ledger and enter a manual transaction. This has happened with every scheduled transaction I have.

Running on Linux Mint 19
Comment 1 Jack 2018-08-02 16:26:03 UTC
I don't think I understand what the problem is.  A scheduled transaction can only be edited on the Schedules View - but that edits the schedule, which affects future instances.  Once the scheduled transaction (say the last day of every month) is entered, it becomes a real transaction on 7/31, and that date will never change unless you edit it in the ledger.  Once that happens, then the schedule should show the next instance as 8/31.  Although future scheduled transactions may be shown in the ledger, you cannot edit them there, because they are not yet real transactions.  

Also, when you enter a schedule, you can alter the details (date, amount, payee, ...) and it should prompt whether you want those changes to apply on to this single instance, or to the schedule itself, thus for all future instances.
Comment 2 Thomas Baumgart 2018-08-02 16:57:42 UTC
Jack probably described what you need to do. Select it with the right mouse button to open the context menu and select "Enter next transaction". Also, the scheduled transaction should appear grayed in the ledger. BTW, there is an option that allows you to enter due schedules automatically at program start. You may want to take a look at the manual for more details about entering scheduled transactions at https://docs.kde.org/stable4/en/extragear-office/kmymoney/details.schedules.entering.html  Please report back if that helps.
Comment 3 Jack 2019-01-26 23:56:00 UTC
Please let us know if the suggestions helped, or if you still have the problem.
Comment 4 George 2019-01-27 00:23:41 UTC
Created attachment 117669 [details]
attachment-26246-0.html

Just happened again this month. The scheduled txns are set up to automatically be entered in the ledger, which they are. However, once there the txn never becomes 'current' and therefore can't be edited. May have something to do with the scheduled date not being a weekday. I'll try to pay closer attention next time it happens rather that just fixing it by deleting the scheduled text and entering a manual txn.

⁣Sent from BlueMail ​

On Jan 26, 2019, 18:56, at 18:56, Jack <bugzilla_noreply@kde.org> wrote:
>https://bugs.kde.org/show_bug.cgi?id=397094
>
>Jack <ostroffjh@users.sourceforge.net> changed:
>
>           What    |Removed                     |Added
>----------------------------------------------------------------------------
>             Status|REPORTED                    |NEEDSINFO
>            CC|                            |ostroffjh@users.sourceforge
>                   |                            |.net
>         Resolution|---                         |WAITINGFORINFO
>
>--- Comment #3 from Jack <ostroffjh@users.sourceforge.net> ---
>Please let us know if the suggestions helped, or if you still have the
>problem.
>
>--
>You are receiving this mail because:
>You reported the bug.
Comment 5 Thomas Baumgart 2019-01-27 13:48:33 UTC
Created attachment 117678 [details]
The schedule

In the first step I create a schedule which today (2019-01-27) is overdue for two days. The option "Enter this schedule into the register automatically when it is due" is turned on (important).
Comment 6 Thomas Baumgart 2019-01-27 13:51:34 UTC
Created attachment 117679 [details]
The schedule in the ledger

If you switch to the ledger of the account the transaction is shown with todays date. This is the standard behavior. It is grayed out to identify a schedule that is due but not yet issued.
Comment 7 Thomas Baumgart 2019-01-27 13:53:10 UTC
Created attachment 117680 [details]
Automatic check upon application start

This option needs to be turned on so that the schedules are checked at application start. A setting of 0 days in advance will enter them exactly on the date they are due.
Comment 8 Thomas Baumgart 2019-01-27 13:54:45 UTC
Created attachment 117681 [details]
Restart the application

In this state when the application starts it detects a schedule that needs to be entered and informs the user. It is still shown grayed out in the ledger. Then press OK to see the next dialog.
Comment 9 Thomas Baumgart 2019-01-27 13:56:46 UTC
Created attachment 117682 [details]
Enter the details of the transaction

You can now enter the details of the transaction. The date is set to the actual due date. I left it here as is to see a change in the ledger and simply pressed Enter. If you change anything here, you will be asked if this is a one time change or should be used for future transactions.
Comment 10 Thomas Baumgart 2019-01-27 13:58:28 UTC
Created attachment 117683 [details]
Real transaction in ledger

Et voilà the transaction is now stored in the ledger with the date we wanted and it is not grayed out anymore (because it's not a scheduled transaction but a real one). The date of this transaction does not change without user intervention.
Comment 11 Thomas Baumgart 2019-01-27 13:59:37 UTC
Created attachment 117685 [details]
Updated schedule

Since the transaction was entered, the schedule was updated to the next due date. The question now is: what is the problem? For me everything works as designed.
Comment 12 George 2019-01-27 14:15:19 UTC
Thomas,

My scheduled transactions are all set up exactly as you outlined in your 
stream of emails. I only have an issue once in a while (still trying to 
figure out pattern) and only with a single schedule (I probably have 
20-30 set up). I have 2 scheduled transactions set up as loan repayments 
and the problem appears to be related to that. Actually, I said I only 
had an issue with a single schedule, but the two loan schedules are very 
similar, so it could be either one or both of those. Either way, I have 
no issues with other types of transactions. At this point I'm thinking 
of just eliminating this type of scheduled transaction and making it a 
simple withdrawal or transfer.

I don't require any further action from you on my behalf. I'm going to 
leave it as-is for now. If I see this happen again I'll try to note all 
the circumstances and forward to you.

Thanks for looking into this.

George

On 1/27/19 8:59 AM, Thomas Baumgart wrote:
> https://bugs.kde.org/show_bug.cgi?id=397094
>
> --- Comment #11 from Thomas Baumgart <tbaumgart@kde.org> ---
> Created attachment 117685 [details]
>    --> https://bugs.kde.org/attachment.cgi?id=117685&action=edit
> Updated schedule
>
> Since the transaction was entered, the schedule was updated to the next due
> date. The question now is: what is the problem? For me everything works as
> designed.
>
Comment 13 Jack 2019-01-27 17:23:57 UTC
George, I'm still not sure exactly what the problem is.  When a scheduled transaction is actually entered, it becomes a real transaction in the relevant account, and you can do anything with it that you can do with any other transaction.  Before that, it is only a scheduled transaction, and although it is displayed in the relevant ledgers, you cannot edit it there until it has been entered.  Up until the scheduled date, it should show the scheduled date, but after that date, since it has not been entered yet, it shows the current date, which will be the date of the transaction if entered then.  

I'm going to close this as WORKSFORME, but do reopen it if the problem happens again, especially if you can provide more details about what seems wrong.