Running a Tax Report question

thecornercabinetllc904

Orders that are paid online do not report the sales tax collected to our POS (Square), so the actual tax we collected versus what Square shows we owe is off. I can generate an SQL report to give me the info I need but I’m not sure which table actually stores the transactions with tax breakdown. Where would I find this?

cupnoodles

Tax values should be stored in ti_order_totals.

thecornercabinetllc904

Thanks, I wound up finding them. The screen I was on was too small and I wasn’t seeing all the tables. Now to build a report to autogenerate the info we need. Thanks for the help!