You’re offline. This is a read only version of the page.
*This post is locked for comments
we have an intranet we built on top of rms..
Store Sales n/t Gift_Cards Taxes Cash b/t Visa b/t Master b/t Amex b/t Debit b/t Certificates n/t Cert Exch s/t Invoices Laway P Layway Placed C Margins COGS
gives you these fields per store and total
Try Store Operations Manager, Utilities, Crystal Reports, Register Analysis Report, select Criteria tab, Date Closed, Between, enter desired date range, Add, Generate, then view/print.
If you want details by register and batch select Additional Details tab and check 'Show individual batches'.
A Z report is run daily at each register to close the batch. A ZZ report can be run periodically to sum all Z reports since ZZ was last run. The Register Analysis Report sums the Z reports for all registers.
For sales tax collected try Store Operations Manager, Reports, Sales, Sales Tax Analysis. This may differ from closed batch report since Register Analysis Report relies on date batches were closed and Sales Tax Analysis is based on transaction tables whether you closed batches or not.
TheNeos, thank you. I've played around with that and will dive into it more. Would I still need to close out or run a z/zzz report on each terminal weekly? I honestly don't care what each terminal is producing, because we are a small business, but do care about having all data on 1 screen/sheet of paper. I'd rather see numbers as a whole.
Thanks
Hello Jim,
Have you tried active reports. Go RMS Manager > reports > Detailed sales report?
This can be trimmed to give you what you need. On the date use custom to get your week, once the report view generated, select from the reports menu bar the "Show/Hide columns" and tick only "Register", "Total Sales", "Total Sales (Incl Tax)", "Tax"... and any other column you are interested.
Once you have your columns, click and drag the "Register" column as first. This will sort by register if you select Select "Columns to Group (Ctrl+G)" and use "1 column" it will sort out by register. Collapse the columns so that only totals of each group are showing.
Finally you can save as memorized ready for next use and change only the dates you need the report for.
Good Luck
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (