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 <psc5@powersupply.net>
To: <emerald@iea-software.com>
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, ronnie@itexas.net 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
>collected.....
>
>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.....
>
>Ronnie@itexas.net
>
>
>----- Original Message -----
>From: David Routh <drouth@davlin.net>
>To: <emerald@iea-software.com>
>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,
>monthly
>> >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
>in
>> >admin...
>> >
>>
>> What we did is create a "dialup single" and a "dialup multi" ... the
>dialup
>> 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
ANY
>> 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
>for
>> >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%
>Web"
>> 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...
>again,
>> ANY Web hosting service SHOULD have the discount...
>>
>> Hope that helps (and makes sense)... if someone can poke holes in it let
>me
>> know.
>>
>> Thanks, David
>>
>> For more information about this list (including removal) go to:
>> http://www.iea-software.com/support/maillists/liststart
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart