1 / 28

Monthly Endowment Report

Monthly Endowment Report. Monthly Endowment Report. First you need to pull the Master Data. Sign onto IRIS, and enter Z_FM_ZFMFINCOD - View / Download ZFMFINCODE Table , into the transaction field. Monthly Endowment Report. Monthly Endowment Report.

nara
Download Presentation

Monthly Endowment Report

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Monthly Endowment Report

  2. Monthly Endowment Report First you need to pull the Master Data. Sign onto IRIS, and enter Z_FM_ZFMFINCOD - View / Download ZFMFINCODE Table , into the transaction field

  3. Monthly Endowment Report

  4. Monthly Endowment Report Your search criteria will be pulling all Funds with a Business Area in the 3000 range. So enter that range into the Business Area Fields.

  5. Monthly Endowment Report

  6. Monthly Endowment Report

  7. Monthly Endowment Report Most of the columns displayed are not needed for this report. To select specific columns, click the “Current Display Variant” button.

  8. Monthly Endowment Report

  9. Monthly Endowment Report Select Fund, Fund Long Name, BE, College, and Department

  10. Monthly Endowment Report

  11. Monthly Endowment Report

  12. Monthly Endowment Report Download to Excel, changing column heading names as needed.

  13. Monthly Endowment Report

  14. Monthly Endowment Report For the Web search query, all blank fields in the BE, Coll, and Dept fields will need to have an asterik (*), inserted. This can be done with a Find/Replace.

  15. Monthly Endowment Report

  16. Monthly Endowment Report

  17. Monthly Endowment Report Repeat this same process to pull all UT Foundation Funds. Use Business Area as the search criteria, and this time use the 7000 series.

  18. Monthly Endowment Report

  19. Monthly Endowment Report

  20. Monthly Endowment Report Copy and paste this to the bottom of the previous master data spreadsheet. This should be all master data.

  21. Monthly Endowment Report The spreadsheet is now ready for Treasury Office personnel to use to add the financial data (not handled by the Controller’s office).

  22. Monthly Endowment Report

  23. Monthly Endowment Report There are now 2 spreadsheets that need to be taken into Access. One with Master Data, and one with the Financial Data provided by the Treasurer’s Office. The master Access query is located at I:/Shared/Pam/endowcurr

  24. Monthly Endowment Report

  25. Monthly Endowment Report Upload the appropriate Excel spreadsheet into the appropriate Access table, and run the ENDRPT query. Export the ENDRPT query back to Excel, and this spreadsheet will be ready to upload to the Web.

  26. Monthly Endowment Report

  27. Monthly Endowment Report

  28. THE END!!!!!

More Related