Good Morning
Part of the mall policy that im in. is to have access to my DB , and only view one table that show only
ticket number
total price
total price with tax
i found Db.payments and Db.tickets… i cant see Tax anywhere… ?? even though i have tax properly installed…
please advise … Thank You So much
You should use reports for that. Look up custom reports for more info.
the mall management they use SSMS to connect they don’t use samba. so it must be a table ?!
Thank You 
Tax is an Order-level calculation. Look in the [Orders] table to see the Tax Template used for the order.
It will also depend on your configuration; that is, whether or not you have Tax included in the Price.
Actual Transaction values are in [AccountTransactionValues].
To get the information you want, in the format you want, you will need to join several tables.
If they use SSMS, ytou could set up a snapshot in SQL, so every time they access the snapshot they will have actual data,in raw format, but the most important READ ONLY…
https://technet.microsoft.com/en-us/library/ms187054(v=sql.105).aspx
this would be a nice start…
I have heard that some malls use this technique since they charge a % of sales…
Thanks!!!
G.
awesome Thak You So much
i will give a shot , thank you so much