[Emerald] Accounting error when adding service to already existing taxed MBR

david leigh ( (no email) )
Thu, 3 Feb 2000 15:03:08 +0800

Hi All

Running Emerald 2.5.322 (Clean install) on SQL 7.0 I have performed dozens
of tests of this error over the last few days to confirm that it is indeed a
bug and not my error. I am reasonably certain now - can others please
comment or confirm the below. I have also cc'ed this to support for

1) Take an existing MBR with services which are taxed. Add a service (the
type of service being one that you've defined in Emerald Admin to be taxed,
and the Billing tab showing taxed account)
2) Save, and when it asks you if you want to invoice, say yes.
3) The invoice is created **BUT WITH NO TAX**


1) As above
2) Save, and when it asks you if you want to invoice, say no.
3) Run a batch and process the new invoices.
4) You will find that an invoice has been created for customer, but will
have been charged for the entire period of all service-types, rather than
how much longer in the period they have to pay.

Example of the above:
I have a PPP type account with a tax rate of 5%. This account has been
invoiced for a year and paid in full around six months ago, so there is
still 6 months to go before re-invoicing shouild happen.
I now add another PPP account to this MBR. Being mindful of the problem with
taxation being left out I say 'no' to creating an invoice when prompted.
I now run a batch and an invoice is created, but the invoice charges the
customer for the **FULL ANNUAL CHARGE** on **BOTH** the services, whereas it
should only be charging for the additional service (it does however,
properly charge the tax).

In order to get round this we've been voiding the invoices from the first
account(s) and then letting Emerald re-invoice all accounts when batching.
This is a frustrating and time consuming hack. Any solutions massively

David Leigh

For more information about this list (including removal) go to: