dragotin / kraft

Kraft helps to handle your daily quotes and invoices in your small business.
http://volle-kraft-voraus.de
GNU General Public License v2.0
60 stars 19 forks source link

Timeline overview calculation is wrong after hard remove of document #89

Closed oyla12 closed 3 years ago

oyla12 commented 4 years ago

Moin

At first: I'm sure this is not a usual case and may not need a fix. So just as informal transparency:

As I started using the software I added the first document (bill) for testing purposes. By testing I realised, I'm willing to change the invoice number system and tried to delete the (testing) document. This was not really possible over the interface (as I may see as feature for clean invoice management), so I removed it from database by sqllitebrowser.

As I now made my sales tax summary report (GER: "Umsatzsteuervoranmeldung") I was very happy about the Timeline feature. But than I realized, that he is summing up over 4 documents (and not as it should be 3). There seems to be the old document involved and as result the calculation is not correct.

Timeline Overview Screenshot_2020-11-15_23-13-35

Documents of this Month Screenshot_2020-11-15_23-14-04

I was manually looking into the database and not sure, were he gets the information about the document I deleted. As database corruption may be always a problem I would expect that the shown calculation is exactly based on what I can the in the documents overview.

Whatever: Thanks for your work, I'm very happy about using your software, it's the simple solution I've looked for :)

ahoi! oyla

dragotin commented 3 years ago

The list is generated from the table archdoc which contains the archived documents, ie. the ones that have been printed. From that, it takes the latest one printed.

Kraft is still lacking a flag that indicates if a doc was actually sent to the customer and with that, is valid.

dragotin commented 3 years ago

I think this specific issue can be closed. Reopen just in case not...