Quote:Thanks Becky, I have located the page
http://www.taxwatch.biz/cgi-win/Kansas/TxWStateSite.exe/ZipCodeEntry which does lookups by zip+4
1. Would like to know if I can do this just using the first 5 digits.
Does the last 4 digits really result in different rates? People on the same street have different rates? 66612-1234 could be different from 66612-2345?
(Never mind, I just did some tests and was quite surprised to see the results. I have determined that the full 9 digits are needed. Forgot you've got some looooong roads in Kansas. PS- we have lots of short roads, but NO SALES TAX, NO INCOME TAX here in NH ).
2. Is it OK to just bring back the Total Tax Due?
Are you looking for State, County, City, Total Tax Rates to bring back?
Are you also entering the amount, and looking for the Total Tax Due, and/or Total Amount?
3. We should probably make this a separate discussion item?
Or use Private Messaging on the forum board?
Not really covered by subject "Inside Sesame March Issue"
Hi Bob,
Your right, this doesn't really fall under the discussion of the March issue of Sesame but our invoice form was similar to what came out in the March issue. Anyway have moved here
To answer your questions
Quote:Would like to know if I can do this just using the first 5 digits.
Does the last 4 digits really result in different rates?
As you discovered, yes it does, heres an example zip code 67037 city of Derby, sales tax 6.8% add 4 digit zip of 8510 and it takes it outside the city limits to a county tax rate of 6.3% even though the address is Derby. Therefore, two address, one across the street from the other may have different +4 zips and different tax rates or even counties for that matter.
Quote:Is it OK to just bring back the Total Tax Due?
Are you looking for State, County, City, Total Tax Rates to bring back?
Was looking to bring back the Total Tax % rate only.
What I have been working on trying to do is:if the invoice is taxable then do lookup on the LE of Zip and Zip4 under the shipping address, return the total tax rate to the LE TaxRate and show as % (customers want to see & check % rate charged). Activating the Calculate Button would add up the line items and place in LE Subtotal, convert the % rate of LE TaxRate to a decimal and multiply the Subtotal putting the resulting amount in LE SalesTax then proceed to Shipping and Total.
Still unsure if this is the way to go as we are relying on the States Dept of Revenues website for the look up as each invoice is done. If they change a link, move the database during update or what ever then our whole invoicing system is down.
Was thinking about setting the tax rate in our Customers db so the tax rate is placed in the invoice with the customer #. Trouble is ShipTo address may have a different Zip, Zip4 and tax rate than the BillTo address then some of our customers have 40 to 50 different job addresses to ship to; So now we would have to create a db of the customer jobs or add a subform to the customer db to show the tax rates for each shipping address.
What did you say no sales or state tax in NH ??? that's gota be tuff