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 ?
|
