May 2007

previous issue

back issues

index by topic

e-News home

Contact us at: admin_systems_enews@harvard.edu or via the UIS Helpdesk at 6-2001

The Administrative Systems e-News is a monthly electronic newsletter
for users of Harvard's financial, human resources, and reporting systems.


Special Issue:
FY2007 Year-End Closing Deadlines

Click the links below to learn more about ...

Schedule announced for FY2007 financial closings
Fiscal year-end reporting guidance and tips
Summary schedule for FY07 transactions and reporting
Whom to call list for closings
Notice of Change in the Posting Date of the July 6, 2007 Bi-weekly and Weekly Payrolls
CREW Sponsored Report Enhancements released on April 22
Departmental-Action Report and Job Group Movement Analysis replaces Personnel Action History report
New Desktop Standards issued
About the e-News

Schedule announced for FY2007 financial closings      top

Overview

Harvard's fiscal year 2007 will end on Friday, June 29. As in the past, we will close the books through a series of steps called "closings."

Please note this year's closing dates:

The first closing will take place on Friday, July 6
The second closing on Friday, July 13
The third closing on Friday, July 20

In the paragraphs that follow, you will find closing deadlines and submission information for the following financial transactions (click on a transaction to jump to that section of the e-News):

NOTE: There is an important change in the journal entries deadlines this year.  In order to allow the tubs more time to process manual journal entries on the day of the closings, the deadline time has been moved to 11 a.m. from 9 a.m.  Therefore, any journals entered into the General Ledger by 11 a.m. on the Friday of the close will be included in that close and will be available in the HDW the next day.

In addition, in order to provide the tubs with more timely information during the FY2007 year end, there will be two additional data refreshes to the Data Warehouse (HDW) on Sunday night, July 8 after the first close and on Sunday night, July 16 after the second close. This means that June journals entered after the 11 a.m. deadline on the Friday of the close and before 6:30 p.m. on Sunday night will be posted and reflected in CREW on Monday morning. Note that there will not be a data refresh on Sunday, July 22nd after the third close. Any regular invoice batches and invoice imports that have been processed by the Accounts Payable department from Friday to Sunday after the first and second closes will also be uploaded on Sunday evening and reflected in CREW on Monday morning. For more information on this topic, please go to the June 2007 eNews issue at http://vpf-web.harvard.edu/training/enews/html/2007-06.html.

The deadlines provided are the last allowable dates to submit transactions.

These are the FAD (Central Financial Administration) deadlines. Since some departments have internal deadlines that may be earlier than these, you should check with your local financial office to obtain any departmentally defined deadlines.

Reporting tips are also included in this e-News. We expect exceptional reporting demands during the year-end closings. Following our suggestions on reporting will reduce the time required to run your reports.

Transaction Type
Closing Deadlines and Submission Information

Accounts Payable Web Vouchers

A mail drop-off box will be located in Room 744 in Holyoke Center. Any items received at 1033 Mass. Ave. or deposited into the drop-off box by the deadlines listed below will be processed for FY2007.

All invoices received by the Accounts Payable office either at 1033 Mass. Ave. or at the drop-off box in Room 744 in Holyoke Center by 5 p.m. on Friday, June 29 (with the exception of special handling requests; see note below) will be processed in FY2007, assuming they have already been entered and approved in the Web Voucher system. A significant exception relates to foreign currency drafts and wires and US wire transfers (see the Foreign currency drafts and wires and the U.S. wire transfers sections for these earlier deadlines).

Invoices received between Saturday, June 30 and Friday, July 13 at 5 p.m. will be processed as part of FY2007 if PROCESS FOR JUNE 2007 is written on each invoice to be processed or there is a cover sheet clearly marked JUNE 2007 INVOICES on any batch of invoices.  Green FY07 stickers that can be placed on each invoice have been provided to the Tub Financial Offices.

