Re: Creating invoice ***SQL Error adding main invoice***

Dale E. Reed Jr. ( (no email) )
Thu, 17 Sep 1998 22:45:16 -0700

Barry Kiesz wrote:
> Got a problem. I'm attempting to invoice customers that should have been
> invoiced on 9/1/98. About 95 of 450 went through. Then I get an error that
> states "SQL Error adding main invoice", I click OK and get "Rolling Back
> Last Invoice", hit OK again and I'm back to the batch screen. I tried
> moving the batch date to 9/15/98, but got the same results. Is there
> something I'm missing here?? Somewhere I could start looking for a solution?

Which version of Emerald are you using? I remember some problems with
2.1 and Invoices having a charge on them that caused this problem.


Dale E. Reed Jr. ( IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today |