[Emerald] Billing Issues

Ken Eitenmiller ( keitenmiller@hughestech.net )
Tue, 18 Jul 2000 08:48:53 -0500

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