Re: [Emerald] sales tax fields

Sheryl D. Weidner ( (no email) )
Fri, 4 Jun 1999 16:01:05 -0700


This is a known issue that's in my/Charlie's bug report. If a setup fee or
other Charge is taxable, the tax is rolled into the total amount of the
charge but the charge is not listed as having separate tax items. For
example, if a recurring service fee were $10.00 and tax were 8%, it would be
listed as
Cost Tax1 Tax2
$10.00 $0.80 $0.00

But if it's a line item, it's listed as:


Sheryl D. Weidner - -
IEA Software Customer Support Manager
Phone: (831) 459-9430 - Fax: (831) 459-9434
Billing and Customer Care for ISPs and Communications Companies

-----Original Message-----
From: Dale E. Reed Jr. <>
To: <>
Date: Thursday, June 03, 1999 9:04 PM
Subject: Re: [Emerald] sales tax fields

:Ben Conner wrote:
:> At 10:37 PM 6/3/99 -0500, you wrote:
:> >Ben Conner wrote:
:> >The Sales Tax is in the InvoiceItems table in three fields: TaxID, Tax,
:> >and Tax2. TaxID matched to a tax entry in the Taxes table, and Tax/Tax2
:> >are the respective monetary tax amounts.
:> I've summed the tax and tax2 fields for the whole invoiceitems table and
:> come up with 0 for both. I have invoices where tax has been charged and
:> paid by clients. ??
:Hmmm.. I'd have to see the invoices, then. The invoice is made up of
:the Invoices and InvoiceItems tables. Therefore, if the tax was on the
:invoice, it will be in the tables. If you want to send me connection
:information to your SQL Server, I can take a look at it.
:Dale E. Reed Jr. Emerald and RadiusNT
:IEA Software, Inc.