Re: [Emerald] Sales Tax Report

Ronnie D. Franklin ( )
Tue, 5 Oct 1999 15:43:21 -0500

The problem is that the sales tax is stored in invoices.... not payments..
so you would have to link the payments to the invoices and etc....

It just takes some that knows CR backwards and forwards....

The simplest thing to do is for Emerald to have a tax field in the payments
table, then the report could be generated no sweat.... I do not know if the
payment posting is handled inside of Emerald or a stored proceedure, but if
it is a stored proceedure it would be simple to add it....

----- Original Message -----
From: PowerNet <>
To: <>
Sent: Tuesday, October 05, 1999 3:26 PM
Subject: Re: [Emerald] Sales Tax Report

Does anyone know the SQL database well enough to create a query like this?

I don't know SQL, but there are many reports that tell amounts collected,
why not add tax to the report.

It will take someone who knows the SQL table.

*********** REPLY SEPARATOR ***********

On 10/5/99, at 12:58 PM, wrote:

>No holes to punch and all this works fine...
>However, There is no easy way to create a report that provides the
>information to file taxes.....
>99% of the ISPs should be working on a Cash Account model since they have
>no inventory.. thus tax is not due until it is actually collected.. using
>the tax_sum.rpt creates a report on what you billed, not what you
>I have sent an Email to IEA requesting a report that actually provides the
>information that is necessary to file taxes... However I have yet to get an
>answer.. I am willing to pay for this report as I am sure there are many
>others that would also.....
>----- Original Message -----
>From: David Routh <>
>To: <>
>Sent: Tuesday, October 05, 1999 11:56 AM
>Subject: RE: [Emerald] Sales Tax Report
>> At 11:35 AM 10/5/1999 -0500, you wrote:
>> >The $25 rule is for each month.. no matter how the payment is made,
>> >4 months, or yearly.... so if you access charge is less than $25.00 per
>> >month on the average then there is no tax.. just change the tax to none
>> >admin...
>> >
>> What we did is create a "dialup single" and a "dialup multi" ... the
>> single is a non-taxed item in admin and the multi is taxed... The dialup
>> single is used for the bulk of our dialup customers which meet the $25
>> exemption.
>> We also created a "$25 exemption" service that is actually a -$1.97 (our
>> tax rate is .07875). That service is added to any account that has the
>> "dialup multi" or other access that is over $25... like ISDN. This way
>> account that has the "multi" or "ISDN" SHOULD have the "$25 exemption"...
>> makes it a little easier for our people to remember.
>> >As for the 20% off the other services.. I don't have anyone that is due
>> >the next 15-20 days so I am still scratching my head...
>> >
>> We basically do a similar thing... We created a "20% Virtual" and "20%
>> to handle the few virtual and business sites we house. The discount is
>> reflective of the cost of the service... Whatever the cost of the service
>> we do the math and deduct the tax charged on 20% of that service...
>> ANY Web hosting service SHOULD have the discount...
>> Hope that helps (and makes sense)... if someone can poke holes in it let
>> know.
>> Thanks, David
>> For more information about this list (including removal) go to:
>For more information about this list (including removal) go to:

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

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