Re: [Emerald] sales tax fields

Dale E. Reed Jr. ( (no email) )
Thu, 03 Jun 1999 23:10:19 -0500

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. www.iea-software.com