Los Angeles County Sales Tax Code help?

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
louderback
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 47
Joined: Tue Nov 11, 2008 10:47 am
Location: Los Angeles

Los Angeles County Sales Tax Code help?

Post by louderback » Wed Nov 12, 2008 1:53 am

I live in Los Angeles; Can anybody help me out with my sales tax problem? I need the information for Los Angeles County Tax to enter. I know LA County Sales tax is 8.25% and the rest of California is 7.25% tax base and every other State is 0%.
Has anybody run across this with something I could add or code to my AbleCommerce Shopping 7 cart so it will fix this issue?
Thanks.

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: Los Angeles County Sales Tax Code help?

Post by jmestep » Wed Nov 12, 2008 8:54 am

Able doesn't calculate by counties and the best you can do is find the zip codes that are in that county and set up the tax grid using them. Just hope that one zip code isn't in two counties like it is in Ohio. You might just have to settle for something close to what it should be if that is true unless you want to spend a lot customizing or hook in with a third party tax source.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

louderback
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 47
Joined: Tue Nov 11, 2008 10:47 am
Location: Los Angeles

Re: Los Angeles County Sales Tax Code help?

Post by louderback » Wed Nov 12, 2008 9:13 am

Thanks' for the information. no, I'm in Los Angeles County and I'm sure someone has come across this, it's county tax vs. State tax...I was just wondering if someone created any code to plug into Able?
Thanks'
e.-

User avatar
BryanWarmoth
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 44
Joined: Fri May 23, 2008 11:24 am
Location: Puyallup, Wa
Contact:

Re: Los Angeles County Sales Tax Code help?

Post by BryanWarmoth » Wed Nov 12, 2008 10:52 am

I created a sales tax calculator for Washington state and posted all the code here: viewtopic.php?f=47&t=7562

You may be able to used it as a template to create your own work around. You would have to find out if California offers a free web service that will take in the customers address and spit out what rate should be applied to their order.
Bryan Bingham
Warmoth Guitar Products Inc.
bryan@warmoth.com
http://www.warmoth.com

beisenman
Ensign (ENS)
Ensign (ENS)
Posts: 4
Joined: Mon Sep 22, 2008 3:23 pm

Re: Los Angeles County Sales Tax Code help?

Post by beisenman » Thu Nov 13, 2008 5:44 pm

I have implemented it state wide in a MSSQL data Table by zone ..... If you'd like I could give you a table export ....

louderback
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 47
Joined: Tue Nov 11, 2008 10:47 am
Location: Los Angeles

Re: Los Angeles County Sales Tax Code help?

Post by louderback » Thu Nov 13, 2008 6:31 pm

Hi.
Sure that would be wonderful! Did it work well for you in Los Angeles? you could email me at edward.noho@gmail.com
Thank you so much.
e.-

beisenman
Ensign (ENS)
Ensign (ENS)
Posts: 4
Joined: Mon Sep 22, 2008 3:23 pm

Re: Los Angeles County Sales Tax Code help?

Post by beisenman » Thu Nov 13, 2008 8:34 pm

You should essentially cover all of the state tax rates, There are 13 distinct rates in the state of Califoria ranging from 7.25 up to 9.25.
Also, because ther is a limitation on the size of the PostalCode Filter there are a total of 73 rows of zipcode - tax rate data. This table is current as of 10/01/2008 and will remain so for at least 6 months per the State Board of Equalization. I will dump the data to CSV files for you. There will be 2 and they must be loaded in order. To use them, Open up an EXCEL window and then open each file separately. After, Open an MSSQL Server Window and open the ac_TaxRuleTaxCodes Table in edit mode. Finally Paste the datat into the table. Next take the other and copy it to the ac_TaxRules table. That's all there is to it. If you need a walk thru then call me.

Bill Eisenman
Systems Architect
ALOM Technologies Corporation
48105 Warm Springs Blvd
Fremont, California 94539
Direct: 510-360-3656

beisenman@alom.com
FastTrak@msn.com

louderback
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 47
Joined: Tue Nov 11, 2008 10:47 am
Location: Los Angeles

Re: Los Angeles County Sales Tax Code help?

Post by louderback » Thu Nov 13, 2008 8:55 pm

Hi Bill,
I went to the State Board of Equalization today in Van Nuys. For the Internet from Los Angeles County it's broken down in just 3 ways: LA County = 8.25% Sales Tax, Anywhere Outside LA County & all the rest of California = 7.25% Sales Tax, Any other State besides California = 0.0% Sales Tax...your CSV will be perfect though!
Thank you.
Edward

louderback
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 47
Joined: Tue Nov 11, 2008 10:47 am
Location: Los Angeles

Re: Los Angeles County Sales Tax Code help?

Post by louderback » Tue Jun 02, 2009 8:02 pm

Does anybody have an updated script for Los Angeles and it's tax rate change?

thanks :)

Post Reply