SQL error adding Charges

William Salame ( williams@kbd.com.au )
Thu, 06 Aug 1998 19:49:10 +1000

I have two problems

1- We have corporate accounts with between 5 and 30 services each, for
two of the accounts
I get an "SQL adding error" during batching of the renewal invoices. I
have checked the resulting
Invoice and seems that emerald did not add the charges to the invoice
only picked up the monthly
services . This has been happening for a while. I have run checkdb.sql
and I couldn't find any errors.
I have moved the services to a new MBR the same problem persisted.
This month I have deleted the MBR including the services and created a
brand new account
and I still have the same problem. I have no problem with other
corporate accounts.

2- I have 10 MBRs where I can not email the invoice, I get 5:Invalid
procedure call
These 10 accounts are corporate accounts as well with between 5 and 20

Assistant would be appreciated. We are running Emerald 2.1.11 and Radius