Created attachment 373151 [details] The report type in Danish layout When using Assets/ and Liabilities i get some bad periods (sorry i don't know the precise English name, but in danish its "Nettoværdi Søjlediagram") Each month is adding up values from the account from (day 2?) the 2. in the month to and with the 1. in the following month. That gives some inconsistent totals of the month's where some months does not calculate the accounts if the first of the month is in a weekend. I think it is an easy fix. Just be aware that a month does not include, the 1. in the next month
Hello Thank you for report. It would be useful to confirm (1) exact setup - v3.4 release on Windows? (2) exact options used - tr PrtScr on each of the options tabs and attach in this bug report? (3) are you in Denmark? Windows language? Any particular changes in locale?
Hello My Windows 10 language is in English. I am using the Danish Translation of GnuCash I'm on GnuCash 3.4 Best Regards Ole
Created attachment 373153 [details] About
Created attachment 373154 [details] Tab 1
Created attachment 373155 [details] Tab 2
Created attachment 373156 [details] Tab 3
I wonder if the issue stems from a Start-Date of 30.10.2014, and monthly intervals. Because the periods will count: 30/10/14 - 29/11/14 30/11/14 - 29/12/14 30/12/14 - 29/01/15 30/01/15 - 01/03/15 (*) 02/03/15 - 01/04/15 02/04/15 - 01/05/15 (*) because there's no 30/02/15, it seems to miscount to 01/03/15 If the above is the right bug, then I am not 100% sure what exactly should be the *desired* behaviour. Having "monthly" periods starting from 30.10.14 does not have an easily defineable range of dates.
The starting date has no influence. Its always 1 month the rest of the year(s), no matter if i choose the 31, the 15. the. 1. or whatever as a starting date. There is a problem with the month definition - it should not include eks. 1. of February in Januarys figures - but it does. :)
I'm afraid I don't understand the problem. All the screenshots you posted seem to be consistent. The report screenshot matches the options you have specified. If you mean the actual valued of each bar in the chart are off, that's not obvious from your screenshots without having actual data to compare with. Could you create a mini sample data file in which we can see the faulty behaviour and attach it here ? That would help a lot.
I'm not sure how to do that, but i will see what I can do. The problem is, that one bare should represent all the transactions in a specific month. The way it works is so: The transactions in the 1. date of the following month is calculated in the bar from the previous month. So lets say I pay my mortgage (kr. 10.000 at the 1. of March and the loan is lowered with 8.500 at that date (I pay Dkr. 1.500 in interest). The report will the show 8.500 less in my liabillities for February. That is wrong. The payment is done in March. My assets are also lowered Dkr. 1.500 in February, all though the payment of interest are done in March. I hope this description could help. Otherwise i will try if i can make a mini sample, as you suggest.
I think the difficulty here is that Gnucash calculates the Networth on a particular date eg 1st-March to *include* all transactions posted on that day. This is not currently a user-customisable behaviour. If you truly wish to determine the net worth at the *beginning* of the month, it is not currently possible to create such a report... but this should be fixed for the next version 3.5 due in a couple months. Hint: in the future you'll choose the start-date e.g. 31st-December, with monthly intervals, and it'll calculate networths at end-of-day of 31-Dec, 31-Jan, 28-Feb, 31-Mar etc. Hint (2): You will not be able to choose start-date 28-Feb to choose end-of-month because monthly intervals from 28-Feb will set the dates as 28-Mar, 28-Apr etc.
On re-reading "My assets are also lowered Dkr. 1.500 in February, all though the payment of interest are done in March." does not seem right -- it is still useful to see a sample mini datafile!
I'm working on it. :) I have made a small test, where it seems like it's all working as it should? I chose the XML storage. Maybee that makes a difference. I will try to make the same test with a MySql storage instead. Ill be back. :)
