business problems - transactions, lots and invoices

[Christoph Holtermann]

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.gnucash at 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 at 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