Financial Data Model Crosswalks updated

The following three (3) crosswalks and one (1) job aid listing has been updated on the Tools page as of September 1st, 2015.

  • FRS Department to Workday Cost Center Crosswalk
  • FRS Account to UR Financials FAO Crosswalk
  • FRS Subcode to Workday Worktags Crosswalk
  • UR Financials Ledger Accounts, Spend & Revenue Category Listing (JOB-AID)

These crosswalks are used for FAO, Worktag, Ledger Accounts and Spend / Revenue Category reference. Each have their own guidance and disclaimers as noted on the Tools page.

Sign Up for August’s User Group Meeting

Sign up for this month’s UR Financials User Group meeting.
August’s meeting will begin with announcements, followed by updates on Reporting Workshop results, Training strategy and Workday 25 new user interface. Spotlight topic will be on Accounts Payable.

There are still open seats left! Please sign up for an option of your choice:

Meeting date/time:
August 19th
from 1:30 – 2:30 PM.

Locations: 

  • In person participation
    Medical Center:  School of Nursing, Loretta C. Ford Education Wing, 1W502 Classroom
    (directions – at bottom of linked page)
  • Remote participation
    WebEx
    participants click hereand enter your name and e-mail if prompted.
    Meeting password is: Workday24

Conference call information:
Dial in: 1-888-330-3581Access Code: 6534022

Presentation materials will be posted on Resource>User Group page.

Workday New User Interface Launches August 17th

On August 17th, UR Financials (Workday) will have an updated user interface and landing page as announced in previous User Group meetings. No longer will users see the My Workday 2.0 page after log in, but will instead land on a Home page with a new look and feel.

Listed below are Workday user interface highlights for August 17th:

  • Workday landing page will now be the Home page
  • Worklets will still be available, but will display as round icons. Each worklet will be represented as a different image. Select the image icon to see Worklet report listings

WD 24 Home page simplier


  • Announcements may be created and will display within the Announcements worklet.  These may be color coded based on message content and timing.  Select the individual announcement to read message details.wd24 announcements

TIP: The Announcements worklet itself does not contain any visual indicator when a message has been added, removed, or updated to the list.  Open this worklet often to see new messages added, removed, or updated regarding UR Financials.


  •  Grants Management Reports worklet, Common Financial Reports worklet and Capital Project Reports worklet will all be located within the Financial Reports worklet icon
    • Within each sub-worklet, reports list will still display

wd24 worklet


  • New navigation using a built in back button WD24 Back Nav will return users to the Home page after selecting a worklet icon.

 

More user interface changes are scheduled for Workday’s next release, coming this September and will be announced here.

For questions on these changes, Contact Us, or
UnivIT: (585) 275-2000 or email: UnivITHelp@ur.rochester.edu
URMC: (585) 275-3200 or email: HelpDesk_ISD@urmc. rochester.edu

Join Us – User Group Meeting on August 19th

Please join us for this month’s UR Financials User Group meeting.
This group has been created to inform, discuss, and share UR Financials practice with one another for continued learning and support.  August’s meeting will begin with announcements, followed by updates on Reporting Workshop results, Training strategy and Workday 25 new user interface. Spotlight topic will be on Accounts Payable.

Meeting date/time:
August 19th from 1:30 – 2:30 PM.
Sign-up to participate in person, or remotely.

Locations: 

  • In person participation
    Medical Center:  School of Nursing, Loretta C. Ford Education Wing, 1W502 Classroom
    (directions – at bottom of linked page)
  • Remote participation
    WebEx
    participants click hereand enter your name and e-mail if prompted.
    Meeting password is: Workday24

Conference call information:
Dial in: 1-888-330-3581Access Code: 6534022

Meeting agenda is posted below:

  • Project Announcement and Accomplishments
  • Reporting Workshop Summary
  • Training Strategy
  • UR Financials Functionality Enhancements
  • Accounts Payable
  • Upcoming Events

Presentation materials will be accessible through this link.

User Alert: Report Excel and Print Icons issue – Workaround

The Excel, View More and Print icons missing on Reports issue has been resolved by Workday. At this time these icons are visible and active.

If you currently cannot see these icons, you may need to clear your browser cache, add the Workday Home page to Internet Explorer browser Trusted Sites and restart your browser.  Steps on how to clear your browser cache can be found below.

How to Add Workday to Internet Explorer Trusted Sites

  1. Open the Internet Explorer browser and log into the UR Financials system.
  2. In Internet Explorer, click Tools (Gear icon in upper right corner), click Internet Options, and then click the Security tab.
  3. In the Select a Web content zone to specify its current security settings box, click Trusted Sites, and then click the Sites button.
  4. In the  Add this Web site to the zone box, click Add to add the UR Financials web page currently on
  5. Click Close, then OK to accept the changes and return to Internet Explorer

How to Clear Browser Cache

  1. In most browsers, press Ctrl+Shift+Del ,or Ctrl+Shift+Fn+Del, or Command+Shift+Del (Mac) to show the cookies/history/cache deletion popup.
  2. From the Delete Browsing History pop up window, deselect Preserve Favorites website data, and select:
    • Temporary Internet files or Temporary Internet files and website files
    • Cookies or Cookies and website data
    • History
  3. Click Delete, then click OK
  4. Exit all browser windows and re-open the browser

 

Sign Up for User Group Meeting

Sign up for this month’s UR Financials User Group meeting.
We will start the meeting with announcements, followed by a discussion on UR Financials Integrations and Year-End Close updates.

There are still open seats left! Please sign up for an option of your choice:

Time:
Wednesday, July 15th from 1:30PM – 2:30PM

Location – In Person:
Held at the Medical Center: Room 2-7544 (select the second floor CEL Department Map)

WebEx:
For those partaking in this meeting via WebExclick here and enter your name and e-mail if prompted. The meeting password is: Workday24
Conference call info is included below:
Dial in: 1-888-330-3581Access Code: 6534022

Presentation materials will be posted on the Resource>User Group page.

Join Us – User Group Meeting on July 15th

Please join us for this month’s UR Financials User Group meeting.  This group has been created to inform, discuss, and share UR Financials practice with one another for continued learning and support.  July’s meeting will focus on the UR Financials Integrations Process with Year-End Close updates.

Meeting date/time:
July 15th from 1:30 – 2:30 PM.
Please, sign-up to participate in person, or remotely.

Location: 
Medical Center: room 2-7544 (second floor CEL Department Map) and WebEx
WebEx participants click hereand enter your name and e-mail if prompted.
Meeting password is: Workday24

Conference call information:
Dial in: 1-888-330-3581Access Code: 6534022

Meeting agenda is posted below:

  • Project Announcement and Accomplishments
  • Integrations discussion
  • Financial Close Update
  • UR Financials Functionality Enhancements
  • Upcoming Events

Presentation materials will be accessible through this link.

Grants Management Enhancements – Facilities & Administration (F&A) and Revenue Recognition

A Grants Management enhancement has been implemented in UR Financials effective July 1, 2015. Facilities and Administration Expense and Revenue Recognition journals will be created at the time the direct expenditure is recorded on Supplier Invoices and Supplier Invoice Adjustments to more accurately match revenue with expense in the accounting period in which the transaction occurs regardless of when settlement occurs.

Please note transactions will be handled differently as follows: 

Supplier Invoices and Supplier Invoice Adjustments Dated prior than 7/1/2015 (Current Process)

  • Supplier Invoices and Supplier Invoice Adjustments do not recognize Facilities and Administration (F&A) Expense and Revenue at the time the direct expense is recorded
  • F&A Expense and Revenue Recognition occur at the time of payment for expenditures (known as settlement, when a check is cut to pay the Supplier)
  • Supplier Invoices and Supplier Invoice Adjustments dated prior to 7/1/2015 will continue under this process and not process under the new enhancement, meaning F&A and Revenue will continue to be recognized at settlement
    • In the very near future, an enhancement will be delivered to change the processing of F&A and Revenue Recognition for new transactions with document dates prior to 7/1/2015. A separate communication will be sent once this functionality is released.
  • Supplier Invoices and Supplier Invoice Adjustments “in process” prior to 7/1/2015 will continue under this current process and not process under the new enhancement, meaning F&A and Revenue will continue to be recognized at settlement
  • These transactions are not Billable until settlement is complete

Supplier Invoices and Supplier Invoice Adjustments Dated 7/1/2015 and later (Enhancement)

  • Supplier Invoices and Supplier Invoice Adjustments will have F&A and Revenue journals created at the time the direct expenditure is recorded to more accurately match revenue with expense in the accounting period in which the transaction occurs, regardless of when payment is made
  • For new transactions, F&A and Revenue Recognition will occur at the time of Business Process (BP) completion (data entry and approval of supplier invoice/adjustment, if needed)
  • These transactions are not Billable until settlement is complete (no change to existing process)

For questions on this, please feel free to contact your Staff Accountant in ORACS or Terry Messenger.

End of Fiscal Year and Reporting

Today is the first day of our Fiscal Year. Please note that UR Financials reports that default to the current fiscal year will now show FY2016. 
end of year FY change 

Remember:  If you need to run reports for the previous fiscal year, type in FY2015 in the Year prompt field. 

 

UR Financials Reports Utilizing Ledger Account – Now Operational

The Ledger Account issues experienced yesterday in UR Financials Production system has been RESOLVED.
Users can now successfully filter and run the following reports listed below. 

Affected reports with prompt issue (may not be limited to):

  1. FAO Budgetary Balance Summary – Monthly Ledger URF0945
  2. FAO Budgetary Balance Summary – Monthly Ledger (NCL) URF0902
  3. FAO Budgetary Balance Summary – Monthly Ledger Printable URF0940
  4. FAO Budgetary Balance Summary – Monthly Ledger Printable (NCL) URF0941
  5. FAO Summary of Funds URF0964
  6. FAO Summary of Funds (NCL) URF0965
  7. FAO Summary of Funds (NCL) URF0965B

