AC010 Financial Accounting and Reporting

AC010
SAP AG 1999 SAP AG
AC010 Financial Accounting and Reporting
Financial Accounting and Reporting
Copyright
Copyright 2000 SAP AG. All rights reserved. Neither this training manual nor any part thereof may be copied or reproduced in any form or by any means, or translated into another language, without the prior consent of SAP AG. The information contained in this document is subject to change and supplement without prior notice. All rights reserved.
SAP AG 1999
Financial Accounting
Level 2
AC200 5 days General Ledger/ Accounts Payable/ Accounts Receivable Configuration
Level 3
AC205 2 days Financial Closing AC260 2 days Additional Financial Functionality AC660 5 days EC-CS: Consolidation Functions *AC240 5 days FI-LC: Consolidation Functions **AC900 R/3 For Auditors CA550 3 days 4 days Consolidation
AC010
5 days
Financial Accounting and Reporting
AC290 Real Estate Management AC305
5 days
4 days
Asset Accounting AC220 5 days
Special Purpose Ledger AC700 5 days
HR050
5 days
Funds Management: Processes, Organization and Configuration AC270 3 days Travel Management Travel Expenses
Inflation Accounting AC275 1 day Travel Management Travel Planning
Human Resources
SAP AG 1999
**
from July 2000 on
Course Prerequisites
Knowledge of accounting processes in Financial Accounting SAP20 (recommended)
SAP AG 1999
Target Group
Participants:

Members of the FI project team Employees from accounting departments
Duration: 5 Days
SAP AG 1999
Navigation
Contents:
Basic features User-specific settings
SAP AG 1999
Navigation: Unit Objectives
At the conclusion of this unit you will be able to: Identify the elements of a typical window Navigate in the system Make personal system settings
SAP AG 1999
Navigation: Business Scenario
New users need to familiarize themselves with the screens in the R/3 System and define their personal default settings
SAP AG 1999
Logging on to the R/3 System

User System Help
SAP R/3
Log off New password
Client User Password
Language
iwdf4042 OVR
SAP AG 1999
Screen Elements
Command field
Menu Edit Favorites Extras System
Menu bar
Help
Standard toolbar Options Title bar Application toolbar

Overview
System function name : Activity
Input field
Input field
1st selection 2nd selection 3rd selection 4th selection 5th selection Display Change
Tab
Green light; positive Yellow light; neutral
Radio button
1st selection
2nd selection
3rd selection
Checkboxes
This screen is made up of various screen elements. It does not exist in the system.
Execute
Pushbutton
I42 (1) (400) iwdf4042 INS
Message
Status bar
SAP AG 1999
SAP Easy Access - Standard

Menu Edit Favorites Extras System Help
SAP Easy Access

Other menu Favorites Accounts receivable Create FD01 Change FD02 Display FD03 Inbox Accounts payable SAP standard menu Office Logistics Accounting Human Resources PPMDT - Managers Desktop Personnel management Time management Payroll accounting Training and events Organizational management Travel management Information system Information Systems Tools
I42 (1) (400) iwdf4042 INS
Create menu
Assign users
Documentation
SAP AG 1999
Selecting Functions...
Create session
SAP Easy Access

Other menu Favorites SAP standard menu
End session User profile Services Utilities List Workflow Links

Create menu Assign users Documentation
using Favorites or the tree structure
Private notes Own spool requests Own jobs Short messages Status... Log off
using the menu path
/nFD03 using the technical name (transaction codes)

SAP AG 1999
Role-Based User Menu

SAP Easy Access

Other menu
Favorites User menu Schedule Manager Information system Closing Account master data Create Change Display Display changes Block / unblock Set deletion flag Confirmation of change Compare Maintain centrally Account balances and account items Entry Payment and clearing Editing options
Create menu
Assign users
Documentation
I42 (1) (400)
iwdf4042
INS
SAP AG 1999
Field Help - F1, F4

Display Customer: Initial Screen
Display Customer: Initial Screen
Display Customer: Initial Screen Customer 1000 1000 IDES Becker Berlin
F1
Help - Display Customer: Initial Screen
Company code
F4
Restrict Value Range
Restrictions Customer Company code Company name City Currency Restrict number to No restriction
Customer account number A unique key is used to clearly identify the customer within the SAP system. Procedure When creating a customer master record, the user either enters the account number of the customer or has the system determine the number when the record is saved, depending on the type of number assignment used..
Application help
Technical info
Possible entries
Hit list
Message
FD03
iwdf4042
INS
SAP AG 1999
SAP Online Help

Menu Edit Favorites Extras System Help Application help SAP library Glossary Release notes SAPNet Feedback Settings...
SAP Library Getting started Release notes Basis Service Cross-Application Components Financials Human Resources Logistics Copyright and Conventions
SAP Library
SAP AG 1999
System Functions - Services
Menu
Edit
Favorites
Extras
System
Help
Create session
SAP Easy Access

Other menu Favorites SAP standard menu
End session User profile Services Utilities List Workflow Links Private notes Own spool requests Own jobs Short messages Status... Log off Reporting Quick Viewer Output controller Table maintenance Batch input Fast entry Direct input CATT Jobs Queue SAP Service Appointment calendar Business Workplace
Documentation
SAP AG 1999
System Functions - User Profile

User Edit Goto System Help
Maintaining your user profile
User Last changed by Address Start menu Logon language Output controller
MUSTER ADMIN
01.01.2000 12:00:00
Status Saved
Defaults
Parameters
Decimal notation 1.234.567,89 1,234,567.89 1 234 567,89
Output immediately Delete after output Personal timezone Date format DD.MM.YYYY MM/DD/YYYY MM-DD-YYYY YYYY.MM.DD CATT YYYY/MM/DD
I42 (1) (400) iwdf4042 INS
SAP AG 1999
Table Settings - Example
Parameters
Value
Text Sales order type Company code Processing group Bank key
Table Settings Choose Variants Current setting Standard setting Maintain Variants Variant Use as standard setting Create Delete My variant Basic setting
Save
Administrator
SAP AG 1999
Personalizing the Frontend

Sales document Edit Goto Environment System Help
Create Sales Order: Initial Screen

Create with reference Sales Item overview Sales document Besteller Edit Goto Environment System Help
Create Sales Order: Initial Screen

Order type Organizational data Sales organization Distribution channel Division Sales office Sales group Order type Standard order Rush order Create with reference Sales Item overview Ordering party
Frankfurt sales organization
... and with GuiXT ... and with GuiXT

Distribution channel Final customer sales Sold for resale
R/3 Standard ... R/3 Standard ...
Returns Free of charge
Remember ... Advertising articles 471199 and 471299 (valid until end of May) Product 34611 must be replaced by product 34611_S!!!
SAP AG 1999
Navigation: Unit Summary
You are now able to: Identify the elements of a typical window Navigate in the system Make personal system settings
SAP AG 1999
Exercises
Unit: Navigation Topic: Basic features
At the conclusion of this exercise, you will be able to: Log on to a given R/3 System Find transaction codes Access the SAP Library Use F1 help to find field information Use F4 help to search for possible field entries
As a new user of the R/3 System, you begin to navigate the system using the menu paths and transaction codes. You also begin to access various online help and discover the kinds of information each provides. 1-1 Logging on to the R/3 System Select the appropriate R/3 System for this course. Use the client, user name, initial password and logon language specified by the instructor. The first time you log on, you will get a prompt in which you must enter your new password twice. Make a note of the following: Client: _ _ _ User: _ _ _ _ _ _ _ _ Password: ____________ Language: _ _
1-2 What is the maximum number of sessions you can have open simultaneously? __
1-3 Identify the screen names and find the transaction codes that correspond to the following menu paths? 1-3-1 Tools Administration Monitor System Monitoring User Overview Name of screen: ________________________________________ Transaction: ___________
1-3-2
Accounting Financial Accounting Accounts receivable Master records Display Enter Customer 1000 and Company code 1000 to get to the next screen.
Name of screen: _______________________________________ Transaction: __________
1-4 Help 1-4-1 If you choose Application help in the SAP Easy Access screen, which area of the SAP Library does it take you to ? _________________________________________________________ To answer the questions below, you will need to go to the Display Customer: Initial Screen
1-4-2 Use F4 help on the Customer field to find the customer number for Becker ##. Note: ## corresponds to your assigned group number. _________________________________________________________ 1-4-3 Use F1 help on the Customer field. What is the use of this field? Please write a brief summary of the business-related information. _________________________________________________________
1-4-4 Use F1 help on the Company code field. If you choose the Application help button from the F1 help screen, which area of the SAP Library does it take you to? _________________________________________________________ 1-4-5 Which pushbutton do you need to use on the F1 help screen to find the parameter ID for the Company code field? _________________________________________________________
Unit: Navigation Topic: User-specific settings

At the conclusion of this exercise, you will be able to: Set a user parameter for a field Set various user defaults such as language, date format, and decimal notation Create folders and add transactions to your Favorites Select a start transaction of your choice as the default displayed after logging on (optional)
You begin to set various user-specific settings to personalize the system to your liking.
Exercises marked * are optional.
2-1 Setting user parameters. 2-1-1 Assign a parameter value for the Company code field to your user profile. Note: The instructor will tell you what parameter value to enter. Parameter ID: ___ ___ ___ Parameter value: ___ ___ ___ ___ 2-2 Setting user defaults.
2-2-1 In your user profile, set your logon language to the value used for the course. 2-2-2 In your user profile, select the decimal notation and date format that you desire. 2-3 Defining favorites of your choice. 2-3-1 Insert at least one new folder under the Favorites folder. 2-3-2 Add any two of your favorite transactions to the corresponding folder(s). 2-3-3 Add the Internet address http://www.sap.com under the text SAP Homepage. 2-3-4 Add the Internet address for the online evaluation (the instructor will tell you the URL) under the text Online Evaluation. *2-4 Setting a start transaction. 2-4-1 Enter a transaction of your choice as the initial transaction. You will then need to log off and on again for the change to take effect. Note: If desired, you can change the initial transaction back to the system default (SAP Easy Access).
Solutions
Unit: Navigation Topic: Basic features
1-1 Log on to the system specified by the instructor and change your initial password. 1-2 You can open and close sessions using System Create session (or using the appropriate icon) and System End session. The maximum number of sessions you can have open simultaneously is 6. 1-3 To find the transaction code, select System Status. These screen names and transaction codes correspond to the menu paths: 1-3-1 Transaction: SM04 for Screen Name: User list 1-3-2 Transaction: FD03 for Screen Name: Display Customer: General data 1-4 Help 1-4-1 The entire SAP Library is available including Getting Started. Help Application help 1-4-2 T-CO05A## (## corresponds to your assigned group number) When you select F4 in the Customer field, the Restrict Value Range window appears. You can explore the various tabs to see the different search criteria available. Find a tab that includes the Name field and enter the following: Field Name Name Values Becker ##
Select the Continue Enter pushbutton. A window now appears listing the customer account numbers that match your search criteria. Select the line that corresponds to Becker ##, then select the Copy Enter pushbutton. This automatically copies the customer account number into the Customer field. 1-4-3 Suggestion: The customer is a unique key (account number) used to clearly identify the customer within the system. 1-4-4 FI Accounts Receivable and Accounts Payable 1-4-5 Use the Technical Info pushbutton to find the Parameter Id: BUK.
Unit: Navigation Topic: User-specific settings
2-1 Setting user parameters. 2-1-1 To assign a parameter value to a field you will need the parameter ID of the field. First you need to select a transaction that contains this field. For example, Company code can be found in transaction FD03. Next, place the cursor on that field (just click on it with the mouse). Accessing: F1 Technical Info Parameter ID gives you the required information. For the Company code field, the parameter ID is BUK. Finally, you enter the parameter ID and desired value in your user profile: System User profile Own data On the Parameter tab you enter the parameter ID and value that you want to be entered into the field. Save your entries. 2-2 Setting user defaults. 2-2-1 To set the logon language, go to your user profile: System User profile Own data On the Defaults tab, enter the language of your choice in the Logon language field. 2-2-2 To set the decimal notation and date format, remain on the Defaults tab in your user profile. Select the indicator adjacent to the notation and format you desire. Save your selections. 2-3 Defining favorites of your choice. 2-3-1 Favorites Insert folder
Type any name for the folder then select Enter. You can add as many folders as you desire. Once created, folders can be dragged and dropped to position them where you want. 2-3-2 To create favorites, select specific applications (transactions) that you need as favorites for your daily work from the menu tree of the SAP standard menu. Add them to your Favorites list by selecting them and choosing Favorites Add from the menu bar. Alternatively, use the mouse to drag & drop favorites to a folder. You can also use the menu path Favorites Insert transaction to add using a transaction code.. Finally, you can move existing favorites to different folders later using Favorites Move or using drag & drop. 2-3-3 Create Internet addresses using Favorites Add Web address or file. When you select SAP Homepage from your favorites, an Internet browser will open and you will be connected to SAPs homepage. 2-3-4 Favorites Add Web address or file You will use this link at the end of the course to fill out the course evaluation. 2-4 Setting a start transaction. 2-4-1 Extras Set start transaction Enter a transaction of your choice then select the Enter pushbutton. Notice the system message on the status bar indicates that your selected transaction has been set as the start transaction. The next time you log on, the system will go directly to your start transaction. Note: To change back to SAP Easy Access as the initial screen, follow the menu path again, delete the transaction code and select Enter. The next time you log on, SAP Easy Access will be the initial screen.
Course Overview
Contents:
Curriculum Progression Course Goals Course Objectives Course Content Course Overview Diagram Main Business Scenario Getting Started
SAP AG 1999
Curriculum Progression
Level 1: Introduction Level 2: Processes
Business processes
SD
IMG
Global Settings Countries Currencies Calendars
Level 3: Special topics

Detailed courses and workshops
Introductory courses
MM
PP
FI
CO
IMG
Global Settings Countries Currencies Calendars
SAP AG 1999
Course Goals
This course will prepare you to: Describe the basic structure and procedures of Financial Accounting in the SAP System Perform essential functions in Financial Accounting Support project teams with important decisions
SAP AG 1999
Course Objectives
At the end of this course, you will be able to: Explain the roles of various applications in Financial Accounting Explain how the financial accounting modules relate to each other Perform typical accounting transactions in the application components of Financial Accounting
SAP AG 1999
Course Content
Preface Unit 1 Unit2 Unit 3 Unit 4 Unit 5 Navigation Course Overview General Ledger Accounting Accounts Payable Accounts Receivable Appendix Unit 6 Unit 7 Unit 8 Unit 9 Unit 10 Asset Accounting Travel Management Bank Accounting Closing and Reporting Summary
SAP AG 1999
Overview Diagram
CO
FIBL
FITV
FIAA
MM
FIAP
FIGL
General ledger
FIAR
SD
Balance sheet ... P&L ... ...
SAP AG 1999
Company Scenario
You want to learn more about the capabilities and processes that the components of Financial Accounting have to offer in SAP R/3. IDES has been productive with all financial accounting application components for quite some time and serves as a reference customer for SAP. You are to visit the IDES group in order to get a practical view of how the IDES group completes its accounting transaction using the FI components.
SAP AG 1999
Clients in R/3
SAP System Hardware

Delivery client (000 & 001) Production client (for example, 100) Test client (for example, 999) Training client (for example, 400)
SAP AG 1999
Clients
Financial Applications
EC
Enterprise Controlling
TR
Cash management and forecast Treasury Management Cash Management
FI
CO
Overhead cost accounting Product cost accounting Profitability analysis
General Ledger Accounting Subsidiary ledgers
IM
Investment Management
PS
Project System
RE
Real Estate
SAP AG 1999
Accounting Target Groups

Journalists Media
Tax authorities
Shareholders
Banks
Legal authorities
Insurance Auditors Executive officers Senior Administrative management staff Financial analysts
Accountants
Employees
SAP AG 1999
General Ledger Accounting
Content:
Organizational Elements for Financial Statements G/L Account Master Records Accounting Transactions within a Period in General Ledger Accounting
SAP AG 1999
General Ledger Accounting: Unit Objectives
At the conclusion of this unit, you will be able to: Describe how G/L Accounting is set up in R/3 Maintain and view G/L accounts Complete daily accounting transactions in the general ledger
SAP AG 1999
Overview Diagram: General Ledger Accounting
CO
FIBL
FITV
FIAA
MM
FIAP
FIGL
General ledger
FIAR
SD
Balance sheet ... ... ...
P&L statement
SAP AG 1999
General Ledger Accounting: Business Scenario
IDES consists of nine affiliates spread over the world. Each affiliated company has to meet different legal requirements for accounting. IDES operates in 13 different branches. Management wants reports on the results of the IDES group for the individual branches. IDES uses its own chart of accounts, INT, which may need to be expanded.
SAP AG 1999
Presentation:
Organizational Elements for Financial Statements

Company codes Business areas
SAP AG 1999
Company Code
Independent accounting entity
Company code
SAP AG 1999
IDES International
IDES International has operations in North America, Europe, and Asia.
IDES International Frankfurt, Germany
IDES N. America
IDES Europe
IDES Asia
New York / USA Toronto / Canada Mexico City / Mexico
Frankfurt / Germany. London / England Lisbon / Portugal Paris / France Barcelona / Spain
Tokyo / Japan
SAP AG 1999
The Company Codes of IDES

The affiliates of IDES International are set up in R/3 as company codes.
IDES International Frankfurt, Germany
IDES North America
IDES Europe
IDES Asia
3000 4000 6000
USA Canada Mexico
1000 2000 2100 2200 2300
Germany England Portugal France Spain
5000
Japan
SAP AG 1999
Business Area
Areas of operation
Business areas
Machinery
1000
Machinery
Plant construction
2000
Plant construction
Automotive
3000
Automotive
SAP AG 1999
Some of the Business Areas of IDES
IDES International Frankfurt, Germany IDES North America IDES Europe IDES Asia/Australia
3000 4000 6000
USA Canada Mexico
1000 2000 2100 2200 2300
Germany England Portugal France Spain
5000
Japan
1000 Machinery 1000 Machinery

SAP AG 1999
2000 Plant constr. 2000 Plant constr.
3000 Automotive 3000 Automotive
Presentation:
G/L Account Master Records

Charts of accounts Account groups Financial statement versions Reconciliation accounts
SAP AG 1999
Charts of Accounts
INT
CAUS
GKR
1000
10000
1000
... and as many additional charts as needed!
2000
20000
2000
SAP AG 1999
Chart of Accounts Assignment
Chart of accounts
Company code A
SAP AG 1999
Company code B
Company code C
IDES - Charts of Accounts

INT
1000 Germany
2000 United Kingdom
2100 Portugal
2300 Spain
6000 Mexico
CAUS
CAFR
CAJP
SAP AG 1999
3000 USA
4000 Canada
2200 France
5000 Japan
Company Code Specific Settings

Account definition in chart of accounts
Account X
PLUS
PLUS
Company code specific settings
Company code specific settings
CC 1000
CC 3000
Account X in company code 1000

SAP AG 1999
Account X in company code 3000
Account Groups for G/L Accounts

Cash accounts
Cash
General ledger
000000-099999
100000-199999
Company code specific settings Account definition in chart of accounts
Asset
200000-299999
Material
300000-399999
400000-499999
P/L
Account groups
Account 001111
Liab.
500000-599999
Cash
000000-099999
unt Acco p grou
...
600000-699999
SAP AG 1999
Reconciliation Accounts
Reconciliation accounts for customers, vendors, and assets
General ledger
aa
bb
Subsidiary ledgers
Customers
Vendors
Assets
Subsd. ledger accounts aa bb
SAP AG 1999
Transaction Figures
G/L account
Line items . . Line items . .
Transaction figure / 1000 1000 debit Mechanical engineering Mechanical engineering 2000 2000 Plant engineering Plant engineering 3000 3000 Automotive Automotive Transaction figure / debit Transaction figure / debit
Transaction figure / credit Transaction figure / credit Transaction figure / credit
SAP AG 1999
Financial statement versions
INT Financial statement IDES

Assets
Items - Sub-items - ...
GKR Financial statement Germany

Assets
CAUS Financial statement USA

Assets
Liab. & OE
Liab. & OE
Liab. & OE
P&L
Items - Sub-items - ... - ...
P&L
P&L
... and many additional financial statement versions

SAP AG 1999
Parallel Accounting Methods
Financial statement per IAS
Valuation per IAS
Financial statement per US-GAAP
Valuation per US-GAAP
1000 Germany
SAP AG 1999
Presentation:
Accounting Transactions Within a Innerperiodische Geschftsvorflle in der Hauptbuchhaltung Period in G/L Accounting
Enjoy - G/L Account Postings Account Status Standard/Complex Postings
Prsentation:
SAP AG 1999
Enjoy - G/L Account Postings
Header information
Information area
Work templates Line item information
SAP AG 1999
Standard/Complex Postings
Initial Screen
Document header entry
Order of screens
1. Item screen
Access to First line item

2nd line item screen
Entry of first doc. line item
Entry of second line item
Access to second line item
Access to third line item

SAP AG 1999
additional line item screens
Important Standard Document Types
er ustom C es nvoic i
er ustom mos C t me credi
er stom Cu ents paym
unt L acco G/ ents docum
DG
DR
SA KN
DZ
or Vend s ce invoi
or Vend t credi os mem
or Vend ts en paym
or Vend oices v net in dit re and c s o mem
KR
KG
SAP AG 1999
KZ
Posting Key
Detail view Account Item 1 / PK Amount Tax ID 2. Debit or Credit? 1. S, D, K, A, M ?
The posting key (PK) has a control function pertaining to the document line items. It determines the following: 1. Account type for the posting of the line item 2. Posting of line items as debit or credit postings 3. Field status of additional information
Additional info. Business area Cost center 3. Field status? Text ...
SAP AG 1999
Standard Posting Keys
Customers 01 02 03 04 05 06 07 08 09 11 12 13 14 15 16 17 18 19
Vendors 21 22 23 24 25 26 27 28 29 31 32 33 34 35 36 37 38 39
General Ledger 40 80 81 83 84 85 86 50 90 91 93 94 95 96
Assets 70 75
Material 89 99
For postings to G/L accounts from MM
SAP AG 1999
Account Information
Balance display Account 100000
January February March April ... 100000+ 400000+ 300000100000+ ... ORIGINAL DOCUMENT
Line item list Account 100000

1.3.2000 10.3.2000 12.3.2000 15.3.2000 18.3.2000 20.3.2000 25.3.2000 400000300000100000+ 500000+ 200000+ 200000200000-
Optically archived
Optional Document
03/18/2000
Line items
01 100000 20000002 113100 200000+
SAP AG 1999
Self-Study: G/L Account Master Records
At the conclusion of this unit, you will be able to:
Display a chart of accounts Create a G/L account directory Create G/L accounts with reference Maintain financial statement versions Explain the special purpose of reconciliation accounts
SAP AG 1999
G/L Account Master Data - Exercises

Unit: G/L Accounting Topic: G/L account master data
At the conclusion of these exercises, you will be able to: Run the chart of accounts report Create the G/L account directory Create a G/L account Edit the financial statement version The IDES group consists of 9 companies that are legal entities. They are set up in the R/3 System as company codes. Each company code has its own complete general ledger, which meets the various country-specific requirements. In the general ledger, very few daily transactions are completed. Most of the daily transactions are completed in subsidiary ledgers. For this reason, the following exercises are to help you become more acquainted with master records in General Ledger Accounting. However, in order to learn about the transaction for G/L account postings, you will post an increase in capital for IDES Germany in the next exercise. To do this, you need a new G/L account. To access General Ledger Accounting: Accounting Financial accounting General Ledger
1-1 The chart of accounts The general ledger of a company code is set up according to the definition of a chart of accounts. 1-1-1 Display chart of accounts The chart of accounts used most often by the IDES group is chart of accounts INT. Use a program to view this chart of accounts. Information system General ledger reports Master data Chart of accounts SAP minimal variant 1-1-2 Display account in chart of accounts Access the definition of account 160000 by double-clicking it. What is the long text of this G/L account in the maintenance language? __________________________________________________________ Which account group does this account belong to? __________________________________________________________ Check whether it is possible to translate the name of this account into other languages and whether you can create key words. __________________________________________________________ Can you add other information to the G/L account? __________________________________________________________ The definition of the account contains some control parameters. Here, for example, you define whether the account is a P&L statement account or a balance sheet account. What type of account is account 160000? __________________________________________________________ Now go back to the SAP Easy Access menu.
1-2 Company-code specific settings
Company-code data has to be entered in the definition of the G/L account in order to provide the settings specific to the company code. 1-2-1 Display account currency An important setting in the G/L account definition is the specifying a currency, in which the account is kept. Look at the company-code specific settings of G/L account 160000 in company codes 1000 and 2000. What is the account currency in: Company code 1000? Company code 2000? __________________________________ __________________________________
Master records Individual processing In company code 1-2-2 Identify reconciliation accounts View the company code specific settings of G/L account 160000 in company code 1000. Is this account a reconciliation account? If so, for which subsidiary ledger? ___________________________________________________________ Also view the following accounts: 161000, 140000, 141000, 1000, and 2000. Account 161000 Reconciliation account for _____________________ Account 140000 Reconciliation account for _____________________ Account 141000 Reconciliation account for _____________________ Account 1000 Account 2000 Reconciliation account for _____________________ Reconciliation account for _____________________
Can you make G/L account postings to these accounts? _______________________________________________________ _______________________________________________________ Master records Individual processing In company code Now go back to the SAP Easy Access menu.
1-2-3 Display G/L account list Create the G/L account list of company code 3000 (IDES USA). Does this tell you which chart of accounts is used by this company code? Chart of accounts for company code 3000: _______________________________ Information system General ledger reports Master data G/L account list SAP minimal variant Now go back to the SAP Easy Access menu. 1-2-4 Difference between chart of accounts and G/L account list How is the G/L account list different than the chart of accounts? _________________________________________________________ _________________________________________________________ _________________________________________________________
1-3 Financial statement versions The balances of the G/L accounts are needed to create the balance sheet and profit and loss statement. All G/L accounts thus have to be put financial statement items of the financial statement version. Various financial statement versions can be used for various purposes. The financial statement version for creating the financial statements for company code 1000 is INT, the same name as the chart of accounts. Note the financial statement item and all items above it in the hierarchy. Financial statement items: ________________________________________________ ________________________________________________ ________________________________________________ ________________________________________________ Master records Individual processing In company code
Now go back to the SAP Easy Access menu.
1-4 Creating a G/L account For the planned increase in capital, IDES Germany (company code 1000) needs a new G/L account. This G/L account is not available in the chart of accounts either. 1-4-1 Checking the chart of accounts The American parent company is responsible for assigning account numbers and maintaining charts of accounts for the IDES group. Based on the requirement, the parent company should have created G/L account 700XX in chart of account INT. Check whether this account was created. Master records Individual processing In chart of accounts Now go back to the SAP Easy Access menu. 1-4-2 Maintaining the company-code specific settings Before postings can be made to account 700## in company code 1000, you need to include the company-code specific settings. The account should have a structure similar to that of account 70000. For this reason, use this account as a reference. Make certain that: The account in company code 1000 uses the UNI currency Line item display is activated - Key 001 is entered as the sort key for line items Remove the alternative account number. Master records Individual processing In company code 1-4-3 Maintaining the financial statement version
The new account has to be entered in financial statement version INT. Enter is in the same financial statement item as reference account 70000. Master records Individual processing In company code When a user is maintaining the financial statement version, it cannot be maintained by any other user. You should therefore carry out this task quickly and exit the transaction at once so that another user can access the transaction. Now go back to the SAP Easy Access menu.
Self-Study: Accounting Transactions in a Period
At the conclusion of this unit, you will be able to: Post a G/L account documents using the Enjoy posting transaction and the general posting transaction Explain how a FI document is structured Call up a G/L account
SAP AG 1999
Accounting Transactions - Exercises

Unit: G/L Accounting Topic: Daily accounting transaction in the general ledger
At the conclusion of these exercises, you will be able to: Post a G/L account document Complete an account query
At the last stockholder's meeting, an increase in capital of 200,000 UNI was agreed upon by converting open reserves of the stockholder's equity.
To access General Ledger Accounting: Accounting Financial accounting General ledger
2-1 Posting an increase in capital Post the increase in capital of 200,000 UNI to the account (700##) you created in business area BA##. Use account 78200 "Transfer of reserves" for the offsetting posting. The posting record is: 78200 (Transfer of reserves) to 700## (Increase in capital)
Use the "With business area" creation variant Enter "Increase in capital, group ##" for the short text. Document entry G/L account posting Now, display the document. What is the meaning of the "PK" column and its entries 40 and 50? PK: 40: 50: ________________________________________________________ ________________________________________________________ ________________________________________________________
Document Display Now go back to the SAP Easy Access menu.
2-2 Account query To make certain that the posting was actually completed properly, check the balance of your account 78200 and drilldown to the document. 2-2-1 Balance display Check the transaction figures and the balance of account 78200 in company code 1000 and business area BA##. Account Display balances Why do you only see one balance of 200000 UNI? Did not all groups make their credit posting to this account? What happened to the postings of the other groups? ___________________________________________________________ ___________________________________________________________ ___________________________________________________________ ___________________________________________________________ ___________________________________________________________
What do you have to do in order to see the entire amount that was posted by all groups to this account during the last exercise? ___________________________________________________________ ___________________________________________________________ Account Display balances 2-2-2 Line item display From the balance display, display all line items that were posted to this account. Test various display variants in order to display the line item list. 2-2-3 Document display Go to the document display from the line item display. Now go back to the SAP Easy Access menu.
2-3 Complex posting Post the same accounting transaction (increase in capital) using the "complex/general posting" transaction. Use document type SA. Document entry Others General posting Now go back to the SAP Easy Access menu.
2-4 Account balances To display a list of all G/L account balances, SAP offers standard reports. Complete these reports.
2-4-1 Create a G/L account balance list Start the G/L account balance list for the current posting period and company code 1000. Find the balances of account 78200. What is the balance in your business area BA##? Balance: _____________________________________ Information system General ledger reports Balance lists General G/L account balances SAP minimal variant Now go back to the SAP Easy Access menu. 2-4-2 Displaying structured balance lists The structured balance list present the G/L account balances in the form of a balance sheet. Start this for the current posting period and company code 1000. Use financial statement version INT. Information system General ledger reports Balance lists General Structured account balances SAP minimal variant Now go back to the SAP Easy Access menu.
Unit Summary
You are now able to: Describe how General Ledger Accounting is set up in the R/3 System Maintain and view G/L accounts Complete accounting transactions within a period in General Ledger Accounting
SAP AG 1999
G/L Accounting - Solutions

Unit: G/L Accounting Topic: G/L account master data
1-1 The chart of accounts 1-1-1 Display chart of accounts Information system General ledger reports Master data Chart of accounts SAP minimal variant Field name or data type Chart of accounts Run report 1-1-2 Display account in chart of accounts Double-click on line 160000, than select the display symbol. G/L account long text Account Group: Trade Payables - domestic General G/L accounts Values INT
"Key word/translation" tab: Here, you can translate the account name and enter key words. "Information" tabs: Here, you can enter long texts for various purposes. "Type/Description" tab: The account is marked as a balance sheet account. Now go back to the SAP Easy Access menu.
1-2 Company-code specific settings 1-2-1 Checking the account currency Master records Individual processing In company code Field name or data type G/L account Company code Select the "Display" symbol The account currency is UNI. Field name or data type G/L account Company code Select the "Display" symbol The account currency is GBP. 1-2-2 Identify reconciliation accounts Master records Individual processing In company code Values 160000 2000 Values 160000 1000
Field name or data type G/L account Company code Select the "Display" symbol
Values 16000 1000
"Control data" tab: The "Reconciliation ID" field is in the "Account control for company code" section The value "Vendors" is entered in this field. This account is thus a reconciliation account for accounts payable. View the other accounts listed in the same manner. Account 161000 Reconciliation account for_____Vendors__________ Account 140000 Reconciliation account for _____Customers________ Account 141000 Reconciliation account for _____Customers________ Account 1000 Account 2000 Reconciliation account for ______Assets______ Reconciliation account for ______Assets______
Reconciliation accounts cannot be posted to directly in the general ledger. They can only be posted to indirectly using subsidiary ledgers. Now go back to the SAP Easy Access menu. 1-2-3 Creating G/L account lists Information system General ledger reports Master data G/L account list SAP minimal variant Field name or data type Company code Run report The name of the chart of accounts is in the third line of the report. CAUS Values 3000
Now go back to the SAP Easy Access menu. 1-2-4 Difference between chart of accounts and G/L account list The chart of accounts contains the definitions of accounts of a certain account structure. The G/L account list lists the company-code specific settings of the G/L accounts for a specific company code.
1-3 Financial statement versions Master records Individual processing In company code Field name or data type G/L account Company code Select the "Display" symbol Select the "Edit financial statement version" button. Field name or data type Financial statement version Continue Account 160000 is found in the financial statement version as follows: LIABILITIES Payables Accounts Payable Due within one year Now go back to the SAP Easy Access menu. Values INT Values 160000 1000
1-4 Creating a G/L account 1-4-1 Checking the chart of accounts Master records Individual processing In chart of accounts Field name or data type G/L account Chart of accounts Select the "Display" symbol The account should exist. Now go back to the SAP Easy Access menu. 1-4-2 Maintaining the company-code specific settings Master records Individual processing In company code Field name or data type G/L account Company code Values 700## 1000 Values 700## INT
Select the "Create with reference" symbol Field name or data type G/L account Company code Continue Values 70000 1000
Check that the default entries are correct and remove the alternative account number. Save the account. 1-4-3 Maintaining the financial statement version Master records Individual processing In company code Field name or data type G/L account Company code Select the "Change" symbol Select the "Edit financial statement version" button. Field name or data type Financial statement version Continue Select "Expand subtree" (second icon from the left on the pushbutton bar). The financial statement version is expanded completely. With the "Find" button, search for account 70000 (Ordinary Share Capital). The account is found under the financial statement item "Subscribed capital". Select "Subscribed capital" and choose the "Assign accounts" button. Insert the interval of 700## to 700##. Continue. Save the financial statement version. Now go back to the SAP Easy Access menu. Values INT Values 700## 1000
Solutions
Unit: G/L Accounting Topic: Daily accounting transaction in the general ledger
2-1 Posting an increase in capital Document entry G/L account posting Enter company code, if not already entered. If you do not need to enter a company code, then the company code has already been determined (set) at an earlier date. You can see which company code has been set by choosing Environment Set company code. Field name or data type Company code Continue Basic data: Field name or data type Document date Values Today's date Values 1000
Posting date Continue Basic data: Field name or data type Short text Continue
Today's date
Values Increase in capital ##
In the left column, select the "with business area" screen variant. 1. Item Field name or data type G/L account D/C Doc. currency amount Business area 2. Item Field name or data type G/L account D/C Doc. currency amount Business area Select the post button. Values 78200 Debit 200000 BA## Values 700## Credit 200000 BA##
Document Display PK: 40: 50: Posting key_______________________________________ Posting key for debit postings in general ledger Posting key for credit postings in general ledger________________
2-2 Account query 2-2-1 Balance display Account Display balances Field name or data type G/L account Company code Fiscal year Business area Execute You see a balance of 200000 UNI because you have limited the selection your own business area BA##. All other groups posted to different business areas. Since the transaction figures are kept per business area, you can view the account balance for your business area. To view the total balance for all business areas, choose "Other business area" and select "All business areas". 2-2-2 Line item display Values 78200 1000 Current year BA##
Double-click the balance of the current period. In the line item list, press "Choose display variant" in order to select a different display variant. 2-2-3 Document display Double-click the line item with business area BA##. You access the detail view of the item. Choose "Document overview" to access the document display. Now go back to the SAP Easy Access menu.
2-3 Complex/general posting Document entry Others General posting Field name or data type Document date Document type Company code Posting date Period Currency Posting Key Account Choose Enter Field name or data type Amount Values 200000 Values Today's date SA 1000 Today's date Current period UNI 40 78200
Business area Posting key Account Choose Continue Field name or data type Amount Business area Post
BA## 50 700##
Values 200000 BA##
2-4 Account balances 2-4-1 Creating G/L account balance lists Information system General ledger reports Balance lists General G/L account balances SAP minimal variant Field name or data type Company code Fiscal year Reporting periods Execute Scroll to account 78200 in the list. Values 1000 Current year Current posting period
Balance in business area BA##:
400000
Now go back to the SAP Easy Access menu. 2-4-2 Displaying structured balance lists Information system General ledger reports Balance lists General Structured account balances SAP minimal variant Field name or data type Company code Financial statement version Reporting year Reporting periods Execute Now go back to the SAP Easy Access menu. Values 1000 INT Current year Current posting period
Accounts Payable
Contents: Organizational Structures of Cost Accounting Master Data in Accounts Payable Daily Accounting Transactions in Accounts Payable Integration with Materials Management Closing Operations in Accounts Payable
SAP AG 1999
Accounts Payable: Unit Objectives
At the conclusion of this unit, you will be able to: Describe how accounts payable accounting is set up in the R/3 System Maintain and view vendor master data Complete accounting transactions within a period in Accounts Payable Describe how Accounts Payable is integrated with Materials Management Describe how SAP supports the financial statement preparations in Accounts Payable
SAP AG 1999
Overview Diagram: Accounts Payable
CO
FIBL
FITV
FIAA
MM
FIAP
FIGL
General Ledger
FIAR
SD
Balance Sheet ... P&L ... ...
SAP AG 1999
Presentation:
Organizational Structures of Cost Accounting

Controlling areas Country-specific charts of accounts Controlling objects
SAP AG 1999
Controlling Area
Controlling area
Chart of accounts
Company code A
SAP AG 1999
Company code B
Company code C
IDES Controlling Areas

6000 Mexico 1000 Europe 5000 Asia
6000 Mexico
2000 United Kingdom
2300 Spain
5000 Japan
3000 America
1000 Germany 2100 Portugal
France
2000
3000 USA
SAP AG 1999
4000 Canada
2200 France
Country-Specific Charts of Accounts

1000 Europe
INT
1000 Germany
2000 United Kingdom
2100 Portugal
2300 Spain
GKR
CAGB
CAES
SAP AG 1999
Group Chart of Accounts
1000 Europe
CONS
3000 America
INT
CAUS
1000 Germany
2000 England
2100 Portugal
2300 Spain
3000 USA
4000 Canada
SAP AG 1999
Cost Controlling Objects
Internal orders Cost objects Projects Networks Cost centers
Make-to-order sales orders
SAP AG 1999
Presentation:
Master Data in Accounts Payable

Account definitions and company codespecific settings Account groups
SAP AG 1999
Vendor Account in SAP FI

Vendor X General data Account definition at client level
PLUS
PLUS
Company codespecific settings
CC 1000
CC 2000
Vendor X in company code 1000

SAP AG 1999
Account Groups for Vendors
Vendor accounts
Vend.
Accounts Payable
000000-099999
100000-199999
Dom.
200000-299999
Company code data General data Purchasing organization data
For.
300000-399999
400000-499999
One-time
0001
500000-599999
Account groups
Account 001111
Vend.
000000-099999
...
600000-699999
unt Acco p grou
SAP AG 1999
Presentation:
Daily Accounting Transactions in Accounts Payable

Enjoy Invoice/Credit Memo Entry Recurring entries Manual and automatic outgoing payments
SAP AG 1999
Enjoy Invoice/Credit Memo Entry

Transaction Invoice/credit memo
Header and vendor data
Information area
Templates
G/L account items
SAP AG 1999
CO Account Assignment Logic
FI document Line items 001 Expense account Amount + True CO object (+ statistical CO objects) 002 Vendor Amount -
FI document # 1200000089
Expense account Amount Vendor Amount
CO document # 1000000009
True CO object Debit Cost element Amount
Statistical CO object Debit Cost element Amount
+ additional statistical objects

SAP AG 1999
The Recurring Entry Program

Template: Recurring entry original document First posting Last posting Next posting Interval in Months: Line items 001 40 Expense 002 50 Vendor 01.01.XX 12.01.XX 02.01.XX 1 1000 1000Batch input session Recurring entry program Settlement period: 02.01.XX - 02.29.XX
Actual posting Expense 1000 Vendor 1000
Next posting on 03.01.XX
SAP AG 1999
Elements of the Payment Transaction
Select payment method and bank Select items for payment
Expend. 10 Vendor 10 10
Calculate payment amount, taking account of cash discount periods
Post payment document
Print payment medium
Manual
SAP AG 1999
Automatic
Parameters
Run date Identification

Account Account Account C or V 10 ... 20 ...
03.01.XXXX AC200
Document
Items Document PK ... Items Document PK ... PK ... ... Line items PK ... PK ... ... PK ... ...
Status
Maintain parameters Parameters have been entered
SAP AG 1999
Proposal Run

03.01.XXXX AC200
Document
Status
Maintain parameters Parameters have been entered Start proposal run Payment proposal has been created
SAP AG 1999
Edit Proposal

03.01.XXXX AC200
Document
Status
Maintain parameters Parameters have been entered Start proposal run Payment proposal has been created Edit proposal Payment proposal has been edited
SAP AG 1999
Payment Run

03.01.XXXX AC200
Document
Status
Maintain parameters Parameters have been entered Start proposal run Payment proposal has been created Edit proposal Payment proposal has been edited Start payment run Posting orders: x generated, x completed Payment run has been carried out
Expenditure
X
Vendor
X
SAP AG 1999
Print Payment Media

03.01.XXXX AC200
Document
Status
Maintain parameters Parameters have been entered Start proposal run Payment proposal has been created Edit proposal Payment proposal has been edited
EDI
Start payment run Posting orders: x generated, x completed Payment run has been carried out Start printout
DME
SAP AG 1999
Integration with Materials Management

Plants Purchasing organizations MM view of the vendor master record Purchase order, goods receipt, invoice verification
Presentation: Presentation: Integration with Materials Management
SAP AG 1999
IDES Plants in Germany
CC 1000 IDES Germany
Plant 1000 Hamburg

SAP AG 1999
Plant 1100 Berlin
Plant 1200 Dresden
Plant 1300 Frankfurt
Plant 1400 Stuttgart
IDES Purchasing in Germany
Plant 1000 Hamburg
Plant 1100 Berlin
Plant 1200 Dresden
Plant 1300 Frankfurt
Plant 1400 Stuttgart
Purchasing organization 1000 purchases for...
Purchasing organization 1000 IDES Germany
Purchasing is posted in...
CC 1000 IDES Germany
SAP AG 1999
Purchasing Data in the Vendor Master Record

Vendor X General data
Account definition at client level
PLUS
PLUS
Purchasing organizationspecific settings

PO 1000
CC 1000

SAP AG 1999
Vendor X in purchasing organization 1000
Three-Stage Verification (Standard)

Goods receipt Purchase order MM
Purchase order Material document Goods receipt
Document
Line items Material GR/IR
Material stock or consumption

1
MM
Order amount
FI GR/IR
2 1
FI No document
Invoice receipt
Invoice verification document
Document
Line items GR/IR Vendor Tax
Vendor
2
MM
SAP AG 1999
FI
Presentation: Presentation: Closing Operations in Accounts Closing Operations in Accounts Payable
Payable
Overview: Accounts Payable closing operations Balance confirmations Foreign currency valuation Reclassification of payables
SAP AG 1999
Overview: Accounts Payable Closing Operations

Legal tasks Technical/organizational tasks
Start of new fiscal year
Run balance carry forward prog. Block posting periods for vendors Open special periods for vendors
Send balance confirmations Evaluate response Valuate foreign currencies Carry out reclassification
Reconciliation Documents - Trans. figures Affiliated companies
Close special periods for vendors
Time line
SAP AG 1999
Balance Confirmations
Accounting Balance confirmations Vendors
Letter Reply
Lists
Reply
Check list Results table
Checkpo int
SAP AG 1999
Foreign Currency Valuation

P&L
Expense from valuation
...
Balance Sheet (loc.crcy UNI)

Liabilities & equity - Payables 1000 UNI Payables 500 USD 1000 UNI Adjustment account
Vendor 500 USD 1000 UNI
SAP AG 1999
Foreign Currency Valuation

P&L
Expense from valuation
...
Balance Sheet (loc.crcy UNI)

Liabilities & equity
100 UNI
- Payables
1100 UNI Payables 500 USD 1000 UNI
Vendor 500 USD 1000 UNI

Valuation difference
Adjustment account 100 UNI
100 UNI
SAP AG 1999
Reclassify Payables
Assets ... - Receivables Vendors with debit balance
Balance Sheet
... - Payables
- with remaining term < 1 year
8000
Payables 1000 2000 RT < 1 yr 3000 RT 1-5 yr 4000 RT > 5 yr
Adjustment
- with remaining term 1-5 years RT 1-5 years
- with remaining term >5 years RT >5 years
SAP AG 1999
Reclassify Payables
Assets ... - Receivables Vendors with debit balance 1000
Balance Sheet
... - Payables
9000
Adjustment 1000
SAP AG 1999
Reclassify Payables
Balance Sheet
... - Payables
6000
Adjustment 3000 1000
3000
3000
SAP AG 1999
Reclassify Payables
Balance Sheet
... - Payables
2000
Adjustment 3000 1000 4000

3000
3000
- with remaining term >5 years RT >5 years 4000
4000
SAP AG 1999
Self-Study: Vendor Master Data in FI
At the conclusion of this unit, you will be able to: Create the list of vendors Maintain vendor master data in FI
SAP AG 1999
Vendor master data - Exercises

Unit: Accounts Payable Topic: Vendor Master Data
At the conclusion of these exercises, you will be able to: Create the list of vendors Create and maintain a vendor master record
Accounting transactions involving vendors are recorded in the accounts payable subledger. The accounts are divided up into account groups so that the large number of vendors can be organized more easily.
To access Accounts Payable: Accounting Financial accounting Accounts payable
1-1 Creating a vendor list You wish to have the system create an overview of the existing vendor master data by listing this data. You are particularly interested in the accounts in account group KRED. Information system Reports for Accounts Payable Accounting Master data Vendor List
1-1-1 Create the whole vendor list Create a list of all vendors in the company code 1000. 1-1-2 Create a list for an account group Use a dynamic selection to create a list of all vendors in account group KRED. Now go back to the SAP Easy Access menu.
1-2 Maintaining a vendor master record IDES Germany is expecting a foreign employee to arrive next month who will be spending a year in Germany. A real estate agency is helping IDES to find an apartment for the employee. The rental agreement has been signed, and the accounting department now has to create a master record for the landlord that can be used for making the monthly rental payments and monitoring them. 1-2-1 Create a master record In company code 1000, create the master record VMIETER## for the landlord. The master record should belong to account group VEND. IDES has created a reference account for each account group so that master data can be entered as easily and accurately as possible. The reference account for the account group VEND is AGENCY00. Select the search term AC010 and make up a name and address for the vendor. Enter a complete address, including a street name, since this is needed to successfully run the payment program in a future exercise. Accept all the values that are copied from the reference account as default values except for the payment terms, which should be changed to 0001 or ZB00. Master records Create Now go back to the SAP Easy Access menu.
1-2-2 Maintain the master record Go to the change display for the master record you have just created. Where is the reconciliation account found, and what number does it have? __________________________________________________________ Check the terms of payment. According to the rental agreement, the rent is always to be paid immediately and without cash discount. Which terms of payment could you use? Enter one of these in the master record. _________________________________________________________ The landlord wishes to receive the rental payment by check. Define the appropriate payment methods. Master records Change Now go back to the SAP Easy Access menu.
Self-Study: Accounting Transactions Within a Period
At the conclusion of this unit, you will be able to: Post vendor invoices in FI Create a recurring entry document and generate recurring entries Post an outgoing payment manually and print a check Carry out automatic payments Monitor vendor accounts
SAP AG 1999
Business Transactions - Exercises

Unit: Accounts Payable Topic: Accounting transactions within a period in Accounts Payable
At the conclusion of these exercises, you will be able to: Post a vendor invoice Post a manual outgoing payment and print a check Create a recurring entry document and generate recurring entries Carry out automatic payment IDES uses R/3 as an integrated system, and so the open vendor items normally arrive in Accounts Payable via invoice verification in Materials Management (MM). Vendor invoices are only posted directly in Accounts Payable in exceptional cases, such as the previous rent scenario.
2-1 Posting a vendor invoice and checking the posting The real estate agency charges a commission of 4400 UNI for finding the apartment, including 10% input tax (tax code 1I), that is 400 UNI. As IDES has often used the services of this real estate agency, a master record already exists for it. The
number of the master record is AGENCY##. The commission invoice has the previous day as the invoice date and was sent directly to the accounting department, without going via invoice verification in MM. The invoice contains the invoice number 1##. 2-1-1 Post the invoice Post the invoice to your cost center CC##. Use the "With cost center" entry variant. Use G/L account 470000 as the offsetting account. Enter the invoice number in the Reference field and enter Real estate commission group ## as the text. Write down the accounting document number: _________________________________________________________ Document entry Invoice Now go back to the SAP Easy Access menu. 2-1-2 Check the vendor account Use the balance display to check whether an open item was created for the vendor account when your document was posted. Identify the open item that was generated by your document. View this document in the document overview. Although you only entered two items (a vendor item and an expense item), the displayed document also contains a third item. What sort of item is it, and how was it generated? _________________________________________________________ _________________________________________________________ _________________________________________________________ Account Display balances Now go back to the SAP Easy Access menu.
2-1-3 Check the reconciliation account Which reconciliation account is defined in the master record of the vendor AGENCY ##? Reconciliation account: ________________________________________ Master records Display Check whether the amount has been posted to the reconciliation account in the General Ledger. To do so, limit the balance display to your business area, BA##. G/L Accounting: Account Display balances Now go back to the SAP Easy Access menu.
2-2 Creating recurring entries The rent is 2000 UNI a month (input tax is 0%, tax code 0I), and is due on the 1st of every month. The rental payments should start next month. The rental agreement has the number 0815 and is valid for exactly one year, since the employee will then return to his native country. To ensure that the posting and payment of the open rent item is not forgotten, the open item should be generated automatically. 2-2-1 Create a recurring entry document Create a recurring entry document for the rent payable. The document should be document type KR. Enter Contract 0815 as the reference. You have already created the vendor account VMIETER## for the landlord. Use the text edit format RENT for the item text. The offsetting entry is made to account 470000 (occupancy costs). The employee works for cost center CC##. Debit the rent to this account. Which posting key should you use for these items? __________________________________________________________ __________________________________________________________
Document entry Reference documents Recurring document Now go back to the SAP Easy Access menu. 2-2-2 Start the recurring entry program The recurring entry program must be run once a month so that actual documents are generated from the monthly recurring entry documents. Start the recurring entry program. To assist you with the entries on the selection screen, report variant AC010 was created. Use this variant and replace ## with your group number. Enter the 1st of the next month as the settlement period. It is important that you use only the recurring entry documents for your own user, AC010##, so that each group can carry out its own recurring entries.
Periodic processing Recurring entries Execute Now go back to the SAP Easy Access menu. 2-2-3 Process batch input session The recurring entry program generates a batch input session that has to be processed so that the actual documents are posted. Have the system process the batch input session in the foreground so that you can see how batch input processing works. The batch input session would normally be much larger (depending on the number of recurring entry documents), and would then be processed in the background.
Warning: Process only the session that you have created yourself.
System Services Batch input Sessions Now go back to the SAP Easy Access menu. 2-2-4 Check the vendor account Check whether the batch input session has generated an open item for the rent payable. Account Display balances Now go back to the SAP Easy Access menu.
2-3 Manual outgoing payment with check printing The real estate agency, AGENCY##, requires the money urgently, and asks the accounting department to make the payment quickly. 2-3-1 Post the outgoing payment Post a manual outgoing payment with simultaneous check printing. The payment is to be made via house bank 1000. Enter LP01 as the printer. Have the system calculate the payment amount. Use either payment method S (non-prenumbered checks) or payment method C (prenumbered checks). For payment method C, use check lot 1. This indicates a lot of prenumbered check forms that are already in the printer. Your trainer will tell you which payment method you should use.
Write down the number of the payment document: ______________________________________________________ Document entry Outgoing payment Post + print forms Now go back to the SAP Easy Access menu. 2-3-2 Check the vendor account Check whether the outgoing payment has cleared the original open item, and write down how much cash discount was calculated and posted. Cash discount: _________________________________________________ Account Display balances Now go back to the SAP Easy Access menu.
2-4 Automatic payment IDES has the system run the payment program once a week. The rent is paid automatically by the payment program at the beginning of the next month, together with all the other open vendor items. Periodic processing Payments 2-4-1 Create a payment run and maintain the parameters Create your own payment run with the 1st of the next month as the Run date, and your business area, BA##, as the identification. Maintain the payment run parameters so that the payment run selects all documents that have been entered up until today for your landlords account, VMIETER-##, in company code 1000. Any payments in this run should be made by
check (payment method S) and posted on the 1st of the next month. You must enter the posting date of the next payment run so that the system can decide whether the payment has to be made in this payment run, or whether it could wait until the next payment run. The next payment run is a week after the posting date. IDES normally has the system include all vendors in the payment run, of course, and also specifies all payment methods that are used. For test purposes, it is sensible to activate the additional log so that any errors that occur can be more easily traced. Activate the additional log for your payment run.
2-4-2 Schedule the payment proposal Have the system start generating the payment proposal by scheduling the proposal to start immediately. IDES usually schedules the payment proposal to be processed in the background at times when the system is less busy (at night, for example). Keep updating the status until a message is displayed to tell you that the payment proposal has been created. 2-4-3 Edit the proposal Accounts Payable clerks print out the payment proposal and check the payments before the actual payment run takes place. This prevents any incorrect payments being made. If necessary, you can then edit the payment proposal by editing the exception list, removing items from the payment run, or changing payments. Have the system display the payment proposal on the screen. If no payments are displayed on the screen, or only the exception list is displayed, you have made an error somewhere. Look at the proposal log (Edit Proposal Display log) and see if you can find the error. Delete the payment proposal (Edit Proposal Delete) and remove the error. Then restart the payment proposal. Repeat this process until payments are displayed in the proposal.
2-4-4 Schedule the payment run After the payment proposal has been checked and accepted as correct, the actual payment run is started, which posts the payments. Start the payment run by scheduling it to start immediately. IDES usually schedules the payment run in the same way as the payment proposal, to be processed in the background at times when the system is less busy. Keep updating the status until a message is displayed to tell you that the payment run has been executed and all postings created. 2-4-5 Print payments You need to define variants for the print programs before the payment media and payment advice notes can be printed. Since payments can only be made by check in this payment run, you only need to define a variant for the appropriate print program, RFFOD__S. Use the SCHECK variant that has already been set up. Schedule the printing to start immediately on printer LP01. Go to the output controller to view the automatically-created check. System Services Output controller Now go back to the SAP Easy Access menu. 2-4-6 Check the vendor account Check whether the automatic payment run has cleared the original open item. Account Display balances Now go back to the SAP Easy Access menu.
2-5 Due date analysis
To gain an overview of the open items that are due in the future, you can display a drilldown report for due date analysis. Carry out this report for company code 1000. Select the graphical report output. Drilldown reporting is another SAP reporting tool, in addition to the classic ABAP reports, SAP Query, and the Accounts Receivable/Accounts Payable Information System.
Now go back to the SAP Easy Access menu. Information system Reports for Accounts Payable Accounting Vendors: Items Due Date Analysis for Open Items
Self-Study: Integration with Materials Management
At the conclusion of this unit, you will be able to: Describe and carry out a simple procurement process in MM, and explain its effects on Financial Accounting
SAP AG 1999
Integration - Exercises
Unit: Accounts Payable Topic: Integration with R/3 MM
At the conclusion of these exercises, you will be able to: Create a purchase order Post a goods receipt Carry out an invoice verification Follow the purchase order history Vendor invoices are not usually posted directly in FI, but are posted to Accounts Payable from invoice verification in MM. A purchase order and a goods receipt precede an incoming invoice in a usual procurement process.
To access Purchasing: Logistics Materials Management Purchasing
3-1 Carrying out a procurement process Your cost center needs a flat screen and has already created a purchase requisition for one. This now has to be processed in the responsible purchasing organization.
3-1-1 Create a purchase order The responsible purchasing group, Corporate Purchasing, in the purchasing organization IDES Germany has to create a purchase order from the purchase requisition. IDES frequently buys flat screens from Blacks AG (account 1006). Create the purchase order. To do so, choose the selection variant Purchase requisitions in the purchase order transaction. The purchase requisition contains a number of line items. Select the correct line item using the requirement tracking number ##, and then move the displayed purchase order to the shopping basket. Complete and post the purchase order. Check whether a flat screen has actually been ordered and that the cost center CC## and the business area BA## have been debited for it. Write down the purchase order number. ______________________________________________________ Now go back to the SAP Easy Access menu. Purchase order Create Vendor/supplying plant known 3-1-2 Post a goods receipt Three days later, the flat screen arrives. Post the goods receipt using movement type 101 (goods receipt for purchase order into warehouse/stores). The purchase order number noted above is on the accompanying delivery note. Write down the goods receipt document number: ______________________________________________________ Now go back to the SAP Easy Access menu.
Purchase order Follow-on functions Goods receipt 3-1-3 Carry out invoice verification A day later, the invoice arrives by mail. The invoice refers to your purchase order and is for 8120 UNI, including 1120 UNI input tax (16%). Carry out the invoice verification. Write down the invoice receipt document number: ______________________________________________________ Now go back to the SAP Easy Access menu. Purchase order Follow-on functions Logistics invoice verification 3-1-4 Display purchase order history and follow-on documents Display your purchase order again and check the purchase order history (tab in the item). First go to the goods receipt document. From here, go to the accounting document that posted the consumption. What information does the posting record contain? ______________________________________________________ ______________________________________________________ Go back to the purchase order. Now go to the invoice receipt document. From here, go to the accounting document that has generated an open item in the vendor account. What information does the posting record contain? __________________________________________________________ __________________________________________________________
Go back to the purchase order. Purchase order Display
Self-Study: Accounts Payable Closing Operations
At the conclusion of this unit, you will be able to: Print balance confirmations
SAP AG 1999
Closing and Reporting - Exercises

Unit: Accounts Payable Topic: Closing operations in Accounts Payable
At the conclusion of these exercises, you will be able to: Print balance confirmations Valuate open items in foreign currency (optional) Regroup payables by remaining term (optional) Depending on legal requirements, various procedures need to be completed in the subsidiary ledgers before financial statements can be created in the general ledger.
To access Accounts Payable: Accounting Financial accounting Accounts payable For the purposes of the following exercises, we will assume that the closing procedures have already been completed for the previous month.
4-1 Print balance confirmations Print a balance confirmation for vendor 1000.
To assist you with the entries in the selection screen, report variant AC010 was created. What is the reconciliation key date for the balance confirmation? ___________________________ By which date does IDES expect to have the balance confirmations returned by the vendors? ___________________________ View the balance confirmation in the output control. Periodic processing Closing Check/count Balance confirmations: Print A balance confirmation would not normally be sent for month-end closing. We will only do so here as a learning exercise.
4-2 Foreign currency valuation (optional) Vendors abroad often create their invoices in the currency of their own country. If this currency is not the same as the company code currency, the system treats it as a foreign currency and translates it into local currency using a defined exchange rate. When the financial statement is prepared, the open items in foreign currency have to be revaluated according to countryspecific requirements because the exchange rate may have changed since the open items were created. 4-2-1 Post a foreign currency invoice The accounting department discovers an invoice from the vendor AGENCY## that has not yet been posted. It is dated from the 15th of the previous month. Fortunately, the last posting period is still open, so the invoice can still be posted in this period before the month-end closing is carried out. It is an invoice in foreign currency, without any tax on sales/purchases (tax code 0I). Post the invoice with the number 2## (reference) for 5000 USD on the last day of the previous month. Use account 470000 as the offsetting account. Use tax code 0I. Use the entry variant With cost center to post the cost to your cost center, CC##.
Before posting the document, select the tab Local currency. Here you will find the amount translated into local currency. Round this amount to the nearest thousand for this exercise. Repeat this action in the line item by double-clicking on it. Document entry Invoice Write down the accounting document number: _________________________________________________________ Now go back to the SAP Easy Access menu. 4-2-2 Carry out foreign currency valuation Carry out the foreign currency valuation for the vendor account AGENCY## only. To assist you with the entries in the selection screen, report variant AC010 was created. Use this variant and replace ## with your group number. On which key date is the valuation carried out? ___________________________ Run the batch input session in the foreground. Now go back to the SAP Easy Access menu. IDES runs the valuation report for all accounts simultaneously, of course. Since this valuation does not form a part of the legal year-end closing, the valuations are not noted in the documents, and the postings will be
reversed on the 1st of the next period. Periodic processing Closing Valuate Open items in foreign country
4-3 Regroup payables (optional) Many governments require that payables (and receivables) be ordered according to remaining term. In Europe, for example, accounting convention 93 requires this classification, and the standard SAP System provides the necessary sorted list. 4-3-1 Post an invoice with remaining term of 2 years Post an invoice with the number 3## (reference) for 6000 UNI for vendor AGENCY##. Use account 470000 as the offsetting account. Use tax code 0I. The invoice and posting dates are both the 15th of the previous month. Use the entry variant With cost center to post the cost to your cost center, CC##. Before posting the document, select the tab Payment. You will find the terms of payment here, as well as other information. Change the terms of payment to ZB99. These terms of payment have been defined with a term of 24 months. Write down the accounting document number: _________________________________________ Now go back to the SAP Easy Access menu. Document entry Invoice 4-3-2 Carry out regrouping Carry out the regrouping by remaining term. To assist you with the entries in the selection screen, report variant AC010 was created. Use this variant and replace ## with your group number on all tab pages.
What is the reconciliation key date for the regrouping? ___________________________ On which document date is the regrouping canceled? ___________________________ Run the batch input session in the foreground. Now go back to the SAP Easy Access menu. Periodic processing Closing Regroup Receivables/payables 4-3-2 Check the regrouping Go to the balance display for account 160020 in business area BA##. This is the balance sheet account that is configured to record payables with a remaining term of 1 to five years. What do the transaction figures show? Now go back to the SAP Easy Access menu. G/L Accounting: Account Display balances
Unit Summary
You are now able to: Describe how accounts payable accounting is set up in the R/3 System Maintain and view vendor master data Complete accounting transactions within a period in Accounts Payable Describe how Accounts Payable is integrated with Materials Management Describe how SAP supports the financial statement preparations in Accounts Payable
SAP AG 1999
Accounts Payable - Solutions

Unit: Accounts Payable Topic: Vendor Master Data
1-1 Creating a vendor list Information system Reports for Accounts Payable Accounting Master data Vendor List 1-1-1 Create the whole vendor list Field name or data type Company code Execute 1-1-2 Create a list for an account group Field name or data type Company code Choose Dynamic selections. Values 1000 Values 1000
In the hierarchy structure on the left side of the screen, select Account group and choose Adopt selected item to include the field in the dynamic selections. Field name or data type Account group Save Execute Now go back to the SAP Easy Access menu. Values KRED
1-2 Maintaining a vendor master record 1-2-1 Create a master record Master records Create Field name or data type Vendor Company code Account group Reference Vendor Company code Continue 1st Screen: Address AGENCY00 1000 Values VMIETER## 1000 VEND
Field name or data type Search term Other fields Continue 2nd Screen: Control Leave all fields blank. Continue
Values AC010 Any -- enter a complete address
3rd Screen: Payment transactions Leave all fields blank. Continue 4th Screen: Accounting information Accounting The displayed data was copied from the reference vendor. Do not change the data. Continue 5th Screen: Payment transactions Accounting The displayed data was copied from the reference vendor. Do not change the data. Continue 6th Screen: Correspondence Accounting The displayed data was copied from the reference vendor. Do not change the data. Save
Now go back to the SAP Easy Access menu. 1-2-2 Maintain the master record Master records Change Field name or data type Vendor Company code Company code data Accounting info Company code data Payment transactions Continue Accounting information Accounting screen: The reconciliation account is 160000. Continue Payment transactions Accounting screen: 0001 or ZB00 should be entered as the payment terms. Payment methods: Save Now go back to the SAP Easy Access menu. Confirm that C and S are entered. Values VMIETER## 1000 Select Select
Solutions
Unit: Accounts Payable Topic: Accounting transactions within a period in Accounts Payable
2-1 Posting a vendor invoice and checking the posting 2-1-1 Post an invoice Document entry Invoice Enter company code, if not already entered. Field name or data type Company code Continue Basic data Field name or data type Vendor Values AGENCY## Values 1000
Continue Basic data Field name or data type Invoice date Posting date Continue The master record of the vendor is displayed on the upper right hand side of the screen. Basic data Field name or data type Amount Tax amount Reference Text Values 4400 400 (10% input tax, code 1I) 1## Real estate commission group ## Values Yesterdays date Todays date
In the left column, select the "with cost center" screen variant. Line items Field name or data type G/L account D/C Doc. currency amount Tax code Values 470000 Debit 4000 1I
Cost center Post by choosing the Save icon.
CC##
Write down the accounting document number. Now go back to the SAP Easy Access menu. 2-1-2 Check the vendor account Account Display balances Field name or data type Vendor Company code Fiscal year Execute Double-click on the balance of the current month. A list of open items appears. Use the document number you wrote down to identify your document. Double-click on this line item, and then choose the document overview. An input tax item has been automatically generated. The tax code you entered determines which account the tax is posted to. Now go back to the SAP Easy Access menu. 2-1-3 Check the reconciliation account Values AGENCY## 1000 Current year
Master records Display Field name or data type Vendor Company code Values AGENCY## 1000
The reconciliation account is found on the Payment transactions Accounting screen. In this case, it has the number 160000. G/L Accounting: Account Display balances Field name or data type G/L account Company code Fiscal year Business area Execute Now go back to the SAP Easy Access menu. Values 160000 1000 Current year BA##
2-2 Creating recurring entries 2-2-1 Create a recurring entry document Document entry Reference documents Recurring document Enter Recurring Entry: Header Data
Field name or data type First run on Last run on Interval in months Run date Document type Reference Posting key (PstKy) Account Continue Field name or data type Amount Payment terms Text Posting key (PstKy) Account Continue Field name or data type Amount Tax code Cost center Save
Values 1st of the next month 1st of the preceding month of next year 1 1 KR Contract 0815 31 VMIETER##
Values 2000 ZB00 =RENT 40 470000
Values 2000 0I (0% input tax) CC##
Now go back to the SAP Easy Access menu. 2-2-2 Start the recurring entry program Periodic processing Recurring entries Execute Goto Variants Get... Select variant "AC010". The displayed variant should contain the following data: Field name or data type Company code Settlement period User Batch input session name User name Execute A message should appear in the status bar, informing you that session SAPF120-## has been created. If this message does not appear, one of the following has happened: The recurring entry original document was not created correctly Your selections for the recurring entry program were incorrect Another group has generated your recurring entry Values 1000 1st of the next month AC010-## SAPF120-## AC010-##
Replace ## with your group number.
Now go back to the SAP Easy Access menu. 2-2-3 Process batch input session System Services Batch input Sessions On the overview screen, select the session SAPF120-## and enter your user, AC010-##, in the Created by field. Choose Process. Select the run mode Visible, choose process in the dialog box. Now observe how the system enters values from the session on a sequence of screens. Accept each screen by choosing Continue (enter). Now go back to the SAP Easy Access menu. 2-2-4 Check the vendor account in A/P Account Display balances Field name or data type Vendor Company code Fiscal year Execute You should see a balance of 2200 UNI. Double-click on the balance of the current month. The automatically-generated rent item is displayed. Double-click on this item to reach the line item itself, and then choose the document header pushbutton (the hat) to display the document header. The document header dialog box contains a reference to the recurring entry document. Values VMIETER## 1000 Current year
2-3 Manual outgoing payment with check printing 2-3-1 Post the outgoing payment Document entry Outgoing payment Post + print forms Payment with Printout: Header Data Field name or data type Company code Payment method If payment method C is used: Check lot number House bank Printer for forms Calculate payment amount Recipients lang. Choose Enter payments. Field name or data type Vendor Adopt all of the other data. Choose Process open items. Deselect all items except the item with your own business area, BA##, or the document number you wrote down. Values AGENCY## Values 1000 S or C (ask instructor) 1 1000 LP01 Selected Selected
Post. Write down your document number. Confirm information. Choose "Check" or "International Check". Place the cursor on the correct spool file. Choose Display contents (eye glasses) the check is displayed and can be printed from the printer that is installed. Now go back to the SAP Easy Access menu. 2-3-2 Check the vendor account Account Display balances Field name or data type Vendor Company code Fiscal year Execute Double-click on the balance of the current month. The original open item has been cleared and a payment item with the number you wrote down has been added. Double-click on the payment item and go to the document display from here. In the document, you will see the item for posting the cash discount received. Because the vendor AGENCY ## grants 3% cash discount for payment made within 14 days, you receive a cash discount of 120 UNI on your payment of 4000 UNI. 12 UNI are posted to the input tax account as a tax on sales/purchases correction. Now go back to the SAP Easy Access menu. Values AGENCY## 1000 Current year
2-4 Automatic payment 2-4-1 Create a payment run and maintain the parameters Periodic processing Payments Field name or data type Run date Identification Continue (enter) The status of the new payment run is: No parameters entered as yet. Choose the tab Parameter: Field name or data type Posting date Documents entered up to Company codes Payment methods Next posting date Vendor Save Choose the tab Additional log. Field name or data type Due date check Values Select (first box) Values 1st of the next month Tomorrow's date 1000 S One week after the posting date VMIETER## Values 1st of the next month BA##
Payment method selection in all cases Line items of the payment documents Vendors Save Go back to the tab Status. 2-4-2 Schedule the payment proposal Choose Schedule proposal. Select Start immediately. Continue
Select (second box)t Select (fourth box) VMIETER##
Keep updating the status until a message is displayed to tell you that the payment proposal has been created. 2-4-3 Edit the proposal Choose Display proposal. If no payments are displayed on the screen, you have made an error somewhere. Look at the proposal log (Edit Proposal Display log) and see if you can find the error. Delete the payment proposal (Edit Proposal Delete) and remove the error. Then restart the payment proposal. Repeat this process until payments are displayed in the proposal. 2-4-4 Schedule the payment run Choose Schedule payment run.
Select Start immediately. Continue Keep updating the status until a message is displayed to tell you that the payment run has been executed and all postings created. 2-4-5 Print payments Choose the tab Printout/data medium. Field name or data type Variant for RFFOD__S Save Go back to the tab Status. Choose Schedule print. Select Start immediately. Replace the ? in the Job name field with an identification of your choice. Continue System Services Output controller Field name or data type Created by Execute Select the spool request for the check and view it (by choosing the glasses). Now go back to the SAP Easy Access menu. Values AC010-## Values SCHECK
2-4-6 Check the vendor account Account Display balances Field name or data type Vendor Company code Fiscal year Execute Double-click on the balance of the current month. The original open item has now been cleared and a payment item has been created. Now go back to the SAP Easy Access menu. Values VMIETER## 1000 Current year
2-5 Due date analysis Information system Reports for Accounts Payable Accounting Vendors: Items Due Date Analysis for Open Items Field name or data type Company code Open items at key date Graphical report-output Execute At the bottom of the screen, you see all the due and non-due items ordered by days. Values 1000 Todays date Selected
The column on the left contains the characteristics you can use to restrict the display. If you select the characteristic Vendor, for example, a list of all vendors and the totals of each of their due and non-due open items is displayed on the right. By selecting a vendor, you can limit the day period split on the bottom part of the screen to this one vendor. Now go back to the SAP Easy Access menu.
Solutions
Unit: Accounts Payable Topic: Integration with R/3 MM
To access Purchasing: Logistics Materials Management Purchasing
3-1 Carrying out a procurement process 3-1-1 Create a purchase order Purchase order Create Vendor/supplying plant known If documentation about the ENJOY ordering transaction appears on the left side of the screen, you can close it by choosing the Close pushbutton. Display the document overview by choosing the Document overview on pushbutton. In the document overview, choose the selection variant Purchase requisitions (on the far left of the pull-down menu). Field name or data type Values
Requirement tracking number Execute
##
A purchase requisition is displayed in the document overview. Select this purchase requisition and drag it to the shopping basket. The data from the purchase requisition is automatically transferred to the purchase order. Complete the purchase order header with the following data. Field name or data type Purchase organization Purchasing group Vendor Values IDES Deutschland (Germany) Corporate Purchasing (100) 1006 (located above the tabs)
To display the items, choose the pushbutton next to Item overview. Select the item and choose Select purchase order item. You can check the account assignment on the Account assignment tab page. Save Write down the purchase order number; you will need this number later. Now go back to the SAP Easy Access menu. 3-1-2 Post a goods receipt Purchase order Follow-on functions Goods receipt Field name or data type Document and posting date Movement type Values Todays date + 3 days 101
Order Continue (Enter).
Your purchase order number
Confirm any messages with Continue. The goods receipt items are displayed. Post (choose Save icon). Write down your goods receipt document number. Now go back to the SAP Easy Access menu. 3-1-3 Carry out invoice verification Purchase order Follow-on functions Logistics invoice verification Field name or data type Document and posting date Values Todays date +4 days last day of month; that is, do not use a day in the next month 8120 1120 (16% domestic input tax) Your purchase order number
Amount Tax amount Purchase order Continue (Enter).
The purchase order items are displayed. Save Write down the invoice receipt document number.
Now go back to the SAP Easy Access menu. 3-1-4 Display purchase order history and follow-on documents Purchase order Display The purchase order is displayed. Expand the item details icon in the lower part of the screen. In the item details, choose the tab Purchase order history. Choose the goods receipt document number. Choose the tab Document info. Choose FI documents. Choose Accounting document. The posting record is: OEM products consumed Go back to the purchase order. Choose the invoice receipt document number. Choose the Follow-on documents button. Choose Accounting document. The posting record is: GR/IR clearing account 7000 Input tax Blacks AG81201120 7000 GR/IR clearing account Goods Rcvd/Invoice Rcvd 7000-
Solutions
Unit: Accounts Payable Topic: Closing operations in Accounts Payable
4-1 Print balance confirmations Periodic processing Closing Check/count Balance confirmations: Print Goto Variants Get... Select variant AC010. Execute The balance confirmation is displayed. Scroll down the screen to display the other sections (including the reply print preview). Note: The subsequent lists can be sent to the output control by selecting the printer symbol. Do not print them during this exercise. Choose the green arrow to go back. The check list is displayed.
Choose the green arrow to go back. The results list is displayed. Choose the green arrow to go back. The selection criteria for the program are displayed. Now go back to the SAP Easy Access menu.
4-2 Foreign currency valuation (optional) 4-2-1 Post a foreign currency invoice Document entry Invoice Enter company code, if not already entered. Field name or data type Company code Continue Basic data Field name or data type Vendor Continue Basic data Values AGENCY## Values 1000
Field name or data type Invoice date Posting date Continue
Values 15th of the previous month Last day of the previous month
A warning appears, informing you that a posting is being made to the previous period. Confirm this message by pressing Enter. The master record of the vendor is displayed on the upper right hand side of the screen. Basic data Field name or data type Amount Tax amount Reference Values 5000 USD 0 (tax code 0I no input tax) 2##
In the left column, select the "with cost center" entry variant. Line items Field name or data type G/L account D/C Doc. currency amount Tax code Cost center Choose the tab Local currency. Values 470000 Debit 5000 0I CC##
Field name or data type Amount in local currency
Values Round to the nearest thousand
Double-click on the amount in the G/L account line item. Field name or data type Amount in local currency Values Round to the nearest thousand
Note: You round off the amount payable here so that a valuation difference exists for the foreign currency valuation in the next step. Back Post Write down the accounting document number. Now go back to the SAP Easy Access menu. 4-2-2 Carry out foreign currency valuation Periodic processing Closing Valuate Open items in foreign country Goto Variants Get... Select variant AC010. Replace ## with your group number on all tab pages. Execute
A list of all items to be valuated appears. Choose Postings. The two documents (valuation and reverse document) are displayed in list format. System Services Batch input Sessions Select the session SAPF100-##. Choose Process. Choose Process. Confirm the following screens by pressing ENTER until the session has finished running. Now go back to the SAP Easy Access menu.
4-3 Regroup payables (optional) 4-3-1 Post an invoice with remaining term of more than 2 years Document entry Invoice Enter company code, if not already entered. Field name or data type Company code Continue Basic data Field name or data type Vendor Values AGENCY## Values 1000
Continue Basic data Field name or data type Invoice date Posting date Continue A warning appears, informing you that a posting is being made to the previous period. Confirm this message by pressing Enter. The master record of the vendor is displayed on the upper right hand side of the screen. Basic data Field name or data type Amount Tax amount Reference Values 6000 UNI 0 (tax code 0I no input tax) 3## Values 15th of the previous month 15th of the previous month
In the left column, select the "with cost center" entry variant. Line items Field name or data type G/L account D/C Doc. currency amount Tax code Cost center Values 470000 Debit 6000 0I CC##
Choose the tab Payment. Field name or data type Terms of payment Post. Confirm any warning messages by pressing enter. Write down the accounting document number. Now go back to the SAP Easy Access menu. 4-3-2 Carry out regrouping Periodic processing Closing Regroup Receivables/payables Goto Variants Get... Select variant AC010. On all tab pages, replace ## with your group number. Execute A list of all items to be regrouped appears. Choose Postings. The two documents (regrouping and reverse document) are displayed in list format. Menu: Values ZB99
System Services Batch input Sessions Select the session SAPF101-##. Choose Process. Choose Process. Confirm the following screens by pressing ENTER until the session has finished running. Now go back to the SAP Easy Access menu. 4-3-3 Check the regrouping G/L Accounting: Account Display balances Field name or data type G/L account Company code Fiscal year Business area Execute The transaction figures show that 6000 UNI were posted to this account for the last period. This is your regrouping for the purpose of creating the financial statement. You can also see that the 6000 UNI were charged off again in the current period. Now go back to the SAP Easy Access menu. Values 160020 1000 1999 BA##
Accounts Receivable
Contents:
Organizational Structures of Revenue Controlling Master Data in Accounts Receivable Daily Accounting Transactions in Accounts Receivable Integration with Sales and Distribution Credit Management Closing Operations in Accounts Receivable
SAP AG 1999
Accounts Receivable: Unit Objectives
At the conclusion of this unit, you will be able to: Describe how accounts receivable accounting is set up in the R/3 System Maintain and view customer master data Complete accounting transactions within a period in Accounts Receivable Describe how Accounts Receivable is integrated with Sales and Distribution Use the functions of credit management Describe how SAP supports the financial statement preparations in Accounts Receivable
SAP AG 1999
Overview Diagram: Accounts Receivable
CO
FIBL
FITV
FIAA
MM
FIAP
FIGL
General Ledger
FIAR
SD
Balance Sheet ... P&L ... ...
SAP AG 1999
Accounts Receivable: Business Scenario
Accounting transactions concerning customers are broken down in Accounts Receivable. Here, the open customer items are managed, monitored, and processed in special customer accounts. Open items can either be posted directly in FI or integrated via Sales and Distribution. The IDES credit department monitors whether customers stay within their credit limits. For financial statement preparation, the open customer items have to be confirmed with selected customers and regrouped.
SAP AG 1999
Presentation: Presentation: The Organizational Structures of The Organizational Structures of Sales Revenue Controlling
Revenue Controlling
Operating concern Profitability segments
SAP AG 1999
Operating Concern
Operating Concern
Co sts
Controlling area
Controlling area
nu ve Re e
Company code
SAP AG 1999
Profitability Segments
Profitability analysis for profitability segment
Divisions
Distribution channels
Characteristics
SAP AG 1999
Co u
Profitability segment
nt ri e s
Master Data in Accounts Receivable

Account definitions and company code-specific settings Account groups
Presentation: Presentation: Master Data in Accounts Receivable
SAP AG 1999
Customer Account in SAP FI

Customer X General Data
PLUS
PLUS
CC 1000
CC 2000
Customer X in company code 1000

SAP AG 1999
Account Groups for Customers
Customer accounts
Accounts Receivable
Cust C
000000-099999 100000-199999
Dom.
200000-299999
Company code data General data Sales area data
For.
300000-399999
400000-499999
One-time
0001
500000-599999
Account groups
Account 001111
...
600000-699999
Cust
000000-099999
un Acco p grou
SAP AG 1999
Presentation: Presentation: Daily Accounting Transactions in Daily Accounting Transactions in Accounts Receivable
Accounts Receivable
Invoices, credit memos Payment differences Automatic dunning Correspondence
SAP AG 1999
Enjoy Invoice/Credit Memo Entry

Transaction Invoice/credit memo
Header and customer data
Information area
Templates
G/L account items
SAP AG 1999
Incoming Payments
Complete payment
Minor payment difference
Greater payment difference
Post partial payment Customer 8000 5000 Partial payment Residual item
Generate residual item Customer 8000 3000 5000
Invoice reference to open item

SAP AG 1999
Dunning Functions
Selecting items for dunning 3 4 Calculating dunning levels
Calculating dunning charges and dunning interest Issuing dunning notices

.......... .......... ..........
Managing dunning history
Individual dunning notice

SAP AG 1999
Mass processing by dunning program
Dunning Procedure
Most of the settings for dunning are made in the "dunning procedure". You can access the dunning procedure directly from the application.
Customer Company code Dunning data
Correspondence
Dunning procedure
0001 Dunning procedure
SAP AG 1999
Parameters

03.01.XXXX AC200
Document
Status
Maintain parameters Parameters have been entered
SAP AG 1999
Dunning Run

03.01.XXXX AC200
Document
Status
Maintain parameters Parameters have been entered Schedule dunning run Dunning run has finished
SAP AG 1999
Changing the Dunning Proposal

03.01.XXXX AC200
Document
Status
Maintain parameters Parameters have been entered Schedule dunning run Dunning run has finished Change dunning notices Dunning data has been changed
SAP AG 1999
Printing Dunning Notices

03.01.XXXX AC200
Document
Status
Maintain parameters Parameters have been entered Schedule dunning run Dunning run has finished Change dunning notices Dunning data has been changed Start printing dunning notices Printing of dunning notices has finished
SAP AG 1999
Correspondence
Correspondence requests Mass request selection program

Periodic account statement Internal documents Standard letter
Individual request manual

Open item list Account statement Individual correspondence
Individual request automatic
Bill of exchange charges statement Payment notice
...
Correspondence requests
Trigger program Print programs

SAP AG 1999
Accounts Receivable Information System

Views of the A/R Information System
Due
date analysis history analysis
Payment Currency Overdue DSO
items
analysis
Create evaluations
Display evaluations
Terms
offered/ terms taken
SAP database
SAP AG 1999
Presentation: Presentation: Integration with Sales and Distribution Integration with Sales and Distribution Sales organization, distribution channel, division SD view of the customer master record Sales, shipping, billing
SAP AG 1999
IDES Distribution Chains in Germany IDES Distribution Chains in Germany

Company code 1000 Germany
A AA
Sales organization 1000 Frankfurt
A AA
Sales organization 1020 Berlin
Distribution channel 10 Fin.cust.sales Distribution channel 12 Resellers Distribution channel 14 Service Distribution channel 16 Factory sales
SAP AG 1999
Distribution channel 20 Store chains Distribution channel 22 Indust.customers Distribution channel 24 Pharmaceutical customers
Sales for IDES Plant Hamburg
Plant 1000 Hamburg
Company code 1000 Germany
... sells goods from ...
... posts the sale in ...
A AA
Sales organization 1000 Frankfurt Distribution channel 10 Final customer sales Distribution chain 1000 10
A AA
Sales organization 1000 Frankfurt Distribution channel 12 Reseller Distribution chain 1000 12
SAP AG 1999
Divisions
Divisions
Division 02 Motorcycles
Division 03 Paints Material
Division 05 Foods
SAP AG 1999
Sales Areas
Divisions
Sales area 1000 10 02 02
A AA
Sales organization 1000 Frankfurt Distribution channel 10 Final customer sales Distribution chain 1000 10
Sales area 1000 10 03 03
Sales area 1000 10 05 05

SAP AG 1999
Sales Area Data in the Customer Master Record

Customer X General data
PLUS
PLUS
Sales areaspecific settings
CC 1000
Sales area 1000-10-10

SAP AG 1999
Customer X in sales area 1000-10-10
Sales Process
SD Sales
Sales order
FI No document
Shipping Outbound delivery

Outbound delivery
Transfer order
Picking
Goods issue
Goods issue
Document
Line items ... ...
SD SD Billing
Billing document
MM FI
Invoice
Line items ... ...
SAP AG 1999
Credit Management
Credit control area Credit management master data Credit control
Presentation: Presentation: Credit Management
SAP AG 1999
IDES Credit Control Area
6000
5000 1000
6000 Mexico
5000 Japan 2000 United Kingdom 2300 Spain
3000
1000 Germany 2200 France 2100 Portugal
3000 USA
SAP AG 1999
4000 Canada
Credit Management Master Record

Credit management master record
Overview
Customer master record
General data
Credit control area data 1000

SAP AG 1999
Credit control area data 3000
Credit Control Process

Sales order
Credit control
Rejection
Order block
Review Further processing No

SAP AG 1999
Release?
Yes
Delivery
Billing d ...
Closing Operations in Accounts Receivable Operations in Accounts Closing Receivable

Overview: Accounts Receivable closing operations Value adjustments
Presentation: Presentation:
SAP AG 1999
Overview: Accounts Receivable Closing Operations

Start of new fiscal year
Run balance carry forward prog. Block posting periods for customers Open special periods for customers Reconciliation Documents Trans. figures Affiliated companies
Send balance confirmations Evaluate response Valuate foreign currencies Value adjustments Carry out reclassification
Close special periods for customers
Time line
SAP AG 1999
Value Adjustments: Parameters

Document
Run date Identification Status

Maintain parameters
03.01.XXXX AC200
Parameters have been entered
SAP AG 1999
Valuation Run
Document

Maintain parameters
03.01.XXXX AC200
Parameters have been entered Schedule valuation run Valuation run has finished
SAP AG 1999
Transfer
Document

Maintain parameters
03.01.XXXX AC200
Parameters have been entered Post the valuation in the general ledger Schedule valuation run Valuation run has finished Schedule transfer Transfer has finished Enter valuation in valuated items
Adjustment
X
Clearing
X
SAP AG 1999
Self-Study: Customer Master Data in FI
At the conclusion of this unit, you will be able to: Maintain customer master data in FI
SAP AG 1999
Customer Master Records - Exercises

Unit: Accounts Receivable Topic: Customer master records
At the conclusion of these exercises, you will be able to: Create the list of customers Use the match code search function Maintain a customer master record Accounting transactions involving customers are recorded in the accounts receivable subledger. The accounts are divided up into account groups so that the large number of customers can be organized more easily. Customer master data is usually created centrally by Sales and Distribution, since they generally make the initial contact with customers. However, maintenance and entry can also be completed by accounting. To access Accounts Receivable: Accounting Financial accounting Accounts receivable
1-1 Creating a customer list Create a customer list for company code 1000. Afterwards, create a list of all customers in account group KUNA. Information system Reports for Accounts Receivable Accounting Master Data Customer List
1-1-1 Creating a customer list for all vendors Create a list of all customers in the company code 1000. 1-1-2 Create a list for an account group Use a dynamic selection to create a list of all customers in account group KUNA. Now go back to the SAP Easy Access menu.
1-2 Maintaining customer master records The Becker company of Berlin-Harmsdorf (Postal code 134##) called IDES to inform IDES of a change to the company's address and bank information. The Becker representative does not know the IDES customer number. Master records Change 1-2-1 Using the address attributes search Determine the account number of the customer using the search per address attributes. Use the postal code as search criteria. Write down the number of the customer account: __________________________________________________________ 1-2-2 Entering changes The company has moved to Alexander Pl. ##. The postal code has changed to 101##. Make the changes to the customer master record. Now go back to the SAP Easy Access menu.
1-2-3 Make changes for a different company code? Becker is also a customer of IDES Canada. Do you need to send the changes to Canada, so that the accounting department there has the most current information? If no, why not? If yes, what additional steps does IDES Canada need to complete? _________________________________________________________ _________________________________________________________
1-3 Tracking changes So that changes to master records can be tracked, a change document is created for every change made, recording the changes exactly. 1-3-1 Displaying change documents Display the change document for the changes you just made to the master record CUSTOMER##. What information is contained in the change document? Master records Display changes Now go back to the SAP Easy Access menu. 1-3-2 Displaying changes to multiple accounts To see what changes were made to all customer accounts today, start the related program. Information system Reports for Accounts Receivable Accounting Master Data Display Changes to Customers Now go back to the SAP Easy Access menu.
Self-Study: Accounting Transactions Within a Period
At the conclusion of this unit, you will be able to: Maintain customer documents Manually post an incoming payment with a payment difference Request correspondence Monitor customer accounts Use the Accounts Receivable information system Describe the functions of credit management
SAP AG 1999

Unit: Accounts Receivable Topic: Accounting transactions within a period in Accounts Receivable
At the conclusion of these exercises, you will be able to: Change a document Manually post an incoming payment with a difference Print periodic account statements Create automatic dunning notices Since IDES uses the application component SD, customer invoices are usually posted directly in SD and not in Account Receivable. Thanks to the integrated software, these invoices are also posted in financial accounting. If, however, there are discrepancies and problems with the payment process, the customers normally contact the accounting department directly. In addition to the payment process, Accounts Receivable is also responsible from correspondence and dunning. 2-1 Making and checking document changes Becker from Berlin (CUSTOMER##) also says, that the invoice for order 800000##, which it received recently from the IDES sales organization, contains incorrect payment terms. Instead of the usual 3 percent cash discount for payments within 14 days, the terms stated are due upon receipt. After speaking to the sales organization, you determine that the wrong terms were entered and the customer should receive the normal cash discount. 2-1-1 Changing invoice documents
IDES has configured their system in such a manner, that the order number is always displayed in the "Allocation" field of the customer document. Select the invoice using this field and change the payment terms to ZB01. This is an invoice for 5000 UNI. Make a note of the number of the changed document: ____________________________________________ Now go back to the SAP Easy Access menu. Account Display/change item 2-1-2 Tracking changes Check whether the system created a change document for the changes you just made. Now go back to the SAP Easy Access menu. Document Display changes 2-1-3 Displaying the profitability segment View the same document and determine the profitability segment to which it was posted. Write down the characteristics displayed and the values of the profitability segment: Characteristic: _____________________________ Characteristic: _____________________________ Characteristic: _____________________________ Characteristic: _____________________________ Characteristic: _____________________________ Value: _________ Value: _________ Value: _________ Value: _________ Value: _________
Now go back to the SAP Easy Access menu. Document Display
2-2 Manual incoming payment with difference Accounts receivable receives a check and payment information saying that Becker (CUSTOMER##) is only paying 80% of the invoiced amount, since order 800000## was incomplete. The check was made out for 4000 UNI. 2-2-1 Posting incoming payments Post the check to incoming check account 113108 using today's date for the document and posting dates and create a residual item for the payment difference. Using the allocation number, select the FI invoice for order 800000##. Record the document number: ______________________________________________________ Document entry Incoming payment Now go back to the SAP Easy Access menu. 2-2-2 Checking customer accounts Check whether the open item for 5000 UNI was actually cleared and whether a residual item was created. Account Display/change line items Now go back to the SAP Easy Access menu.
2-3 Automatic dunning IDES uses the R/3 dunning program, to inform customers of overdue payments on line items. Most of the dunning parameters are saved in so called dunning procedures, which have to be entered in the customer master record, so that the account can be dunned. IDES runs the dunning program every week. 2-3-1 Checking master records Check whether dunning procedure 0001 is entered in the master record of CUSTOMER##. If not, make this entry. Master records Change 2-3-2 Creating a dunning run and maintaining the parameters Today is the day on which the dunning program is to be run. Create a dunning run using today's as the run date and your business area BA## as the identification. Make your entries so that all documents that have been posted up to today for CUSTOMER## in company code 1000 are selected. Normally, IDES makes the dunning run for all customers. For test purposes, it is advisable to activate the additional log so that any errors that occur can be more easily traced. Activate the additional log for your dunning run.
Periodic processing Dunning 2-3-3 Creating a dunning proposal Have the system start generating the dunning proposal by scheduling the proposal to start immediately. Do not start the printing of the dunning. IDES usually schedules the dunning proposal to be processed in the background at times when the system is less busy (at night, for example).
Keep updating the status until a message is displayed to tell you that the dunning selection has been created. 2-3-4 Checking the dunning selection Accounts Receivable clerks print out the dunning selection and check the dunning proposal before the actual dunning run takes place. This helps prevent the sending of incorrect dunning notices. You can also make changes to the dunning proposal; that is, you can remove items from the dunning run or lower the dunning levels. Check the dunning proposal on the screen and determine whether CUSTOMER## will be dunned. If no items to be dunned are displayed on the screen, you have made an error somewhere. Look at the proposal log from the initial dunning screen where the display log appears to see if you can find the error. Delete the dunning proposal (Edit Proposal Delete) and remove the error. Then restart the dunning proposal. Repeat this process until the items to be dunned are displayed in the proposal. 2-3-5 Printing the dunning notices After the dunning proposal has be checked and approved, the actual dunning run is started. It creates the dunning notices and enters the dunning data (dunning level and dunning date) in the master record and documents. Start the dunning run by scheduling it to start immediately. Use printer LP01 as the output device. IDES usually schedules the dunning run in the same way as the dunning proposal, to be processed in the background at times when the system is less busy. Update the status be pressing the ENTER key until the dunning run has been completed and the postings are created. Go to the output controller to view the automatically-created dunning notice. System Services Output controller Now go back to the SAP Easy Access menu. 2-3-6 Checking customer accounts
Check whether the dunning run updated the dunning data in the master record of CUSTOMER##. Master records Display Now go back to the SAP Easy Access menu. 2-3-7 Scheduling the next dunning run (optional) Schedule the dunning run for 10 PM in 7 days using the same parameters. Periodic processing Dunning Now go back to the SAP Easy Access menu.
2-4 Printing account statements (optional) Many customers would like a monthly statement from IDES, in order to check their records. This needs to be indicated in the master records of these customers and a special program has to be started every month. The programs selects these customers and creates an account statement for them. 2-4-1 Checking the customer master records Check whether this setting has been made for customer Becker of Berlin (CUSTOMER##), so that Becker gets a monthly account statement. If not, make this setting. Master records Change Now go back to the SAP Easy Access menu. 2-4-2 Requesting and printing monthly statements
In order to print monthly statements, a program has to be started once a month. It selects the master records with the entry "2" (monthly account statement) and requests the account statements. The account statements can be printed directly after the request is made or at a later time. The request program for monthly account statements is normally started automatically on the first of the month by a job. IDES accounting will allow you to run this program manually, if you promise to delete the print assignments created. Use variant AC010 and select customer##. Send the account statements directly to printer LP01 and check the output assignment. Periodic processing Print correspondence Periodic account statements Now go back to the SAP Easy Access menu. 2-5 Using the A/R information system (optional) The information system is an additional reporting tool in FI. It does not access the entire database, but only a pre-selected dataset. 2-5-1 Creating a pre-selected dataset Create the pre-selected dataset by creating a job with the name Info system## using the Job Wizard, which executes the ABAP program RFDRRGEN immediately using variant SAP VARI. Access the job overview, where you can determine when the job is complete. Technically speaking, one group could create the dataset. The purpose of this partial assignment is to help you become more familiar with job management. If system response time is impeded by the scheduling of the jobs, skip this exercise and continue with exercise 2-5-2. Information system Tools Configure Create evaluations Now go back to the SAP Easy Access menu.
2-5-2 Due-date analysis using the customer information system Using the customer information system, create a due-date analysis for company code 1000 per business areas. What is the total due in your business area BA##? _______________________________ Which customers in your business area still have outstanding balances? _________________________________________________________ Now go back to the SAP Easy Access menu. Information system Tools Display evaluations
2-6 Account analysis (optional) Use the account analysis to check the payment history of customer 1000. Now go back to the SAP Easy Access menu. Account Analysis
Self-Study: Integration with Sales and Distribution
At the conclusion of this unit, you will be able to: Describe the most important organizational units in Sales and Distribution (SD) Describe and carry out a simple sales process in SD, and explain its effects on Financial Accounting
SAP AG 1999
Integration - Exercises
Unit: Accounts Receivable Topic: Integration with R/3 SD
At the conclusion of these exercises, you will be able to: Create a sales order Create an outbound delivery Create a billing document Customer invoices are not usually posted directly in FI, but are posted to Accounts Receivable from billing in SD. A normal sales process at IDES consists of receiving a sales order, creating an outbound delivery, and billing.
To access Sales: Logistics Sales and Distribution
3-1 Carrying out a sales process The sales organization in Frankfurt (1000) receives a purchase order from the company Becker (CUSTOMER##). The company orders two pumps, model Cast steel IDESNORM 170-230. The material has the material number p-109. The purchase order has the number 12## and is dated from yesterday.
3-1-1 Create a sales order Create the sales order as a standard order. The distribution channel used is Final customer sales. The division is cross-division sales. The customer has requested that delivery be made one week after the purchase order date. Write down the standard order number: ______________________________________________________ Write down the requested delivery date: ______________________________________________________ Sales Order Create Now go back to the SAP Easy Access menu. 3-1-2 Outbound delivery On the customers requested delivery date, shipping point 1000 creates the outbound delivery, the goods are taken from the warehouse (picking), and the goods issue is posted. Carry out this process. In an operating concern, collective transactions are usually used to generate and process a large volume of the following documents. You will carry out the steps for individual processing here so that the procedure is clearer.
3-1-2-1
Create an outbound delivery Create the outbound delivery.
Write down the outbound delivery number: ___________________________________________________ Shipping and Transportation Outbound delivery Create Single document With reference to sales order Now go back to the SAP Easy Access menu. 3-1-2-2 Carry out picking Pick the delivery by creating a transfer order for warehouse management. The goods are in the Hamburg warehouse (010). The process should be system-guided. Write down the transfer order number: ___________________________________________________ Picking Create Transfer Order Single Document Now go back to the SAP Easy Access menu. 3-1-2-3 Post a goods issue Go back to the outbound delivery and post the goods issue. Choose Environment Document flow to find out the number of the goods issue delivery document. Write down the goods issue delivery document number: _________________________________________________
View the goods issue delivery document. From here, go to the accompanying accounting document and write down the accounting transaction. __________________________________________________ __________________________________________________ Post Goods Issue Outbound Delivery Single Document Now go back to the SAP Easy Access menu. 3-1-3 Billing The customer must then be charged for the delivery. Bill the customer for the delivery. Write down the billing document number: _______________________________________________________ Display the billing document on the screen and from here, go to the accompanying accounting document. What information does the accounting transaction contain? _______________________________________________________ _______________________________________________________ Billing Billing document Create Now go back to the SAP Easy Access menu.
Self-Study: Credit Management
At the conclusion of this self-study unit, you will be able to: Maintain credit management master data Check and release locked SD documents
SAP AG 1999
Credit Management - Exercises

Unit: Accounts Receivable Topic: Credit management
At the conclusion of these exercises, you will be able to: List customers with missing credit management data Maintain credit management master records
Credit department 1000 is responsible for the European IDES company codes. It monitors: Whether credit management data exists for every customer Whether credit limits have been exceeded and decides on appropriate action
To access credit management: Accounting Financial accounting Accounts receivable Credit management
4-1 Listing customers with missing credit data Credit management master data must be maintained for each customer in order for the automatic credit control to work. To ensure that this is not forgotten, the credit department runs a program every day that lists all the customers for whom credit management master data has not yet been maintained.
Start this program for company code 1000. You will find CUSTOMER## among the listed master records. An alternative procedure is to define credit data for new customers in Customizing, which is then used automatically. However, we will not use this method here.
Now go back to the SAP Easy Access menu. Credit management info system Customers with missing credit data
4-2 Maintaining credit management master data Maintain the credit management master data for CUSTOMER##. Central data: Assign a maximum total limit of 1,000,000 UNI for all credit control areas, and a maximum limit of 500,000 UNI for each individual credit control area. Data for credit control area 1000: The customer should have a credit limit of 200,000 UNI for credit control area 1000. Assign the customer to the risk category for customers with low risk, and also to the relevant credit representative group. Master data Change Now go back to the SAP Easy Access menu.
4-3 Creating a large order
CUSTOMER## gives the sales organization Frankfurt (1000) an unusually large order for 50 pumps, model Cast steel IDESNORM 170-230 (material P-109). The purchase order has the number 13## and is from yesterday. Create the sales order as a standard order. The distribution channel used is Final customer sales. The division is crossdivision sales. The customer has requested that delivery be made one week after the purchase order date. The dynamic credit check reports that the credit limit has been exceeded. Save the order. Write down the standard order number: ______________________________________________________ Logistics Sales and Distribution Sales Order Create Now go back to the SAP Easy Access menu.
4-4 Displaying and releasing a blocked SD document The credit department runs a program twice every day that lists all SD documents that have been blocked as a result of credit checks. Start this program for the credit representative group for customers with low risk in credit control area 1000. In urgent situations (such as for deliveries at short notice), the credit department can also be notified by mail.
Select display variant 001. Before you release the order, go to the credit overview and display the data for CUSTOMER##. You will also find the customers telephone number here. By calling the customer, you establish that the customer now wishes to make IDES AG his main supplier of pumps, and that this order is only the first of many.
Release the order. Credit Management Exceptions Blocked SD documents Now go back to the SAP Easy Access menu.
4-5 Raising the credit limit Increase the credit limit to 500,000 in credit control area 1000 for the new major customer, CUSTOMER##. Master data Change Now go back to the SAP Easy Access menu.
Self-Study: Accounts Receivable Closing Operations
At the conclusion of this unit, you will be able to: Print balance confirmations Post value adjustments Valuate open items in foreign currency Group receivables according to due date
SAP AG 1999
Closing Procedures - Exercises

Unit: Accounts Receivable Topic: Closing procedures in Accounts Receivable
At the conclusion of these exercises, you will be able to: Make adjustments to customer accounts in accounts receivable
Depending on legal requirements, various procedures need to be completed in the subsidiary ledgers before financial statements can be created in the general ledger.
To access Accounts Receivable: Accounting Financial accounting Account receivable For the purposes of the following exercises, we will assume that the closing procedures where already completed for the previous month.
5-1 Completing value adjustments for bad debt
5-1-1 Prepare flat-rate individual value adjustment IDES wants to make a 5 percent adjustment on all foreign receivables that are overdue by more than 30 days at the time the adjustment is made. A value adjustment key was set up in the configuration and entered into the master record of all foreign customers. Check whether valuation adjustment key AB has been entered in the master record of customer FOREIGN##. If not, enter it. Now go back to the SAP Easy Access menu. Master records Change 5-1-2 Starting a valuation run As part of closing procedures, a valuation run has to be started in order to carry out the valuation adjustment. Use today's date as the run date and your business area BA## as the identification. The key date is the last day of last month. Use the valuation method "Individual value adjustment". Use the last day of last month as the posting date and the first day of the current month as the reversal date. The document type is SB. Remember to set the indicator to generate postings. Using the "Selection options" button, make certain you only select your customer FOREIGN## in company code 1000, so that each group can complete the exercise on its own. Activate the additional log by entering your customer FOREIGN## in the "Trace customer account" field. Start the valuation run. Periodic processing Closing Valuate Further valuations 5-1-3 Displaying the valuation proposal
View the valuation list. Two items should have been selected, one of which should have been valuated with 500 UNI. A value adjustment is not yet necessary for the other item. If no valuations are displayed on the screen, you have made an error somewhere. Look at the proposal log from the initial screen to see if you can find the error. Delete the proposal (Edit Proposal Delete) and remove the error. Restart the valuation run. Repeat this process until valuations are displayed in the proposal.
5-1-4 Executing valuations Transfer the valuation to FI. Now go back to the SAP Easy Access menu. 5-1-5 Checking the valuation Check whether the postings were made by looking at the balances of account 142100 (Allowance for doubtful accounts) in company code 1000 in business area BA##. G/L Accounting: Account Display balances
Unit Summary
You are now able to: Describe how accounts receivable accounting is set up in the R/3 System Maintain and view customer master data Complete accounting transactions within a period in Accounts Receivable Describe how Accounts Receivable is integrated with Sales and Distribution Use the functions of credit management Describe how SAP supports the financial statement preparations in Accounts Receivable
SAP AG 1999
Account Receivable - Solutions

Unit: Accounts Receivable Topic: Customer master records
To access Accounts Receivable: Accounting Financial accounting Accounts receivable
1-1 Creating a customer list Information system Reports for Accounts Receivable Accounting Master Data Customer List 1-1-1 Creating a customer list of all customers Field name or data type Company code Execute 1-1-2 Create a list for an account group Field name or data type Company code Values 1000 Values 1000
Choose Dynamic selections (fourth icon from left). In the hierarchy structure on the left side of the screen, select Account group and choose Adopt selected item to include the field in the dynamic selections. Field name or data type Account group Save Execute Now go back to the SAP Easy Access menu. Values KUNA
1-2 Maintaining customer master records Master records Change 1-2-1 Using the address attributes search Select the "Search" button. Field name or data type Postal code Continue Write down the number of the customer account found: CUSTOMER## Select the entry found with a double click. Continue 1-2-2 Entering changes Values 134##
Field name or data type Street/ number Postal code Save.
Values Alexander Pl. ## 101##
Confirm all information with Continue. Now go back to the SAP Easy Access menu. 1-2-3 Make changes for a different company code? No, since the customer address is part of the general data, the address is valid for all company codes. IDES Canada does not need to do anything.
1-3 Tracking changes 1-3-1 Displaying change documents Master records Confirmation of Change Display changes Field name or data type Customer Company code Continue Double-click on one of the fields listed. The date of the change, the new value, and the old value are all displayed. Values CUSTOMER## 1000
Double-click on the entry. The time of the change and the user name of the person who made the change are displayed. Now go back to the SAP Easy Access menu. 1-3-2 Displaying changes to multiple accounts Information system Reports for Accounts Receivable Accounting Master Data Display Changes to Customers Field name or data type Change date Execute A list of all changes made is displayed. Now go back to the SAP Easy Access menu. Values Today's date
Solutions
Unit: Accounts Receivable Topic: Accounting transactions within a period in Accounts Receivable
2-1 Making and checking document changes 2-1-1 Changing invoice documents Account Display/change line items Field name or data type Customer account Company code Execute Search for the open item using 800000## (order number) under allocation, and double-click it. Switch to change mode ("Display -> Change" button). Change the payment terms to ZB01. Values CUSTOMER## 1000
Write down the number of the document you are changing. Save Confirm warnings. Now go back to the SAP Easy Access menu. 2-1-2 Tracking changes Document Display changes The document number of the changed document should be defaulted. If it is not, enter it. Continue You can drilldown to the additional detail of any line item by double-clicking on that item. Now go back to the SAP Easy Access menu. 2-1-3 Displaying the profitability segment Document Display The document number of the changed document should be defaulted. If it is not, enter it. Continue Double click the sales revenue item The item is displayed. Click on the profitability segment display icon. The characteristics of the profitability segment are displayed. Characteristic: __________Customer_______________ Value: CUSTOMER08 Characteristic: __________Sales organization____ Characteristic: __________Distr. channel__________ Value: ____1000_____ Value: ____12_______ Value: ____02_______
Characteristic: ___________Division________________
Characteristic: __________Country_________________Value: ____DE______ Now go back to the SAP Easy Access menu.
2-2 Manual incoming payment with difference 2-2-1 Posting incoming payments Document entry Incoming payment Field name or data type Document date Company code Bank data Account Amount Open item selection Account Additional selections Continue As selection criteria, choose "Allocation". Continue Field name or data type Allocation Values 800000## (Enter in "From" column) CUSTOMER## Others 113108 4000 Values Today's date 1000
Choose the "Process open items" button. One open item should be listed and marked in red. In the "Res. items" tab: Double-click on the empty field labeled "Resi" next to the item. The residual item is calculated and entered in the field automatically. Post by choosing save. Record the document number. Now go back to the SAP Easy Access menu. 2-2-2 Checking customer accounts Account Display/change line items Field name or data type Customer account Company code All items Execute Search for the item with the allocation number 800000##. It should now be a cleared item. Search for the item using the document number you wrote down. It is the residual item and should be an open item. Now go back to the SAP Easy Access menu. Values CUSTOMER## 1000 Select
2-3
Automatic dunning
2-3-1 Checking master records Master records Change Field name or data type Customer Company code Continue Select the "Company code data" button. "Correspondence" tab: Field name or data type Dunn.procedure Save Now go back to the SAP Easy Access menu. 2-3-2 Creating a dunning run and maintaining the parameters Periodic processing Dunning Field name or data type Run on Identification Continue The status of the new dunning run is: No parameters entered as yet. Values Today's date BA## Values 0001 Values CUSTOMER## 1000
Choose the Parameter tab Field name or data type Dunning date Docmnts posted up to Company code Custom. account Save Choose the Additional log tab Field name or data type Custom. account Save Go back to the tab Status. 2-3-3 Creating a dunning proposal Choose the Schedule dunning run button Select Start immediately. Schedule Keep updating the status by pressing enter until the message "Dun.selection is complete" is displayed. 2-3-4 Checking the dunning selection Select the "Change dunning notices" button Execute Values CUSTOMER## Values Today's date Today's date 1000 CUSTOMER##
If no items to be dunned are displayed on the screen, you have made an error somewhere. Look at the proposal log (Extras Dunning run log) to see if you can find the error. Delete the dunning proposal (choose Delete dunning run) and remove the error. Then restart the dunning proposal. Repeat this process until the items to be dunned are displayed in the proposal. Go back to the initial screen of the dunning program. 2-3-5 Printing the dunning notices Return to the initial dunning screen. Choose Schedule dunning notice printout Select Start immediately. Output device: LP01 Print Keep updating the status by pressing enter until the message "Dun.printout is complete" is displayed. System Services Output controller Field name or data type Created by Execute Select the spool request "Script" and view it (by choosing the eye glasses icon). Now go back to the SAP Easy Access menu. 2-3-6 Checking the customer account Values AC010-##
Master records Display Field name or data type Customer Company code Continue "Correspondence" tab: The "Last dunned" and "Dunning level" fields should contain entries. Now go back to the SAP Easy Access menu. 2-3-7 Scheduling the next dunning run (optional) Periodic processing Dunning Field name or data type Run on Identification Continue The status of the new dunning run is: No parameters maintained. Choose the Parameter tab Edit Copy Field name or data type Run on Identification Values Today's date BA## Values Today's date plus 7 days BA## Values CUSTOMER## 1000
Adjust date details Copy Save Go back to the tab Status.
Select
Choose the Schedule dunning run button Field name or data type Start Date Start time Schedule Now go back to the SAP Easy Access menu. Values Today's date plus 7 days 22:00:00
2-4 Printing account statements (optional) 2-4-1 Checking the customer master records Master records Change Field name or data type Customer Company code Continue Select the "Company code data" button. Values CUSTOMER## 1000
"Correspondence" tab: The "Bank statement" field should contain the value 2 (monthly account statement). Now go back to the SAP Easy Access menu. 2-4-2 Starting the program for periodic account statements Periodic processing Print correspondence Periodic account statements Goto Variants Get... Choose AC010 Replace ## with your group number. Execute Confirm information Answer "Yes" to "Would you like to issue the Request?" (Output device LP01) Continue System Services Output controller Execute Select and display the request (Display contents icon) Now go back to the SAP Easy Access menu.
2-5 Using the A/R information system (optional) 2-5-1 Creating a preselected dataset Information system Tools Configure Create evaluations Choose the "Job wizard" button
Continue Field name or data type Job name Continue (twice) Field name or data type ABAP program name Variant Continue (twice) Select "Immediately" Continue (twice) Complete Select "Job overview" Execute Press "Refresh" (first icon from left) until the status "Finished" is displayed. Now go back to the SAP Easy Access menu. 2-5-2 Due-date analysis using the customer information system Information system Tools Display evaluations Choose the "Change path" button Path in Information system tree: Values RFDRRGEN SAP_VARI Values Info system ##
Evaluation view Customer standard evaluations for business area (open folder for your business area) Due date analysis to company code Double-click on company code IDES AG 1000. Customers Becker## and Poirot## are shown as having overdue items. Now go back to the SAP Easy Access menu.
2-6 Account analysis (optional) Account Analysis Field name or data type Customer Company code Fiscal year Continue Choose the Payment history tab Now go back to the SAP Easy Access menu. Values 1000 1000 Current year
Solutions
Unit: Accounts Receivable Topic: Integration with R/3 SD
To access Sales and Distribution: Logistics Sales and Distribution
3-1 Carrying out a sales process 3-1-1 Create a sales order Sales Order Create Field name or data type Order type Sales org. Distribution channel Division Continue Field name or data type Values Values Standard order (OR) 1000 10 00
Sold-to party Purch.order no. Purchase order date Req. delivery date Material Order quantity Save Confirm information
CUSTOMER## 12## Today's date less one day P.O. date plus seven days P-109 2
Write down the number of the standard order and the requested delivery date. Now go back to the SAP Easy Access menu. 3-1-2 Outbound delivery 3-1-2-1 Creating an outbound delivery Shipping and Transportation Outbound delivery Create Single document With reference to sales order Field name or data type Shipping point Selection date Continue The delivery overview is displayed. Save Write down the delivery number: Values 1000 Req. delivery date
Before the goods issue can be posted, the goods have to be picked. Now go back to the SAP Easy Access menu. 3-1-2-2 Carry out picking Picking Create Transfer Order Single Document Field name or data type Whse number Delivery Control Continue The transport order is displayed. Save Write down the transfer order number. Now go back to the SAP Easy Access menu. 3-1-2-3 Post a goods issue Post Goods Issue Outbound Delivery Single Document Field name or data type Outbound delivery Click on "Post goods issue" Values Delivery number you noted Values 010 Delivery number you wrote down System-guided
The message "Deliver xxx has been saved" appears This is the changed delivery for which the goods issue is now ready. Environment Document flow The document flow is displayed. Write down the goods issue delivery document number. Select the goods issue document. Choose Display document. The material document is displayed. Choose Accounting documents. Choose Accounting document. The accounting transaction is: Credit: Finished goods inventory Debit: Cost of goods sold 2073.862073.86
The amount of the goods issued was taken from the material master record and was calculated there by product cost controlling. The amount display could vary. Now go back to the SAP Easy Access menu. 3-1-3 Billing Billing Billing document Create Field name or data type Document Save Write down the billing document number. Values Delivery number you noted
Billing document Display Field name or data type Billing document Continue The invoice is displayed. Click on "Accounting" Choose Accounting document. The accounting document is displayed. The accounting transaction is: Debit: Becker ## Credit: Sales revenue Credit Output tax 15660 135002160Values Billing document number you noted
The amounts are determined by price determination in SD and could vary from the values here.
Solutions
Unit: Accounts Receivable Topic: Credit Management
To access credit management: Accounting Financial accounting Accounts receivable Credit management
4-1 Listing customers with missing credit data Credit management info system Customers with missing credit data Field name or data type Company code Execute CUSTOMER## should appear in this list. Use the search function to find your customer in the list. Now go back to the SAP Easy Access menu. Values 1000
4-2 Maintaining credit management master data
Master data Change Field name or data type Customer Credit control area Central data and status Continue Field name or data type Total amount Individual limit Currency Continue Field name or data type Credit limit Risk category Credit rep. group Save Now go back to the SAP Easy Access menu. Values 200,000 001 001 Values 1,000,000 500,000 UNI Values CUSTOMER## 1000 Select
4-3 Creating a large order Logistics Sales and Distribution Sales Order Create
Field name or data type Order type Sales org. Distribution channel Division Continue Field name or data type Sold-to party Purch.order no. Purchase order date Req. delivery date Material Order quantity Save
Values Standard order (OR) 1000 10 00
Values CUSTOMER## 13## Today's date less one day P.O. date plus seven days P-109 50
Confirm first message about billing date. The message is displayed: "Dynamic credit check has been exceeded". Confirm (press enter) Write down the standard order number. Now go back to the SAP Easy Access menu.
4-4 Displaying and releasing a blocked SD document Credit Management Exceptions Blocked SD documents
Field name or data type Credit control area Credit rep. group Execute
Values 1000 001
A list of all blocked SD documents is displayed. Select "Choose display variant" (push button "Choose") Select "001" Select the SD document of your CUSTOMER##. Environment Credit overview Execute In the credit overview, the most important credit information is displayed and you can branch from here to other evaluations. Return to the list of blocked SD documents. Select "Release" (second icon from left). Save Now go back to the SAP Easy Access menu.
4-5 Raising the credit limit Master data Change Field name or data type Customer Credit control area Values CUSTOMER## 1000
Status Continue Field name or data type Credit limit Save
Select
Values 500,000
Solutions
Unit: Accounts Receivable Topic: Closing procedures in Accounts Receivable
5-1 Completing value adjustments for bad debt 5-1-1 Preparing flat-rate individual value adjustment Master records Change Field name or data type Customer Company code Continue Select the "Company code data" button "Account management" tab Values FOREIGN## 1000
AB has to be entered in the "Value adjustment" field. If not there, enter it and save the change to the master record. Confirm message regarding VAT reg. No. Now go back to the SAP Easy Access menu. 5-1-2 Starting a valuation run Periodic processing Closing Valuate Further valuations Field name or data type Run on Identification Continue Click on "Maintain" Field name or data type Key date Val. method Currency type Postings Posting date Rev.post.date Document type Values Last day of the previous month 3 (Reserve for bad debt) 10 Select Last day of the previous month First day of current month SB (in left section of screen) Values Today's date BA##
Press the "Selection options" button Field name or data type Values
Company code Customer account Customer account trace Execute Save Click on "Dispatch" Select Start immediately. Continue (press enter)
1000 FOREIGN## FOREIGN##
Press "Enter" until valuation run is finished. 5-1-3 Displaying the valuation list Edit Valuation run Value list Continue A list with all proposed valuations is displayed. This should be a valuation for 1000 UNI. If no valuations are displayed on the screen, you have made an error somewhere. Look at the proposal log (Edit Valuation run Display log) and see if you can find the error. Delete the proposal (Edit Proposal Delete) and remove the error. Restart the valuation run. Repeat this process until valuations are displayed in the proposal. Go back by choosing the green arrow. 5-1-4 Executing valuations Click on "Forward" Select Start immediately.
Continue (press enter) Press "Enter" until you see the message "Transfer finished". Now go back to the SAP Easy Access menu. 5-1-5 Checking the valuation G/L Accounting: Account Display balances Field name or data type G/L account Company code Fiscal year Business area Execute The account should have a credit balance of 1000 UNI in the previous period. In the current month, the posting was reversed. Values 142100 1000 1999 BA##
Asset Accounting
Contents:
Asset Master Data Standard Accounting Transactions in Asset Accounting Closing Procedures in Asset Accounting
SAP AG 1999
Asset Accounting: Unit Objectives
At the conclusion of this unit, you will be able to: Maintain asset master data Post asset transactions Determine and post depreciation Describe how SAP supports closing procedures in Asset Accounting
SAP AG 1999
Overview Diagram: Asset Accounting
CO
FIBL
FITV
FIAA
MM
FIAP
FIGL
General Ledger
FIAR
SD
SAP AG 1999
Asset Accounting: Business Scenario
Accounting transactions relating to assets are broken down in Asset Accounting. Here, the adjustments to the values of assets are managed, monitored, and processed in special asset accounts. Asset transactions can either be posted in FI or from Materials Management, if integrated. For financial statement preparation, the values of assets have to be checked and adjusted.
SAP AG 1999
Asset Master Data

Asset classes Depreciation areas
Presentation: Presentation: Asset Master Data
SAP AG 1999
Assets in FI Organizational Units
Company code
Asset 1
Asset 2
Asset 3
Business area A
SAP AG 1999
Business area B
Business area C
Asset Class
Accounts for buildings
Asset 001111
1000
000000-099999
t Asse class
1000
Asset Accounting
000000-099999
Buildings
100000-199999
2000
200000-299999
Machinery Business equipment
Standard assets
3000
300000-399999
400000-499999
4000
Assets under construction Low-value assets
5000
500000-599999
...
600000-699999
SAP AG 1999
Depreciation Areas
Asset xy in year 2000

Asset value Depreciation Remaining value
Trade law Legal
100 000
40 000
60 000
100 000
40 000
60 000
Cost accounting Parallel valuation
100 000
10 000
90 000
100 000
10 000
90 000
SAP AG 1999
Control Data in Depreciation Areas

For example, depreciation area trade law Depreciation key Estimated life
What should be depreciated?
How long will the asset be used?

Years, months
Normal depreciation start date Index Previous usage
Calendar
01 Jan
When was the asset placed in service? Should higher replacement costs be determined each year?
Years, months
How long has the asset already been in service?
SAP AG 1999
Account Determination
Depreciation areas Trade law
Balance sheet accounts
Depreciation accounts
Asset X Account determination
Cost accounting
Cost accounting depreciation accounts Balance sheet accounts e.g. for IAS Depreciation accounts e.g. for IAS
Parallel depreciation
SAP AG 1999
Group Assets and Sub-Numbers
Group asset
3000 / 0000
Assets
1000 / 0000 2000 / 0000
Asset sub-numbers
1000 / 0100
SAP AG 1999
1000 / 0200
Presentation:
Standard Accounting Transactions in Presentation: Daily Accounting Transactions in Asset Accounting Asset Accounting
Transaction type Asset transactions Unplanned depreciation Assets under construction Asset Explorer
SAP AG 1999
Transaction Type
Asset posting such as acquisition, asset retirement, allocation, depreciation, appreciation
Asset history sheet

Book values Acquisit begin of fiscal year ions Retire ment Transfers Depreciation Book values end of fiscal year
Posting keys 70/75 Posting type xxx
DM $
+ -
DM
Depr.
SAP AG 1999
Asset Transactions
Assets
General ledger
Asset 100
Clearing 100
Asset transaction using (non-integrated) clearing accounts
Assets
Vendors
Asset 100
Vendor 100
Asset transaction integrated with accounts payable or accounts receivable
Assets
Vendors
Asset 100
Vendor 100
MM
Asset transaction from MM
SAP AG 1999
Unplanned Depreciation
Transaction type for unplanned depreciation
Asset xy in year 2000 -- Plan values ... Trade law Legal Cost accounting Parallel valuation
SAP AG 1999
Unplanned Depreciation 40 000 40 000 10 000 10 000
...
Assets Under Construction

Asset 1 IM
In or ves de tm rs en t
40%
Assets under construction
o r
ns io s it
et ss A
ui cq a
60 %
Settlement of asset under construction according to distribution rule Asset 2
FIAA
SAP AG 1999
Asset Explorer
Selection from asset and year
Planned values
Book values
Selection of depreciation area

Transactions in fiscal year Overview: posted/ planned depreciation
Depreciation parameters
Tab
SAP AG 1999
Presentation: Presentation: ClosingProcedures in Asset Accounting Closing Procedures in Asset
Accounting
Inventory Depreciation posting run Asset history sheet
SAP AG 1999
Overview: Asset Closing

End of year Beginning of new fiscal year Reconciliation FI-AA -- G/L Take inventory, post corrections as needed Depreciation posting run Periodic posting to blnce sht acct Year-end closing Create asset history sheet
Time line
SAP AG 1999
Inventory
Asset Accounting
Inventory list
Inventory
Inventory list
Make corrections
SAP AG 1999
Depreciation Posting Run

FIAA FIGL
Trade law Planned depreciation Cost accounting Planned depreciation Parallel depreciation Planned depreciation Posted depreciation
Depreciation accounts trade law
Depreciation posting run
Process batch input
Posted depreciation
Cost accounting depreciation accounts
Posted depreciation
Depreciation accounts e.g. for IAS
SAP AG 1999
Asset History Sheet

Book value Acquisitions Postings Depreciation start of f. year Retirements Book value end of f. year
DM
DM + Dep.
SAP AG 1999
Self-Study: Asset Master Data
At the conclusion of this self-study unit, you will be able to: Maintain asset master data Describe the role of deprecation areas
SAP AG 1999
Asset Master Data - Exercises

Unit: Topic: Asset Accounting Asset master data
At the conclusion of these exercises, you will be able to: Create a asset balance list Create asset master data
Accounting transactions involving assets are recorded in the Asset Accounting subsidiary ledger. The asset accounts are divided up into asset classes so that the large number of assets are organized in a useful manner.
To access Asset Accounting: Accounting Financial accounting Fixed assets
1-1 Creating asset balance lists Create an asset balance list for company code 1000 in depreciation area 01 (book depreciation) on 12/31 of the current fiscal year. Afterwards, create a list of all personal computers in company code 1000. Info system Reports on Asset Accounting Asset Balances Balance Lists Asset Balances ...by Asset Class
1-1-1 Creating a complete asset balance list Create a complete asset balance list of all assets in depreciation area 01 - book depreciation of company code 1000 as of 12/31 of the current fiscal year. List all assets. 1-1-2 Balance list of an asset class Create a complete asset list of all personal computers in depreciation area 01 - book depreciation of company code 1000 as of 12/31 of the current fiscal year. List all assets. 1-1-3 Asset list of all low-value assets Create a list of all asset balances of all low value assets (asset class 5000) in company code 1000 as of 12/31 of the current fiscal year. Create this asset balance list first for depreciation area 01 (book depreciation) and then for depreciation area 20 (cost accounting). Why do the values in these two depreciation areas vary? _______________________________________________________ _______________________________________________________ _______________________________________________________ _______________________________________________________ _______________________________________________________
1-1-4 Asset list of all assets under construction Create an asset balance list of all assets under construction (asset class 4000) in depreciation area 01 - trade law of company code 1000 as of 12/31 of the current fiscal year. Why is the depreciation of the listed assets under construction zero? _______________________________________________________
_______________________________________________________ _______________________________________________________ Now go back to the SAP Easy Access menu.
1-2 Creating asset master data IDES is to purchase an office building for the plant in Hamburg (1000). Before it can be activated, an asset master record has to be created in asset class 1100 (Buildings) with the name "Office building Hamburg ##". In Germany, buildings have a legal life of 50 years. Assign this building to your cost center CC## and business area BA##. Do not activate the building yet. Write down the asset number. Office building: _____________________________________ In how many depreciation areas will the asset values be posted to? What are the main differences between depreciation area 01 and 20? __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ __________________________________________________________________ Asset Create Asset Now go back to the SAP Easy Access menu.
Self-Study: Daily Accounting Transactions
At the conclusion of this self-study unit, you will be able to: Post an asset acquisition Plan manual depreciation Display transactions affecting the value of an asset Post the retirement of a transaction
SAP AG 1999

Unit: Asset Accounting Topic: Accounting transactions within a period in Asset Accounting
At the conclusion of these exercises, you will be able to: Post an asset acquisition Schedule unplanned depreciation Scrap an asset (optional) Create, post to, and settle an asset under construction Asset transactions are posted to using a transaction key.
2-1 Asset acquisition IDES purchased the building from real estate agency AGENCY##. This agency has already done business with IDES. The building is worth 1,000,000 UNI. 2-1-1 Posting the asset acquisition Post the asset acquisition completely, that is, post the asset acquisition and the amount payable to the vendor in one document. The date of the invoice is yesterday's date. Input tax of 10% (1I) is in addition to the net amount. Payment
terms call from three installment payments. Make certain you use the correct payment terms (R001). Use transaction type 100 (External asset acquisition). Record the document number: _____________________________________________________ Assets Posting Acquisition External acquisition With vendor 2-1-2 Displaying documents View this document in the document overview. Which three accounts were posted to in this document and to which ledgers do they belong? _______________________________________________________ _______________________________________________________ _______________________________________________________ How can you tell that the amount is due in three payments? _______________________________________________________ _______________________________________________________ Now go back to the SAP Easy Access menu. 2-1-3 Asset query Use the Asset Explorer to check the values of the new asset in depreciation area 01 (book depreciation). What are the planned and posted depreciation values for the current year? _______________________________________________________ _______________________________________________________
Asset Asset Explorer
2-2 Scheduling unplanned depreciation A powerful storm tore half of the roof off of the new building, causing significant damage. Schedule 50,000 UNI of unplanned depreciation in depreciation area 01 to cover this damage. Use this value in all other depreciation areas except for 20 (cost accounting). The controlling department has determined that the damage has a lower value, 40,000 UNI. Use transaction type 650 (Unplanned depreciation on new acquisition). Check your results using the Asset Explorer. Posting Manual val. correction Miscellaneous depreciation Now go back to the SAP Easy Access menu.
2-3 Scrapping (optional) At the beginning of the current fiscal year, IDES purchased a used robot for 500,000 UNI and estimates that it can be used for another three years. Unfortunately, the company determined at the end of September of the current fiscal year, that the technology of the robot is out of date. IDES decides to scrap the robot, even though the book value is still positive. The robot is being scrapped, because no profit could be made in any attempt to sell it. Post the scrapping of the robot with the asset number ROBOT## on 09/30 of the current fiscal year. Posting Retirement Scrapping Now go back to the SAP Easy Access menu.
2-4 Assets under construction (optional) The capacity of the purchased building in not sufficient for current capacity and the build thus needs an addition. During construction, the expenses are posted to a master record for assets under construction (asset class 4000) and then calculated into the cost of the building.
2-4-1 Creating master data for assets under construction Create a master data record for the asset under construction "Office building addition ##". Assign this building to your cost center CC##, your business area BA##, and the plant in Hamburg (1000). Write down the asset number. Asset under construction: _________________________________ Asset Create Asset Now go back to the SAP Easy Access menu. 2-4-2 Posting expenses to assets under construction For the construction of the addition, invoices are received that have to be posted to the asset under construction. Post an invoice to your asset under construction for 100,000 UNI plus input tax of 10 % (1I) UNI using today's date. The invoice is from vendor 1000. Make an integrated posting. Use transaction type 100. Assets Posting Acquisition External acquisition With vendor Now go back to the SAP Easy Access menu. 2-4-2 Settling an asset under construction Once the asset is completed, it has to be converted from an asset under construction into an asset. 2-4-2-1 Defining a distribution rule Before you can convert an AuC, you have to define a distribution rule which determined which part of the AuC is to be converted into an asset.
Specify that the entire amount is to be charged to the building as of today. Posting Cap. asset u. const .Distribute Now go back to the SAP Easy Access menu. 2-4-2-2 Completing settlements Complete the settlement for your asset under construction. Posting Cap. asset u. const .Settle Now go back to the SAP Easy Access menu. 2-4-3 Checking the settlement Using the Asset Explorer, check whether the settlement was completed properly. Asset Asset Explorer Now go back to the SAP Easy Access menu.
2-5 Printing asset charts (optional) In order to have the data for the scrapped asset (ROBOT##) in printed form, IDES accounting wants to create an asset record for this asset. To do so, start the asset history program and select the criteria needed. Info system Reports on Asset Accounting History Asset History
Self-Study: Asset Closing
At the conclusion of this self-study unit, you will be able to: Start the depreciation posting run Transfer balance sheet postings to the general ledger Print inventory lists Create asset history sheets
SAP AG 1999
Closing Procedures - Exercises

Unit: Asset Accounting Topic: Closing procedures in Asset Accounting
At the conclusion of these exercises, you will be able to: Print an inventory list Create the asset history sheet
Depending on legal requirements, various procedures need to be completed in the subsidiary ledgers, before financial statements can be created in the general ledger.
To access Asset Accounting: Accounting Financial accounting Fixed assets For the purposes of the following exercises, we will assume that the closing procedures where already completed for the previous month.
3-1 Inventory list
In order to carry out an inventory, an inventory list needs to be created with the SAP System. Here, the variances between the actual inventory and the listed inventory can be noted. The variances determined then need to be posted in the system. Create an inventory list for plant 1000 in company code 1000. To assist you with the entries in the selection screen, report variant AC010 was created. What is the date of the report? _____________________________________________________________ Which assets were listed in your cost center CC## on the report date? _____________________________________________________________ Info system Reports on Asset Accounting Asset Balances Inventory Lists Physical Inventory List ...by Plant Now go back to the SAP Easy Access menu.
3-2 Asset history sheet Create the asset history sheet for your business area BA## in company code 1000. To assist you with the entries in the selection screen, report variant AC010 was created. Use this variant and replace ## with your group number. Which asset history sheet version is used in the variant? _____________________________ Which depreciation area was used by this variant for the values displayed? _____________________________ Info system Reports on Asset Accounting Balance Sheet Explanations International Asset History Sheet
Unit Summary
You are now able to: Maintain asset master data Post asset transactions Calculate and post depreciation Describe how SAP supports closing procedures in Asset Accounting
SAP AG 1999
Asset Accounting - Solutions

Unit: Asset Accounting Topic: Asset master data
To access Bank Accounting: Accounting Financial accounting Fixed assets
1-1 Creating asset balance lists Info system Reports on Asset Accounting Asset Balances Balance Lists Asset Balances ...by Asset Class 1-1-1 Creating the entire asset directory Field name or data type Company code Report date Depreciation area List assets Execute 1-1-2 Balance list of an asset class Values 1000 12/31 of current fiscal year 01 Select
Field name or data type Company code Asset class Report date Depreciation area List assets Execute 1-1-3 Asset list of all low-value assets Field name or data type Company code Asset class Report date Depreciation area List assets Execute
Values 1000 3200 (Personal Computer) 12/31 of current fiscal year 01 Select
Values 1000 5000 12/31 of current fiscal year First 01, then 20 Select
The book values for area 01 (book depreciation) are all zero. This is due to the nature of low value assets, since they can be completely written off. In cost accounting deprecation area 20, the book values are greater than zero, since all costs are to be calculated in controlling (even small amounts). 1-1-4 Asset list of all assets under construction
Field name or data type Company code Asset class Report date Depreciation area List assets Execute
Values 1000 4000 12/31 of current fiscal year 01 Select
There is no depreciation since assets under construction may not be depreciated. Now go back to the SAP Easy Access menu.
1-2 Creating asset master data Asset Create Asset Field name or data type Asset class Company code Number of similar assets Select the "Master data" button Field name or data type Description Values Office building Hamburg ## Values 1100 (Buildings) 1000 1
"Time-dependent" tab Field name or data type Business area Cost center Plant Save Write down the asset number. Office Building: _______________________ Select the "Depreciation areas" button Eight depreciation areas are used. In depreciation area 01, the building is depreciated using the declining balance method. In depreciation area 20, straight-line depreciation is used. For calculating the replacement cost, an index is used in depreciation area 20. Now go back to the SAP Easy Access menu. Values BA## CC## 1000
Solutions
Unit: Asset Accounting Topic: Accounting transactions within a period in Asset Accounting
2-1 Asset acquisition 2-1-1 Posting the asset acquisition Assets Posting Acquisition External acquisition With vendor Field name or data type Document date Posting key (PstKy) Account Continue Field name or data type Amount Values 1100000 Values Today's date less one day 31 AGENCY##
Tax amount Tax code Payment terms Posting key (PstKy) Account Transaction type Continue Confirm warnings. Field name or data type Amount Tax code Asset value date Post
100000 1I R001 70 Your asset 100 (Acquisition from purchase)
Values * 1I Today's date
Write down your document number. 2-1-2 Displaying documents Document Display This document is posted to the accounts of the following ledgers: Your asset AGENCY## Asset subsidiary ledger A/P subsidiary ledger
154000
General ledger
You can see that the amount is due in three payments, since the total is divided into three items in account payable. Now go back to the SAP Easy Access menu. 2-1-3 Asset query Asset Asset Explorer Field name or data type Company code Asset Continue The planned depreciation is 50,000 UNI. The posted depreciation is still zero, since the depreciation is posted by a depreciation run. Now go back to the SAP Easy Access menu. Values 1000 Your asset
Select depreciation area 01 (book depreciation)
2-2 Scheduling unplanned depreciation Posting Manual val. correction Miscellaneous depreciation Field name or data type Company code Asset Values 1000 Your asset
Transaction type Continue Field name or data type Posting amount Text Continue
650
Values 50000 Storm damage
You can use the arrow keys to scroll back and forth between the depreciation areas. Use 50,000 UNI for the other depreciation areas excepts for depreciation area 20. Enter 40,000 UNI for it. Save Now go back to the SAP Easy Access menu. Asset Asset Explorer Field name or data type Company code Asset Continue The unplanned depreciation of 50,000 UNI also has to appear for the plan values. Check this. Now go back to the SAP Easy Access menu. Values 1000 Your asset
2-3 Scrapping (optional) Posting Retirement Scrapping Field name or data type Assets Document date Posting date Asset value date Save Now go back to the SAP Easy Access menu. Values ROBOT## 09/30 of current fiscal year 09/30 of current fiscal year 09/30 of current fiscal year
2-4 Assets under construction (optional) 2-4-1 Creating master data for assets under construction Asset Create Asset Field name or data type Asset class Company code Number of similar assets Select the "Master data" button Field name or data type Values Values 4000 (Asset under construction) 1000 1
Description "Time-dependent" tab Field name or data type Business area Cost center Plant Save Write down the asset number.
Office building addition ##
Values BA## CC## 1000
Now go back to the SAP Easy Access menu. 2-4-2 Posting expenses to the asset under construction Assets Postings Acquisition External acquisition With vendor Field name or data type Document date Posting key (PstKy) Account Continue Field name or data type Amount Tax Values 11,0000 10,000 Values Today's date 31 1000
Tax code Posting key (PstKy) Account Transaction type Continue Field name or data type Amount Tax code Asset value date Post
1I 70 Your asset under construction (office building addition) 100 (Acquisition from purchase)
Values * 1I Today's date
Now go back to the SAP Easy Access menu. 2-4-2 Settling asset under construction 2-4-2-1 Defining a distribution rule Posting Cap. asset u. const .Distribute Field name or data type Company code Asset Continue Values 1000 Your asset under construction (office building addition)
Select document for 100000 UNI. Choose Enter rules. Field name or data type CAT Settlement receivers % Back Save Now go back to the SAP Easy Access menu. 2-4-2-2 Completing settlements Posting Cap. asset u. const .Settle Field name or data type Company code Asset Document date Posting date Text Test run Detail list Values 1000 Your asset under construction (office building addition) Todays date Todays date Completion of addition Deactivate Activate Values FXA (Asset) Your office building 100
Execute The receiver list is displayed. Now go back to the SAP Easy Access menu. 2-4-3 Checking settlement Asset Asset Explorer Field name or data type Company code Asset Continue The acquisition with the transaction type 346 should be in the plan values. Now go back to the SAP Easy Access menu. Values 1000 Your office building
2-5 Printing asset charts (optional) Info system Reports on Asset Accounting History Asset History Field name or data type Company code Asset Execute Values 1000 ROBOT##
Solutions
Unit: Asset Accounting Topic: Closing procedures in Asset Accounting
3-1 Inventory list Info system Reports on Asset Accounting Asset Balances Inventory Lists Physical Inventory List ...by Plant Goto Variants Get... Double-click AC010 to select this variant. The report date is the last day of the previous month. Execute At the report date, your cost center CC## keeps the asset ROBOT##. If you completed the optional scrapping exercise, the value displayed here is 0 UNI: Now go back to the SAP Easy Access menu.
3-2 Asset history sheet Info system Reports on Asset Accounting Balance Sheet Explanations International Asset History Sheet
Field name or data type Company code List assets History sheet version Execute
Values 1000 Select 0008
Travel Management
Contents:
Master Data in Travel Management Accounting Transactions in Travel Management
SAP AG 1999
Travel Management: Unit Objectives
At the conclusion of this unit, you will be able to: Maintain travel privileges Plan trips Enter trip costs
SAP AG 1999
Overview Diagram: Travel Management
CO
FIBL
FITV
FIAA
MM
FIAP
FIGL
General ledger
FIAR
SD
SAP AG 1999
Travel Management: Business Scenario
Travel management is used to efficiently plan travel, to collect the travel information as easily as possible, and to calculate and post the trip costs and trip reimbursement amounts. The trip expenditures are transferred from Travel Management to FI, and the reimbursement amount could, for example, be paid to the employee by the accounts payable department.
SAP AG 1999
Presentation: Presentation: Master Master Data in Travel Management Data in Travel Management
Setting Up Personnel Master Data A/P Master Records for Employees
SAP AG 1999
Personnel Master Data in HR and in FI-TV
Trip Cost Mini Master Record in FI-TV Organizational assignment Personal information (Completed) personnel actions Bank information
Addresses
Travel preferences
Personnel number 1000
Travel privileges
Contract elements
Leave entitlement
Planned work time
Basic pay
... and many additional Infotypes
HR master record
SAP AG 1999
Actions
Trip costs- Mini master record FI-TV Bank information Personnel number 1000
Addresses
(Completed) personnel actions
Personal information
Organizational assignment
Travel privileges
Travel preferences
Actions in mini master record:
Enter trip costs (Mini master record)
Organizational change
SAP AG 1999
Vendor Master Record for an Employee
FIAP
FITV
Vendor X Personnel number: 1000

Report and batch input
Personnel number 1000
Infotypes
SAP AG 1999
Accounting Transactions in Travel Accounting Transactions in Travel Management Management

Enter travel information Enter travel costs Transfer travel data to FI
Presentation: Presentation:
SAP AG 1999
Travel Manager (ENJOY)
Name of employee Travel Travel requests Travel plans Travel expenses Creating travel objects or Detail view of a travel object Overview of created travel objects
SAP AG 1999
Travel Expenses
Travel request
Travel plans
Open travel expenses
Simulation
Vendor x
Approval Calculation Transfer to FI
Travel expense x
SAP AG 1999
Self-Study: Master Data in Travel Management
At the conclusion of this self-study unit, you will be able to: Maintain travel privileges in HR master data Automatically create vendor master records for employees
SAP AG 1999
Master Data - Exercises

Unit: Travel Management Topic: Master Data in FI-TV
At the end of these exercises, you will be able to: Expand a personnel master record to include travel privileges Generate vendors for personnel master records automatically Travel Management is used to plan trips efficiently, to enter travel expenses as simply as possible and to settle the trips. The travel expenses are transferred from Travel Management to FI and the reimbursement amount is paid out to the employee by IDES Accounts Payable. Accessing Travel Management: Accounting Financial accounting Travel management
1-1 Creating Travel Privileges An employee in the personnel area 1000 (Hamburg) goes on his first business trip for IDES Germany. So that his trip can be planned and settled in Travel Management, you have to expand his personnel master record to include the "trip privileges" area. The employee has the personnel number 20##. Accept the default values without making any changes.
Person-related master data Maintain Return to the SAP Easy Access menu.
1-2 Creating Vendors At IDES Germany travel expenses are paid out by Financial Accounting using a payment program. To be able to do this a vendor master record must exist for each employee who travels. This can then be used to process the payments. You can create these vendors automatically using a report. 1-2-1 Starting Report for Creating Vendors from Personnel Master Records Use the report to create a vendor for employee 20##. To help you fill in the selection screen use the report variant AC010. Replace ## with your group number. Enter the following as the name of the work file: D:\usr\sap\<system>\SYS\global\APACT Note: Replace the placeholder <system> with the name of your training system. Be sure to restrict the selection to your personnel number 20##, so that each group has the opportunity of creating their own vendor. The variant AC010 forces you to restrict the selection to exactly one personnel number. In production operation the report would, of course, be run for a greater number of sessions. Person-related master data Create vendors Return to the SAP Easy Access menu.
1-2-2 Starting Batch Input Session The report has created a batch input session that has to be run to create the vendor master records. Run the session A/P_ACC## in dialog. System Services Batch input Sessions Return to the SAP Easy Access menu. 1-2-3 Checking Vendor Check the vendor that just been created automatically. To find the correct vendor use the matchcode "Vendor by Personnel Number" Make a note of the vendor number: __________________________________________________________ Accounts payable Master records Display
Self-Study: Accounting Transactions in Travel Management
At the conclusion of this self-study unit, you will be able to: Enter travel information Enter travel costs Transfer travel data to FI
SAP AG 1999

Unit: Travel Management Topic: Accounting Transactions in FI-TV
At the end of these exercises, you will be able to: Query the travel overview of an employee Create travel expenses Settle trips Transfer trip receipts to FI An employee goes on a business trip and enters the travel expenses incurred in the R/3 system on his return. The expenses department settles the trips and transfers the receipts to Financial Accounting.
Accessing Travel Management: Accounting Financial accounting Travel management
2-1 Querying Trip Overview Use the travel manager to obtain an overview of all the trips created for the employee Angie Miller (personnel number 1000). Where did she go on her second trip and why? When did this trip begin and end? _______________________________________________________________ _______________________________________________________________
_______________________________________________________________ _______________________________________________________________ Display the travel expenses for this trip. How much is the total reimbursement amount and to which FI and CO objects are the expenses or costs assigned? _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ _______________________________________________________________ Travel manager Return to the SAP Easy Access menu.
2-2 Creating Travel Expenses As you have entered the travel privileges for the employee John Doe ##, he can now go on his business trip to Berlin. He has to visit an important customer there. He will leave today at 16:00 and fly to Berlin. He will take a return flight tomorrow, to be back at 22:00. IDES Germany reimburses meals with a per diem amount. IDES has already paid for the flight, but this must still be entered by John Doe ## so that the total travel expenses can be calculated correctly. The flight costs 900 UNI. John Doe ## also has two receipts for taxi journeys (one for today to the hotel, one for tomorrow to the airport), each one for 25 UNI, and a hotel bill of 200 UNI. Enter the travel expenses for this trip. Always accept the input tax rates proposed by the system. You can display the reimbursement amount John Doe ## will receive even before you save the trip. How much is the total reimbursement amount? ______________________________________________________________ How high are the total costs of the trip? ______________________________________________________________ After the trip has been saved, John Doe ## transfers his trip receipts to the expenses department.
Travel manager Return to the SAP Easy Access menu.
2-3 Settling Trips Once the expense receipts have been checked the expenses departments wants to settle the trip. The employee 20## belongs to the payroll area D2. Settle the trip using the variant AC010. Enter the period in which the trip took place and the personnel number 20##. Travel expenses Periodic processing Settle trips Return to the SAP Easy Access menu.
2-4 Transferring to FI The transfer of receipts to FI consists of two steps. Carry these out one after another. 2-4-1 Creating Trip Transfer Documents The first step in the transfer of travel expenses to FI is to create trip transfer documents. Create these using the variant AC010. Enter the period in which the trip took place and the personnel number 20##. Call the posting run after your business area "BA##". Travel expenses Periodic processing Transfer to accounting Create posting run Return to the SAP Easy Access menu. 2-4-2 Creating Accounting Documents Now post the trips to FI.
Travel expenses Periodic processing Transfer to accounting Manage posting runs Return to the SAP Easy Access menu. 2-4-3 Checking Transfer Check how the document has posted in Financial Accounting by displaying the vendor line items for employee 20##. Name the posting items. _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ Accounts payable Account Display/change line items Return to the SAP Easy Access menu.
Unit Summary
You are now able to: Maintain travel privileges Enter travel information Enter travel costs
SAP AG 1999
Travel Management - Solutions

Unit: Travel Management Topic: Master Data in FI-TV
1-1 Creating Travel Privileges Person-related master data Maintain Field Name or Data Type Personnel number Continue The Infotypes possible in the mini master record FI-TV are displayed. If there is a tick next to it this means that the respective Infotype has been created. There is no tick next to the "Travel Privileges" Infotype so you can now create the travel privileges. Select "Travel Privileges" Click on "Create" Do not make any changes Save Values 20##
Return to the SAP Easy Access menu.
1-2 Creating Vendors 1-2-1 Starting Report for Creating Vendors from Personnel Master Records Person-related master data Create vendors Goto Variants Get Double-click on variant "AC010" Replace ## with your group number Field Name or Data Type Personnel number User in workfile File name Values 20## AC010## D:\usr\sap\<system>\SYS\glob al\APACT Note: Replace the placeholder <system> with the name of your training system, such as T20. Execute 1-2-2 Starting Batch Input Session System Services Batch input Sessions Select session A/P_ACC## Click on "Process"
Click on "Process" Confirm each screen by clicking on "Continue" until the whole session has been processed. Return to the SAP Easy Access menu. 1-2-3 Checking Vendor Accounts payable Master records Display F4 in Vendor field Choose "Vendors by Personnel Number" matchcode Field Name or Data Type Personnel number Company code Continue Choose the vendor displayed. Make a note of the vendor number. Select all views and go through all of these. Note that the personnel number is entered in the Accounting Information section. Return to the SAP Easy Access menu. Values 20## 1000
Solutions
Unit: Travel Management Topic: Accounting Transactions in FI-TV
2-1 Querying Trip Overview Travel manager Field Name or Data Type Personnel number Continue On the left you see a list of all the trips for Angie Miller. To display more information in the overview, click on "Open navigation area". Her second trip took her to Munich to an EnjoyProject. She left on 02.01.98 at 10:00 and returned on 04.01.98 at 17:00. Click on the arrow to the left of the trip and then double-click on Travel Expenses. The travel expenses are displayed. At the bottom you can see the reimbursement amount (692.70 UNI) and the cost assignment (company code 1000, business area 9900, cost center 1110). Return to the SAP Easy Access menu. Values 1000
2-2 Entering Travel Expenses Travel manager Field Name or Data Type Personnel number Continue Click on "Creating an expense report" Choose trip schema "Domestic Trip" Continue General trip data Field Name or Data Type Trip beginning Trip end Trip destination Trip country Reason for trip Values Today, 16.00 Tomorrow, 22.00 Berlin DE Business trip Values 20##
Expand Mileage and per diem reimbursement Mileage and per diem reimbursement Field Name or Data Type Per diem meals reimbursement Values Select
Expense receipts Field Name or Data Type Exp. receipt 001 On Amount Click on "Add to table" The receipt is displayed in the receipt list. Field Name or Data Type Exp. receipt 002 On Amount Click on "Add to table" The receipt is displayed in the receipt list. Field Name or Data Type Exp. receipt 003 On Amount Click on "Add to table" The receipt is displayed in the receipt list. Field Name or Data Type Exp. receipt 004 Values NGTHotel Values Taxi Tomorrow 25 UNI Values Taxi Today 25 UNI Values Airfare paid Today 900 UNI
On Amount Click on "Add to table"
Today 200 UNI
The receipt is displayed in the receipt list. Click on "Results" The employee receives a reimbursement of 280 UNI. The total cost of the trip amounts to 1180 UNI. Back Save. Confirm the question about trip receipts by pressing "Yes". Return to the SAP Easy Access menu.
2-3 Settling Trips Travel expenses Periodic processing Settle trips Goto Variants Get Double-click on variant "AC010" Field Name or Data Type Period Personnel number Values Period and year of trip 20##
Execute Return to the SAP Easy Access menu.
2-4 Transferring to FI 2-4-1 Creating Trip Transfer Documents Travel expenses Periodic processing Transfer to accounting Create posting run Goto Variants Get Double-click on variant "AC010" Field Name or Data Type Period Personnel number Name of posting run Execute Return to the SAP Easy Access menu. 2-4-2 Creating Accounting Documents Travel expenses Periodic processing Transfer to accounting Manage posting runs Select posting run "BA##" Click on "Post" Post documents immediately Values Period and year of trip 20## BA## (replace ## with your group number)
Return to the SAP Easy Access menu. 2-4-3 Checking Transfer Accounts payable Account Display/change line items Field Name or Data Type Vendor account Company code Execute You should see a line item for 280 UNI displayed. Double-click on the line item Click on "Document overview" The document items are: John Doe ## 280.00900.00Travel Expenses Clearing Travel exp./accommod. 200.00 Travel exp./meals 30.00 Travel Exp. Drive/Fl. Travel Exp. Drive/Fl. Input tax 3.70 46.30 900.00 Values Vendor number for employee 20## 1000
Bank Accounting
Contents:
Master Data in Bank Accounting Accounting Transactions in Bank Accounting
SAP AG 1999
Bank Accounting: Unit Objectives
At the conclusion of this unit, you will be able to: Maintain the bank directory Process various accounting transactions in bank accounting
SAP AG 1999
Overview Diagram: Bank Accounting
CO
FIBL
FITV
FIAA
MM
FIAP
FIGL
General ledger
FIAR
SD
SAP AG 1999
Bank Accounting: Business Scenario
All accounting transactions affecting incoming or outgoing payments can be completed centrally in Bank Accounting. Bank Accounting is, however, not a true subsidiary ledger, like A/P, A/R, and Asset Accounting, since it does not have its own set of accounts. Rather, it posts directly to the G/L accounts.
SAP AG 1999
Master Data in Bank Accounting

Bank master records Bank G/L accounts Cash ledgers
Presentation: Presentation: Master Data in Bank Accounting
SAP AG 1999
Bank Directory
Bank master records in the bank directory Country Bank key Address... Tax info..
Bank details in customer and vendor master records Client level Customer / Vendor Bank details Country Bank key Account Bank type Direct debit
Client level
Banks
AG 1999 SAP
Bank Accounts
Bank G/L accounts - master data Account number Account control Account currency Bank account in the SAP System House bank ID Acct ID Bank/fin. details House bank Acct ID
Bank
Bank account at house bank
SAP AG 1999
Cash Ledgers
Company code xxxx
Cash 0001
Cash 0002
Cash 0003
Cash journal 0001

SAP AG 1999
Cash journal 0002
Cash journal 0003
Presentation: Presentation: Accounting Transactions in Bank Accounting Transactions in Bank Accounting
Accounting
Cash procedures Check deposits Lockbox
Account statement Check management

SAP AG 1999
Cash Journal Transaction (ENJOY)
Data selection
Balance display for display period
Accounting transactions (Cash in / cash out)
SAP AG 1999
Types of Cash Journal Transactions

Cash X Cash X Cash X Cash X Cash X Cash X
SAP AG 1999
Bank clearing X Bank clearing X Customer X Vendor X Revenue X Expense X
Incoming payment to bank account
Outgoing payment from bank account
Customer payment
Vendor payment
Revenue posting
Expense posting
Processing Incoming Checks

Bo bJ
r Ka
r eie lM ier Me r eie lM
rl Ka r Ka
on es Bo bJ on es Bo bJ on es
CC 1000 Germany Checks and deposit slip
Creating a check deposit slip and posting the checks received

Account statement
Bank
Creating a lockbox file
Lockbox file
Bank
Collecting the money and posting the incoming cash
CC 3000 USA
Posting lockbox data
SAP AG 1999
Depositing Checks
Electronic entry
Inventory Check deposit list
Batch input session or direct posting
Manual entry Manual postprocessing

SAP AG 1999
Posting a Check Deposit
Customer
OI 2
Check clearing
2 1
Check receipt
1
Open Item
Subledger accounting session

SAP AG 1999
Bank ledger accounting session
Lockbox
Customer Lockbox file Data transfer

House bank OI 1
Amounts and payment information
Import
Check receipt
1 2
Bank
2
AG 1999 SAP
Bank Account Statement
House bank
Data transfer Account statements in bank-data memory Batch input session or direct posting
account Import statement file
Manual entry
AG 1999 SAP
Print account statement
Incoming and Outgoing Checks

Outgoing checks Bank
2
Outgoing checks
2 1
Vendor
1 OI
Account statement bank accounting session or check cashing Incoming checks Customer
OI 1
Payment program
Open item
Incoming checks
1 2 2
Bank
Open item
SAP AG 1999
Depositing checks or lockbox
Account statement Bank accounting session or lockbox
Bank Transfers
Outgoing bank transfers Bank
2
Expenditure
2 1
Vendor
1 OI
Account statement Bank accounting session
Payment program
Open item
Incoming bank transfers Customer

OI 2
Cash receipt
2 1 1
Bank
Open item
SAP AG 1999
Account statement subledger accounting session
Account statement bank accounting session
Managing Outgoing Checks
Vendor's bank
... Submittal of check to bank
..sends check to house bank
Check register Check 1000 Check 2000 ... Bank

2
Vendor Payment program
Bob Jones
Outgoing check
2 1
Vendor
1 OI
Payment method C
1
House bank
SAP AG 1999
Check extract Cashed checks list / file

2 CC 3000 USA
Self-Study: Master Data in Bank Accounting
At the conclusion of this self-study unit, you will be able to: Maintain the bank directory Describe the relationship of G/L accounts to bank accounts
SAP AG 1999
Bank Master Data - Exercises

Unit: Bank Accounting Topic: Bank Master Data
At the conclusion of these exercises, you will be able to: Describe the connection between the bank account and the general ledger Change an entry in the Bank Directory It is possible to perform all accounting-based business transactions involving direct incoming or outgoing payments centrally in bank accounting. Bank accounting is not really subledger accounting like accounts payable, accounts receivable or asset accounting, as it does not have its own chart of accounts, but posts directly to general ledger accounts instead.
To access bank accounting: Accounting Financial accounting Banks
1-1 Identifying bank accounts Every IDES company code has accounts at one or several house banks. Every bank account is assigned to exactly one G/L account. On the general ledger, this G/L account then reflects all postings performed by the bank on the assigned bank account.
In company code 1000, for example, G/L account 113100 is such a G/L account representing a bank account. Take a look in the company code-specific settings of the G/L account to see which bank account this G/L account represents. House bank: _____________ with bank key:___________________________ Account: ___________________________________________________________ G/L Accounting: Master records Individual processing In company code Now go back to the SAP Easy Access menu.
1-2 Changing the Bank Directory The Bank Directory contains the addresses of all banks in a certain country. You can access the Bank Directory both from subledger accounting and from bank accounting when entering bank details in a customer master data record, for example. In some countries (Germany, for example) it is possible to automatically and regularly update the Bank Directory using a file available from the banks and an import report. However, if you are aware of changes to bank data from accounting in advance, you can also enter these manually. The bank group UNI Bank has been taken over by the bank group Interbank. Change the description of the bank with bank key 900000## from "UNI Bank ##" to "Interbank ##". Master records Bank master record Change Now go back to the SAP Easy Access menu.
Self-Study: Accounting Transactions
At the conclusion of this self-study unit, you will be able to: Create and process a check deposit slip Process lockbox data (USA) Manually enter an account statement
SAP AG 1999
Business Transactions - Exercises

Unit: Bank Accounting Topic: Business Transactions in Bank Accounting
At the conclusion of these exercises, you will be able to: Enter business transactions in the cash journal Perform a manual check deposit transaction Postprocess lockbox data Manually process a bank statement In different countries, the automatic handling of incoming payments by check is performed differently. Here are two examples: In Germany, the checks are sent from the customers directly to accounting of company code 1000. Here a check deposit transaction is created and this is passed, along with the checks, to the house bank. In the USA, company code 3000 uses the lockbox service of its house bank. The house banks receive the checks directly and enter the check data. This data is sent as a file to accounting and imported there. Cashed, outgoing checks can also be handled differently. In Germany, the cashed checks appear individually as outgoing payments on the bank statement and are processed with this. In the USA, the cashed checks only appear as a total on the bank statement and accounting receives a list of the cashed checks as a
separate file (cashed checks). 2-1 Cash journal
2-1-1 Entering expenses The accounting department urgently needs paper for the printer and sends employee Paul Wahl to the nearest office supplies store. He pays the purchase price of 30 UNI from his own pocket and then goes to the company code's cash register to get his money back. Enter the outgoing cash payment for office supplies. Debit the expense to your cost center CC##. Then print a receipt for the cash register. This must be signed by the cash recipient. 2-1-2 Payment to the bank account At the end of the week, the total amount of petty cash is brought to the bank. Enter this transaction. 2-1-3 Forwarding to FI At the end of every day, all entered transactions are forwarded to the general ledger where they are updated. Carry out this procedure and then display the accounting documents generated for each item. 2-1-4 Printing the cash journal Print out the cash journal. Now go back to the SAP Easy Access menu.
2-2 Manual check deposit transaction
Every day, IDES Germany receives a very large number of checks that need to be deposited at the house banks. To keep the effort of entering all these checks to a minimum, IDES usually uses a check reader and imports the entered data into the R/3 system by means of a report. To test the functions of the check deposit transaction and to better understand it, you should now enter two of the checks received manually. These two checks reached the accounting department of company code 1000, each together with a payment advice note. The first check is from customer CUSTOMER## (Becker##), the second one from customer FOREIGN## (Poirot##). The companies specify in the payment advice note which of their orders they wish to pay for with the checks. The accountant explains to them that the system is configured in such a way that the order number is always automatically entered in the field "Reference" on the accounting document when it is transferred to financial accounting. Input Check deposit Manual entry 2-2-1 Entering specifications The first time you use the check deposit transaction, you are asked to store specifications based on the following entries. Select "Internal bank determination" to indicate that you wish to assign your house banks using the house bank ID (rather than with the bank key). Use variant 1001 as entry variant. As further processing type, store "1" to have the postings created by means of batch input. This is always advisable if a large number of postings is involved, as is usually the case for IDES. 2-2-2 Editing the header of the check deposit transaction list The checks are to be paid into the house bank with ID 1000 to the checking account with ID 1000. Name the check deposit transaction list "##" (field "Group") and specify your user name. The account the checks are posted to is stored as transaction in the configuration. Choose transaction "0001". Use today as the posting date. Experience shows that the check amounts are credited to the bank account three working days later. Name the batch input session with the bank postings "Bank ##", and that of the batch input session with the subledger postings "Customer##".
2-2-3 Entering items of the check deposit transaction list All data relevant for the bank for further processing, and the data needed for the selection of the paid items is entered per check - in the items of the check deposit transaction list. You receive the following data from the checks and the payment advice notes: Check issuer Poirot ## Becker ## Check number 145 254 Bank key 10020030 10050000 Bank account 222222 333333 Check amount 15000 9700 Order paid for 600000## 500000##
Use this information to enter the items in the check deposit transaction list and then save your entries. 2-2-4 Printing the check deposit transaction list Print the check deposit transaction list you entered (individual list) with printer LP01 and take a look at the print request. This list is given to the bank together with the checks. Now go back to the SAP Easy Access menu. 2-2-5 Processing the check deposit transaction list Create the batch input sessions for the updating of the check deposit list. Check deposit Post Individual list First process the batch input session "Bank ##" and then the session "Customer ##". Go back to the screen "Edit check deposit list ".
Now go back to the SAP Easy Access menu. 2-2-6 Controlling check processing To check and see whether check processing has in fact cleared the paid, open item, have all the items from account CUSTOMER## (Becker ##) displayed. How can you tell which item was created by the batch input session? _________________________________________________________ What is on the item lines of the posted document? _________________________________________________________ _________________________________________________________ _________________________________________________________ _________________________________________________________ Accounts Receivable: Account Display/change line items Now go back to the SAP Easy Access menu.
2-3 Manual bank statement (optional) IDES usually uses the functions of the electronic bank statement to subsequently post the numerous account movements on the general ledger. However, so that you can better understand how the bank statement functions, you should now manually process a bank statement. This bank statement consists of only two transactions from Customer## (Becker##): a) a bank transfer credit to pay an open invoice b) a credit for the deposited check of 9700 from the previous exercise Input Bank statement Manual entry 2-3-1 Entering specifications
The first time you use the bank statement function, you are asked to store specifications based on the following entries. Select "Internal bank determination" to indicate that you wish to assign your house banks using the house bank ID (rather than with the bank key). IDES always uses variant 1001 as entry variant. As further processing type store "1" to have the postings created by means of batch input. This is always advisable if a large number of postings is involved or if you are expecting to have to postprocess the postings. 2-3-2 Editing the header of the bank statement The bank statement comes from house bank 1000 of company code 1000 and applies to the checking account with the ID 1000. Your statement has the number ## and shows today's date as statement date. The beginning balance printed on the bank statement is 10000 UNI and the closing balance is 29,700 UNI. The movements on the bank statement have all been posted today. Name the batch input session with the bank postings "Bank ##", and that of the batch input session with the subledger postings "Persons##". Confirm the warning that the beginning balance does not correspond to the closing balance of the previous bank statement, or that statements are missing. This cannot be avoided when several bank statements are entered simultaneously (as during this exercise). 2-3-3 Entering items of the bank statement The first item on the bank statement is the credit for the deposited check. The second one involves a customer payment per bank transfer. You can see the following information on the bank statement: Transaction Check credit Value date Today's date + 3 days Amount 9700 10000 Note to payee Check 254 Delivery Customer Becker ## Becker ##
Bank transfer Today's date
credit
900000##
The IDES System is set up in such a way that the delivery number is always entered automatically in the Assignment field. The stored customer matchcode (Cust.-MC) uses the field "Search term" in the customer master record to assign the correct item. The company IDES always uses the customer's last name as the search term, (in this case, Becker ##). 2-3-4 Posting the bank statement Create the batch input sessions for the updating of the bank statement. Bank statement Post Individual statement First process the batch input session "Bank ##" and then the session "Persons ##", both in the foreground. The system is unable to perform the selection of the open item for the updating of the incoming cash payment per bank transfer on its own, as it has found more than one customer with the search term "Becker*". This means you must manually intervene in the batch input processing by choosing "CUSTOMER##" from the proposed selection list of customers. This is precisely how the bank employee would react if the item cannot be found automatically. Now go back to the SAP Easy Access menu. 2-3-5 Checking the bank statement processing To check and see whether bank statement processing has in fact cleared the paid, open item with the incoming bank transfer, have all the items from account CUSTOMER## (Becker ##) displayed. What is on the item lines of the posted document? _________________________________________________________ _________________________________________________________
Accounts Receivable: Account Display/change line items Now go back to the SAP Easy Access menu.
Unit Summary
You are now able to: Maintain the bank directory Process various accounting transactions in Bank Accounting
SAP AG 1999
Solutions
Unit: Bank Accounting Topic: Bank Master Data
1-1 Identifying bank accounts G/L Accounting: Master records Individual processing In company code Field name or data type G/L account Company code Click on the symbol "Display" Tab "Create/Bank/Interest": The fields "House bank" and "Account ID" are located under "Bank/financial details in company code". The entries here indicate that this account is assigned to checking account 1000 at house bank 1000 with the bank key 20050000 (see the possible entries). Now go back to the SAP Easy Access menu. Values 113100 1000
1-2 Changing the Bank Directory Master records Bank master record Change Field name or data type Bank country Bank key Continue Field name or data type Bank Save Now go back to the SAP Easy Access menu. Values Interbank ## Values DE 900000##
Solutions
Unit: Bank Accounting Topic: Business Transactions in Bank Accounting
2-1 Cash journal (petty cash) Outgoings Cash journal Field name or data type Company code Cash journal Continue 2-1-1 Posting cash payments Tab "Payments" Field name or data type Business transaction Values Cash purchase of office supplies (select from possible Values 1000 10##
entries) Amount Cost center Receipt recipient Text Save Select the business transaction Click on "Print receipt" The receipt is displayed. Back 2-1-2 Payment to the bank account Tab "Payment" Field name or data type Business transaction Amount Save 2-1-3 Forwarding to FI Click on "Post" (all entries to G/L) To display the documents generated, select an item and then choose "FI follow-on documents". Select the accounting document. Values Cash transfer to the bank (select from possible entries) Cash register closing balance 30 CC## Paul Wahl Printer paper
2-1-4 Printing the cash journal Click on "Print cash journal" Now go back to the SAP Easy Access menu.
2-2 Manual check deposit transaction Input Check deposit Manual entry 2-2-1 Entering specifications Field name or data type Internal bank determination Start variant Further processing type Continue Confirm information about line layouts 2-2-2 Editing the check deposit list Field name or data type Company code House bank Account ID Group Values 1000 1000 1000 ## Values Select 1001 1
User name Transaction Posting date Value date Currency Bank posting session Subledger session Continue
AC010-## 0001 Today's date Today's date + 3 days UNI Bank ## Customers ##
2-2-3 Entering items in the check deposit list Field name or data type 1. Item Check number Amount Issuer Bank key Bank account Reference 2. Item Check number Amount Issuer Bank key Bank account 254 9700 Becker ## 10050000 333333 145 15,000 Poirot ## 10020030 222222 600000## Values
Reference Save 2-2-4 Printing the check deposit list Click on "Print individual list" Field name or data type Output device Choose "Print"
500000##
Values LP01
To view the printed check deposit transaction list, choose System Services Output controller Execute Select spool request Click on "Display" (glasses) Go back to the screen "Edit Check Deposit List ". 2-2-5 Processing the check deposit transaction list Check deposit transaction Post Individual list (or simply choose the "Post" icon) The sessions have been created System Services Batch input Sessions First select "Bank ##", click on "Process", choose "Process/foreground" and then "Execute". Confirm screens by pressing "Return" until the batch input session has been processed completely. Click on "Resume" Then select "Customers ##" and repeat the same steps. Choose "Exit" when the session has been processed.
Now go back to the SAP Easy Access menu. 2-2-6 Controlling check processing Accounts Receivable: Account Display/change line items Field name or data type Customer account Company code All items Execute The item created by the batch input session can be found with the cleared items. The item text includes the check number, the account number and the bank key (in Germany: Bank identification number). Double-click on the item Click on "Document overview" The document items include: 113117 880000 175000 Incoming checks clearing account 9700.00 Customer cash discount Output tax 41.38 258.62 10000.00Values CUSTOMER## 1000 Select
CUSTOMER## Becker ##
Choose the document header symbol. Here you will see that the document has been created by the session "Customers ##". Now go back to the SAP Easy Access menu.
2-3 Manual bank statement (optional) Input Bank statement Manual entry 2-3-1 Entering specifications Field name or data type Internal bank determination Start variant Further processing type Continue 2-3-2 Editing the header of the bank statement Field name or data type Company code House bank Account ID Statement number Statement date Beginning balance Closing balance Bank posting session Subledger session Continue Values 1000 1000 1000 ## Today's date 10,000 29,700 Bank ## Persons ## Values Select 1001 1
Confirm the warning that the beginning balance does not correspond to the closing balance of the previous bank statement, or that statements are missing. This cannot be avoided when several bank statements are entered simultaneously (as during this exercise). 2-3-3 Entering items of the bank statement Field name or data type 1. Item Transaction Value date Amount Cust.-MC Vend.-MC Assignment 2. Item Transaction Value date Amount Cust.-MC Vend.-MC Assignment Save 2-3-4 Posting the bank statement Bank statement Post Individual statement The sessions have been created 067 Today's date 10,000 Becker <leave blank> 900000## 070 Today's date + 3 days 9700 Becker <leave blank> <leave blank> Values
System Services Batch input Sessions First select "Bank ##", click on "Process", choose "Process/foreground" and then "Execute". Confirm screens with "Return" until the batch input session has been processed completely. Click on "Resume" Select "Persons ##" and repeat the same steps. The system is unable to perform the selection of the open item for the updating of the incoming cash payment per bank transfer on its own, as it has found more than one customer with the search term "Becker*". This means you must manually intervene in the batch input processing by choosing "CUSTOMER##" from the proposed selection list of customers. This is precisely how the bank employee would react if the item cannot be found automatically. 2-3-5 Checking the bank statement processing Accounts Receivable: Account Display/change line items Field name or data type Customer account Company code All items Execute Double-click the item for 10000 UNI with document type DZ and the highest clearing document number (meaning the document last posted) Click on "Document overview" The document items include: 113109 Customer incoming cash account 10000.00 Values CUSTOMER## 1000 Select
CUSTOMER## Becker ##
10000.00-
This involves the posting of the bank transfer credit. Now go back to the SAP Easy Access menu.
Preparing Financial Statements
Contents:
Closing Procedures in the General Ledger Cost-of-Sales Accounting Consolidation
SAP AG 1999
Preparing Financial Statements: Unit Objectives
At the conclusion of this unit, you will be able to: Describe the basic process for creating financial statements Describe how R/3 support the preparation of financial statements in FI-GL Describe how a profit and loss statement can be created based on cost-of-sales accounting Name the various options for consolidation in R/3
SAP AG 1999
Overview Diagram: Preparing Financial Statements
CO
FIBL
FITV
FIAA
MM
FIAP
FIGL
General Hauptbuch ledger
FIAR
SD
SAP AG 1999
Preparing Financial Statements: Business Scenario
At the end of the fiscal year, the companies of the IDES group have to create financial statements based on the requirements of their respective countries. The profit and loss statement of many companies is set up based on period accounting, whereas other companies used cost-of-sales accounting. The group is also required to prepare a group financial statement. This requires the completion of consolidation measures.
SAP AG 1999
Closing Procedures in the General Ledger

Schedule Manager Overview: General ledger closing Accruals/deferrals, GR/IR analysis Balance audit trail, creating financial statements Reporting
SAP AG 1999
Presentation:
Schedule Manager
Task plan
Task groups Tasks
Monthly overview
Daily overview
SAP AG 1999
Overview: General Ledger Closing

Legal tasks
Begin of new fiscal year
Technical/organizational tasks
Balance carry forward program Block posting periods for G/L accounts Open special periods for G/L accounts Technical reconciliation Balance sheet / P&L adjustment
Foreign currency valuation of open items and liquid assets Make accrual/deferral postings Accruals/deferrals, GR/IR analysis
Balance audit trail Create financial statements Reporting
Close special periods for G/L accounts
Time line
SAP AG 1999
Accruals/Deferrals for Revenues & Expenses
Example: Accrual of expenses
Invoice 120
10
10
10
10
10
10
10
10
10
10
10
Expenses Periods Anticipated accruals/deferrals Transitory accrual/deferrals
SAP AG 1999
Accruals
Reference: Recurring entry original document First posting 01/01/XX Last posting 06/01/XX Next posting 02/01/XX Interval in months: 1 Line items 40 Expense 10 50 Other payables /reserves 10Recurring entry program Accounting period: 01.02.XX - 29.02.XX
Batch input
Actual posting Expense 10 Other payables/res. 10 10 ...
Next posting on 03/.01.XX
from 01/01/XX from 02/01/XX
SAP AG 1999
Deferrals
Invoice 120 Vendor 10 10 10 10 10 120 Other payables/res.
Expenses Periods
Expenses 60 50
50
60
60*
AR/AP
Post invoice Post accrual Reverse accrual posting

SAP AG 1999
Period 7

* 50
50
Period 8
Accumulated accruals
GR/IR Analysis
Balance Sheet
Assets
... ...
Balance Sheet
Liabilities & equity Shipped but not billed 20 or
Billed but not received 20
Appendix GR/IR account 100 80 GR/IR correction 20
Appendix GR/IR account 80 100 GR/IR correction 20
SAP AG 1999
Balance Audit Trail
Periodic
Working file
Database
Yearly
Journal
Account Balance carry forward ... Line items Account balance
SAP AG 1999
Preparing Financial Statements for Period Accounting

Company code financial statements
Financial statement versions CAUS Fin. statement USA GKR Statement Germany INT Financial statement IDES
Business area financial statements
Operating chart of accounts
Country-specific chart of accounts

SAP AG 1999
Reporting
Company code reporting
Tax authority
Law
Consolidated report (EU)

SAP AG 1999
VAT tax reports
Other legally required reports
Presentation:
Cost of Sales Accounting

Functional areas Cost of sales accounting ledger
SAP AG 1999
Period Accounting
P&L based on period accounting

Sales revenue +/- Changes to inventory = Operating result (gross) Material expenses Personnel costs + Depreciation + Other business expenses =Total expenses Net operating profit
SAP AG 1999
Total result for period
Total costs for period broken down by cost type
Cost of sales accounting
P&L based on cost of sales accounting

Sales revenue = Operating result (gross) Manufacturing cost of sales + Sales costs + Administrative costs + R&D + Production costs = Cost of sales Net operating profit
SAP AG 1999
Revenue for period
Cost of sales for the period broken down by functional area
Derivation of Functional Area
Document
Line items Account 40 50 Functional area Co object 1000 10Amount 10
Expense 0400 Balance sheet acct
Manual Entry
Master record of CO object Master record of P&L account
Substitution
SAP AG 1999
Cost of Sales Accounting Ledger
FIGL
General Ledger
FIGL
Cost of sales accounting ledger
G/L account
1000 1000 Mechanical eng. Mechanical eng. 2000 2000 Building construct. Building construct. 3000 3000 Automotive Automotive
G/L account
300 300 Sales Sales 400 400 Management Management 500 500 Research Research
Transaction figures per business area
Transaction figures per business area
SAP AG 1999
Presentation:
Consolidation
EC-CS, SEM-BCS
SAP AG 1999
EC-CS: Data Flow
CO-PA HR
EIS Executive Information System
BP Business Planning
EC-CS Consolidation View FI DataConsolidation unit = company/business area PCA Data KE =Company/ profit center
EC-PCA Profit Center Accounting

Profit center, company code
FI-GL Accounting
SD MM
B/S accounts P&L accounts and CO objects
Assets Receivables Payables
WIP Inventory Other
CO - Controlling
Cost center assignment project
SAP AG 1999
EC-CS: Organizational Units

View (Consolidation type) Hierarchy Consolidation group (part of group company) Company Business area Per region
Profit center
Per ownership World
North America Consolidation United unit States (company)
Europe
Canada
Germany
Great Britain
France
Company code
SAP AG 1999
3000 USA
4000 Canada
1000 Germany
2000 England
2200 France
Status Monitor
Procedures
Hierarchy of groups/units Total status Data transfer Validation Conversion
...
Segments + Cons.goods Non-food Pharma + USA + Germany + Australia + + Electronic Other Milestone
SAP AG 1999
Data Transfer to EC-CS

CO
Cost elements Group-
Consolidation Direct update Rollup

chart of
chart of accounts
Balance sheet
FI
Operating" Country chart of accounts (legal require.) chart of accounts
EC-CS
P&L
accounts
1 N:
1 1:
N:1
Financial statement version
Cash flow
Statistical items
Postings
B/S P&L
Key figures B/S P&L
Periodic extract
Operating sender systems
Consolidated financial statements
SAP AG 1999
SAP Consolidation Future Development
SAP consolidation engine
Value oriented group control functions
R/3
OLTP structures fixed partially flexible
BW
OLAP structures
EC-CS Consolidation
SAP AG 1999
SEM-BCS Business Consolidation
SAP Strategic Enterprise Management
BPS: Connection between strategic planning and enterprise planning/ simulation CPM: Balanced scorecards, Management cockpit, Key figure systems SRM: Inclusion of stakeholder expectations in company goals BCS: Legal and management consolidation with the press of a button BIC: Automatic information collection from external and internal company data BW: Integration of strategic, operative information and financial data
SAP AG 1999
SAP SEM
Stakeholder relationship Corporate management (SRM) performance monitor (CPM)
Business Consolidation (BCS) Business Information Collection (BIC)
Business planning & simulation (BPS)
BW
Self-Study: Closing Procedures in General Ledger
At the conclusion of this self-study unit, you will be able to: Complete accruals/deferrals Analyze the GR/IR clearing account Run the financial statement program
SAP AG 1999
Closing and Reporting - Exercises

Unit: Closing and Reporting Topic: Closing procedures in the general ledger
At the conclusion of these exercises, you will be able to: Post and reverse accrual/deferral postings Analyze the GR/IR clearing account (optional) Create financial statements At the end of the fiscal year, the companies in the IDES group have to create financial statements based on the requirements of the countries in which they operate. The profit and loss statement of some companies is based on period account, while other companies use the cost of sales accounting method.
To access General Ledger Accounting: Accounting Financial accounting General ledger For the purposes of the following exercises, we will assume that the closing procedures where already completed for the previous month.
1-1 Creating accruals/deferrals (optional)
The IDES group purchased an insurance policy which costs 6000 UNI (0% VAT) per year. The premium was paid in full last month, providing insurance for the twelve following months. 1-1-1 Post invoice Post the insurance invoice for 6000 UNI using vendor 1921 "Global Insurance", and use the first of last month as the posting and document date. The insurance contract number is 100##. Use this as a reference. Enter "Insurance premium BA##" as text. Use the "With cost center" creation variant For the offsetting posting, use account 466000 "Insurance" and tax code 0I (Input tax training 0%). Charge the amount to your cost center CC##. Write down the accounting document number: _________________________________________________________ Accounts Payable: Document entry Invoice Now go back to the SAP Easy Access menu. 1-1-2 Posting accruals/deferrals Only part of the insurance premium can be charged to the last month. Thus, the insurance expense needs to be assigned to multiple periods. Create an accrual/deferral document which moves the correct amount of the insurance premium to the next period (deferral). Post the deferral document using document type SB, the last day of the previous period as the posting date, and the first of the current month as the reversal date. For the reversal reason, select "Accrual/deferral posting". The account for invoice deferral postings in 98000. Enter "Deferral for insurance premium BA##" as the text for the item. G/L Accounting: Periodic processing Closing Valuate Enter Accrual/deferral doc. Now go back to the SAP Easy Access menu.
1-1-3 Reversing accruals/deferrals Reverse the accrual/deferral document by running the reversal report. To assist you with the entries in the selection screen, report variant AC010 was created. Use this report and replace ## with your group number. Write down the document number of the reversal posting: _________________________________________________________ IDES only runs this program once in order to reverse all accrual/deferral documents at the same time.
Periodic processing Closing Valuate Reverse Accrual/deferral document Now go back to the SAP Easy Access menu. 1-1-4 Checking accruals/deferrals Check the effect of the deferral by viewing the transaction figures of account 466000 (Insurance) in your business area BA##. What is the balance listed for this G/L account for the previous period? _________________________________________________________ What amount is posted to the current period? _________________________________________________________ Account Display balances
1-2 Analysis of the GR/IR clearing account (optional) The balance of the GR/IR clearing account displays the balance of goods billed but not received or goods delivered but not billed. This balance has to be posted to a balance sheet account for reporting purposes. 1-2-1 Posting an incoming invoice Post an invoice receipt using the invoice verification for order 41010010## in the amount of 116 UNI (including 16% VAT) for a spiral housing material in your business area BA##. Charge this amount to your cost center CC##. Use the first of last month as the document and posting dates. Logistics Materials Management Invoice Verification Logistics Invoice Verification Document Entry Enter Invoice Now go back to the SAP Easy Access menu. 1-2-2 Checking the GR/IR clearing account View the balances of GR/IR clearing account 191100 in your business area BA##. What is the balance listed for this account for the previous period? ___________________________________________________________ Where does this balance have to be listed in the balance sheet? ___________________________________________________________ G/L Accounting: Account Display balances Now go back to the SAP Easy Access menu. 1-2-3 Starting the analysis program
Start the program for analyzing the GR/IR clearing account. To assist you with the entries in the selection screen, report variant AC010 was created. Use this report and replace ## with your group number on all tab pages. What is the date of the GR/IR analysis? ___________________________________________________________ What posting date will be used for the regrouping? ___________________________________________________________ On what date will the regroupings be reversed? ___________________________________________________________ Run the batch input session. Normally, IDES runs the program for all business areas. For practice, you ran the program specifically for your business area BA##.
Periodic processing Closing Regroup GR/IR clearing Now go back to the SAP Easy Access menu. 1-2-4 Checking regroupings Check whether the regroupings are correct, by viewing the balances of account 191101 (Goods/services not yet delivered) for your business area BA##. From there, drill down to the regrouping document. What are the line items? __________________________________________________________ __________________________________________________________
Account Display balances Now go back to the SAP Easy Access menu.
1-3 Creating the compact journal (document journal) Create the compact journal for company code 1000 and the current week. Information system General ledger reports Document General Compact document journal SAP minimal variant Now go back to the SAP Easy Access menu.
1-4 Creating financial statements Create financial statements for company code 1000 using an actual/actual comparison for the previous period. Use financial statement version INT. Create the report using the graphical report output, first for the entire company code and then for your business area BA##. General ledger Information system General ledger reports Balance sheet/profit and loss statement/cash flow General Actual/actual comparisons Periodic actual/actual comparison Now go back to the SAP Easy Access menu.
Self-Study: Cost of Sales Accounting
At the end of this self-study unit, you will be able to: Explain how cost of sales accounting is set up Explain the need and the role of the functional area Start the program that creates a profit and loss statement based on cost of sales accounting
SAP AG 1999
Cost of Sales Accounting - Exercises

Unit: Closing and Reporting Topic: Cost of goods sold
At the conclusion of these exercises, you will be able to: Create a profit and loss statement based on cost of sales accounting
Based on legal requirements and options, a company creates a profit and loss statement based on period accounting of cost of sales accounting. To use the cost of sales method, functional areas have to be derived in the SAP System and included in the documents.
2-1 Displaying the functional area in documents During this course, you have posted various invoices to the vendor account AGENCY##. View these invoices and find the functional area in the documents. Functional area: ___________________________________ Accounts Payable: Account Display/change item Now go back to the SAP Easy Access menu.
2-2 Creating a P&L based on cost of sales accounting Create a profit and loss statement based on cost of sales accounting for company code 1000. Use the classic drilldown report. Now create the same report for your business area BA##. G/L Accounting: Information system General ledger reports Balance sheet/profit and loss statement/cash flow General Actual/actual comparisons Annual Profit and Loss Statement C/S Now go back to the SAP Easy Access menu.
Unit Summary
You are now able to: Describe the main steps in the closing process Describe how R/3 supports you when creating financial statements in FI-GL Describe how you can create profit and loss statement based on cost of sales accounting Name the various options for consolidation in R/3
SAP AG 1999
Closing and Reporting - Solutions

Unit: Closing Topic: Closing procedures in the general ledger
1-1 Create accruals/deferrals (optional) 1-1-1 Post invoice Accounts Payable: Document entry Invoice Enter company code, if not already entered. Field name or data type Company code Continue Basic data Field name or data type Vendor Values 1921 Values 1000
Continue Basic data Field name or data type Invoice date Posting date Continue Confirm message. The master record of the vendor is displayed in the upper right hand side of the screen. Basic data Field name or data type Amount Tax amount Reference Text Values 6000 0 (0I Input tax training 0%) 100## Insurance premium BA## Values First day of the previous month First day of the previous month
In the left column, select the "with cost center" screen variant. Line items Field name or data type G/L account D/C Doc. currency amount Values 466000 Debit 6000
Tax code Cost center Post
0I CC##
Write down the accounting document number. Now go back to the SAP Easy Access menu. 1-1-2 Posting accruals/deferrals G/L Accounting: Periodic processing Closing Valuate Enter Accrual/deferral doc. Field name or data type Document date Document type Company code Posting date Currency Reversal Reason Reversal Date Posting key (PstKy) Account Choose Continue Confirm message. Field name or data type Values Values Last day of previous period SB 1000 Last day of previous period UNI 05 First day of current period 40 98000
Amount Tax code Business area Text Posting key (PstKy) Account Continue Field name or data type Amount Tax code Cost center Text Post
5500 0I BA## Accrual for insurance premium BA## 50 466000
Values * 0I CC## + (last text)
Now go back to the SAP Easy Access menu. 1-1-3 Reversing accruals/deferrals Periodic processing Closing Valuate Reverse Accrual/deferral document Goto Variants Get Double-click AC010 Replace ## with your group number. Execute Write down the document number of the reversal posting.
Now go back to the SAP Easy Access menu. 1-1-4 Checking accruals/deferrals Account Display balances Field name or data type G/L account Company code Fiscal year Business area Execute By looking at the transaction figures, you will see that the balance of the account in the previous period is only 500 UNI, which is also the amount that was supposed to be charged to this period. The remaining insurance premium paid of 5500 UNI was moved forward to the current period. Now go back to the SAP Easy Access menu. Values 466000 1000 Current fiscal year BA##
1-2 Analysis of the GR/IR clearing account (optional) 1-2-1 Posting an incoming invoice Logistics Materials Management Invoice Verification Logistics Invoice Verification Document Entry Enter Invoice
Field name or data type Document and Posting Date Amount Tax Purchase order/scheduling agreement Continue Confirm message. Field name or data type Amount Quantity Save
Values The first of last month 116 16 (16% domestic input tax) 41010010##
Values 100 1
A warning appears that no goods receipt has been received for this invoice (quantity delivered is zero). Confirm warning. Confirm information if prompted to. Now go back to the SAP Easy Access menu. 1-2-2 Check the GR/IR clearing account G/L Accounting: Account Display balances Field name or data type G/L account Values 191100
Company code Fiscal year Business area Execute
1000 Current year BA##
For the last period, the balance has to be 100 UNI. The 100 UNI have to appear in the "Billed but not received" account for closing. Now go back to the SAP Easy Access menu. 1-2-3 Starting the analysis program Periodic processing Closing Regroup GR/IR clearing Goto Variants Get Select variant "AC010". In the description of the business area and on all tab pages, replace ## with your group number. The date for the GR/IR analysis is the last day of last month. This is also the posting date. The reversal posting date is the first day of the current month. Execute A batch input session is created. System Services Batch input Sessions Select the "RFWERE00-##" session. Click on "Process". Ensure that "Process foreground" is selected. Click on "Process" again. Confirm all screens with Enter.
Choose "Exit" when the session has been processed. Now go back to the SAP Easy Access menu. 1-2-4 Checking regroupings Account Display balances Field name or data type G/L account Company code Fiscal year Business area Execute The account should have a balance in the previous month of 100 UNI. This amount is reversed in the following period. Select the balance for the previous period to display the line item list. Select the line item to display that item. Select "Document overview" The document line items are: 191199 191101 GR/IR External procurement correction GR/IR Non-complete goods and services 100,00100,00 Values 191101 1000 Current year BA##
1-3 Create compact journal Information system General ledger reports Document General Compact document journal SAP minimal variant Field name or data type Company code Posting date Execute Now go back to the SAP Easy Access menu. Values 1000 Period of current week
1-4 Create financial statements General ledger Information system General ledger reports Balance sheet/profit and loss statement/cash flow General Actual/actual comparisons Periodic actual/actual comparison Confirm information if prompted. Field name or data type Company code Financial statement version Fiscal year Period Graphical report output Execute Values 1000 INT Current fiscal year Last period Selected
The financial report for the last period compared to the same period of the previous year is displayed. You can drilldown for the transaction figures of the accounts in the financial statement. Return to the selection screen and limit the selection to your business area BA##. Now go back to the SAP Easy Access menu.
Solutions
Unit: Closing and Reporting Topic: Cost of goods sold
2-1 Displaying the functional area in documents Accounts Payable: Account Display/change line items Field name or data type Vendor account Company code Execute Select an item with a double-click Select "Document overview" Double-click the expense item Select "More" Values AGENCY## 1000
You see the functional area here, such as 400 for administrative costs. Now go back to the SAP Easy Access menu.
2-2 Creating a P&L based on cost of sales accounting G/L Accounting: Information system General ledger reports Balance sheet/profit and loss statement/cash flow General Actual/actual comparisons Annual Profit and Loss Statement C/S Confirm information if prompted Field name or data type Company code Fiscal year Classic drilldown report Execute The P&L based on cost of goods sold is displayed for company code 1000. Return to the selection screen and run the same report for your business area BA##. Now go back to the SAP Easy Access menu. Values 1000 1999 Select
Summary
Contents:
Overview: Organizational Elements in Accounting Overview: Organizational Elements in Logistics Recommendations for Enhancing Understanding of Material
SAP AG 1999
Overview: Organizational Elements in Accounting
Operating Concern
Controlling area
Controlling area Business areas
SAP AG 1999
Company codes
Overview: Organizational Elements in Logistics

Divisions
... purchased for ...
... purchased from ...

A A A
Purchasing organization
Plant
Sales organization
SAP AG 1999
Distribution channel Distribution chain
Course Objectives
You are now able to:

Explain the roles of the various applications in
Financial Accounting
Explain how the Financial Accounting application
modules relate to each other

Perform typical accounting transactions in the
application components of Financial Accounting
SAP AG 1999
Recommended Follow-up Courses
AC200 General Ledger and Business Partner Configuration AC205 Financial Closing AC270 Travel Management AC305 Asset Accounting AC805 Cash Management
SAP AG 1999
Increasing Understanding of Material
Repeat the exercises, using the IDES data or your own data. Read the online documentation. Read the IMG documentation. Read the release notes.
SAP AG 1999
Appendix
Contents:
Posting tips Glossary Menu paths
SAP AG 1999
Posting Tips
Contents:
Reference documents Set/hold data Parameter IDs Document parking Validations and substitutions Report variants
SAP AG 1999
Simplifying Postings
Reference document Number 087234098 Line items:

PK 40 50 50 Account 123000 345560 907902 Amount 5000 2000 3000
Sample document Sample doc. No. 255 Line items:

PK 40 50 50 Account 123000 345560 907902 Amount 5000 2000 3000
Hold/Set data Header & line items:

Co.Code: 0001 01/23/95 PK 40 Account 123000 Amount 5000
Header:
PK 40 50 50
23.01.1995
Account 123000 345560 907902 Amount 5000 2000 3000
Comp. code: 0001
Line items: Posted document
SAP AG 1999
Posting Using Reference Documents
Document # 1 (Reference document):

Header: Line items: PK 40 50 50 Account 123000 345560 907902 Amount 5000 2000 3000 01/19/1995 Comp. code: 0001
Document # 2:
Header: Line items: PK 40 50 50 Account 123000 345560 907902 Amount 5000 2000 3000 01/23/1995 Comp. Code: 0001
SAP AG 1999
G/L Quick Entry of G/L Line Items

Screen Variants
SAP01 Standard 1 line Line items: PK 40 40 50 Account 415000 415000 113100 Amount St 5000 i0 4000 i0 9000 BA Cst Cntr 9900 3200 990 310 Order PK 3000 3000 3000
Quick entry - Acct., Cost Ctr, Amount Line items: PK 40 50 50 Account 123000 345560 907902 Cost center Amount 546 5000 546 2000 556 3000
The user selects a screen variant that meets his/her requirements.
SAP AG 1999
Account Assignment Model

Account assignment model
Account assignment model 9889 Items: PK 40 50 50 Account 123000 345560 907902 Amount 5000 2000 3000
Posted document
Header: Items: PK 40 50 50 Account 123000 345560 907902 Amount 5000 2000 3000 1/ 21/1995 Company code: 0001
SAP AG 1999
Parameter IDs
Maintenance of user parameters

PID BUK Parameter value 1000 Short text Company code
Initial screen Create G/L Account

Account number Company code Template Account number Company code
? 1000
SAP AG 1999
Document Parking
Document parking Account Amount Cost center 470000 1000 ??? Park
Document number: 505021 Transaction figures not updated User: MacDonald
SAP AG 1999
Posting a Parked Document
Parked document: 505021 Parked document: 505021 Account Amount Cost center 470000 1000 ??? Park
Document completed/posted Document completed/posted Account Amount Cost center 470000 1000 2000 Post
Posted document number: 505021 Transaction figures updated
SAP AG 1999
Validation
Validation improves the control of the data integrity!
Account = Heat Account = Heat
Cost ctr. = 05 Cost ctr. = 01

X
Is the account / cost center combination valid?

SAP AG 1999
Validations are completed using the criteria IF, THEN, ELSE !
Substitution
A Substitution is the process of replacing values when they are entered into the R/3 System Substitutions are completed prior to the validation (have priority) No error messages are output during substitution Substitutions are transparent for the user entering the data
Asset 1 cost center 2 Asset 2 cost center 3 Asset 3 cost center 4 All assets in cost centers 2 to 4 are posted to cost center 5.
SAP AG 1999
Report Variants
A report variant provides a way of storing predefined selection criteria for a report. An individual report can have multiple report variants defined for it. However, an individual variant can be used for only one report. Variants are required for reports run in background. Report variants allow standardized report settings in order to provide consistent report output. They are also helpful when executing reports which require complex data selection criteria.
SAP AG 1999
Special Purpose Ledger
Contents:
Set up of Special Purpose Ledger Reporting capabilities in the Special Purpose Ledger
SAP AG 1999
Customer-Defined Special Purpose Ledgers
CO FI
SD Ext. data
MM
Adjustment posting
Customer-defined Special Purpose Ledgers are a collection of information from other R/3 application components (FI, MM, CO, SD), external data transfers and FI-SL adjustment postings in customer-defined tables
SAP AG 1999
Special Purpose Ledger and Reporting
XXXXX XXXXXXXXX
If data is collected in the customer-defined ledgers, you can use the Report Writer and Report Painter to create your own specific reports
SAP AG 1999
The Structure of FI-SL Reporting using Report

General Ledger
ASSETS Accts rcvble 760 LIABILITIES PROFIT & LOSS Sales 760
XX
Painter
....
Dimensions
Account BA Cost Ct X .... Amount
-760 150 760
Data
TC
900 JPY 650 USD -900 JPY 720 GBP
.... Quantity
400 PCS
XXX... 900
Accts pybl. 150
Water expense .... YY 150
Electric Water Heat XXXX
XX YY
-650 USD 900 KG
-150 -900
3 PCS
Quantities are not entered in the G/L. In this example, the "Quantity" field is included by using a special purpose ledger.
SAP AG 1999
Coding Block Enhancement

The coding block defines the dimensions of the account assignments during document entry. It is possible to insert a new field in the coding and then to include information in reporting using the functions of the Special Purpose Ledger
New field
Document posting Amount: Tax ID: Special area: Business area: Cost center: PK: Account:
Dimensions
Acct. Cst Ctr Special area...
Data
Amt. ID
#### #### #### #### #### ### ### ### ### ###
REPORT PAINTER
A1
GENERAL LEDGER
1997 DEM
250 380 235
1998 DEM
300 10 435
+/50 (370) 200
SAP AG 1999
Report Painter / Report Writer
FI CO MM
REPORT WRITER
REPORT REPORT WRITER PAINTER
Cost elements 400100 400200 400300 600000 Total
Actual 45600 95000 35600 5600 181800
Plan Variance 45000 94500 40000 6000 185500 600 500 44004003700-
The Report Painter offers a user-friendly WYSIWYG (what you see is what you get) interface to the Report Writer.
SAP AG 1999
Report Painter
REPORT PAINTER
Report A1
Allows the definition of differentiated reports using the data from the FI, CO, and MM databases
Row
Characteristics?
Column Key figure/ Characteristics?
General data selection Characteristics?
FI/CO/MM databases Key figures Characteristics

xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx xxxxx
##### xxxxxxx ###### ##### xxxxxxx ###### ##### xxxxxxx ###### ##### xxxxxxx ###### ##### xxxxxxx ###### ##### xxxxxxx ###### ##### xxxxxxx ###### ##### xxxxxxx ###### 250 380 45 235 300 310 10 330 50 70 35 95
A1
1997
1998 Der.
SAP AG 1999
Basic Structure of Reports
Columns
Key column Key column ----------------------....... ....... ------------ ------------....... ....... ........ ........
------------------- . . . . . . . . ------------------- . . . . . . . .
Rows
-------------------
General data selection . . . . . . . .(valid. for . . . . . entire. report) . . . . . . the . . . . . . . . .

....... ....... ....... ....... ........ ........
------------------- . . . . . . . . ------------------- . . . . . . . .
SAP AG 1999
Additional Painter Functionality

Reports can be defined using Variables Reports can be designed to interface with other reports Reports can be exported to an EXCEL spreadsheet for further processing
SAP AG
Unit: Appendix Topic: Glossary
ABAP/4 Advanced Business Application Programming Language ABAP/4 Query ABAP/4 Queries provide user with basic lists, sorted and totalled by various criteria. Statistics and ranked lists are also available. Account Assignment Model The account assignment model is a template for posting documents. It includes the line items that will be defaulted into a document to facilitate data entry. It can contain an indefinite number of line items and include the posted amount or it can use an equivalency factor to spread an amount proportionally. Account Groups Account Groups are a classifying feature for G/L, Vendor and Customer master records. The account group assists in screen display and account numbering. Each master record must be assigned to an account group. Account Types When posting line items, there are 5 types of accounts that may be entered: Customer, Vendor, G/L Account, Asset and Material. The posting key defines which type of account is being used. Accrual Entries Accrual & Deferral Entries are adjustment postings which are necessary at the end of a posting period. They are typically reversed in the following period. R/3s accrual program books the accrual to the G/L, then specifies the date upon which the reversal should be effective. A reversal program is executed to select and reverse the applicable accrual documents.
Activity Types Activity Types describe the activity produced by a cost center and are measured in units of time or quantity. Examples: Machine hours, Labor hours.
Additional Account Assignments All entries that are made in the line item in addition to the account number, amount and posting key. These include terms of payment, payment method, cost center and others. Allocation Field The 'Allocation' field is an additional reference field for line items. It is contained on every posted line item. Line items can be sorted in the line item directory by the content of this field. The 'Allocation' field is either filled automatically (sort key in the master record) or manually (entry in a line item). ASAP (Accelerated SAP) ASAP is SAPs comprehensive implementation solution to streamline R/3 projects. AcceleratedSAP optimizes time, quality and efficient use of resources. It focuses on the coordination of all elements that make an implementation successful.
0
Asset Class The asset class provides the classification for fixed assets. It provides account determination, number ranges and screen display options. Automatic Account Assignment Automatic function (in financial accounting) during posting transactions, whereby the system assigns the items to their appropriate accounts, without the user having to make any entries. Balance Audit Trail Recording of all transactions in an account within a certain period. The balance audit trail shows the balance at the beginning of the period and the development of the account until period end. Balance Carried Forward The transfer of an account balance from the previous year. A balance is carried forward for balance sheet accounts. Balance Sheet Readjustment Program Program SAPF180 ensures zero balances per business area necessary for creating business area balance sheets. If profit center accounting is activated, readjustments are made for profit centers as well. It distributes Receivables & Payables, tax postings, cash discount postings and valuated exchange rate differences. Balance Sheet Account Valuation Program RFSBEW00 valuates General Ledger accounts managed in a foreign currency at a key date specified in the selection parameters.
Bank master data Information on a bank that is required in order to carry out business transactions with the bank. It is stored in the bank directory, which contains data on all the banks required. Bank master data includes, for example, the name of the bank, the address and country specifications. Baseline Date The Baseline Date defines the date on which terms of payment are to begin. R/3 allows customization of this date to meet user requirements. Bill of Exchange Promise to pay in the form of an abstract payment paper detached from the original legal transaction. Branch Account Account that is used to represent the head office/branch relationship of a customer or vendor in the R/3 system. Purchase orders, deliveries or invoices entered for branch accounts are posted to the head office account. Every branch account must refer to a head office account. Business Area Business areas are used for internal purposes to create balance sheet and profit and loss statements or alternatively can be used to meet external segment reporting requirements. Chart of Accounts Systematically organized list of all the G/L account master records that are required in a company code or several company codes. The COA contains the account number, the account name and control information for G/L account master record. There are several types of charts. See Operating COA, Corporate COA and Country COA. Clearing Procedure where open items in an account are marked as cleared. You ca clear open items if you can assign an amount of equal value to the opposite side of the account. Example: if a customer pays an invoice, you can clear the open items belonging to it. Client Each client is a self-contained technical unit. It does not have any business related meaning. General data and tables which are used by multiple organizational structures are usually stored at this level. Data records carry a client key. There are only a few client independent tables (item sorting, for example). A user master record must be created for each user needing access to the client. Company Code A company code is an independent accounting entity. It is the smallest organizational unit for which a complete selfcontained set of accounts can be drawn up. Several company codes can be set up per client to mange the accounts of independent companies simultaneously.
Company Code Currency/ Local Currency This is the currency of the company code in which the document is attached. R/3 will always store the company code currency. Controlling Area A controlling area identifies an independent organizational structure for which costs and revenues are collected. Each controlling area can have one or more company codes assigned to it. Corporate Chart of Accounts The Corporate Chart of Accounts groups dissimilar charts of accounts together for consolidated reporting. It is sometimes referred to as the Group Chart of Accounts. Cost Center Cost centers are organizational units that collect the costs arising within areas of responsibility. They are defined within a Controlling Area. Cost Element A cost element is used to classify and assign values to the consumption of productive resources. Country Chart of Accounts The Chart of Accounts provides an alternative account number structure to meet localized reporting requirements. It is sometimes referred to as the Alternative Chart of Accounts. Credit Control Area The Credit Control Area is the organizational structure that tracks and monitors customers credit in R/3. It is used by the Sales & Distribution components of R/3 as well as the Accounts Receivable component to provide integrated credit management. Cross Company Posting Posting transaction involving several company codes. The system creates a document for each company code involved. Cross company code posting are used to process centralized purchasing or payments. Correspondence All evaluations and reports sent to business partners are considered correspondence. Correspondence includes, account statements and open item lists in letter form, individual and standard letters, balance confirmations, document extracts, payment notices and statements of bill of exchange charges.
Document Change Rules Documents can be changed using the original document number based on Document Change Rules. They determine which fields and under what circumstances fields can be changed. Document Principle The R/3 system records at least one document for every business transaction. Each document receives a unique document number. The document remains as a complete unit and can be displayed at any time until it is archived. Document Type Accounting documents are managed within R/3 through the use of Document Types. The document type is located on the header portion of every document. Documents can be viewed, sorted and archived by document type. Drill Down Reporting User definable reporting tool which allows interactive data evaluation. Dunning The structured process of reminding overdue customers of the status of their accounts. Within R/3 customers are assigned to a dunning procedure which defines exactly how and when the dunning will take place. ERS (Evaluated Receipt Settlement) Evaluated Receipt Settlement is a type of Invoice Processing. In this method, you do not receive any invoices from your vendors, but generate them yourself based on information contained in purchase orders and goods receipts. Exchange Rate Tables Exchange Rate Tables are user maintainable. They contain dates with applicable translation rates for foreign currency transactions. The system will default to the rates entered in this table if no rate is specifically entered on a transaction. Exchange Rate Types Exchange Rate Types allow multiple rates to be stored and used for different purposes. You can use Exchange Rate Types to define a bank buying & selling rate, an average rate for translation of foreign currency amounts, rates for financial report translations, or a rate for any specialized currency requirement within your company. FI-CO Reconciliation Program The RKAKALFI report is used when a business has one or more companies tied to the same controlling area and cross-company CO allocations and cross-business area postings take place. This report will then compare total postings in FI and CO per company and create adjusting entries.
Field Status The goal of R/3 is to ensure accurate and efficient data entry. The use of field status functionality allows the appropriate combination of fields to be presented at data entry time preventing errors of inclusion and exclusion. Individual fields can be required, suppressed or optional, depending on the user defined configuration of R/3. Financial Calendar The Financial Calendar provides a quick, centralized overview of Accounting Activities planned or already performed, where the user can monitor and plan Financial Accounting tasks centrally as they arise.
1
Financial Management Area The financial management area is found in the treasury component of R/3. It subdivides an enterprise into units that can carry out independent cash budget management and independent funds management. Financial Statement Version Versions are created to provide row and hierarchy structure to the balance sheet and profit and loss statement. You can define versions for a special chart of accounts, for a corporate chart of accounts, or without any special allocation. You assign groups of accounts to the items at the lowest levels of the hierarchy. Functional Area Functional areas classify operating expenses according to the requirements of cost-of- sales accounting by production, administration, sales and distribution, marketing, research and development etc. By breaking costs down into these functional areas, costof-sales accounting shows why costs accrued in an enterprise and indicates the economic purpose of the expense. General Ledger Account Master Record Data record containing information that controls the entering of data to a G/L account and the management of the account. This includes for example the currency in which an account is managed. General Ledger Information System The general ledger information system, which is based on R/3s Executive Information System (EIS) functionality, is a dialog-oriented information system that is capable of evaluating a dataset according to all characteristics contained in the data description. Both G/L account transaction figures as well as balance sheet and P&L structures serve as the primary database for the general ledger information system. Balance sheet key figure reports and financial statement versions are available as report types. G/L Fast Entry In regular line item posting, each line item requires a new screen with the possible fields available presented to the user. G/L fast entry uses line item templates that have only the predefined fields available. This limited selection is usually 1 or 2 lines in length, therefore many line items fit on the same screen, making multiple line item entry much quicker for standardized entries.
2GR/IR Account
This General Ledger account that includes postings for goods received but not yet invoiced, and also postings for goods invoiced but not yet received. Goods Received / Invoice Received Reclass This program, (RFWERE00), analyzes goods receipts and invoices received clearing accounts and generates adjustment posting to classify business transactions correctly for balance sheet presentation. Group Company A group Company is the legal unit of consolidation to which company codes are assigned. Holdback/Retainage Holdback/ Retainage are payment terms which consist of proportional installment payments. Each installment payment can carry its own payment term definition. IMG (Implementation Guide) The IMG or Implementation Guide is the central element of Customizing. It leads the user online through all the steps required for the implementation of the R/3 system, for subsequent changes and for system upgrades and release upgrades. The IMG is valid system wide and is client independent.
2.2.2Input Tax Tax that is charged by the vendor.

Internal Order Internal orders are used to plan, collect, monitor, and settle the costs of specific operations and tasks performed within a controlling area. The SAP R/3-System allows you to control your internal orders throughout their entire life cycle (from initial creation through the planning and posting of actual costs right up to final settlement). Invoice Verification Invoice verification is the R/3 process of matching a vendors invoice with the purchase order for the goods, and the actual receipt of the goods. Lockbox Processing Payment transactions in the USA are largely made in the form of checks. In order to process these payments quickly, banks offer lockbox services where customers can send their payments directly to a lockbox at a bank. The bank deposits the checks and sends check deposit information to the payee via file transfer.
Net procedure Procedure where cost or inventory postings are reduced automatically by the expected cash discount when an invoice is posted. As a result, it is possible to post exact acquisition values less the cash discount.
2.2.3Noted Item Special item that does not affect the account balance. When you post a noted item, a document is generated; the item can be displayed via a line item display. Certain noted items are processed by the payment program or dunning program. Example: down payment request
Number Ranges Within the Financial Modules number ranges are configured to meet individual business requirements. Number Ranges can be an externally or internally defined. Several number ranges are reserved for special uses in R/3. Number ranges are defined for master records and documents. One time accounts One time accounts are managed for business partners with whom business is carried out only once or rarely One special master record is needed for all one time accounts. Specific data on the business partner, such as address and bank data, is not entered in the master record but in the document itself. Open FI Interface The standard financial accounting functions are not always sufficient to meet the specific demands of certain customers or industries. It is not always practical to extend the standard system. At the same time modifications to the standard system should be avoided or at least kept to a minimum. The Open FI Interface enables enhancement of standard functions without having to modify the standard system.
3Open Item Management
Specification that the items in an account must be cleared by other items in the account. The sum of the items involved in the clearing procedure must be zero. As a result, the account balance always results from the sum of the open items. Open Item Valuation Open Item Valuation (SAPF100) carries out foreign currency valuation for accounts managed on an open item basis such as A/P and A/R. Operating Chart of Accounts Each company code in R/3 uses the G/L accounts from only one chart of accounts for account validation at journal entry time. This is called the operating chart.
Operating Concern An operating concern is the central organizational element in profitability analysis. Controlling areas are mapped to one and only one operating concern for internal management segment reporting. Output Tax Tax that is charged to the customer. Parameter IDs (PIDs) Parameter IDs are used to determine the default value for a field in the user master record. The advantage of this procedure for the user is that he or she no loner has to specifically enter a field value on the screen. Parked Document An incomplete document may be temporarily stored within R/3 and then posted at a later date; this may be done by the same or a different user. Parallel Currency R/3 always stores the transaction currency and the local currency of a transaction. It is possible to configure R/3 to capture 2 additional or parallel currencies. The user can display the transaction in any of the currencies being stored. Postings to exchange rate difference accounts are made automatically. Payment Terms Payment terms are defined as 4 character alphanumeric keys. R/3 is delivered with typical payment term keys; however, new payment terms can be defined in configuration. Each term consists of up to 3 possible combinations of due date and discount availability.
4
Personnel Area The personnel area is an organizational unit that represents a specific area of the company and is organized according to aspects of personnel, time management and payroll. Each personnel area is allocated to one company code. Payment Program The payment program has been developed for international payment transactions with vendors and customers, and it handles both outgoing and incoming payments. It is flexible enough to allow you to define those payment features that vary from country to country such as payment method, payment form or data carrier specifications. Plant The Plant is an operating area or branch within an enterprise. It plays an important role in material valuations, inventory management, MRP, production, costing and plant maintenance. In configuration a plant is assigned to a company code. A plant can only belong to one company code; however, multiple plants can be assigned to the same company code.
Posting Key One and only one posting key is associated with every document line item processed within R/3. It is the posting key that controls whether a line item will be a debit or a credit. The posting key controls the specific type of account of the line item, and also influences screen display. Posting Period Variant Company codes are attached to a posting period variant. This variant controls the opening and closing of fiscal periods within R/3. Primary Cost Primary elements are cost or revenue items in the chart of accounts with corresponding general ledger (G/L) accounts in Financial Accounting. When creating a primary cost element or revenue element, it must be listed first as a G/L account in the Financial Chart of Accounts. Profitability Segment Profitability segments represent marketing and management views of an organization as opposed to legal reporting views. They are defined within an Operating Concern and are found in the Profitability Analysis module. Profit Center Profit centers collect revenues, and costs from the cost centers for which they are responsible. Purchasing Organization The purchasing organization is responsible for the complete processing of purchasing activities (such as requests for quotations and purchase orders). It maintains information relevant to vendors and pricing to support the most efficient and cost effective acquisition of goods. Reconciliation Account A general ledger account that ensures real-time integration of subledger accounts with the general ledger. Each subledger account has a reconciliation account defined within the company code portion of its master record. In this way, all postings to subledger account are also posted automatically to the G/L reconciliation account. Recurring Journal Entries Recurring Journal Entries are business transactions that are repeated regularly. Therefore recurring reference documents can be created within R/3 to speed periodic processing. These reference documents are then selected and processed at periodic intervals. The actual update to the G/L uses batch entry processing.
Reference Documents or Master Records are previously posted documents or master records, which can be copied, then modified to aid in data entry. Report Painter An ABAP/4 coded generator, which allows the end user the opportunity to define report rows and columns for customized reporting. Painter has a GUI front end for definitions. Report Trees Report Trees are graphical displays of reports organized by application area. R/3 contains standard report trees for each area, but users can customize to meet individualized company requirements. Report Variant A report variant provides a way of storing predefined selection criteria for a report. An individual report can have multiple report variants defined for it. However an individual variant can be used for only one report. They allow
standardized report settings in order to provide consistent report output.
Sales Organization A sales organization represents a selling unit in the legal sense and is allocated to a company code. This establishes a link between the SD and FI systems. Since a sales organization belongs to just one company code all financial transactions for this sales organization are posted to the linked company code. More than one sales organization can be linked to the same company code. Sapscript Sapscript is the integrated text management system of the SAP R/3 System. It is tightly integrated into the R/3 System. You will therefore be using it for many different text-processing tasks all over the R/3 System. Secondary Cost Element Secondary cost elements are created and maintained exclusively in Controlling (CO). They serve to assist in internal value flows, such as in internal activity allocation, surcharge accounting, and settlement transactions. Special G/L Indicator Indicator that identifies a special G/L transaction. Special G/L transactions include down payments and bills of exchange. The indicator triggers the use of an alternative reconciliation account for special business transactions in the subledger. These transactions are not balanced with the receivables and payables form goods and services. Special Period Special posting perod that divides the last normal posting period for closing operations. Up to 4 special periods are possible with FI.
Special Purpose Ledgers (Customer Defined) Customer Defined Special Purpose Ledgers are collections of information from R/3 applications (FI, MM, CO, SD), external data transfers and FI-SL adjustment postings in customer defined tables. These customer-defined tables then provide a database for user defined reporting. Standard Hierarchy One main hierarchy reflects the overall structure of a companys profit and cost center management, and is mandatory. This is called the standard hierarchy within R/3.
5Statistical Key Figures
Statistical key figures represent activities or statistics in controlling. They are measured in units of time of quantity and are used as an allocation basis for assessments and distributions. Substitution A Substitution is the process of replacing one value with another as it is input into R/3. Substitutions are transparent to the user inputting the data. SWIFT Code Society for Worldwide Interbank Financial Telecommunication. In foreign payment transactions, the identification of a bank is possible via the SWIFT code. This code is standard throughout the world. Tax Code Two digit code that reporesents the information required for identifying and calculating tax. It controls the tax rate, type of tax and calculation method. Transaction Currency This is the currency that is input on the header of the document. R/3 will always store the document in transaction currency.
6Validation
A validation is the process of checking values as they are entered into the R/3 system. If the conditions of the validation are not met, the resulting message can be either an error or warning message depending on user defined configuration. Valuation Balance Sheet term: the calculation of the value of all goods belonging to fixed and current assets as well as all payables at a certain time point according to legal requirements.
Vendor Master Record Data record containing all the information on the vendor that is required to carry out business transactions. It includes, for example, address and bank data. Worklist When displaying account balances or line items, you can use work lists to rapidly query a series of accounts at the same time. Work lists can be defined for the following objects: BUKRS (company code), KUNNR (customer), LIFNR (vendor) and SAKNR (G/L account).
Menu Paths
Unit: Appendix Topic: Menu Paths
Activities
Menu Path
Cross-Application Menu Paths (Menu Bar):

Maintain user profile Call up help Create session End session Display output controller Maintain batch input sessions General reporting System User profile Own data Help SAP Library System Create session System End session System Services Output controller System Services Batch input Sessions System Services Reporting
G/L Accounting:
Initial screen Master Data Display chart of accounts Display G/L account list Information system General ledger reports Master data Chart of accounts Information system General ledger reports Master Accounting Financial accounting General ledger
Activities
Maintain account definition Maintain company codespecific settings Business Transactions
Menu Path
data G/L account list Master records Individual processing Chart of accounts Master records Individual processing In company code
G/L account posting (ENJOY) Posting G/L account posting Complex/general posting Balance display Line item display Reporting Display G/L account balances Display structured account balances Information system General ledger reports Account balances General G/L account balances Information system General ledger reports Account balances General Structured account balances Document entry Others General posting Account Display balances Account Display/change line items
Accounts Payable:
Initial screen Master Data Create vendor list Create vendor master record Change vendor master record Display vendor master record Information system Reports for accounts payable accounting Master data Vendor list Master records Create Master records Change Master records Display Accounting Financial accounting Accounts payable
Activities
Menu Path
Track changes in an individual Master records Display changes master record Display changes to multiple accounts Business Transactions Post a vendor invoice Balance display Line item display Display documents Display document changes Manual outgoing payment with form printout Create recurring document Execute recurring entry program Automatic payment Reporting Carry out due date analysis Information system Reports for accounts payable accounting Vendors: Items Due date analysis for open items Logistics Materials Management Purchasing Purchasing: Purchase order Create Vendor/supplying plant known Document entry Invoice Account Display balances Account Display/change line items Document Display Document Display changes Document entry Outgoing payment Post + print forms Document entry Reference documents Recurring document Periodic processing Recurring entries Execute Periodic processing Payments Information system Reports for accounts payable accounting Master data Display changes to vendors
Purchasing Initial screen Create a purchase order
Activities
Post a goods receipt Carry out invoice verification Closing Activities Print balance confirmations Carry out foreign currency valuation Regroup receivables and payables
Menu Path
Purchasing: Purchase order Follow-on functions Goods receipt Purchasing: Purchase order Follow-on functions Logistics invoice verification Periodic processing Closing Check/count Balance confirmations: Print Periodic processing Closing Valuate Open items in foreign country Periodic processing Closing Regroup Receivables/payables
Accounts Receivable:
Initial screen Master Data Create customer list Information system Reports for accounts receivable accounting Master data Customer list Master records Change Master records Display Accounting Financial accounting Accounts receivable
Create customer master record Master records Create Change customer master record Display customer master record
Track changes in an individual Master records Display changes master record Display changes to multiple Information system Reports for accounts receivable
Activities
accounts Business Transactions Post a customer invoice Balance display Line item display Display documents Display document changes Manual incoming payment Print account statements Automatic dunning Reporting Create dataset for Accounts Receivable information system Use the A/R information system Account analysis Sales and Distribution Initial screen Create a sales order Create an outbound delivery
Menu Path
accounting Master data Display changes to customers Document entry Invoice Account Display balances Account Display/change line items Document Display Document Display changes Document entry Incoming payment Periodic processing Print correspondence Periodic account statements Periodic processing Dunning Information system Tools Configure Create evaluations Information system Tools Display evaluations Account Analysis Logistics Sales and Distribution Sales and Distribution: Sales Order Create Sales and Distribution: Shipping and Transportation Outbound delivery Create Single document With reference to sales order Sales and Distribution: Shipping and Transportation
Carry out picking
Activities
Billing Post a goods issue Credit Management Initial screen Listing customers with missing credit data Maintain credit management master data Display and release a blocked SD document Closing Activities Print balance confirmations Carry out foreign currency valuation Regroup receivables and payables Start a valuation run
Menu Path
Picking Create transfer order Single document Sales and Distribution: Billing Billing document Create Sales and Distribution: Shipping and Transportation Post goods issue Outbound delivery single document Accounting Financial accounting Accounts receivable Credit management Credit Management: Credit management info system Customers with missing credit data Credit Management: Master data Change Credit Management: Exceptions Blocked SD documents
Periodic processing Closing Check/count Balance confirmation: Print Periodic processing Closing Valuate Open items in foreign currency Periodic processing Closing Regroup Receivables/payables Periodic processing Closing Valuate Further valuations
Asset Accounting
Initial screen Accounting Financial accounting Fixed assets
Activities
Master Data Create asset balance lists Create asset master data Business Transactions Post asset acquisition (integrated with Accounts Payable) Asset query Schedule unplanned depreciation Scrapping Asset under construction: Define distribution rules Asset under construction: Complete settlements Reporting and Closing Print asset charts Print inventory lists Asset history sheet
Menu Path
Info system Reports on Asset Accounting Asset balances Balance lists Asset balances Asset Create Asset Assets Posting Acquisition External acquisition With vendor Asset Asset Explorer Posting Manual val. correction Unplanned depreciation Posting Retirement Scrapping Posting Cap. asset u. const .Distribute Posting Cap. asset u. const .Settle
Info system Reports on Asset Accounting History Asset History Info system Reports on Asset Accounting Asset balances Inventory lists Inventory list Info system Reports on Asset Accounting Balance sheet explanations International Asset history sheet
Travel Management:
Initial screen Accounting Financial accounting Travel
Activities
Master Data Create travel privileges Create vendors Business Transactions Maintain trip Settle trip Create trip transfer document Create accounting documents
Menu Path
management Person-related master data Maintain Person-related master data Create vendors Travel manager Travel expenses Periodic processing Settle trips Travel expenses Periodic processing Transfer to Accounting Create posting run Travel expenses Periodic processing Transfer to Accounting Manage posting runs
Bank Accounting:
Initial screen Master Data Maintain list of banks Business Transactions Manage cash journal Manual check deposit transaction Manual bank statement Outgoings Cash journal or Incomings Cash journal Incomings Check deposit Manual entry Incomings Bank statement Manual entry Master records Bank master record Change Accounting Financial accounting Banks
Closing in the General Ledger
Activities
Initial screen Create accrual/deferral Reverse accruals/deferral Analyze GR/IR clearing account Create compact journal
Menu Path
Accounting Financial accounting General ledger Periodic processing Closing Valuate Enter accrual/deferral doc. Periodic processing Closing Valuate Reverse accrual/deferral document Periodic processing Closing Regroup GR/IR clearing Information system General ledger reports Document General Compact document journal SAP minimal variant Information system General ledger reports Balance sheet/profit and loss statement/cash flow General Actual/actual comparisons Periodic actual/actual comparison Information system General ledger reports Balance sheet/profit and loss statement/cash flow General Actual/actual comparisons Profit and loss statement using cost of goods sold (German trade law)
Create balance sheet according to period accounting Create balance sheet according to cost of sales accounting

AC010 Financial Accounting and Reporting

Uploaded by

Copyright:

Available Formats

AC010 Financial Accounting and Reporting

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

AC010 Financial Accounting and Reporting

Uploaded by

Copyright:

Available Formats

What are some of the main master data and business transactions covered in asset accounting?

What are some of the main master data and business transactions covered in asset accounting?

What steps are involved in the periodic processing of travel expenses?

What steps are involved in the periodic processing of travel expenses?

AC010

SAP AG 1999 SAP AG

AC010 Financial Accounting and Reporting

Financial Accounting and Reporting

Financial Accounting and Reporting

AC290 Real Estate Management AC305

Asset Accounting AC220 5 days

Special Purpose Ledger AC700 5 days

Inflation Accounting AC275 1 day Travel Management Travel Planning

from July 2000 on

Knowledge of accounting processes in Financial Accounting SAP20 (recommended)

Members of the FI project team Employees from accounting departments

Navigation: Unit Objectives

Navigation: Business Scenario

Logging on to the R/3 System

Client User Password

Standard toolbar Options Title bar Application toolbar

System function name : Activity

SAP Easy Access - Standard

SAP Easy Access

SAP Easy Access

End session User profile Services Utilities List Workflow Links

using Favorites or the tree structure

using the menu path

/nFD03 using the technical name (transaction codes)

Role-Based User Menu

SAP Easy Access

I42 (1) (400)

Field Help - F1, F4

Display Customer: Initial Screen

SAP Online Help

System Functions - Services

SAP Easy Access

System Functions - User Profile

Maintaining your user profile

Decimal notation 1.234.567,89 1,234,567.89 1 234 567,89

Table Settings - Example

Personalizing the Frontend

Create Sales Order: Initial Screen

Create Sales Order: Initial Screen

Frankfurt sales organization

... and with GuiXT ... and with GuiXT

R/3 Standard ... R/3 Standard ...

Returns Free of charge

Navigation: Unit Summary

Name of screen: _______________________________________ Transaction: __________

Unit: Navigation Topic: User-specific settings

Exercises marked * are optional.

Unit: Navigation Topic: User-specific settings

Level 3: Special topics

Balance sheet ... P&L ... ...

SAP System Hardware

General Ledger Accounting Subsidiary ledgers

Accounting Target Groups

General Ledger Accounting

General Ledger Accounting: Unit Objectives

Name of screen: _____________________________ Transaction: