washington state sales tax integration
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: washington state sales tax integration
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.
Re: washington state sales tax integration
Look in the shipper fax number field. See if you have a 4 digit number for your WA state customers.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.
Code: Select all
shipment.Address.Fax = locCode;
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: washington state sales tax integration
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?
Do you have a SQL statement or something setup in the store to pull them all and give you the totals for each code?
Re: washington state sales tax integration
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.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?
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: washington state sales tax integration
Well share!! sheesh
Re: washington state sales tax integration
Uh, it's in Coldfusion and is very much a one trick pony. Otherwise, I'd have offered it up.compunerdy wrote:Well share!! sheesh
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: washington state sales tax integration
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?
Can you or someone else reading this offer a SQL statement or something else that would work to pull this info for me?
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: washington state sales tax integration
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.
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.
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: washington state sales tax integration
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?
-
- Ensign (ENS)
- Posts: 2
- Joined: Wed Jul 29, 2009 11:09 pm
Re: washington state sales tax integration
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
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
-
- Ensign (ENS)
- Posts: 2
- Joined: Wed Jul 29, 2009 11:09 pm
Re: washington state sales tax integration
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
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
-
- Lieutenant, Jr. Grade (LT JG)
- Posts: 47
- Joined: Tue Nov 11, 2008 10:47 am
- Location: Los Angeles
Re: washington state sales tax integration
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!
Any help would be great!
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: washington state sales tax integration
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.
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.
Re: washington state sales tax integration
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!!
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: washington state sales tax integration
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.
It does use the correct address once someone has a account but it seems to be sending a lot of requests to the server.
- compunerdy
- Admiral (ADM)
- Posts: 1283
- Joined: Sun Nov 18, 2007 3:55 pm
Re: washington state sales tax integration
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.
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.