Affected reports with behind-the-scenes filtering:

  1. Award Line Summary of Funds (NCL) URF0983
  2. All Project LTD reports.

Please contact us with any questions.

UR Financials Planned Outage tonight at 11:00 PM EST

The UR Financials systems (Sandbox and Production) will be unavailable this evening, June 29th, at 11:00 PM while fixes are being applied by Workday.  Service should be back online at 2:00AM on June 30th.

As a precautionary measure, system monitoring will take place to verify overnight integration have not been impacted.

 

User Alert: UR Financials Reports Utilizing Ledger Account – Currently Nonoperational

The Ledger Account object is not working presently in certain UR Financials scenarios listed below. 

Scenarios include:

  • Filtering Reports – “No Items” will show when searching for Ledger Accounts in the Ledger Account (Exclude prompt). See a partial list of impacted reports below.
  • Running Reports – User receives the error “The entered information does not meet the restrictions defined for this field (Ledger Account for CRF)” when running a report that filters on ledger account behind the scenes.

ledger account error msg 062915

Affected reports with prompt include, but may not be limited to:

  1. FAO Budgetary Balance Summary – Monthly Ledger URF0945
  2. FAO Budgetary Balance Summary – Monthly Ledger (NCL) URF0902
  3. FAO Budgetary Balance Summary – Monthly Ledger Printable URF0940
  4. FAO Budgetary Balance Summary – Monthly Ledger Printable (NCL) URF0941
  5. FAO Summary of Funds URF0964
  6. FAO Summary of Funds (NCL) URF0965
  7. FAO Summary of Funds (NCL) URF0965B

Affected reports with behind-the-scenes filtering but not prompt:

  1. Award Line Summary of Funds (NCL) URF0983
  2. All Project LTD reports

A Workday case has been opened to resolve this issue.  They have estimated this to be resolved by July 4th.  Once this defect is resolved, it will be announced on the UR Financials site and emailed to users.


Please note: The Spend Category (Exclude) filter is operational and is listed on the monthly ledger reports.  This can be used to remove allocations from your report results.

To view your monthly ledgers, with allocations removed, follow these simple steps:

  1. Locate your monthly ledger report in UR Financials
  2. Select your required prompts, as normal
  3. In the Spend Category (Exclude) prompt, select all the spend category allocations to remove from the report results
    1. Click the prompt icon for Spend Category (Exclude)
    2. Type allocationsin the prompt search window
    3. To quickly select all allocations listed, scroll to the bottom of the list, then hold the SHIFT key and left-click on the last value
      exclude allocations
  4. Run report

A follow-up message will be posted when this issue is resolved.  In the interim, if you have any questions on this issue, please contact us.

 

 

 

Common Financial Reports Simplified

Five months of using the UR Financials system has illuminated how to refine reports and implement additional features making them easier to use. This Summer we continue reporting improvement efforts through a series of reporting enhancement design sessions.  These will be conducted with a select focus group dedicated to improving UR Financials reports.

Reporting modifications and simplified report retrieval structures (Worklets) approved from these sessions will be communicated to all users every 1-2 weeks within the UR Financials Newsletter. Once reports are finalized, training materials will be updated to reflect approved enhancements.

For more on the progress of this effort, information will continue to be provided in upcoming User Group meetings held the third Wednesday of every month.  The next User Group meeting will be held on July 15th.  More details will be published soon on how to participate.

2015 Fiscal Year-End Finance Announcements

There has been an update to the 2015 Fiscal Year-End Finance Schedule.  Please see change highlighted inline below.
______________________________________________________

As the University’s fiscal year end approaches for June 30, 2015, there are special timing considerations and actions required on your part in order to ensure that all financial transactions are recorded properly and in the current fiscal year.

FORMS:

Request for Payment (F-4) and Student Expense Report for University Business (F-34) must be received in Accounts Payable no later than 4PM on Friday, June 12, 2015. Please send to Accounts Payable, RC Box 278958.

Payroll Reallocation Changes – Requests for payroll reallocation changes on Form 800 should be received no later than 4PM on Friday, June 12, 2015. Please send your materials to Laura Bardossi, Box PERC.

Employee Expense Reports (F-3) – must be received in Accounts Payable no later than 4PM on Tuesday, June 23, 2015. Please send to Accounts Payable, RC Box 278958.

All journal entry forms and 312 requisitions (non-purchasing) due in divisional office / central finance by 4PM on Wednesday, July 1, 2015

REPORTS:

Preliminary reports available on the morning of Thursday, July 9, 2015

Final reports available at 12:00 noon on Wednesday, July 15, 2015

NOTE: If you should have any questions, or need further clarification:

  • Fiscal year end closing, please contact Karen Lombard-Bryce (5-8350).
  • Request for Payments & Employee Expense Reports, please contact Marta Herman (5-7880).
  • Payroll Reallocations should be directed to Laura Bardossi (5-7027).