business problems - transactions, lots and invoices

[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