Any invoices received between June 30 and July 13 that are not clearly marked with PROCESS FOR JUNE 2007 or that do not have a cover sheet indicating JUNE 2007 INVOICES will be processed as July 2007 (that is, FY2008) invoices.  Pink FY08 stickers that can be placed on each invoice have been provided to the Tub Financial Offices.

Please note that if you are submitting an invoice between Saturday, June 30 and Friday, July 13 for goods or services received in FY2007, you should request that the invoice be processed in JUNE 2007, and not in July, consistent with Generally Accepted Accounting Principles.  The availability of budget monies should not be a consideration in determining which fiscal year to process the invoice.

If you purchase items late in the fiscal year that you want charged in FY2007, be sure to request immediate billing from vendors so that you can meet these deadlines.

Special handling requests that need to be expensed in FY2007 must be received at 1033 Massachusetts Avenue, 2nd Floor by 12 noon on Friday, June 29.

Special handling requests received after 12 noon on June 29 cannot be expensed to FY2007.  If the special handling request is for an FY2007 expense you will need to accrue the item.

Petty cash fund settlement

If you maintain a departmental petty cash fund, you must submit your petty cash log for reimbursement to Accounts Payable either at 1033 Mass. Ave. or at the drop-off box in Room 744 in Holyoke Center by 5 p.m. on Friday, June 29 if you want the charges to be included in FY2007.

New vendor setup

For new vendors that need to be set up or for changes to current vendors, the approved vendor setup form must be received in Vendor Setup either at 1033 Mass. Ave. or at the drop-off box in Room 744 in Holyoke Center by 5 p.m. on Wednesday, July 11.

Credit vouchers (cash receipts)

The Cash Receipts Office, Holyoke 953, will accept credit vouchers accompanied by cash or checks until 5 p.m. on Friday, June 29.

Credit vouchers (validated deposit slips)

The Cash Receipts Office, Holyoke 953, will accept credit vouchers accompanied by a validated deposit slip until 5 p.m. on Friday, June 29.

Massachusetts taxable sales deposits

All Massachusetts Taxable Sales forms with a validated bank deposit ticket for deposits made in May through Friday, June 22 must be delivered to Cash Receipts, Holyoke 953, by 5 p.m. Monday, June 25.

In order to allow for sufficient processing time in FY2007, the paperwork for all deposits made from June 23 through June 28 must be delivered on a daily basis to Cash Receipts. Deposit forms and validated bank deposit tickets for deposits made on June 29 must be delivered to Cash Receipts by 12 p.m. on Monday, July 2 in order to recognize the income in FY2007.

Foreign check deposits on credit vouchers

Credit vouchers accompanied by foreign checks that need to be sent to the bank for collection should be submitted to the Cash Receipts Office, Holyoke 953, by 5 p.m. Friday, June 1. Because each bank and country's collection times and processes are different, we cannot guarantee that we will receive credit from the bank for these checks before June 30.

The University has an agreement with Bank of America to receive provisional credit on most common foreign currencies, and the June 1 deadline may be your best opportunity to collect these funds and recognize the income in FY2007. Cash Receipts will continue to deposit all foreign currency checks throughout the month as they are received but cannot guarantee collection for this fiscal year. It is extremely important that you deposit these checks with Cash Receipts immediately upon receiving them.

Voided checks

All checks that need to be voided and re-deposited must be received by Cash Management, Holyoke 451, by 5 p.m. Wednesday, June 27 in order for the credit to be included in FY2007.

Stopped checks

All checks that need to be stopped and re-deposited must be received by Cash Management, Holyoke 451, by 5 p.m. Wednesday, June 27 in order for the credit to be included in FY2007.

Escheat checks

All checks that need to be re-deposited must be received by Cash Management, Holyoke 451, by 5 p.m. on Wednesday, June 27 in order for the credit to be included in FY2007.

Foreign currency drafts and wires

 

Cash Management will process one last batch of foreign currency drafts and wires on Wednesday, June 27. The majority of these items should be value dated for June 30. These expenses will be included in FY2007. Web Voucher payments to be made in a foreign currency must be entered and approved online and the related invoices received by Cash Management, Holyoke 451, no later than Tuesday, June 26 at 5 p.m. Note: These invoices must have a bank draft authorization form or a wire transfer authorization form attached to the front of the invoice.

