Hey All,
We noticed this week that the canned report “Financial Transactions by Payment Type” logs Refunds as a positive value throwing off our accounting. We greatly prefer the format of this report over the Daily Cash Drawer report. I’m looking for any way to get at daily financial reports as error free as possible and wondering if anyone out there has any recommendations or ideas.
Are you hosted? Do you have an SQL access? If so, it might be a pretty quick change to flip that value.
Otherwise, you might look into SimplyReports as another option.
We are hosted, I definitely can’t download/edit any of the canned reports via SRS.
I have looked at Simply Reports but there are two issues: 1. It still reports refunds as a positive integer and 2. Patron Accounting only lets you output Transaction Types not filter by them so we’d have to modify output in excel.
It may be easiest then to take the report that you really like and just run a Get & Transform step in Excel. @jcole did a presentation on that process that is available on the forum: Get & Transform Part I & II - that would make the changes basically a one-step process.
The file could also be manipulated via python or powershell. I bet you could even put the file into the AI tool of your choice and say write me a NNN (python/powershell) script that transforms refunds from a positive number to a negative number.