Thanks O, Your solution did not help. But after trying it, it helped me with finding the real problem. It had to do with filing a credit note of an article that had a negative stock already.
So, thanks! Rik On zaterdag, nov 2, 2002, at 12:10 Europe/Amsterdam, o wrote: > > I did change the tax rate in the customer file , then posted the > invoice , and then put the tax rate as > it was and post the invoice again, > it is a hassel , but it worked > Omar > > 27/08/23 11:34:47 ?, Rik Zandvoort <[EMAIL PROTECTED]> wrote: > >> >> Omar, >> >> What did you do about it? Did you delete the wrong lines in the >> database? Or do you have another solution? >> Rik >> >> On woensdag, okt 30, 2002, at 10:11 Europe/Amsterdam, Omar BaheyEldin >> wrote: >> >>> >>> I am sometimes having the same problem >>> Omar >>> >>> 24/08/23 02:52:13 ?, rik <[EMAIL PROTECTED]> wrote: >>> >>>> >>>> In AR , Edit Customer Invoice, I have one invoice with a payment >>>> that >>>> does not belong there. It is not possible to delete it. >>>> If I clear all the fields of the payment, click Update Form, it >>>> looks >>>> like the payment is deleted, but after Post Invoice the payment is >>>> there again. >>>> If I alter the amount and Post Invoice, a second payment with the >>>> new >>>> amount is added, the old one is still there. The new one I can >>>> delete. >>>> >>>> If I delete the invoice, I can not see the stubborn payment(s) >>>> listed >>>> in any of the reports (in GL and Trial balance). But I found out >>>> they >>>> are still in the database. Actually it is 3 lines with the same >>>> trans_id in the acc_trans table (one amount including tax, one tax, >>>> one >>>> excluding tax). >>>> >>>> If I add the same invoice again, after a while the same error >>>> occurs. >>>> >>>> I can not exactly remember what I did do when this occurred. I >>>> think I >>>> added a Credit Invoice with a positive Qty and a negative Price, >>>> then >>>> added two transactions in GL, one to balance the Credit Note with an >>>> Intermediate Account (In Dutch called Kruisposten, sorry I do not >>>> know >>>> the English translation) and the second to balance the Intermediate >>>> Account with the Invoice the Credit Note was mend for. >>>> >>>> What should I do? Just delete the three lines in the database or is >>>> this going to make things worse? >>>> >>>> Thanks in advance, >>>> >>>> Rik >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>> >>> >>> >>> >>> >>> >> >> >> >> >> > > > > > >
