Custom_Tender_Summary_by_Cashier Report with multiple tenders

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)

Reply to
Nick S
Loading thread data ...

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)

Reply to
Todd Berger [MSFT]

Thanks Todd,

I've reported the issue through Customer Source

Regards

Nick

"Todd Berger [MSFT]" wrote:

Reply to
Nick S

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.