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