Shipping tax rate in order summary

[Noodleyman]

It would be VERY helpful to log the tax rate, and price with/without tax applied to shipping and stored against an order summary. this is helpful in case a tax rate changes over time.

Currently the only way to get the rate is to make a call to the module, and gather the tax rate, which had a dependency on the rates always remaining the same.

Having it to reference from the point of time the order was placed is valuable information.

[abrookbanks]

Awesome for debugging!! Thanks Alec... fab suggestion.

[Dirty-Butter]

AS USUAL - the problem I asked about below is my own error. It finally dawned on me I could use Notepad++ to search the db/sql file for all instances of tax. The table field was added in 6.1.14. I'm not sure I even knew how to use the setup upgrade sql manually way back then.

ALTER TABLE CubeCart_order_inventory ADD tax_percent DECIMAL(7,4 ) NOT NULL DEFAULT '0.0000' AFTER tax; #EOQ

I don't have tax in my order_inventory structure. Did I just miss a setup change somewhere along the way? Or does altering order_inventory to add the tax field need to be included in this SQL file? Since tax is not already there in mine, the sql query fails.