U.S. wire transfers

Web voucher payments to be wire transferred must be entered and approved online in the Web Voucher system with related invoices received by Accounts Payable, 1033 Mass Avenue, no later than Friday, June 29 at 10 a.m. Note: These invoices must have a wire transfer authorization form attached to the front of the invoice.

ACH payments
(Benefits/Tax)

Web Voucher payments via ACH must be entered and approved online in the Web Voucher system with related invoices received by Cash Management, Holyoke 451, no later than Thursday, June 28 at 1 p.m.  Note:  These invoices must have an ACH transfer authorization form attached to the front of the invoice.

Purchasing Card sweeps

In order to ensure that as many current PCard transactions as possible are swept in this fiscal year, the PCard sweeps originally scheduled for June 28, July 5, and July 12 will all be moved.

  • The originally scheduled June 28 sweep will be moved to Wednesday, June 27 at 5 p.m. This sweep will contain PCard transactions loaded into the settlement system between June 8 and June 14. The sweep date will change in the settlement system on June 18.
  • The originally scheduled July 5 sweep will be moved to Thursday, June 28 at 5 p.m. This sweep will contain PCard transactions loaded into the settlement system between June 15 and June 21. The sweep date will change in the settlement system on June 25.
  • The originally scheduled July 12 sweep will be moved to Thursday, July 5 at 3 p.m. This sweep will be booked into FY2007 and contain PCard transactions loaded into the settlement system between June 22 and June 28. The sweep date will change in the settlement system on July 2.
Please note that there is no way to determine a final day on which users can make PCard purchases and assure that those transactions will be swept in this fiscal year, since timing is dependent on vendors and other factors.

Web Voucher Travel Authorization Forms (WV-TAFs)

WV-TAFs must be approved and ticketed by 5 p.m. on Friday, June 29 to be included in FY2007.

Web Voucher Reimbursement reports

Web Voucher Reimbursement reports that require a tax review must reach the Travel and Reimbursement Office at 1033 Massachusetts Avenue or the drop-off box at Room 744 in Holyoke Center by 5 p.m. on Friday, July 6.

Note: If you are submitting a reimbursement report that requires a tax review between Monday, July 2 and Friday, July 6 that should be included in FY2007, clearly mark the report PROCESS FOR FY2007.

Web Voucher Reimbursement reports that do not require tax pre-audit will be accepted either at 1033 Mass. Ave. or at the drop-off box in Room 744 in Holyoke Center until 5 p.m. on Wednesday, July 11.

Note that if you are submitting a report between Monday, July 2 and Wednesday, July 11 for reimbursements to be included in FY2007, you should clearly mark the report PROCESS FOR JUNE 2007.

If there is no indication on the voucher as to which month the report should be processed in (June or July), the report will be processed in July.

Web Voucher Reimbursement reports with advance settlements

Web Voucher Reimbursement reports with advance settlements, when accompanied by unused funds (checks), will be accepted by the Travel and Reimbursement Office at 1033 Mass. Ave. or the drop-off box in Room 744 Holyoke Center until 5 p.m. on Tuesday, June 26.

Advance settlements for zero balance or amounts due to the traveler will be accepted at either location until 5 p.m. on Wednesday, July 11.

Central Accounts Receivable billing

Central Accounts Receivable will close FY2007 on Wednesday, July 11 at 5 p.m.

AR feeds to be included in FY2007 need to be entered into the Oracle AR system by 5 p.m. on Wednesday, July 11. Invoices and credit memos processed by the tubs can be entered into the AR system until 5 p.m. on Wednesday, July 11.

From July 1 to July 11, the GL date in Oracle AR will automatically default to the July date. In order for transactions to be included in FY2007 during this time, users will have to enter the date of June 30, 2007 to override the default date. This process applies to invoices and credit memos entered both manually and via feeds.

Please note that receivables for goods or services provided in FY2007 should be entered in the period of JUNE 2007, and not July, consistent with Generally Accepted Accounting Principles.

Central AR will accept invoice and credit memo templates that AR enters on behalf of local units until 5 p.m. on Friday, July 6.

As a reminder, the AR department will process invoices and credit memos for those units that process fewer than 10 invoices per month. Areas that process more than this number per month are responsible for entering the invoices and credit memos themselves.



Journal Entries

Closing
Journal Data Entry Deadline
GL Feed Deadline
First
Friday, July 6, 11 a.m.
Thursday, July 5, 4 p.m.
Second
Friday, July 13, 11 a.m.
Thursday, July 12, 4 p.m.
Third
Friday, July 20, 11 a.m.
Thursday, July 19, 4 p.m.
Daily input deadline: Monday - Thursday, 6:30 p.m.

Note the change this year in the journal data entry deadline time for each of the closes to 11 a.m.  Historically this time had been 9 a.m.  Any journals entered by 11 a.m. on the Friday of the close will be processed in that close and will be available in the HDW on Saturday.

Please keep in mind the following:

  • The University is closed on Wednesday, July 4 for the holiday. Therefore, there will be no journal vouchers posted to the General Ledger or recorded in the Data Warehouse on that day. Thus, any journals entered in the system after 6:30 p.m. on Tuesday, July 3 until 6:30 p.m. on Thursday, July 5 will be posted to the General Ledger on Thursday, July 5 and available in the Data Warehouse on Friday, July 6.

  • For the first, second and third closings, from Monday through Thursday, any feeds or manual journals for the month of June will be posted to the General Ledger at 6:30 p.m. Therefore, journals must be entered by 6:30 p.m. in order to be posted and recorded in the Data Warehouse for the next day. (The one exception is July 4, when the University is closed.)

  • Note that any June journals entered on Friday after 11 a.m. during the first and second closings will not be posted until the following Monday at 6:30 p.m. and will be in the Data Warehouse on Tuesday. Any June journals entered after Friday, July 21 at 11 a.m. will be deleted.

  • Be careful to select the proper period (JUN-07 or JUL-07) when you are entering a journal. Beginning July 1, the default period will be JUL-07. If you want to post a journal to FY2007 during July 2007 you will need to select JUN-07 as the proper period.

  • Entries must not be processed to another tub after the second closing without authorization from the financial office of the tub being charged. Individuals processing journals have personal responsibility to ensure they follow this requirement.

  • A journal should only be reversed by the person who created the journal, or with the permission of that person.

  • Based upon departmental activity and the reports you run through the month of May, please make any necessary adjustments as early in June as possible.

Interdepartmental billings

  • All interdepartmental billings – whether entered manually or via a feed to the General Ledger – must be processed by the end of the second closing. (GL billing feeds are generally submitted by service centers like UIS and UOS.) An interdepartmental billing journal may be processed in the third closing only if permission has been obtained from the financial office of the tub being charged.

  • An interdepartmental billing should only be reversed by the person who created the entry, or with the permission of that person. Interdepartmental billings should provide a name and contact number on the journal for questions or concerns the tub being billed may have.

Cost transfer requests

Closing
Submission Deadline to OSP
First
Tuesday, July 3, 10 a.m.
Second
Tuesday, July 10, 10 a.m.
Third
Tuesday, July 17, 10 a.m.
  • These dates apply to ALL requests for cost transfers to federally sponsored funds (funds in the range from 100000-199999). Note that these requests may require supporting documentation.

  • Cost transfer requests should be submitted directly to OSP. OSP will review the request and any necessary documentation for appropriateness. OSP will then enter the cost transfer journals into the General Ledger. Note that OSP only enters cost transfer journals during the year-end closing process; during the fiscal year, these transfers are entered directly by the tubs.


Chart of Accounts maintenance requests

Disable Requests:
June 7 (MAY-07 close) is the last date that values will be disabled in FY2007. Any CSMA requests not successfully disabled on June 7 will be held until the JUL-07 close on Wednesday, August 8.

