Re: [SL] help!! duplicate items appearing on invoices RESOLVED

[Lenny L. <lle...@ma...>]

This did end up being the sequence numbers in the invoiceid sequence.

After using setval() to update the sequence number everything appears to
be working fine, however I do still have to remove and re-add all of the
invoices that have duplicate information.  I haven't noticed any
oddities with older invoices but I'm hoping that none of the information
has been overwritten.

--
Lenny Leblanc


-----Original Message-----
From: sql...@li...
[mailto:sql...@li...] On Behalf Of R
Pennington
Sent: Friday, December 08, 2006 11:57 AM
To: sql...@li...
Subject: Re: [SL] help!! duplicate items appearing on invoices

On Friday 08 December 2006 11:00 am, Lenny Leblanc wrote:
> Hello List,
>=20
> I've been running sql-ledger for a long time and just recently my
> invoices have started showing up with duplicate items when I view or
> print the invoice.  This only happens with new invoices that I enter.
> All my older invoices show and print normal.
>=20
> This appeared to start after entering a cash receipt for a customers
> invoice that wasn't fully paid.  Rather than applying the payment to
the
> actual invoice sql-ledger created a separate blank transaction with
only
> the payment.
>=20
> I also checked into the General Ledger transactions and I don't see
the
> duplicates there, in fact everything appears to be fine.
>=20
> I do have backups and can try reverting to see if this resolves it,
but
> I thought I would check with the list first to see if there is an
easier
> way around it.
>=20
> Anyone have any ideas?
>=20
> --
> Lenny Leblanc


Hello Lenny.

I seem to remember a similar problem that was posted to the list
recently.
I believe it was caused by a problem with the sequence number generated
by the database.
Did you recently restore from a backup ?




------------------------------------------------------------------------
-
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share
your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CID=3D=
DEVDE
V
_______________________________________________
sql-ledger-users mailing list
sql...@li...
https://lists.sourceforge.net/lists/listinfo/sql-ledger-users