I am making a report for my client where show total sales for credit cards, checks, ebt etc. Can someone send me query that I can run that will show the totals for today. I need to know the table that shows the other payment types total.
*This post is locked for comments
There is already a Tender Summary report that tells you what/how was paid for.
The problem you will have in your report is what if someone pays by 2 or more Tenders? That's why there isn't one already in RMS.
The tenderentry table contains the totals for each tender id, for each batch. So i think thats the table you want to query. Join that table with tender table to get the names of each tender type. I could probably right a query if you dont get to it
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (