As the category name suggests, BW Job Aids are intended to help you do your job. They are guides that target specific business questions commonly asked by report users. Topics addressed include finding open commitments, P-card information, Concur transaction information, etc.
Related to Finance
BW How to – View Concur Expense Activity
Expense data from the Concur Travel System has been loaded into the BUworks Business Warehouse (BW) on a daily basis since October, 2014. While there is no BW report designed specifically to display data pulled from the Concur System, this document describes how to modify an existing BW report to view Concur data.
BW How to – View Open Commitments Help Guide or Video
The document and video describe the process recommended to identify all open commitments for a Funds Center as of a specified date. Commitments associated with Purchase Orders, Internal Service Requests (ISR’s) and Facilities Service Requests (FSR’s) are considered. This solution requires access to Funds Management (FM) reports.
BW How to – View P-Card Data
This document describes how to view P-Card data in any of these detail-level reports: Transaction Detail and Transaction Detail w/ Payroll Detail in the Funds Management (Distributed) folder, and Grant Document for Expenditures in the Grants Management (Distributed) folder. Additional P-Card data, specifically cardholder name and vendor, became available in transactions posted after April 26, 2013.
BW How to – View ISR or FSR Activity
Goods or services provided by vendors internal to Boston University are procured via Internal Service Requests (ISRs) or Facilities Service Requests (FSRs). This Help Guide provides a step-by-step look at how to filter data in a report like Funds Management Transaction Detail to focus on ISR/FSR activity.
BW How to – Reconcile Accounts at Period-end
Reconciliation at the end of a period – whether it is at the end of a month or a fiscal year – requires careful examination of balances and the corresponding transactions that posted during that period. This document recommends a set of questions that should be asked and answered for any period-close. For each question, analysis steps are suggested and Funds Management Business Warehouse reports are recommended for use in the process of analyzing and answering the question.
Related to Purchasing
BW How to – View Open Commitments Help Guide or Video
The document and video describe the process recommended to identify all open commitments for a Funds Center as of a specified date. Commitments associated with Purchase Orders, Internal Service Requests (ISR’s) and Facilities Service Requests (FSR’s) are considered. This solution requires access to Funds Management (FM) reports.
Related to Labor Distribution
BW How to – Build a Split Distribution Report
This document describes the steps required to modify the Labor Distributions Payroll Inquiry by Employee (PA15) report to produce a list of employee split distributions. The PA15 report was selected for this purpose because it displays all employees in an Organizational Unit. This solution requires access to Labor Distribution (payroll) reports.
Related to Grants Management
BW How to – View Funds Reservation Numbers – FRNs
This document describes how to modify a Business Warehouse Funds Management report in order to focus on Funds Reservation Numbers (FRNs) associated with grants under examination.
BW How to – Reconcile Grants on a Monthly Basis
Use this checklist as a guide when examining grant activity with an eye toward month-end reconciliation