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

[R P. <arc...@mt...>]

On Friday 08 December 2006 11:00 am, Lenny Leblanc wrote:
> Hello List,
> 
> 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.
> 
> 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.
> 
> I also checked into the General Ledger transactions and I don't see the
> duplicates there, in fact everything appears to be fine.
> 
> 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.
> 
> Anyone have any ideas?
> 
> --
> 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 ?