When are you going to come up with a tax report that actually reports tax
collected on Payments made????
----- Original Message -----
From: Dale E. Reed Jr. <email@example.com>
Sent: Monday, February 07, 2000 12:01 PM
Subject: Re: [Emerald] project for the day
> > Kenneth Gustav Eitenmiller Jr wrote:
> > Maybe this will explain it better...
> Have you seen this report?
> It does a lot of what you want.
> > SQL Query follows....kinda
> > /* tax summary for month by taxid */
> > set nocount on
> > declare @begindate char(10), @enddate char(10)
> > select @begindate = '1/1/2000'
> > select @enddate = '1/31/2000'
> > set nocount off
> A side note:
> Tax is tracked at the line item detail, rather than the invoice
> detail (so some items are taxable and some are not).
> This is just a rough guess and hasn't been double checked:
> Select TaxID, beforetax=sum(amount*quantity), taxes=sum(tax)+sum(tax2),
> From Invoices i, InvoiveItems ii
> Where i.InvoiceID = ii.InvoiceID
> and i.Type <> "VOID"
> and i.Date between @begindate and @enddate
> Group By TaxID
> Order By TaxID
> > print discription from virtual table (tax1)
> > print "Amount Invoiced before taxes =" amountsberforetax
> > print "Amount Invoiced taxes only =" bothtaxes
> > print "Amount Invoiced Total =" amounts
> Dale E. Reed Jr. Emerald and RadiusNT
> IEA Software, Inc. www.iea-software.com
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: