> ------------------------------ > > Message: 2 > Date: Mon, 8 Sep 2008 18:50:28 -0700 > From: "Chris Travers" <..hidden..> > Subject: Re: [Ledger-smb-users] Error when trying to mark AR as paid > > On Mon, Sep 8, 2008 at 5:39 PM, Roberto C. S?nchez <..hidden..> wrote: > > > > I have an open AR. When I enter the payment in SQL-Ledger, I enter the > > transaction, and then under "Payments" I enter the date and ammount. I > > then click "Update" and "Post". When I click "Post", I get a warning > > about posting an existing transaction, but it goes through and the AR is > > showed as closed and the amount of money shows up in the checking > > account balance. > > Better way: > > Cash/Receipt or Cash/Receipts > Brilliant! > > > > When I try the same thing with LedgerSMB, I get this error right after > > clicking through the warning: > > > > DBD::Pg::st execute failed: ERROR: duplicate key violates unique constraint "transactions_pkey" > > Error! > > > > INSERT INTO ar (id, customer_id) VALUES (?, ?) > > ERROR: duplicate key violates unique constraint "transactions_pkey" > > > > Why might that be? > > THere is a known bug for which the SQL script > sql/fixes/transactions_pkey_repost.sql corrects > However, be advised that reposting invoices is *not* gaap compliant > and ideally you should not need to apply the fix. There are also > known issues that happen with reposting invoices including issues that > can occur with COGS. There are no accepted accounting fixes because > this is not an accepted accounting practice :-) > I was not aware of that not being an accepted accounting practice. Anyhow, you were correct that applying that patch was not necessary. I am now also aware of a feature which I had no idea was there :-) Regards, -Roberto -- Roberto C. Sánchez http://people.connexer.com/~roberto http://www.connexer.com
Attachment:
signature.asc
Description: Digital signature