Thanks for great work.
I am generating a sales report by executing an sql script against SQL server 2014.
One issue i am facing is not able to get correct sales report,
how can i detect the correct sales data once
item is sold?
item is voided?
item is cancelled?
which database table stores what - where is sold item recorded or voided/cancelled item recorded
I am using the Ticket Table and Orders table is there any other table i need to include?
How can I tell with surety that an item is NOW sold and money is received?
Could I can share the sql script i am currently using?
You help is highly appreciated.