Hi,
One of our clients wants a detailed sales report that shows the tender type used by their customers. So I modified the detailed sales active report and linked the TenderEntry table. My problem is some of the customers uses multiple tenders to pay per transaction. Ex. Items 1 & 2 were paid with Cash and Creditcard.
Item 1 100.00 Cash 100.00 CreditCard 100.00
Item 2 100.00 Cash 100.00 CreditCard 100.00
Overall Total will appear as 400.00 in the report instead of 200.00
Any ideas how to modify the active report?
Thanks.
Rodney