Versions Compared

Old Version 17

changes.mady.by.user Sharon Helen Markus

Saved on

compared with

New Version 18

changes.mady.by.user Sharon Helen Markus

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Filtering and Sorting Data in Excel File Downloads for Automated Reports - step-by-step instructions


Table of Contents


Short TitleDescription
Link to Excel download of
Yesterday
yesterday's
Data
dataShort TitleDescription

Link to Source Query

to run for Current Version of Data

MCR113 





MCR113 FY2025

Excel download of yesterday's data

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. 

MCR113 FY2025

source query

MCR114 





MCR114 

Excel download of yesterday's data

short title

description
MCR113

MCR114 FY2025

source query

MCRXXX Excel Download

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. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default.

MCR132Y FY2025 

MCR132C FY2025

MCR116





MCR116 

Excel download of yesterday's data

short title

description

MCR116 


source query

MCR120





MCR120

Excel download of yesterday's data

short title

description

MCR120


source query

MCR132





MCR132Y FY2025 

Excel download of yesterday's data

MCRXXX Excel Download

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. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default.

MCR132Y FY2025 

MCR132C FY2025

MCRXXX Excel Download

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. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default.

MCR132Y FY2025 

MCR132C FY2025

MCRXXX Excel Download

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. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default.

MCR132Y FY2025 

MCR132C FY2025

MCRXXX Excel Download

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.
The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default.
 

MCR139

source query

MCR139





MCR139

Excel download of yesterday's data

short title

description

MCR139

source query

MCRXXX




MCRXXX

Excel download of yesterday's data

MCR132Y FY2025 

MCR132C FY2025

MCRXXX Excel Download

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. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default.

MCR132Y FY2025 

MCR132C FY2025

MCR132Y Excel Download

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. The fiscal year can be selected in the WHERE clause. The current fiscal year is preselected by default.

MCR132Y FY2025 

MCR132C FY2025

MCRXXX Excel Download

query_name


query description

MCRXXX

source query






Next Reports:


MCR113Y - yesterday's data automated

...

MCR139 - yesterday's data automated for this fiscal year

MCR140?