Any idea on why the sequence got out of sync ?
Cheers,
Roy
On Monday 11 December 2006 5:09 pm, Lenny Leblanc wrote:
> 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,
> >
> > 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 ?
|
