Page 1 of 1
Where do I find the tax field? Solved
Posted: Thu Oct 16, 2008 8:21 pm
by joebeazelman
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?
Re: Where do I find the tax field?
Posted: Thu Oct 16, 2008 9:22 pm
by AbleMods
I believe tax is a line item just as shipping and discounts are.
Look in ac_OrderItems.
Re: Where do I find the tax field?
Posted: Thu Oct 16, 2008 9:25 pm
by Shopping Cart Admin
Hello Joe,
I believe tax is a line item just as shipping and discounts are.
That is correct.
Re: Where do I find the tax field?
Posted: Fri Oct 17, 2008 6:54 am
by jmestep
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.
Re: Where do I find the tax field?
Posted: Fri Oct 17, 2008 8:19 am
by joebeazelman
Thanks. I realized that I didn't setup my taxes and didn't see it.