SAP for MIT Documentation on the Web

SAP for MIT home page..

Getting StartedFinancial OperationsPurchasing & PaymentReportsAdvanced Topics & Tips

 

Glossary

Home

Site Map

Updates

Help

Reports
Analysis of Billing (WIP) Report

Contents
Overview
Displaying the Analysis of Billing Report
Entering the Fields on the Analysis of Billing Report
Executing the Report
Reading the Analysis of Billing Report
Downloading the Report
Printing the Report

Overview

This report shows the billing status of active research accounts including authorized totals, amount billed, overruns, and unbilled costs. It is based on the report formerly known as GL25. You must have either departmental level (profit-center) authorization to view specific projects or WBS elements in order to run this report.

top

Displaying the Analysis of Billing Report

Use the following navigation path from the SAP User Menu screen or type in the transaction code from any screen:

Navigation Path:

- User Menu
- Role ZMIT
-
Reports
- Research Reports

- Analysis of WIP

Transaction Code :

/nzwip

Result: The "Analysis of Billing" entry screen is displayed.

screen capture:  Analysis of Billing entry screen

top

Entering the Fields on the Analysis of Billing Report

Type in or select one or more of the fields listed in the following table. Remember, more precisely defined reports generally take less time to run.
In some fields, you can use the Matchcode Matchcode button (Mac) (PC: Matchcode button (PC)) search function to find the data you want. (See Getting Started: Matchcodes.) Many fields offer Multiple Selections Multiple Selection button for entering nonconsecutive numbers or multiple ranges of data. (See Reporting Fundamentals: Selection Options for Setting Report Parameters.)

The Period Ending date is a required field. Enter at least one of the following fields:

Field Name

Description

Project

Type in or select the project number or range of project numbers.

WBS Element

Type in or select the WBS element or the range of the WBS elements.

Billing type

Enter the billing type or a range of billing types.

Sponsor Code

Accept or change the default sponsor codes by typing them in or selecting them.

Profit Center

Type in or select the profit center (your department number prefaced by the letter "P" ) or a range of profit centers.

Period Ending
(required)

Defaults to the last business day of the previous month, or current month if it is the last working day. To change the default, type over the date or select it using the Matchcode button.

Sort Sequence

If you want to sort the report, type in 1,2, or 3 in the Project, Agreement, or Sponsor Code fields.

To erase the numbers, click in the field and use the Space bar.

If you select Descending, the report will be sorted in descending order by the first field you selected for sorting.

Click in the box next to With total to subtotal each field selected for sorting.

top

Executing the Report

Click the Execute button Execute button (F8) to run the report.

top

Reading the Analysis of Billing Report
1st horizontal row

Row Name

Description

WBS Element

Displays the WBS element number

WBS Element Description
Description of the research project.

Sponsor Code

Code assigned to the sponsor

Sponsor
Number of the project

Authorized Total

An authorized total is the amount of funding from a research sponsor available to be spent on a WBS element.

The authorized total does not represent actual income to the Institute, but rather a promise from a sponsor or donor to support a particular project at an agreed-upon level of funding. As expenses occur on the project, the sponsor or donor is billed and income is received to offset the project expenses. Eventually, this revenue will equal the agreed-upon authorized total for the project.

Billing

Amount the sponsor was billed

Unbilled Costs

Amount the sponsor was not billed

2nd horizontal row

Row Name

Description

Project

Project number of the WBS element.

Contract Number

Contract number of the WBS element.

Billing Type

Type of billing.

Agrm Type

Type of agreement.

Total Expense

Total expenses of the project.

Cost Sharing

Amount of MIT's participation in the cost of the project.

Current Expense

Amount of expenditures for the current period.

3rd horizontal row

Row Name

Description

Expiration Date

Date the contract or agreement ends.

Profit Center

Profit center that the contracts fall under.

Term Code

Termination code that reflects the status of the WBS element.

1 = Closed. Pre-end date charges allowed.
2 = No longer in use.
3 = Terminated. Charges not allowed.

Overrun

Amount the project was overrun.

Prepaid Expense

Travel expenses paid by MIT before the trip is billed.

Net Unbilled

Difference between what MIT billed the sponsor and what the expenses are.

top

Downloading the Report

For instructions on downloading this report, see Reports: Reporting Fundamentals: Downloading Reports: Using the Save Option.

top

Printing the Report

  • Click the Print button Print button on the Toolbar to print the report immediately on your default printer;

    or

  • Follow the menu path: List>>Print to select your printer first.

Result: The "Print Screen List" window appears.

For more information on printing, see Reports: Reporting Fundamentals: Printing Reports.

top

Copyright 2001 © Massachusetts Institute of Technology
SAP for MIT Documentation on the Web
Valid From: 02/23/2001