Display Customer Balance

Display Customer Balance

Work Instruction
Functional Area: Accounts Receivable / Display Customer Balance
Purpose Accounts Receivable for Grants - Customer Billing Through Payment
Use this procedure to display balances of a customer’s account for a specific fiscal year.
Trigger
Perform this procedure when a Department or Treasurer’s Office has a need to review a customer’s account balance to investigate such issues as payment discrepancies or general customer inquiries.
Prerequisites
None
Menu Path
Use the following menu path to begin this transaction:
  • Select Accounting Financial Accounting Accounts Receivable Account Display balances to go to the Customer Balance Display screen.
Transaction Code
FD10NA
Helpful Hints
  • The R/O/C column in the field description tables below defines whether the field is required (R), optional (O), or conditional C).
  • On certain screens you may have to scroll to view some data entry fields.
  • If this is repeatedly used with the same selection criteria (customers), the reporting parameters can be saved as a variant.
  • Click to default the variant reporting parameters into the transaction.

Work Instruction
Functional Area: Accounts Receivable / Display Customer Balance
Procedure
1. / Start the transaction using the menu path or transaction code.
Customer Balance Display

2. / As required, complete/review the following fields:
Field / R/O/C / Description
Customer / Required / SAP code that identifies a customer; A customer is a business partner who orders goods and services.
Example:
1000015
Company code / Required / Organizational unit within Financial Accounting
Example:
UC
Fiscal year / Required / State of Ohio mandated fiscal year (accounting period) running from July 1st of one year to June 30th of the following year
Example:
2005
3. / Perform one of the following:
If You Want To / Then / Go To
Use a saved reporting variant / Click . / Step 4
Save the entered reporting parameters (customers, company code, fiscal year) as a reporting variant / Click . / Step 7
Run the report / Click . / Step 10
ABAP: Variant Directory of Program RFARBALANCE

4. / Click on the variant you want to use.
5. / Click .
6. / Return to Step 3.
ABAP: Save as Variant

7. / As required, complete/review the following fields:
Field / R/O/C / Description
Variant Name / Required / User defined name assigned to a reporting variant. Reporting variants are used to modify a report's display layout.
Example:
Mary Customers
Meaning / Required / Description of variant
Example:
Mary Customers
8. / Click .
/ The system displays the message, “Variant XXXX saved.”
9. / Return to Step 3.
Customer Balance Display

10. / Review the displayed information.
11. / Perform one of the following:
If You Want To / Then / Go To
Save the entered reporting parameters (customers, company code, fiscal year) as a reporting variant / Click . / Step 3
View the line item detail / 1. Click the Period you want to display.
2. Click . / Step 12
Print the online report / Click . / Step 17
View list output / 1. Click .
2. Select List Output. / Step 19
Export the report information to a software application or a local/external drive / 1. Click .
2. Select Spreadsheet. / Step 26
View the customer’s special ledger transactional balance / Click the tab.
Special general ledger activity includes customer down payments. / Step 36
View the customer’s master record information / Select Environment Master record. / Step 38
Exit this transaction / -- / Step 41
Customer Line Item Display

12. / Review the displayed information.
13. / Perform one of the following:
If You Want To / Then / Go To
Exit the customer line item display / Click . / Step 11
Display line item details / 1. Select to the left of the line you want display.
2. Click . / Step 14
Display Document: Line Item XXXX

14. / Review the displayed information.
15. / Click twice.
16. / Return to Step 11.
Print ALV List

17. / Click .
18. / Return to Step 11.
Customer Balance Display

19. / Review the displayed information.
20. / Click .
21. / Return to Step 11.
Select Spreadsheet

22. / Click to the left of All Available Formats.
23. / As required, complete/review the following fields:
Field / R/O/C / Description
All Available Formats / Required / Spreadsheet formats available to use for export.
Example:
24. / Click to the left of Always Use Selected Format.
25. / Click .
Information

26. / Click .
Export list object to XXL

27. / Select to the left of Table.
28. / Click .
Export list object to XXL

29. / Click .
Microsoft Excel

30. / Review the displayed information.
31. / Perform one of the following:
If You Want To / Then / Go To
Cancel the spreadsheet / Click . / Step 11
Save the spreadsheet / Select File Save Copy As… / Step 32
Save As

32. / As required, complete/review the following fields:
Field / R/O/C / Description
Save in: / Required / Location to save the document
Example:
File name: / Required / Name of the file
Example:
Save as type: / Required / Type of file to save as
Example:
33. / Click .
34. / Click to close the spreadsheet.
35. / Return to Step 11.
Customer Balance Display (Special general ledger tab)

36. / Review the displayed information.
/ The same functionality options listed in Step 11 are available on this tab.
37. / Perform one of the following:
If You Want To / Then / Go To
Return to the Balances tab / Click the tab. / Step 11
Exit this transaction / -- / Step 41
Display Customer; General Data

38. / Review the displayed information.
/ Refer to the work instruction Display Customer Master Record – FD03.
39. / Click .
40. / Return to Step 11.
41. / Click until you return to the SAP Easy Access screen.
42. / You have completed this transaction.
10/4/2017
Ver: / 12_AR_FD10NA_Disp Cust Bal_R1.2_CustomerBilling_04.udc
© University of Cincinnati / 1/16
Work Instruction
Functional Area: Accounts Receivable / Display Customer Balance
Result
You have displayed a customer account balance.
Comments
None
10/4/2017
Ver: / 12_AR_FD10NA_Disp Cust Bal_R1.2_CustomerBilling_04.udc
© University of Cincinnati / 1/16