I am trying to get a no sale receipt to print the shift tender section of the x-report. I have got an extract of the x-report into the reciept report in the correct spot to print the cash in drawer and credit cards for the shift however they are always zero amounts, is there no access to the data when the receipt prints out?
The reason we need this is to provide clerks a way of knowing how much money is in the drawer for doing drops, we are curently just running x-reports randomly to find this out.
I tried to create an excell spread sheet to just show the cash in drawer amount, but when i connected to the database I cannot find where Report.Tender.ShiftTotal is, their is no tender under the reports table.