Hello, just found the transaction repair button in gnucash. I will test if it fixes the described problems. I made a backup as xml. Usually I use MySQL.
regards, Christoph Am 21.06.2015 um 07:59 schrieb Christoph Holtermann: > Hello, > > I'd like to use gncInvoiceAttachToLot to try to fix the disconnection but > I don't get it to work in python. It's not in declared in engine/gncInvoice.h > and if > I declare it there's a probleme with scheme compiling. So I guess I'll > just leave it like that and fix the invoice-transaction links by creating > new invoices/transactions. > > regards, > > Christoph Holtermann > > Am 21.06.2015 um 05:47 schrieb Christoph Holtermann: >> 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