Requests to disable CoA values that require approval should be submitted through CSMA before 5 p.m. on Thursday, May 24. Disable requests that do not require approval should be submitted through CSMA before 10 a.m. on Thursday, June 7.

Add / Modify / Re-enable Requests:
Requests to add, modify, or re-enable CoA values submitted through CSMA will be processed according to the normal daily schedule (7 a.m. - 5 p.m., Monday - Friday) throughout year-end. CSMA requestors wishing to specifically designate for the JUN-07 period any CoA changes entered from July 1 through August 8 (the date of the July close) should enter 30-JUN-2007 as the effective date for their request.

Fiscal year-end reporting guidance and tips      top

The Financials FY07 Year End web page for standard and ad hoc reporting provides detailed information on the fiscal year-end close and illustrates how to use the Common Reporting Environment for the Warehouse (CREW) reporting features to automate and organize year-end reporting.

The FY07 Reporting web page will show you how to use the Detail Listing close period dates to capture results from each close. By grouping these reports together and scheduling the group to run after each close, you can streamline the steps you need to take to run your reports, as well as ensure that the majority of year-end reports run overnight, reducing traffic to allow more system bandwidth during normal business hours.

Fiscal Year 2007
Close Dates

Detail Listing Report Periods:
Show Transactions “Between Dates”

CREW Scheduled
YE Closes "Event"
Kick-off Date

First Close

Fiscal June entries from June 1 through July 6

Saturday, July 7

Second Close

Fiscal June entries from July 7 through July 13

Saturday, July 14

Third Close

Fiscal June entries from July 14 through July 20

Saturday, July 21

Fourth Close

Fiscal June entries from July 21 through July 26

Friday, July 27

Fifth Close

Fiscal June entries from July 27 through August 3

Saturday, August 4

Every year-end we experience exceptional reporting demands during the closings. Following these suggestions on reporting will reduce the time required to run your reports.

  • Use the Detail Listings “close” dates to limit to the specific transactions that occurred in each close. Choose the specific close (First Close, Second Close, etc.) from the report period pick list. Note that the start and end dates populated for these periods will display July dates. For these closing periods only, these dates refer to the actual entry dates of fiscal month June entries. We strongly recommend that you take advantage of using the close dates to narrow the scope of your data rather than capturing all of the Prior Fiscal Year data throughout the close periods.


  • IMPORTANT NOTE: Fiscal Year 2006 close dates will be displayed in the Detail Listings report period names until July 1. On July 1, these dates automatically update to the FY2007 dates. This does NOT preclude setting up and scheduling reports in advance. The FY2007 dates will automatically repopulate all scheduled reports.


  • Schedule your closing reports to run on the Year-End “Event” dates.


  • Enter all of the chart segment parameters you can for a given report request to increase performance for yourself and the whole University. Never use your security view to filter your data. For example, let's say a user wants to see amounts for a range of objects within the tub and org for which they have a view. Because of their view limitation, the user will get the same result whether tub and org are entered as parameters or not. However, not including tub and org will make the query take much longer to run, tying up system resources and slowing things down for all report users.


  • Only use transaction reports like the Detailed Listing when you really need to see the transaction line detail. Summary-level balances can be retrieved in reports such as the Summary Actuals Listing report, Fund Summary report, Fund, Gift, & Unrestricted Unexpended Balance report, and the Budget Variance report.


  • Preserve server disk space by deleting unneeded reports instead of waiting for them to “purge.” (Note: Report requests are systematically purged after seven days.) This is especially important if you have report output that you know is large.


  • Keep in mind that, as of July 1, the Current Fiscal Year to Date option will reflect FY2008. To retrieve FY2007 year-to-date transactions, select the Prior Fiscal Year date period from the period pick list.

Summary schedule for FY07 transactions and reporting     top

Please follow this link for a "printer-friendly" version of the summary schedule.

Date
Time
Event

Thurs., May 24

5 p.m.

CoA values to be disabled that require approval submitted through CSMA

