*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Filtering and Sorting Data in Excel File Downloads for Automated Reports - step-by-step instructions
| Click Link Below to Download Excel Report | Short Title | Description | Click Link Below to go to Source Query |
|---|---|---|---|
| daily_appr_inv_exported | This query provides the total amount of voucher lines per account number and per approval date for transactions exported to accounting. |
|
| daily_appr_inv_vendor | This query provides a list of invoices paid by vendor along with the voucher line details. |
|
|
short title
payables_inv_not_fed_notes | This query provides the total amount of voucher lines not sent to accounting (manuals) per account number with notes. |
| |
MCR120
| short title | description | MCR120
|
| yesterday_YTD_acct_bal_by_ledger_univ_acct | This report provides the year-to-date external account cash balance along with total_expenditures, initial allocation, and net allocation. | MCR132
|
| inv_appr_paid_diff_date | This query provides a list of approved invoices that have been paid at a different date. |
|
MCRXXX FYXXXX | short title | description | MCRXXX source query FYXXXX |
Next Reports:
MCR113Y - yesterday's data automated
...