washington state sales tax integration

This forum is where we'll mirror posts that are of value to the community so they may be more easily found.
User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: washington state sales tax integration

Post by compunerdy » Mon Feb 02, 2009 6:06 pm

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.

User avatar
WylieE
Captain (CAPT)
Captain (CAPT)
Posts: 281
Joined: Tue Mar 25, 2008 8:26 am
Location: Puyallup, WA
Contact:

Re: washington state sales tax integration

Post by WylieE » Wed Feb 04, 2009 3:20 pm

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.

Code: Select all

shipment.Address.Fax = locCode;
Eric Wylie
Warmoth Guitar Products, Inc.
http://www.warmoth.com

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: washington state sales tax integration

Post by compunerdy » Wed Feb 04, 2009 3:56 pm

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?

User avatar
WylieE
Captain (CAPT)
Captain (CAPT)
Posts: 281
Joined: Tue Mar 25, 2008 8:26 am
Location: Puyallup, WA
Contact:

Re: washington state sales tax integration

Post by WylieE » Wed Feb 04, 2009 4:02 pm

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.
Eric Wylie
Warmoth Guitar Products, Inc.
http://www.warmoth.com

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: washington state sales tax integration

Post by compunerdy » Wed Feb 04, 2009 5:37 pm

Well share!! sheesh

User avatar
WylieE
Captain (CAPT)
Captain (CAPT)
Posts: 281
Joined: Tue Mar 25, 2008 8:26 am
Location: Puyallup, WA
Contact:

Re: washington state sales tax integration

Post by WylieE » Wed Feb 04, 2009 5:45 pm

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.
Eric Wylie
Warmoth Guitar Products, Inc.
http://www.warmoth.com

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: washington state sales tax integration

Post by compunerdy » Wed Feb 04, 2009 7:13 pm

I figured as much 8) 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?

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: washington state sales tax integration

Post by compunerdy » Thu Feb 12, 2009 12:57 pm

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.

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: washington state sales tax integration

Post by compunerdy » Tue Jun 02, 2009 12:23 pm

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?

wellonthehill
Ensign (ENS)
Ensign (ENS)
Posts: 2
Joined: Wed Jul 29, 2009 11:09 pm

Re: washington state sales tax integration

Post by wellonthehill » Mon Aug 03, 2009 9:26 pm

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

wellonthehill
Ensign (ENS)
Ensign (ENS)
Posts: 2
Joined: Wed Jul 29, 2009 11:09 pm

Re: washington state sales tax integration

Post by wellonthehill » Mon Aug 03, 2009 10:58 pm

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

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: washington state sales tax integration

Post by louderback » Wed Aug 05, 2009 10:50 pm

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!

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: washington state sales tax integration

Post by compunerdy » Tue Nov 02, 2010 9:13 am

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.

User avatar
WylieE
Captain (CAPT)
Captain (CAPT)
Posts: 281
Joined: Tue Mar 25, 2008 8:26 am
Location: Puyallup, WA
Contact:

Re: washington state sales tax integration

Post by WylieE » Tue Nov 02, 2010 9:18 am

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!!
Eric Wylie
Warmoth Guitar Products, Inc.
http://www.warmoth.com

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: washington state sales tax integration

Post by compunerdy » Tue Nov 02, 2010 1:35 pm

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.

User avatar
compunerdy
Admiral (ADM)
Admiral (ADM)
Posts: 1283
Joined: Sun Nov 18, 2007 3:55 pm

Re: washington state sales tax integration

Post by compunerdy » Mon Jan 24, 2011 2:32 pm

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.

Post Reply