Hello, I'm cleaning up my invoices. When I wanted to assign a payment to an invoice there were some invoices missing in the dialogue. Those invoices have transactions assigned to them. I wanted to find out what was wrong and I came as far as to find out that the list of invoices to attach the payment to was created by gnc_payment_window_fill_docs_list an there with xaccAccountFindOpenLots
having a look at the lots I found that in those lots that were missing there was no attached payment. The text of the assignment with the number of the invoice is there but GetInvoiceFromLot is None. The Lot is not closed. When in gnucash I changed the invoice taking back the transaction gnucash crashed. When I started it anew I could create a new transaction. For that new transaction I could properly assign a payment. I didn't use the assignment procedure until some days ago. So I cannot tell when how or why the data corruption happened. I created the first invoices in the end of 2013. Maybe something changed in the meantime. Maybe it would be useful to check for consistency of data by having a look if every transaction which is supposed to have an assigned transaction has all these transactions with lots pointing at itself. I wonder if I can make things work if I manually assing the transaction to the lot. regards, Christoph Holtermann Am 23.05.2015 um 21:04 schrieb John Ralls: >> On May 23, 2015, at 8:41 AM, Geert Janssens <geert.gnuc...@kobaltwit.be> >> wrote: >> >> On Saturday 23 May 2015 15:51:34 Christoph Holtermann wrote: >>> Am 23.05.2015 um 11:47 schrieb Geert Janssens: >>>> On Saturday 02 May 2015 17:10:39 Christoph Holtermann wrote: >>>>> Hello, >>>>> >>>>> for some months it seems to me that some business reports don't >>>>> work right. For example there's the "Kundenbericht" (customer >>>>> report). It shows only one invoice where there are a lot for the >>>>> specific customer. Changing the period of time doesn't solve the >>>>> problem. It seems like a bug to me. >>>> I don't see this on my system. My customer report lists all my >>>> invoices. Do you perhaps have multiple A/R accounts ? The customer >>>> report can only list one at the time and my select the wrong one by >>>> default. I have been bitten by this in the past for vendor reports. >>>> >>>>> Then when I enter a new invoice it's always number 1 and not >>>>> counting >>>>> up anymore. >>>> Same here - I can't reproduce on my system (Fedora 21, latest git >>>> build). >>>> >>>> What backend are you using ? I only tested with an xml file. >>>> >>>> Regards, >>>> >>>> Geert >>> Backend is MySQL. I'm using the master branch. Maybe it's the latter. >>> If I find some time I'll build the normal one. >>> >> My test was with the master branch as well. Can you try if the same >> happens with an xml file ? If not, there is a bug in the mysql backend. >> It's very well possible this is one of the corner cases we've mentioned >> before in the sql backends. > Could be. Counters are maintained in KVP directly from Scheme. Moving all KVP > to libqof is my current development project; I intend to rewrite the > File>Properties stuff in C++ as part of that effort. > > Where are the invoice-customer links kept? > > Regards, > John Ralls > > > _______________________________________________ > gnucash-devel mailing list > gnucash-devel@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel -- --- Nachricht gesendet von C. Holtermann --- - - - Verschlüsselte Nachrichten können über - - den öffentlichen Schlüssel auf folgendem - - Keyserver an mich gesendet werden: - http://pgp.mit.edu:11371/pks/lookup?op=get&search=0x4DD9CF0482B0620B _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel