.. Reports Customer Balance Display Contents Overview Displaying the Entry Screen Entering the Fields Executing the Report Checking Account Balances Drill Down to Line Items Drill Down to Source Document Overview The Customer Balance Display screen is used to keep track of invoices and payments by customers. Debits, credits, and balances are listed by fiscal period. You can drill down on an amount to view all line items relating to the debit or credit. Note You can only display account information for sponsored research customers belonging to the SPON (sponsored research) account group. top Displaying the Entry Screen 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 - Customer Reports - Customer Balance Display Transaction Code : /nfd10n Result: The "Customer Balance Display" screen appears. top Entering the Fields 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 (PC: ) search function to find the data you want. (See Getting Started: Matchcodes.) Many fields offer Multiple Selections for entering nonconsecutive numbers or multiple ranges of data. (See Reporting Fundamentals: Selection Options for Setting Report Parameters.) Field Name Description Customer The customer number is assigned to each sponsor for billing purposes. Type in the customer number or select one from the SPON account group. To find the SPON account group: 1. Click on the Matchcode button in the Customer field. The Restrict Value Range box appears. 2. Type Spon in the Account Group field. (The tab should be K: Customers per account group. If it is not, change it.) 3. Click the Enter button at the bottom of the box. A list of customers belonging to the Spon group is displayed. 4. Double-click on an item to select it. Company Code Select the appropriate company code using the Matchcode button. Fiscal Year Type in the fiscal year. top Executing the Report Click the Execute button . top Checking Account Balances 1. Click the Balances tab to display outstanding balance, debit and credit information. Column Description Period Fiscal periods (1-16) Debit Amount billed for the fiscal period Credit Amount paid for the fiscal period Balance Difference between the debits and credits for the fiscal period Cumulative Balance Balance carried forward from the previous fiscal year and added to each line item 2. (optional) Click on the Special general ledger tab to display the account balance. top Drill Down to Line Items 1. Double-click on an amount. Result: The "Customer Line Item Display" screen appears. Column Description Stat Status of the debit or credit: red = open items green = cleared items yellow = parked items Assignment WBS that is associated with the transaction. Doc. no. Unique number assigned to a business transaction; for example, an invoice or incoming payment and the contract number. Type DZ = incoming payment RV = invoice created by the system S1 = sponsored research credit memo SR = manual invoice See Doc Types on SAP DTR's to look up other document types. Area Dunning area for sponsored research. Doc Date Date the transaction was entered into SAP. PK (Posting Key) Identifies the type of document posted 01 = invoice 08 = payment clearing 11 = credit memo 15 = incoming payment Amt in loc. cur. Amount that was debited or credited to the WBS element. Negative numbers (-) are credits; positive numbers (+) are debits. Clearing Date the invoice was either paid or cancelled. Clring doc number Clearing document number. Text Explanatory note or billing period related to the amount. 2. (optional) Click the Print button on the Toolbar to print the line items report. Result: The "Customer Line Item Display" screen appears which is similar to the "Print Screen List." For instructions on the "Print Screen List", see Reports: Reporting Fundamentals: Printing Reports. top Drill Down to Source Document 1. Double-click on a field under the columns on the "Customer Line Item Display" screen. Result: The "Display Document:" screen appears. Two significant fields are: Bline date (Baseline date) Lists the date the invoice begins aging (This is not always the same as the Posting Date.) Clearing (Clearing date) Lists the clearing date and the clearing document number. 2. Click on the Document Header button . This screen shows the Document type and explanation, Document Date, Posting Date, date the transaction was entered and the initials of the person who entered it. 3. Click on the Back button to return to the Customer Line Item display. top Copyright 2001 © Massachusetts Institute of Technology SAP for MIT Documentation on the Web Valid From: 05/21/2001