Hi,
We've recently downloaded the Custom_Tender_Summary_by_Cashier report from Customer Source and have found it to be most useful at the end of the day to show all of our Cash Sales and transactions. However last week one of our cashiers took payment for a sale using two different cards each to the amount of £250. On the report however this only shows up once and as a result the total amounts are incorrect and do not tally with the Z report from the till.
Looking at the SQL code for the report this appears to be happening when as a result of the UNION statement between a number of different SELECT queries but I'm having trouble getting my head around it and would appreciate any feedback/thoughts on this or if anyone else uses this report if they have come across this before?
Many thanks in advance for your time.
Nick S (UK)