Re: [Emerald] SQL Server Error... adding service

Paul Bennett ( (no email) )
Wed, 31 May 2000 11:59:26 -0500

2.5.334 does not like to invoice non taxed accts for some reason

----- Original Message -----
From: "David Routh" <drouth@davlin.net>
To: <emerald@iea-software.com>
Sent: Wednesday, May 31, 2000 10:35 AM
Subject: [Emerald] SQL Server Error... adding service

> Hey,
>
> I went to add another service to an existing MBR and when I saved it and
it
> asked if I wanted to create an Invoice I said yes.... that's when I got
> this error:
>
> SQL Server Error: 547 INSERT statement conflicted with COLUMN FOREIGN KEY
> constraint 'FK_Invoicelt_TaxID_2CBDA3B5'. The conflict occurred in
database
> 'Emerald', table 'Taxes', column 'TaxID'.
> State=1, Severity=16
>
> After clicking past the error I got this:
>
> SQL Error2 Adding Invoice Item
>
> Then this message:
>
> Rolling back last invoice
>
> What's all this telling me... needless to say it didn't create the
Invoice.
>
> Using Emerald 2.5.334
>
> Thanks, David
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart