Re: [Emerald] sales tax fields

Dale E. Reed Jr. ( (no email) )
Thu, 03 Jun 1999 22:37:34 -0500

Ben Conner wrote:
>
> I'm trying to prepare a state report on sales tax and have looked several
> places in the Emerald database--Invoices, Invoiceitems tables, etc. No
> identifiable tax field has sales tax in it.

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.

-- 

Dale E. Reed Jr.      Emerald and RadiusNT__________________________________________IEA Software, Inc.    www.iea-software.com