-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of
marcus@redcentre.com
Sent: Tuesday, July 18, 2000 08:53
To: emerald@iea-software.com
Subject: Re: [Emerald] Billing Issues
This is a bug....You need to select "taxable Account" on the billing 
tab sheet of all MBR's.
Marcus
From:           	Ken Eitenmiller <keitenmiller@hughestech.net>
To:             	"'emerald@iea-software.com'"
<emerald@iea-software.com>
Subject:        	[Emerald] Billing Issues
Date sent:      	Tue, 18 Jul 2000 08:48:53 -0500
Send reply to:  	emerald@iea-software.com
> 
> I have TRIED to run billing...
> Here is my problem...
> 
> Batch
> -Summary
> -Charges
> Auto Batch Checked
> -create
> --Create 229 invoices?
> ---writing 1 of 229(49)
> 
> SQL Server Error 547 INSERT Statement conflicted with COLUMN FORGIEN KEY
> constraint 'FK_InvoiceIt_TaxID_519A22A9'. The conflict occurred int
database
> 'Emerald' table 'Taxes' column 'TaxID'
> State = 2, severity = 16
> 
> Then an OK box...
> 
> SQL Error2 Adding Invoice Item
> 
> Then an OK box...
> 
> Rolling back last invoice
> 
> Then an OK box...
> 
> It then skips all of the invoice customers and goes to credit card and
then
> interm credit card...
> 
> ANY IDEAS?
> 
> I ran checkdb.sql (in emerald admin) last night and left it...
> It locked up...
> 
> I am willing to run the batch process without autobatch checked... but
then
> it prints all invoices, weather or not they are email invoices... Then
takes
> all day to decide which ones need to be mailed...
> 
> Thanks,
> Ken
> 
> Ken Eitenmiller
> keitenmiller@hughestech.net
> www.hughestech.net
> 
> 
> 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
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart