AbleCommerce Shopping Cart Software

I dunno..I used the code you guys provided above. Is that saving that info and if so how are you pulling it? I just um..got creative for this year since I didnt notice this problem until the last day.

compunerdy wrote:I dunno..I used the code you guys provided above. Is that saving that info and if so how are you pulling it? I just um..got creative for this year since I didnt notice this problem until the last day.

Look in the shipper fax number field. See if you have a 4 digit number for your WA state customers.

They sure are...

Do you have a SQL statement or something setup in the store to pull them all and give you the totals for each code?

compunerdy wrote:They sure are...

Do you have a SQL statement or something setup in the store to pull them all and give you the totals for each code?

Not within AC. I created an external page that pulls the data from the tables so our accounting folks don't have to log in.

Well share!! sheesh

compunerdy wrote:Well share!! sheesh

Uh, it's in Coldfusion and is very much a one trick pony. Otherwise, I'd have offered it up.

I figured as much Thanks for helping me get this far with this stupid tax crap.

Can you or someone else reading this offer a SQL statement or something else that would work to pull this info for me?

Eric,

Did you guys upgrade to 7.0.2 yet? I cant get this to work now and no tax's are being added. I will keep working on trying to fix it but I wanted to see if you ran into any problems as well.

EDIT.. It started working again..not sure what I did.

This works for 7.0.3 except for kit items. It will only apply tax to the parent kit item which in my case has $0 price so tax is not getting charged. Anyone know how to fix it?

hi everybody,

shouldn't there be some error checking like try/catch or something in case wa.gov site is unavailable? you could tax at a default 9.0% tax rate maybe?

from a quick look it seemed like if connection to gov site fails then buyer is charged zero tax.

also, maybe i missed it but is it calling the wa.gov site regardless of buyer's location? shouldn't there be a trivial rejection (like checking for a 9 as first digit) before continueing on and calling wa.gov?

i hate seeing multiple programmers all having to do the same work. if someone has already done these kind of improvements would you mind posting them?

thanks,

paul

where is the documentation for TaxCodeId ?

either as a member of Basketitem

or ShipMethod

I see how the provided code sets TaxCodeId

however, how does the value of TaxCodeId relate to the taxcodes and taxrules i have set up?

in the switch statement why does 0.75% get a code of 5 ?? where does this 5 map to the tax codes i've set up ?

very confused

Has anybody created one for Los Angeles? I'm so lost concerning script and programing...it's like I'm another planet. I'm lost just reading through the threads how to make the tax code & rules work let alone understanding the relationship to one another?

Any help would be great!

I was very happy when I saw that Able had implemented wash state tax in 7.0.5 I finally upgraded the other day and have noticed some issues. Is anyone else currently using it?

1. It seems to be sending my address for the tax code and not the customers.

2. I am not sure it is storing the loccode.

3. We need a report to give the total of each loccode in order to pay the tax to the state.

4. There is no fall back if the server is down. It should charge the minimum rate at least.

We're still on 7.0.4. Not sure when we'll upgrade to 7.0.5. Looks like you're leading the pack this time!!

Katie is working with me on the issues. I will keep everyone posted here.

It does use the correct address once someone has a account but it seems to be sending a lot of requests to the server.

Have not got anywhere as far as help from Able making this service useable..

Here is what is needed.

AC was kind enough to implement this but they provide no way to get the info back out of AC as all they seem to be recording is the tax cost period. Here is what the log file shows during the communication.

Send: http://dor.wa.gov/AddressRates.aspx?out ... &zip=98502

Receive: <?xml version="1.0" encoding="UTF-8"?>
<response loccode="3403" localrate="0.022" rate="0.087" code="0"><addressline houselow="2251" househigh="2299" evenodd="O" street="CARRIAGE DR SW" state="WA" zip="98502" plus4="0000" period="Q12011" code="3403" rta="N" ptba="Thurston PTBA" cez=""/><rate name="OLYMPIA" code="3403" staterate="0.065" localrate="0.022"/></response>

As you can see they are receiving the loccode shown here as 3403. This code needs to be stored in the database and then we need a report that would show the tax collected per loccode.

loccode tax collected

3403 $25.53
3805 $45.06
etc..

The tax is being stored as a line item in the OrderItems table with a ton of empty fields. I would think one of them could be used to store the loccode. Then you would just need to make a report that searches all OrderItems for ones that have that field non null and pull all the codes and the price (tax amount) and sort by code.

I know, I know.. I make it sound soo easy.