Fri., June 1

5 p.m.

Credit vouchers with foreign checks to Cash Receipts

Thurs., June 7

10 a.m.

CoA values to be disabled that do not require approval submitted through CSMA

Mon., June 25

5 p.m.

Mass Taxable Sales Deposit forms for deposits made in May and through June 22 to Cash Receipts

Tues., June 26

5 p.m.

  • Web Voucher Reimbursement reports with advance settlements accompanied by checks to Travel & Reimbursement Office
  • Web Voucher payments to be made in a foreign currency entered and approved by tub with related invoices to Cash Management

Wed., June 27

5 p.m.

  • Stopped and re-deposited checks to Cash Management
  • Voided and re-deposited checks to Cash Management
  • Escheat checks to be re-deposited to Cash Management
  • PCard sweep for transactions loaded between June 8 and June 14

Thurs., June 28

1 p.m.

Web voucher payments via ACH entered and approved online in the Web Voucher system with related invoices to Cash Management

5 p.m.

PCard sweep for transactions loaded between June 15 and June 21

Fri., June 29

10 a.m.

US wire transfers: web vouchers entered and approved by tubs; related invoices to Accounts Payable

12 p.m.

AP special handling requests to Accounts Payable

5 p.m.

  • Petty cash logs for settlement to Accounts Payable
  • Credit vouchers accompanied by cash or checks to Cash Receipts
  • Credit vouchers with validated deposit slips to Cash Receipts
  • Web Voucher Travel Authorization forms (WV-TAFs) approved and ticketed by tubs

Mon., July 2

12 p.m.

Massachusetts Taxable Sales Deposit forms for 6/29 to Cash Receipts

Tues., July 3

10 a.m.

First closing sponsored funds Cost Transfer requests to OSP

Thurs., July 5

3 p.m.

PCard system final FY2007 sweep for transactions loaded between June 22 and June 28

4 p.m.

First closing General Ledger feed deadline

Fri., July 6

11 a.m.

First closing manual journal entry deadline (including interdepartmental billing JVs)

5 p.m.

  • Web Voucher Reimbursement reports requiring tax pre-audit to Travel & Reimbursement Office
  • Templates for AR invoices and credit memos to be entered by Accounts Receivable to Central AR

Sat., July 7

9 a.m.

Data Warehouse updated for first closing results

Tues., July 10

10 a.m.

Second closing sponsored funds Cost Transfer requests to OSP

Wed., July 11

5 p.m.

  • Web Voucher Reimbursement reports not requiring tax pre-audit to Travel & Reimbursement Office
  • Web Voucher Reimbursement reports with advance settlements for zero balance or amount due to traveler to Travel & Reimbursement Office
  • Central AR feeds entered into the AR system
  • AR invoices and credit memos entered by tubs into the AR system
  • Vendor setup forms for new vendors or changes to current vendors to Vendor Setup

Thurs., July 12

4 p.m.

Second closing General Ledger feed deadline

Fri., July 13

11 a.m.

Second closing manual journal entry deadline (including interdepartmental billing JVs)

5 p.m.

Web vouchers to be processed in FY2007 entered and approved by tubs; related invoices to Accounts Payable

Sat., July 14

9 a.m.

Data Warehouse updated for second closing results

Tues., July 17

10 a.m.

Third closing sponsored funds Cost Transfer requests to OSP

Thurs., July 19

4 p.m.

Third closing General Ledger feed deadline

Fri., July 20

11 a.m.

Third closing manual journal entry deadline

Sat., July 21

9 a.m.

Data Warehouse updated for third closing results

Fri., July 27

9 a.m.

Data Warehouse updated for fourth closing results

Sat., August 4

9 a.m.

Data Warehouse updated for fifth closing results

Whom to call list for closings      top

