DexReports: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
==== To Create the Morning Credit Card Report ==== | ==== To Create the Morning Credit Card Report ==== | ||
This procedure can only be run at any circ desk computer | |||
*On the Transactions page, click the Received box. | *On the Transactions page, click the Received box. | ||
*You will need to choose the date range for reports. Since you only create reports for a single day, you'll need to click your desired date twice - once to indicate the first day of date range, and then to indicate the last day of the date range. | *You will need to choose the date range for reports. Since you only create reports for a single day, you'll need to click your desired date twice - once to indicate the first day of date range, and then to indicate the last day of the date range. | ||
| Line 26: | Line 27: | ||
*Ensure the selected cell is A1, then paste using Ctrl- | *Ensure the selected cell is A1, then paste using Ctrl-V | ||
[[file:FortePaste.png]] | [[file:FortePaste.png]] | ||
Latest revision as of 06:59, 20 October 2022
To Create the Morning Credit Card Report
This procedure can only be run at any circ desk computer
- On the Transactions page, click the Received box.
- You will need to choose the date range for reports. Since you only create reports for a single day, you'll need to click your desired date twice - once to indicate the first day of date range, and then to indicate the last day of the date range.
- Click Apply
- Click the Download icon, located at top right
- The file will download to the Downloads folder of your computer.
- Use File Explorer to navigate to Downloads.
- Find the .csv with date and time of "now"
- Double-click - it will open in Excel
- Select all in the transactions file using Ctrl-A
- Copy by using Ctrl-C
- Find and open the ForteDailyCreditCard shortcut on the desktop.
- Ensure the selected cell is A1, then paste using Ctrl-V
- Run the macro using Ctrl-M, then print!
- Unsuccessful transactions, such as Voids or Declines, will be listed but not included in the calculated total amount.
