Where do I find the tax field? Solved

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
joebeazelman
Lieutenant (LT)
Lieutenant (LT)
Posts: 78
Joined: Wed Mar 05, 2008 11:27 am

Where do I find the tax field? Solved

Post by joebeazelman » Thu Oct 16, 2008 8:21 pm

I am trying to export orders from AC7 to another database for further processing. Where do I find the total tax for an order? I do see a tax code but I wondering if I have to use it to calculate the tax for the order. If so, I do find this odd because it is possible for taxes to change (i.e. change in government) long after the order was placed, making the order invalid in the future. Am I thinking about this correctly?

User avatar
AbleMods
Master Yoda
Master Yoda
Posts: 5170
Joined: Wed Sep 26, 2007 5:47 am
Location: Fort Myers, Florida USA

Re: Where do I find the tax field?

Post by AbleMods » Thu Oct 16, 2008 9:22 pm

I believe tax is a line item just as shipping and discounts are.

Look in ac_OrderItems.
Joe Payne
AbleCommerce Custom Programming and Modules http://www.AbleMods.com/
AbleCommerce Hosting http://www.AbleModsHosting.com/
Precise Fishing and Hunting Time Tables http://www.Solunar.com

User avatar
Shopping Cart Admin
AbleCommerce Admin
AbleCommerce Admin
Posts: 3055
Joined: Mon Dec 01, 2003 8:41 pm
Location: Vancouver, WA
Contact:

Re: Where do I find the tax field?

Post by Shopping Cart Admin » Thu Oct 16, 2008 9:25 pm

Hello Joe,
I believe tax is a line item just as shipping and discounts are.
That is correct.
Thanks for your support

Shopping Cart Guru
AbleCommerce.com
Follow us on Facebook

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

Re: Where do I find the tax field?

Post by jmestep » Fri Oct 17, 2008 6:54 am

If so, I do find this odd because it is possible for taxes to change (i.e. change in government) long after the order was placed, making the order invalid in the future. Am I thinking about this correctly?
Since the tax amount for an order is stored in the order items table, it won't change in the future if the tax rates change. Once the order is placed, it doesn't change.
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

joebeazelman
Lieutenant (LT)
Lieutenant (LT)
Posts: 78
Joined: Wed Mar 05, 2008 11:27 am

Re: Where do I find the tax field?

Post by joebeazelman » Fri Oct 17, 2008 8:19 am

Thanks. I realized that I didn't setup my taxes and didn't see it.

Post Reply