SAP ERP Financials User's Guide: Heinz Forsthuber, Jörg Siebert
SAP ERP Financials User's Guide: Heinz Forsthuber, Jörg Siebert
Bonn �
Boston
Contents at a Glance
1 Overview ..........................................................................................19
Introduction ................................................................................. 15
1 Overview ....................................................................... 19
..........................................2GeneralLedgerAccounting 39
7
Contents
......................................3AccountsPayableAccounting 105
8
Contents
.................................4AccountsReceivableAccounting 163
9
Contents
..........................................................5AssetAccounting 261
10
Contents
11
Contents
.........................................................................Appendices 531
12
Contents
13
Accounts Payable manages payables. This chapter describes
the points of contact between SAP ERP Financials and the
purchas-ing department. It also details how to perform efficient
postings. Information on standard evaluations and the automatic
payment run rounds off the chapter.
For subledger accounts you differentiate between vendor accounts or vendors Accounts payable
and customer accounts or customers. In contrast to general led-ger management as
a continuous
accounting, in which you only manage the total of payables for the financial
business process
statement, you use Accounts Payable Accounting to manage all details
regarding business transactions, such as invoices, credit memos, and
outgoing payments. The interaction between the purchasing depart-ment and
accounts payable accounting assumes a significant role here. At
105
3 Accounts Payable Accounting
a very early stage, purchase requisitions or purchase orders lay the foun-
dation for successful invoice verifications. You also have to ensure a cor-
rect documentation of the goods receipt, because it is used as the basis
for releases for payments of invoices. The FI-AP component keeps and
manages account-based data of all vendors. Furthermore, it is an integral
part of the purchasing system. Purchase orders, deliveries, and invoices
are managed based on vendors and update vendor evaluations.
Features FI-AP (accounts payable accounting) ensures that legal obligations to keep
records are fulfilled for reliable accounting but also serves as the information
source for an optimal purchasing policy and supports the enterprise’s liquidity
planning owing to the direct integration with cash management and
forecasting. Account analyses, due date forecasts, and further standard
reports are available for the open item management. You can customize the
correspondence according to the individual require-ments of your enterprise.
The payment program automatically pays due payables and closes the
corresponding items. To document the processes in accounts payable, you
can use account balances, journals, balance audit trails, and numerous
standard reports. For key date valuations you revaluate foreign currency
items, determine vendors on the debit side, and scan the balances
established this way for remaining terms.
This section focuses on the vendor master record. The data contained
therein is required for handling business transactions in the accounting
area and in the purchasing area.
106
Master Data 3.3
for individual company codes is specified in the company code area. This
includes the account number of the reconciliation account in the general
ledger, the terms of payment, and the settings for the dunning proce-dure.
Figure 3.1 shows the basic structure of a vendor account.
Vendor
Master Data
General
Data
Company Code
Data
Purchasing
Data
For the integrated use with the MM module (materials management ), you
are provided with additional fields for the vendor master record. These
fields contain information that you require to handle business transactions
in the purchasing component. In this area, you enter data on requests, on
purchase orders, and for invoice verifications. This data can vary in each
defined purchasing area and is only used by applica-tions of the MM
module. This data includes conditions (for example, purchase order
currency, terms of payment, or minimum purchase order value), sales
data (sales person including telephone number), and control parameters.
107
3 Accounts Payable Accounting
You create vendor master records by selecting the menu path Account-
ing • Financial Accounting • Accounts Payable • Create Master Data
(Transaction FK01).
Central/ Alternatively, you can enter the general data and the company code data
decentralized separately. However, you can enter and display the purchasing data
maintenance of the
within the vendor menu in the Central Maintenance only. In contrast to the
master record
maintenance of the customer accounts, the system doesn’t open a dialog
box but navigates you to an initial screen (see Figure 3.2). Here, you can
enter the account number of the vendor and the company code. When
you create a vendor account, you must also specify an account group,
which controls the internal and external number assignment when
creating the master record.
When you press the [Enter] key, the SAP system displays the screen
shown in Figure 3.3.
108
Master Data 3.3
EE Search Terms
In this field, you can enter a freely selectable term that is used for the
search for master records with the matchcode. To ensure that the field
is filled uniformly, it is recommended that you specify rules. For the
standard matchcode, this is the primary key with which you can search
for master records most rapidly.
EE Language (Communication)
Here, you define the language in which the correspondence is writ-ten.
If a business partner is both a vendor and a customer, you’re provided Clearing processes
with the option to have the system clear receivables and payables auto- with vendors that
are also customers
matically (automatic payment program or dunning). In this case, you must
enter the account number of the customer in the vendor master
109
3 Accounts Payable Accounting
record and vice versa (see Figure 3.4). If these fields are filled, the sys-
tem displays the Clearing field in the account management for the data of
the company code. Clearing is not possible until this field is activated. In
the example, the vendor is also a customer. Here, a link to customer
account 1000 including subsequent clearing was selected. The effects of
this become particularly obvious in Section 3.7, Automated Payment
Transactions.
Payment If you press [Enter], the system takes you to next entry screen (see Fig-ure
transaction 3.5):
settings
EE Bank Details
If the automatic payment program is supposed to consider a vendor,
you need to enter the bank details. For automatic debits, the corre-
sponding field must also be selected.
110
Master Data 3.3
EE Alternative payee
If you enter the account number of the vendor here, all payments are
made using the bank details of this business partner (bank transfers,
automatic debit, credit memos). This field exists in the general part, in
the company code area, and at the document level. The specification
that is more detailed applies (from the general area to document level).
EE Bank type
If you define multiple bank details in a vendor master record, you can
differentiate them by means of any four-digit abbreviation (partner bank
type). If you want to pay an open item using specific bank details of the
vendor, you must define the corresponding abbreviation in the line
item. The payment program of the SAP system then controls the
specified bank details of the vendor.
EE IBAN
In many cases, you can determine the IBAN from the bank key and
account number. Because this procedure is not necessarily unique, you
should always verify it. Chapter 6, Bank Accounting, provides more
information on the IBAN and SEPA.
111
3 Accounts Payable Accounting
When you press [Enter], the system navigates you to the maintenance of
the company code area of the vendor account—to the account manage-
ment data first (see Figure 3.6):
EE Reconciliation account
Each posting to an account of subledger accounting automatically cre-
ates an entry to the general ledger. This integration is ensured through
the reconciliation account. The field status group in the master record
of the reconciliation account specifies the screen layout for document
entry. The items of the vendor’s account are managed in the currency
of the reconciliation account.
EE Sort key
You use sort keys to display line items. Usually, the SAP system sorts
the documents in the line item display based on the content of the
Assignment field in the document. This sort key controls how the
Assignment field is automatically filled during document entry if it is not
populated with a value from another source.
EE Authorization
In this field, you can specify who receives change or read authoriza-tion
for this account.
112
Master Data 3.3
When you press [Enter], the system takes you to the settings for the pay-
ment transactions in financial accounting. The system now displays the
screen shown in Figure 3.7.
EE Payment terms
This key is used for orders, purchase orders, and invoices and pro-
vides information about dunning and payment transactions. The value
entered here is used as a default value for the document entry.
EE Tolerance group
To map different rights for the processing of business transactions, you
can assign accounting clerks to so-called tolerance groups. You make
specifications for the granting of cash discounts and for the han-dling of
payment differences for each tolerance group. This entry affects
dunning and the entry of payment transactions. For manual closing, the
payment differences are accepted by the system up to the defined
tolerance, and the items are closed.
113
3 Accounts Payable Accounting
Dunning vendors When you press [Enter], the system takes you to next entry screen (see
Figure 3.8). You can also dun vendors. This is particularly useful if the
payables are less than the receivables.
114
Master Data 3.3
EE Dunning Procedure
If this business partner is supposed to be considered in the automatic
dunning procedure, you must define a dunning procedure here. The
entry is used as a default value for the document entry.
EE Dunning block
If you select this field, this business partner is not included in the
dunning proposal of the automatic dunning program.
EE Dunning level
This field is usually set by the dunning program. In exceptional cases,
you can change the dunning level manually. The dunning level influ-
ences the next dunning run. If the dunning level is 0, the system uses
the specified minimum number of days to calculate the days in arrears;
for all other dunning levels, the system uses the grace days. The days
in arrears define the date for the next dunning run of this account.
EE Dunning clerk
The specified name is printed on the dunning notices. The dunning
clerk does not have to be identical to the accounting clerk.
EE Accounting clerk
The name that corresponds to the defined ID appears on all corre-
115
3 Accounts Payable Accounting
With these specifications, two of three possible parts of the vendor mas-
ter data are maintained at the client and company code level. If a vendor
account is no longer supposed to be used, various blocking mechanisms
are available.
Central block The master record of a vendor contains multiple fields for blocking the
account. This makes it possible to centrally block an account for account-
ing and purchasing. For accounting, you have the option to block the
account in one or more company codes. A dunning or payment block can
be set at the company code level. You can set and undo the block-ing
indicator in the subledger at any time. Figure 3.9 illustrates a central
block, which is available under the menu path Accounting • Financial
Accounting • Accounts Payable • Central Maintenance • Master Data •
Block/Unblock menu path (Transaction XK05).
116
One-Time Vendor 3.4
For vendors, you can set posting blocks and purchasing blocks. The block
for quality reasons differentiates again between blocks for purchase
orders; for requests and purchase orders; for purchase orders, requests,
and goods receipt; and for source determinations and total blocks.
In addition to the options for defining master data for accounts pay-able
and blocking it at any time, an option for one-time vendors is also
available.
The SAP system provides a special master record type for one-time or One-time vendor
sporadic vendors. In contrast to the “regular” master records (customers
and vendors), this master record does not contain specific data of the
business partner, such as the address and bank details. This information
is entered separately during document entry. When posting to a one-time
account, the system automatically navigates to a master data screen
where you can enter the specific data of the business partner (see Figure
3.10). Master records for one-time accounts are stored separately in a
specific account group. The system hides the specific fields of the busi-
ness partner when the master data is entered (see Figure 3.11).
If you decide to use one-time accounts, you should create multiple one-
time accounts, because the large volume of postings to a one-time
account can easily lead to confusion. In this case, you should group the
business partners according to defined criteria (first letter, area, indus-try).
These criteria assume a particular role, because it is critical for post-ings
or clearings to quickly find the appropriate account of the business partner
and the corresponding item.
You maintain one-time accounts the same way you maintain customer or Limited
vendor accounts. The open items can be dunned using the dunning functionality
117
3 Accounts Payable Accounting
118
Overview of the Integrated Business Transaction 3.5
Ordering Process
The ordering process in this example starts with a purchase requisition. Purchase
Before you can generate a purchase order for the vendor, this internal requisition
119
3 Accounts Payable Accounting
Goods Receipt
GR/IR account If goods have been received for this purchase order, the goods receipt is
not only based on quantities but also documents the exact value of the
goods for the purchase order. If no vendor invoice that corresponds to the
goods receipt is available at the end of the month, this value serves as the
basis for accrual and deferral postings. You can find a detailed description
in Chapter 7, Section 7.3, Automatic Maintenance of the GR/IR Account.
Incoming Invoice
Processing of incoming invoices is one of the traditional areas in accounts
payable accounting. Services are usually documented in paper form and
sent by post: “No posting without document.” This statement referred to
paper documents in the past. Longer legally stipulated retention periods
and the demand for more comfortable options to access archived docu-
ments ruled out microfilming. Today, enterprises store a scanned, optical
image of the original document. Up until recently, this scanning process
was performed quite late in the process, but now a lot of enterprises per-
form it at the beginning of the process chain. The benefit of this is addi-
tional transparency and an acceleration in processing, which means that
cash discounts are no longer lost thanks to timely processing and pay-
ment. However, the implementation of this requires a central inbox for
incoming invoices. Once the invoices have been scanned, they find their
way through the enterprise as optical documents via the workflow.
EDI If a large invoice volume is involved, the transfer of invoice data via EDI
(electronic data interchange) including a subsequent printout of the col-
120
Overview of the Integrated Business Transaction 3.5
Payment
If goods and invoices have been received and the invoice verification has
a positive result, the automatic payment program is responsible for
making the payments at the optimal time. The payment run includes the
planned liquid funds (see Chapter 6, Section 6.5, Payment Transactions
and Bank Communication) and cash discounts and due dates for net pay-
ments of invoices. Because the accounts payable accountant is involved
in this process, the following sections discuss the manual and automatic
payment transactions.
Cashed Checks
Cashed checks enable specific evaluations. You can evaluate when and
whether vendors cashed the received checks and even indicate this as an
average value in the master record.
121
3 Accounts Payable Accounting
You can use several transactions to post incoming invoices in the SAP
system. For example, you can enter an incoming invoice in the SAP sys-
tem either in the logistics area in the MM module or within the account-ing
area in the FI-AP component.
The general FI-AP posting transaction has basically been provided since
the days of the R/2 system (formerly Transaction TB01). The menu path
in SAP ERP is Accounting • Financial Accounting • Accounts Payable
• Other Postings • General Invoice (Transaction FB01).
The most important fields for entering a document header are the
following:
Required entry Pressing [Enter] takes you to the next screen (see Figure 3.14). The ven-
fields dor’s payables account controls the selection of the fields for the entry
screen and their ready-for-input status. For entering a vendor item you
122
Entering Incoming Invoices 3.6
require other fields than for entering a G/L account item. In this exam-ple,
the Business Area field has the Mandatory Entry field status.
After you have entered the vendor item , first enter the posting key of the
document item, which is 40 in this example (debit posting to a G/L
account), and the corresponding account. When you press [Enter], the
system takes you to next screen (see Figure 3.15).
123
3 Accounts Payable Accounting
You can display the document item, which has been automatically gener-
ated by the SAP system, via the menu path Document • Simulate.
Figure 3.16 shows the posting from the example, which the system gen-
erates after you click on the Save button. The G/L accounts involved are a
material stock account for goods receipt, the “payables” account
124
Entering Incoming Invoices 3.6
for invoice receipt, and the typical interim account, “GR/IR clearing
account,” which is usually directly cleared when the invoice receipt is
entered. In addition to Transaction FB01, the SAP system provides you
with further options.
125
3 Accounts Payable Accounting
EE Basic data
This refers to general document data.
EE Payment
Here, you specify data for the payment transactions.
EE Tax
If the invoice contains multiple tax codes and the tax amounts are
supposed to be copied from the invoice, you can enter them here.
EE Details
Here, you specify additional fields for the business partner line, such as
assignment number and business area.
EE Notes
You can define additional notes for the open item. The system assigns
the text to the receivable or payable and not to the complete docu-
ment.
EE Local currency
This tabs appears if postings are made in a foreign currency or if paral-
lel currencies exist in the company code.
You can find this transaction in the menu path Accounting • Financial
Accounting • Accounts Payable • Posting • IR/GU Fast Entry • Invoice
126
Entering Incoming Invoices 3.6
Pressing [Enter] takes you to next screen, the actual fast entry screen.
Figure 3.19 shows a screen that is populated with a minimum of infor-
mation. You can easily access all field information using the Tab key. The
system displays the vendor item first and then offsetting items including
additional account assignments.
127
3 Accounts Payable Accounting
The entry transactions described so far, that is, general posting (Transac-
tion FB01), single-screen transaction (FB60), or fast data entry (Transac-
tion FB10), can only be used to a limited extent; the entry transaction in
the MM logistics module may close this gap.
128
Entering Incoming Invoices 3.6
The example in Figure 3.20 shows an invoice receipt with purchase order
reference. When you enter purchase order number 4500018601, you
need to enter additional information on the amount and quantity.
129
3 Accounts Payable Accounting
Once incoming invoices have been entered in the SAP system, you can
start the payment process for paying the vendor.
Accounting and You can structure the payment transactions in an enterprise accord-ing to
process view various aspects and issues and separate the individual processes. You
distinguish between the accounting view and the process view. The
accounting view—as usual—differentiates between incoming pay-ments
and outgoing payments. The process view, in contrast, differenti-ates
between incoming and outgoing payment processes. The outgoing
process is usually triggered via a payment run by your company, and the
corresponding information (bank, account, amount, and so on) is defined
by the SAP system and passed on to third parties. This includes bank
transfers and outgoing checks to third parties (outgoing payments) but
also debit memos that are collected by third parties (incoming pay-ments).
The incoming process instead is triggered by third parties, and the
corresponding information is provided from the outside (banks, ven-dors,
customers). This includes bank transfers and incoming checks by third
parties (incoming payments) but also debit memos that you collect from
third parties (outgoing payments). Consequently, SAP’s automatic
payment program manages the outgoing payments of an enterprise but
also processes the outgoing payment process and thus includes both out-
going payments and incoming payments (debit memos). In this context,
the payment program has the following functions:
130
Automated Payment Transactions 3.7
Before you can execute Transaction F110 for the payment program, you
need to implement some basic settings.
Which specifications from the master record of the business partner are Payment method:
inevitably required is defined for each country. If one of the neces-sary Check (C)
specifications is not provided in the master record, you cannot use this
payment method. For the C payment method (Check), a complete
address must be maintained in the master record. Otherwise, the C pay-
ment method is not valid for this business partner. Furthermore, under
which conditions this payment method can be used is defined in the
individual company codes for each payment method. The following also
applies here: If one required condition is not met, you cannot use this
payment for the respective open item. These defined checks affect the
following specifications:
131
3 Accounts Payable Accounting
EE Allowed bank details abroad (country code in the bank master record)
The payment program only selects the payment method for which you
specify a minimum or maximum amount if the payment amount doesn’t
fall below the minimum amount and doesn’t exceed the maximum
amount.
A due open item may be included in the exception list for several rea-
sons. A brief look at the exception list is sufficient to determine why an
item is not included in the proposal list.
132
Automated Payment Transactions 3.7
You can remove or set payment blocks during the processing of the pay-
ment proposal. However, you cannot remove and set all payment blocks
in a proposal. The restrictions for the respective block reason are defined
in Customizing. For the example in Figure 3.22, it is specified that the V
payment block cannot be removed during the processing of the payment
proposal. If the block reason “ ” (Free for payment) is not selected, the
account cannot be manually blocked in the payment run.
If you have implemented the basic settings for the payment methods and
payment block reasons, you can access the payment program.
You access the initial screen of the payment program via the menu path
Accounting • Financial Accounting • Accounts Payable • Periodic
Processing • Pay (Transaction F110).
First, enter the date of the payment run and an identification feature. You
can add a sequential number to the identification feature to distinguish
between different runs on the same date.
133
3 Accounts Payable Accounting
ID and bank The example illustrated in Figure 3.23 displays 01/12/2008 as the day of
communication the execution and the ID of the person responsible, that is, JS2. The
Identification field is provided with a new function and meaning in the
context of bank communication. For detailed information, refer to Chap-ter
6, Bank Accounting.
To enter the parameters and navigate to the respective tab. You have to
specify the complete company codes (four digits) and separate them by a
comma. In addition to single values, you can enter intervals. No blanks
are allowed between the defined company codes or intervals. The
required payment methods must be indicated without any separa-tors.
The posting date of the next payment must run to check the due date of
the payables. If an item is due on the date of the next payment run, it will
be paid in this payment run. Receivables (debit memos) can generally not
be paid before the baseline date for payment. They are paid once the due
date is reached or expired, independent of when the next payment run is
supposed to be executed. You additionally have to enter the vendors or
customers that the SAP system is supposed to include in this payment
run. This can be done in single values or intervals. The parameters
illustrated in Figure 3.24 consider all posting documents until 01/12/2008
in company code 1000. The payment run is supposed to clear the
payables using a payment document with 01/12/2008 as the posting date.
All due payables of a vendor are supposed to be paid via check or bank
transfer. 10/12/2008 is defined as the date for the next
134
Automated Payment Transactions 3.7
payment run; that is, the system selects all items with a due date for net
payment before this date.
The Free selection tab navigates you to the entry of further selection cri-
teria. Here, you can define fields at the document level or from the mas-
ter records of the business partners as additional selection criteria . You
enter the name of the database field in the Field Name field. The system
supports the search process for the corresponding field name with the [F4]
search help. If you select the Exclude values field, this payment run
doesn’t include the documents with the corresponding criterion. The
setting in Figure 3.25 doesn’t define any restrictions.
In the payment run, you can define restrictions for the additional log. The
log displays the processing logic of the payment program with the
corresponding level of detail (see Figure 3.26).
135
3 Accounts Payable Accounting
136
Automated Payment Transactions 3.7
These settings must be saved with the Save button. Then, navigate to the
Status tab. It displays the status message “Parameters have been
entered” (see Figure 3.28).
137
3 Accounts Payable Accounting
Once all parameters have been entered, you can schedule the payment
proposal.
Based on the defined parameters, the SAP system determines the out-
standing payments for the vendor or customer. Here, the generated pay-
138
Automated Payment Transactions 3.7
ment proposal is the first step. For this purpose, click on the
button. The Schedule Proposal dialog box opens (see Figure 3.29).
When you select the Start immediately option and press [Enter], the
processing is performed in the foreground. You can retrieve data of this
payment run using the proposal list, which stores a wealth of informa-tion,
for example, an overview of all payments and line items.
At the end of this list, you can find a list of the payment amounts, sorted
by the following criteria:
EE Business areas
EE Countries
EE Currencies
EE Payment methods
EE Banks
139
3 Accounts Payable Accounting
dure. Here, the proposal list is processed first, and then the payment
medium is generated. The status message in Figure 3.30 indicates that
the proposal run created a payment proposal.
Task sharing per The system now displays the Accounting clerk dialog box (see Figure
accounting clerk 3.31). If you select All accounting clerks, the system selects all payments
of a payment proposal run for processing. To only process the payments
of the payment proposal that are assigned to a specific accounting clerk,
select the Selected accounting clerk option and enter the correspond-ing
ID. If you want to process all payments that aren’t assigned to an
accounting clerk, select the Selected Accounting Clerk option and don’t
enter any ID.
Task Sharing
Particularly if a large number of vendors and customers are included in a pay-ment
proposal list, it makes sense to use the selection of accounting clerks to enable task
sharing. A prerequisite is that the respective accounting clerks are also stored in the
master data of the subledger account.
If you press the [Enter] key, the system takes you to the overview of the
payment run. The first level displays a list of the individual payment media
and exceptions for each business partner.
140
Automated Payment Transactions 3.7
The example shown in Figure 3.32 is not that complex. It refers to the
enterprise, Testcompany, which is not supposed to be paid. The payment
volume of the proposal run is €0.
You can view the corresponding open item if you double-click on a row Clearing of
within the exceptions. At the business partner level, you can see in Fig- customers/
vendors
ure 3.33 that the Testcompany example involves the clearing process of
vendor 2000000030 and customer 1000, that is, from a vendor that is also
a customer.
When you double-click on a line item, the system provides information on Removing the
why this item has been included in the exception list. You can remove payment block
141
3 Accounts Payable Accounting
the payment block here. Then, the item would be included in the actual
payment run. Note that there are also payment blocks that you cannot
remove in the payment proposal.
142
Automated Payment Transactions 3.7
143
3 Accounts Payable Accounting
After the changes have been saved, the updated payment proposal list
provides the corresponding information. In the example shown in Figure
3.36, this is the second row, with an amount of €550,000 that has to be
paid. The debit balance in the first row, which is not supposed to be paid,
is then increased by this value.
When the processing of the payment proposal list has been completed,
clearing entries and payment media can be generated.
After you have processed the proposal list, you can schedule the payment
run using the button. The amount of €550,000 is cleared in
the vendor account with an automatically generated payment document.
Accordingly, the status message illustrated in Figure 3.37 changes.
144
Automated Payment Transactions 3.7
Parallel Process
The SAP system creates the clearing document and payment medium in
par-allel and independently of each other. You should consider this aspect
par-ticularly when you reconfigure the payment run. If the Customizing is
set incorrectly, the system may clear items on the credit side without
generating a payment medium subsequently.
In addition to the automated payment run, you can also trigger the pro-
cess manually.
145
3 Accounts Payable Accounting
The basis of manual outgoing payments are usually payables that exist in
the SAP system. In individual cases, advance payments can also be
made without posted payables. This is referred to as a payments on
account . You access the initial screen of outgoing payments via the menu
path Accounting • Financial Accounting • Accounts Payable • Posting •
Outgoing Payments • Post (Transaction F-53).
For complete clearings, the SAP system generates the screen shown in
Figure 3.39. In the initial screen of the Enter Outgoing Payments transac-
tion, you enter the document header as usual. The input in the Clearing
text field appears for the clearing item in the vendor account. Compared
to the previous document entry, the bank data is new.
146
Manual Outgoing Payments 3.8
The outgoing payments are implemented through one of the defined Outgoing
house banks. The SAP system maps transactions in this bank account in payments through
the house bank
a G/L account. You can enter the corresponding G/L account number in
the Account field in the Bank data area. You then have to specify the
payment amount and additional data. Additional selections enables you to
include additional selection criteria (amount, document number, and so
on).
The system supports you in specifying the offsetting entry in the ven-dor
account. Consequently, you only need to enter the vendor account and
the K account type (vendor). The SAP system supports you with a list of
the open items that are supposed to be assigned. When you press the [¢]
key, the system opens the next screen, which displays the exist-ing open
items selected by the system in the account (see Figure 3.40). Depending
on the setting in the editing options, you have to assign the corresponding
open items by double-clicking on the payment amount fields. The
example in Figure 3.41 shows the assignment of an open item with an
amount of the outgoing payments of €11,000. The 2% cash dis-count is
not used here.
The entered amount and the assigned amount are identical in the exam- Simulating
ple. Therefore, the document can be posted. You can call the document documents
147
3 Accounts Payable Accounting
Postings in the The objects involved are a vendor from the FI-AP component and the
SAP system general ledger from the FI-GL component. First, the “enter incoming
invoice” activity leads to a credit entry for the “vendor” SAP object. The
SAP system created an automatic entry to the reconciliation account
defined in the vendor master record. The system posted the document
and simultaneously closed the open item with the outgoing payment. The
“payables” G/L account is not cleared, because the SAP system only
stored the balance of the reconciliation account . The actual clearing pro-
cess takes place for the “vendor ” SAP object. The corresponding offset-
ting entry is posted in the G/L account that is defined in the initial screen
(see Figure 3.39). Both documents are linked to each other through a 10-
digit clearing number (in this example, this is the document number of the
payment), as you can see in Figure 3.42.
Tolerance limits for Differences that exceed the tolerance limits for postings may occur in the
difference postings payment transaction. These limits are the tolerances defined by the
accounting clerks and business partners in the SAP system during the
system configuration. This could have been done for several reasons, for
example, because a partial amount was paid (as in the example in the
following section).
148
Manual Outgoing Payments 3.8
When processing the open items, the following options are available in
such cases:
149
3 Accounts Payable Accounting
Figure 3.43 Outgoing Payments—Initial Screen for the Residual Item Formation
When you press [Enter], the system navigates you to the list of the
selected items. From the processing of the open items, you must go to the
Residual Items tab. In the Residual Items column, you enter the amount
of the residual item . Alternatively, you can copy the remain-ing amount
calculated by the system by double-clicking on the Residual Items field.
You can either first simulate or directly post the document. However, in
both cases the system outputs the message that the item of the residual
item still has to be corrected. For residual items, the SAP system requires
you to make an entry in the text field of the document item (required entry
field).
150
Manual Outgoing Payments 3.8
Figure 3.44 Residual Item for Outgoing Payments—List of the Selected Items
Then, you can post the document. Figure 3.46 shows the process in the
line item display. The original open item has been cleared, and the sys-
tem has generated a new residual item.
151
3 Accounts Payable Accounting
In addition to the complete clearing and the described residual item for-
mation, there are further options for posting outgoing payments.
Pressing the [Enter] key takes you to the next screen. Now, you first have
to assign the respective invoices to outgoing payment. This can be done
by double-clicking on the corresponding field in the amount column of the
displayed item list (see Figure 3.47). Then, select the Partial Payment tab
(see Figure 3.48).
In the Payment amount column, you enter the amount of the partial pay-
ment. Alternatively, you can double-click on an amount to copy it. Figure
3.49 shows this process in the line item display.
152
Manual Outgoing Payments 3.8
153
3 Accounts Payable Accounting
The two items are indicated as open and linked to each other with iden-
tical content in the Assignment field. You can evaluate manual or auto-
mated outgoing payment postings—independently of whether they are
implemented as complete clearings, residual items, or partial payments—
with reports in SAP ERP.
154
Evaluations in Accounts Payable Accounting 3.9
screen shown in Figure 3.50 enables you to select the vendors that still
need to be confirmed.
When you click on the button, the system executes the selection run
and displays the results list from Figure 3.51.
This list indicates that numerous master record changes still have to be
confirmed. The confirmation date indicates the date from which this
process step is pending.
155
3 Accounts Payable Accounting
The example in Figure 3.52 shows the detailed status of a master record
that has not been confirmed yet. The Changes to Sensitive Fields but-ton
displays the details before and after the modification of the master record.
Based on this information, the modification can be confirmed or rejected.
In addition to maintaining vendor master data, you can also list payables
in the open item due date analysis listed according to different blocks.
156
Evaluations in Accounts Payable Accounting 3.9
Figure 3.53 Selection for the Open Item Due Date Analysis
The result of this selection is illustrated in Figure 3.54. The drill-down Analysis of the
report shows a sorted list with intervals of 30 days on the selected key liquidity
requirement
date. The result includes payables that are already due (past) or items
that will be due in the future (not due). This indicates that a considerable
liquidity requirement of about €2 million already exists for a short-term
period of 0 to 30 days.
157
3 Accounts Payable Accounting
You can better analyze these values using the navigation within the drill-
down report. Figure 3.55 illustrates a drill-down to the payables that are
due to vendor 1000 (C.E.B. Berlin). Here, the screen is nearly identical to
the general overview, because the major part of the payables is due
within 0 to 30 days.
At this point it is useful to navigate to the line items of the vendor using
the report-to-report interface to view at invoice level whether this huge
amount is made up of multiple items or to view the underlying deliver-ies
and services. If this flexible and versatile report is not sufficient, you can
also use the vendor information system.
The vendor information system is a kind of data cube that is filled with up-
to-date information at regular intervals. You can view, rotate, and
158
Evaluations in Accounts Payable Accounting 3.9
The data cube of the vendor information system is static and always
refers to a specific point in time. Via the menu bar entry, Extras • Day/
Time On, you can display the creation time. The evaluations don’t con-
sider the posting procedures after this point in time. You therefore need to
perform updates at regular intervals. The following sections describe the
due date analysis as an example from the three evaluations shown in
Figure 3.56.
You can access the due date analysis via the following views:
EE Company code
EE Business area
EE Country
159
3 Accounts Payable Accounting
EE Planning group
EE Reconciliation account
The fixed, defined data cube provides these dimensions as standard eval-
uations. The example that is illustrated in Figure 3.57 uses the company
code as the display format.
A list of the company codes that exist in the system including the respec-
tive payments that are currently due or will be due in the future maps the
structures and may indicate faulty processes within a group with
worldwide operations.
160
Conclusion
3.1
0
If the due (to be paid) proportion of the total open item balance is dispro-
portionally high, this may be due to a poorly structured invoice receipt
process. Figure 3.58 illustrates an example of a demo system in which the
total open item balance is due as of company code IDES Australia. This is
based on the fact that no new incoming invoices with a date of required
payment are entered in this test company code, and outgoing payments
are not made for older invoices. In contrast, some items are not yet due
for the second company code on top, Company 1000. With a double-click
you can navigate to the display shown in Figure 3.58. This view allows for
analyses per vendor and provides subsequent drill-down options to the
vendor’s line items.
Overall, the evaluations for critical master record modifications, the open
item due date analysis, or the vendor information system provide useful
support for the daily work of the accounts payable accountant.
3.10 Conclusion
161
3 Accounts Payable Accounting
ment this process step is performed and depending on the structure of the
invoices, different SAP transactions are used. The next process step
involves manual or automated outgoing payments. In particular, the two-
level procedure with the proposal run enables you to obtain a good
overview of the outstanding invoices. The necessary evaluations that
provide transparency for future liquidity requirements for outgoing
payments round off accounts payable accounting.
162
Index
581
Index
582
Index
583
Index
584
Index
585
Index
586
Index
587
Index
588
Index
P Payments
final approval, 349
Parallel accounting, 386 merge, 343
Parallel financial reporting, 85, 92, 318 Payment term, 69, 74
Parameters, 549 Payment transactions, 126, 130, 171,
Partial amount, 148, 152 173, 332, 564, 567
Partial payment, 149, 152 accounting view, 130
Partial transfer, 312 Partner differences, 148
bank type, 111, 171 process view, 130
Passwords, 535 Payables, Payroll posting document, 399
105, 124, 146 Payables Payroll results, 397
account, 122 Payment, 147, Performance, 484
148, 149, 166 Period control, 511, 572
withhold, 347 Period control method, 293
Payment amount, 147, 152 Periodic accruals/deferrals, 409
Payment block, 132, 142, 174 Periodic posting run for APC values, 30
Payment by check, 336 Personal value range, 290
Payment deduction, 200 P&L account, 47, 100,
clarify, 565 Planning, 39, 44
Payment differences, 334 Plant maintenance, 269
Payment history, 173 P&L profit and loss statement, 47
Payment method, 114, 131, 132, 142, P&L statement account, 51
174 Portal role, 345
Payment monitoring, 344 Posting, 63
Payment on account, 146, 335 cross-company code, 557
Payment process manual check, 479
outgoing, 130 Posting a parked document, 387
Payment program, 106, 130, 133, 166, Posting code currency, 560
332, 560 Posting date, 65
access, 133 Posting items, 64
additional log, 135, 137 Posting key, 66, 69, 70, 71, 72, 73, 74,
amounts, 132 75, 122, 123, 560
block reasons, 132 customer, 71
determining the due date, 134 vendor, 72
free selections, 135 output, general ledger, 72
137 Posting list, 420
parameter, 134 Posting method, 353
payment forms, 137 Posting period, 65
payment medium program, 137 block, 485
proposal list, 139 Posting period variant, 560
selection criteria, 135 Posting to asset balance sheet
Payment proposal account periodic, 267
accounting clerk, 140 Postprocessing
process, 133 bank charges, 357
schedule, 138 bank selection, 354
Payment request, 177 check posting, 356
Payment run, 135, 140, 144, 342 completed, 359
589
Index
R
S
Rating, 189
Real-time processing, 19, 21, 40, 41 Sales, 185
Receivable Sales order, 100, 186
process, 213 create, 186
Receivables management, 30, 164, 184 Sales organization, 561
Receivable valuation, 384 Sales process, 45
Reclassification, 498, 572 Sample account, 50
590
Index
Sample charts of depreciation, 263 Special G/L transaction, 73, 176, 455
Sample posting, 464 Special ledger, 96
SAP application menu, 23 Special period, 561
SAP authorization concept, 386 Start of fiscal year, 47
SAP Bank Communication Management, Statistics, 39, 40
30, 324, 341, 568 Status bar, 538, 543, 545
SAP Biller Direct, 193 Status change history, 349
SAP Collections Management, 209, 258 Stockholders’ equity, 384
SAP component, 24 Store, 553
SAP Controlling, 25, 28, 268, 442 Structuring fixed assets, 271
SAP Credit Management, 185, 254 Subaccount, 325
SAP Dispute Management, 255 Subcomponent, 533
SAP ERP, 26 Subledger, 47, 263
SAP ERP 6.0 Subledger account, 99, 105, 163, 378
maintenance strategy, 35 Subnumbers, 271
new features, 29 Summarization, 441
release upgrade, 32 Summary data, 63
SAP ERP Financials, SWIFT code, 327, 561
27 SAP ERP HCM, System configuration, 41, 266
397 SAP Library, 553 System messages, 545
SAP NetWeaver, 26 System status, 34
SAP NetWeaver BI, 102, 236, 376
SAP R/2, 22
SAP R/3, 22, 26, 85 T
SAP RF, 19
SAP Treasury and Risk Management, 28 Tab page, 24
SD, 166 Tangible fixed asset, 261
Seasonal business, 191 Target asset, 312
Segment balance sheet, 89 Tax category, 59
Segment information, 87 Tax code, 126, 561
Self-service, 30, 195 Tax depreciation, 263
Sending asset, 312 Tax on sales/purchases, 515, 572
SEPA, 323, 328 Tax on sales/purchases group, 517
Session, 552 Tax payable account, 518
Set data, 544 TCODE, 540
Settlement rule, 426 Term of payment, 173, 561
Single-column journal, 98 Three-column journal, 99
Single document posting, 40 Title bar, 537
Single payment, 175 Tolerance, 148
Single-screen transaction, 74, 76 group, 113, 173
Small subledger accounting, 360 limits, 148
Smoothing method, 450 Toolbar, 536, 537, 543
Solution Browser, 31 Transaction
Sort key, 56, 172 ABZON, 295, 436
Source of funds, 383 AS01, 275
Special G/L indicator, 73, 561 AS02, 282
591
Index
592
Index
W
Warning message, 552
Window dressing, 208
593