For questions relating to ...
Please contact:
Transaction
Office
Location
Phone
A/P web vouchers
Accounts Payable
1033 Mass. Ave., 2nd floor 5-8500
Credit vouchers
Cash Receipts
Holyoke 953 6-8332
Check voids / re-deposits Cash Management Holyoke 451 5-4175
Wires and drafts Cash Management Holyoke 451 6-3018
PCard transactions Travel Desk 1033 Mass. Ave., 2nd floor 6-2273
Travel authorization forms Travel Desk 1033 Mass. Ave., 2nd floor 5-7760
Web Voucher Reimbursement reports Travel Desk 1033 Mass. Ave., 2nd floor 5-7760
AR invoices Accounts Receivable 1033 Mass. Ave., 2nd floor 5-3787
Journal vouchers General Accounting 1033 Mass. Ave., 3rd floor 5-4592
Cost transfers - sponsored funds Sponsored Research Holyoke 617 6-2513

Notice of Change in the Posting Date of the July 6, 2007 Bi-weekly and Weekly Payrolls     top

The bi-weekly and weekly payrolls for Friday, July 6, 2007 are both for time worked in June, which should be reported in FY2007.  The bi-weekly payroll includes the pay period Sunday, June 17 through Saturday, June 30; the weekly payroll includes the pay period Sunday, June 24 through Saturday, June 30.  In order for the University to comply with financial statement reporting requirements and to properly record its salary and fringe benefit expenses for FY2007, these two payroll files will be processed in the first closing of FY2007 with a general ledger posting date of June 30, 2007.  All entries which include regular payroll, overtime, bonuses with an effective date of 6/30/07 or before and supper money payments on the two files will be posted.

Doing so eliminates the need to process payroll accruals for these expenses and ensures the accurate recording of both the payroll and the related fringe benefits.

Employees will not be affected by this posting date change.  They will still receive their paychecks on Friday, July 6.

CREW Sponsored Report Enhancements released on April 22      top

Enhancement
Brief description of the enhancement
Invalid Code Combinations

A column has been added showing the Earliest Transaction Date for an invalid code combination.  The existing column labeled ‘Transaction Date’ has been renamed to ‘Latest Transaction Date’.

Scheduled Reports A column has been added to show the comments for the report that were entered in GMAS.
Segments The repeating header row has been removed from the xls output to enable easier sorting and filtering.

Departmental-Action Report and Job Group Movement Analysis replaces Personnel Action History report      top

As a reminder, with the upgrade to PS 8.9 on April 16, 2007, the PS Personnel Action History (HUC) Report which was in PS 8.0 under Compensate Employees > Manage Payroll Process (US) > Report 2 is no longer available. Instead, users can log into CREW and use HRJOBDP005: Departmental-Action Report and Job Group Movement Analysis (Human Resources) in its place.

The Action Sub Report is designed to show users actions that were processed in the PeopleSoft system during a certain time period. This report will show all employees who meet the criteria entered for the report. The dates represent the effective date the action took place, not the day the action was entered into the system. The decision to retire the PS report with the Upgrade to 8.9 was done by the HR Focus Group in October 2005 and communicated to the HR Users Group shortly there after. If you have any questions regarding the CREW report, you can call the Help Desk (495-8411) to log a ticket and a member of the HR Product Team will contact you to answer any questions.

New Desktop Standards issued     top

The Harvard University Current Desktop Standards document was revised on April 24. The new version has updates to the recommended system memory sizes and the Brio/Hyperion plug-ins used for the optional 'bqy' report format in CREW.

About the e-News   top

The Center for Workplace Development publishes this electronic newsletter for users of Harvard University's financial, HR, and reporting systems, policies, and procedures. The e-News is generally published on or around the 15th of each month.

It contains:

  • updates on projects underway to build or improve University administrative systems;
  • information about new University policies, procedures, and forms;
  • reminders about upcoming deadlines and cut-over dates;
  • tips and tricks for working more easily or productively.

We welcome questions and suggestions for improvement from readers. If your questions are of general interest, we will answer them in future issues.

Please send comments, questions, or suggestions for improvement by email to us at: admin_systems_enews@harvard.edu.

For information about subscribing or unsubscribing to the eNews notifications, visit our who gets the eNews page.