1.1.revenue SD Revrec
1.1.revenue SD Revrec
1.1.revenue SD Revrec
RECOGNITION -
BEST PRACTICE
Knowledge Document
Version 1.4
SAP R/3 SD
REVENUE RECOGNITION -
BEST P R A C T I C E
SAP AG 07/2005. All rights reserved.
K NOWLEDGE D OCUMENT
(Based on R/3 Release 4.7)
Release:
Version 1.4 from of July 2005
Issued by:
SAP AG
Neurottstraße 16
69190 Walldorf
1 GENERAL RECOMMENDATIONS...........................................................................6
3.1.1.2 Presteps........................................................................................................................................12
Customizing FI accounts and their settings.........................................................................................................14
3.1.1.3 Unbilled receivable account and deferred revenue account........................................................14
3.1.1.4 Revenue account..........................................................................................................................18
SD-Customizing...................................................................................................................................................20
3.1.1.5 SD item-categories and their settings..........................................................................................20
3.1.1.6 Customizing revenue recognition type on item category level....................................................22
3.1.1.7 Customizing revenue recognition accrual start date....................................................................24
3.1.1.8 Account determination.................................................................................................................25
4.4 Service based revenue recognition (‘B’) contract with call off............................................................37
4.6 Time based revenue recognition in credit/debit memo processing with a credit/debit memo request
(‘A’) 43
General Information.............................................................................................................................................43
Business steps overview and process description................................................................................................43
4.6.1.1 Process 9 – time based with VF44 as first..................................................................................44
4.6.1.2 Process 10 – time based with invoice as first.............................................................................45
Critical functions.................................................................................................................................................46
SAP AG 07/2005. All rights reserved.
4.7 Credit/debit memo revenue recognition with reference to preceding document (‘F’)......................47
General Information.............................................................................................................................................47
Business steps overview and process description................................................................................................48
Critical functions.................................................................................................................................................49
Variations of the process.....................................................................................................................................49
Additional important information........................................................................................................................49
4.8 Time based or service based revenue recognition recognition in credit/debit memo processing
without a credit/debit memo request (‘A’ or ‘B’)................................................................................................50
General Information.............................................................................................................................................50
Business steps overview and process description................................................................................................51
Critical functions.................................................................................................................................................51
Variations of the process.....................................................................................................................................51
Additional important information........................................................................................................................52
4.9 Service based revenue recognition in return processing with reference to an order (‘B’)...............53
General Information.............................................................................................................................................53
Business steps overview and process description................................................................................................53
4.9.1.1 Process 13 – service based return processing with reference to an order with VF44 as first.....54
4.9.1.2 Process 14 – service based return processing with reference to an order with invoice as first...55
Critical functions.................................................................................................................................................56
Variations of the process.....................................................................................................................................56
Additional important information........................................................................................................................56
4.10 Service based revenue recognition in return processing with reference to a contract and call off
order (‘B’)...............................................................................................................................................................57
General Information.............................................................................................................................................57
Business steps overview and process description................................................................................................57
Critical functions.................................................................................................................................................58
Variations of the process.....................................................................................................................................58
Additional important information........................................................................................................................59
6.2 FI-Monitoring...........................................................................................................................................62
Check Account Balances.....................................................................................................................................62
Reconcile FI and SD Values................................................................................................................................64
Automatic Clearing of Accrual Accounts............................................................................................................65
7 FUNCTIONAL ENHANCEMENTS..........................................................................83
9 OTHER RESTRICTIONS........................................................................................89
10 IMPORTANT TO DO´S........................................................................................90
11 IMPORTANT NOTES..........................................................................................91
1 General recommendations
In order to comply with the latest bookkeeping principles and current regulations, like
Generally Accepted Accounting Principles (US-GAAP), International Accounting
Standards (IAS) / Financial Reporting Standards (FRS), as well as the Sarbanes-Oxley
Act, SAP provides some general recommendations and best practices for customers
using SAP R/3 revenue recognition in the Sales and Distribution component (SD).
In the whole document revenue recognition is set for SAP R/3 SD revenue recognition.
If customers want to use the revenue recognition functionality in their productive
environment, the implementation must be subject to a pre go-live assessment to
avoid a negative impact on the financial statement. This assessment is
completely free of charge. In other words, the customer will have to ask explicit
permission from SAP in order to use this functionality (detail information provided
by note 768561 and 779366).
As revenue recognition provides a data stream into the financial system, the
setup of the function is not only an SD task. FI consultants with experience in the
area of Balance Sheet and P&L customizing have to setup the account
SAP AG 07/2005. All rights reserved.
assignment using SAP Best Practices and need to review the processes that are
customized in the SD area.
Furthermore, the entire revenue recognition process should be approved by the
responsible Head of Accounting and, if necessary, reviewed by the external
auditor of the company.
Revenue recognition needs to be implemented by SAP-certified SD- and FI-
Consultants.
To make sure that compliance with the latest requirements is possible, always
implement the latest versions of the SD module, especially the latest notes on
revenue recognition.
Also, SAP always recommends the application of the latest support package.
Because of the nature of the revenue recognition function, it is necessary to
monitor continuously (at a minimum monthly) the results by using the transaction
VF45 and VF48, which delivers a process view of SD and FI and also by using
transaction VF47, which provides a more technical view.
To implement revenue recognition in already existing processes (transfers of old
data) a detailed concept creation is necessary. For this request SAP offers
consulting, which is chargeable.
Program modifications in a revenue recognition relevant process are discouraged
because they may have unexpected effects and may result in an incorrect data
stream for FI. Any modifications made must be very closely monitored to prevent
any negative impacts to the revenue recognition process. Additionally
modifications have to be reviewed whether they are still in line with legal finance
guidelines and regulations.
The comments in these documents are binding for all customers using the SAP R/3
revenue recognition functionality and the outlined recommendations have to be
implemented.
This document mainly deals with the non-standard revenue recognition since only for
these the special revenue recognition functionality is relevant. Further in this document
the term ‘revenue recognition’ refers to the use of a revenue recognition method other
than the standard revenue recognition.
When you want to start with revenue recognition, the very first step to do is, look at your
system-status!
Recommended releases and support packages are (as for May 2005):
SAP AG 07/2005. All rights reserved.
The supported processes and functions are described in the document “Best Practice
for Revenue Recognition”.
You will find a link to the latest version of this document in SAP-note 779365.
Also look at the “prerequisites for revenue recognition” mentioned in SAP-note 782758.
Despite this special release process, customers are still responsible for setting up, using
and operating the R/3 SD Revenue Recognition function.
3.1.1.2 Presteps
For the setup of revenue recognition processes you have to customize
1) FI accounts and their settings
2) SD item-categories and their settings
3) revenue recognition type on item category level
4) account determination
The following accounts are needed for the representation of the revenue re-cognition
process:
Revenue account (recognized revenues)
Receivables account (customer account)
Revenues to be deferred (deferred revenue account or D/R account)
Unbilled receivables (unbilled receivables account or U/R account)
For the revenue account and receivables account you can use the accounts that you
used before in the other standard processes. The account of the revenues to be
deferred (in the following called D/R account) and the account of the unbilled
receivables (in the following called U/R account) have to be created as new accounts.
The U/R account must be different from the D/R account, i.e. different account
numbers must be used. Only this way the posting process of the revenue
recognition can be monitored.
Transaction : FS00
Path: Financial Accounting -> General Ledger Accounting -> G/L
Accounts -> Master Records -> G/L Account Creation and
Processing -> Edit G/L Account (Individual Processing) -> Edit G/L
Account Centrally
SAP AG 07/2005. All rights reserved.
*3) With “yes” it indicates that the account can still be posted, even if a tax code has
not been entered. In revenue recognition it should be possible to post both,
taxable and non-taxable items, to an account. For example, you would usually
set up a separate tax code for the non-taxable transactions. When taxes are
entered using jurisdiction codes, however, this separate tax code cannot be used
since jurisdiction codes cannot be specified for foreign customers. In this case,
you allow users to post items without tax codes in the corresponding expense
and revenue accounts.
*4) With “yes” it determines that open items are managed for this account. Items
posted to accounts managed on an open item basis are marked as open or
cleared. The balance of these accounts is always equal to the balance of the
open items. Set up accounts with open item management if offsetting entries are
to be assigned to the postings made to these accounts. Postings to these
accounts represent incomplete processes or process-steps.
Be careful when using open item management, because in this case you cannot
use document summarization!
Userexit xxxxxxxxx must be used to set the assignment in the SD invoices.
*5) With “yes” here it indicates that line item display is possible in this account. For
line item display, the system stores an entry per line item in an index table which
contains the link between line item and account.
On Tab “Type/description”
SAP AG 07/2005. All rights reserved.
SD-Customizing
Path: Sales and Distribution -> Sales -> Sales Documents -> Sales Document Item ->
Define Item Categories
SAP AG 07/2005. All rights reserved.
Use “I” for the document item category you want to use with a billing plan.
For a billing plan type, choose one of the above types or create your own billing plan
type and the use this one for the item categories. You can create your own billing plan
type in customizing via path Sales and Distribution -> Billing -> Billing Plan -> Define
Category blank ‘ ‘: see chapter 4.1 used with standard revenue recognition
at time of billing
Category ‘A’: see chapter 4.2 used with timebased revenue
recognition
see chapter 4.6 used with credit/debit memo timebased
revenue recognition with memo request
see chapter 4.8 used with credit/debit memo timebased
revenue recognition without memo request
Category ‘B’: see chapter 4.3 used with servicebased revenue
recognition
see chapter 4.4 used with servicebased revenue
recognition in contracts with calloffs
see chapter 4.8 used with credit/debit memo timebased
SAP AG 07/2005. All rights reserved.
In the SD module, both the revenue account and the account for deferred revenue
amounts must be maintained in the revenue account determination. This occurs in
customizing transaction according the following example:
SAP AG 07/2005. All rights reserved.
Will not be discussed further as this process is the standard billing process with the
standard revenue recognition at the time of billing.
Critical functions
Nothing.
Nothing.
Nothing.
As a first step in the process the sales contract is created, which can contain a billing
plan. This sales document contains the line items, which have to be billed as well as
If only a partial billing took place or was realized, the steps following the order creation
may be repeated for further periods until the sales document is completed. In such
cases another revenue account (deferred account) can be posted.
As a first step in the process the sales contract is created, which can contain a billing
plan. This sales document contains the line items, which have to be billed as well as
the relevant conditions. The saving of this document triggers the creation of control lines
(VBREVK) and the revenue lines (VBREVE) for each period. With time-related revenue
recognition the recognition is carried out between a specific start and end date in equal
parts. The start and end dates are determined on item level in the sales document. Here
the billing plan dates or the contract data dates will be used. The number of periods
between these dates is determined using the financial calendar for the company code
assigned to the document. According to the number of periods and the amount to be
billed, the revenue lines are calculated.
When the invoice is first created and released to accounting, an accounting document is
created. It posts to a different reconciliation account called ‘deferred revenues’ and to
the receivables account. This event also triggers the update of the control lines with the
realized value and the new balance and creates the reference lines.
Now transaction VF44 runs. This triggers the update of the control lines and the update
of the revenue lines. Also in FI, an accounting document is automatically created, which
posts on the reconciliation account ‘deferred revenues’ and on the revenue account.
SAP AG 07/2005. All rights reserved.
If only a partial billing took place or was realized, the steps following the order creation
may be repeated for further periods until the sales document is completed. In such
cases another revenue account (unbilled receivable account) can be posted.
Critical functions
A contract will be used without contract data and without billing plan. As a
consequence no VBREVE can be created, as there is no start and no end date.
A condition is added manually in the invoice, not in the contract/order, and the
new condition is using separate accounts. As a consequence the posted values
from VF44 would differ from the values posted by the billing document. The
invoice cannot be released to accounting, the error message F5 702 would
appear. Note 496721 explain the solution: the added condition has to be
classified in a way that it is not relevant for revenue recognition.
Instead of a contract, a sales order can be used as sales document in this
process, which then replaces the contract. In this case a billing plan has to be
used, if the sales order contains no contract data. This triggers the same follow
on steps.
Additional steps of the process can include the delivery of items and posting
goods issue which do not affect the revenue recognition process.
Nothing.
Nothing.
Using service-related revenue recognition, you can carry out recognition on the
basis of a specific event. An example of this is revenue recognition for a service
contract, where services are included.
Revenue recognition method = ‘B’.
Process 4 demonstrates the process, when transaction VF44 is run before
invoicing.
Process 5 demonstrates the process, when the invoice is posted before
transaction VF44.
SAP AG 07/2005. All rights reserved.
As a first step in the process the sales order or sales contract is created. This sales
document contains the line items, which have to be billed, as well as the relevant
SAP AG File: RR_Best_Practice_Knowledge_Document_V1.doc Page: 34
Of: 91
Revenue Recognition - Best Practice 4 Description of Core Business Processes
Knowledge Document
conditions. The saving of this document triggers the creation of the control lines
(VBREVK) only. No revenue lines are created at this stage.
The next process step consists of the creation of the delivery with reference to the
order/contract, the line items are copied into this document. The goods are picked either
with lean warehouse management or with full warehouse management including
transfer orders. When the goods have left the company stock, goods issue is posted.
This triggers the creation of the revenue lines (VBREVE) in service based revenue
recognition according to the document data.
Now the invoice is created and released to accounting. An accounting document is
created, which posts to the reconciliation account ‘deferred revenue’ and to the
receivables account. The revenue recognition tables are updated by this step. A new
reference line is created containing information from the invoice, the control lines will
also be updated.
After this step transaction VF44 is used. This triggers the update of the control lines and
the update of the revenue lines. In FI an accounting document is automatically created,
which posts to the reconciliation account ‘deferred revenue’ and to the revenue account.
SAP AG 07/2005. All rights reserved.
Critical functions
Nothing.
Nothing.
SAP AG 07/2005. All rights reserved.
4.4 Service based revenue recognition (‘B’) contract with call off
General Information
Using service-related revenue recognition you can carry out recognition on the
basis of a specific event. An example of this is revenue recognition for a contract
with a call off order while the contract item is invoiced and the linked call off order
item is delivered.
Revenue recognition method = ‘B’ for the contract and call off order.
Process 6 demonstrates the process, when transaction VF44 is run before
invoicing.
Process 7 demonstrates the process, when the invoice is posted before
transaction VF44.
SAP AG 07/2005. All rights reserved.
The first step in this process is the creation of the sales contract, which may contain a
billing plan. This contract creation generates control lines in table VBREVK. In the
SAP AG File: RR_Best_Practice_Knowledge_Document_V1.doc Page: 37
Of: 91
Revenue Recognition - Best Practice 4 Description of Core Business Processes
Knowledge Document
second step a call off order is generated with reference to the contract and a delivery
may have been created with reference to the call off order.
The next process step is that the goods are picked either with lean warehouse
management or with full warehouse management including transfer orders. When the
goods have left the company stock, goods issue will be posted. This triggers the
creation of the revenue lines (VBREVE).
In the subsequent step, when transaction VF44 is run, an update of the control and
revenue lines is generated. Additionally an accounting document is automatically
created in FI, which posts to the unbilled account.
After the invoice is created with reference to the contract and released to accounting,
the reference lines will be created and the control lines will be updated. The created FI
document posts to the unbilled account.
The first step in this process is the creation of the sales contract, which may contain a
billing plan. This contract creation generates control lines in table VBREVK. In a second
step a call off order is generated with reference to the contract and a delivery may have
been created with reference to the call off order.
The next process step is that the goods are picked either with lean warehouse
management or with full warehouse management including transfer orders. When the
Critical functions
If terms are added manually in the call-off order, there must be a link to a contract
item otherwise the call-off order items are handled separately.
Changes of the revenue recognition accounts (D/R account / U/R account) are
SAP AG 07/2005. All rights reserved.
not supported.
If there is an over/under delivery of the call-off order items, the process should be
completed. There is no clearing of the balance on the clearing account. The
difference between billed and recognized value has to be posted by a credit
memo. The creation of a credit memo in reference to a credit memo request
doesn’t lead to the clearing of the balance and therefore the credit memo must be
created in reference to the billing document.
In case of changes of condition values or time data in the contract / call-off order
an adjustment for the revenue is only possible, if there is no invoice created.
Before an invoice is created, the price and time changes have to be done
correspondingly in the contract item and the related call-off order item.
In accordance with the above described process, where the invoice is related to the
contract and the call off order is to be delivered, two other scenarios exist:
The call off order will be invoiced and delivered:
When the call off order is created with reference to the contract, the saving of the
call off order creates control lines (VBREVK). After the related delivery has
posted the goods issue, revenue lines (VBREVE) are created.
Important remark: The invoice has to be created in reference to the call off order
(order-related invoicing) and NOT in reference to the delivery (delivery-related
invoicing).
The contract will be invoiced and the call off order will not be delivered:
While the contract is created, control lines are created in table VBREVK and
during saving of the call off order revenue lines are generated in table VBREVE.
In order to implement the three scenarios, the following customizing settings must be
configured in the sales document types:
The contract will be invoiced and the call off order will be delivered:
The billing relevance of the contract item category should be ‘B’ or ‘I’, while the
billing relevance of the call off order item category should be ‘ ‘. The revenue
recognition relevance of the contract and the call off order item categories should
be set to ‘B’.
The call of order will be invoiced and delivered:
The item category of the contract should be customized with revenue recognition
relevance ‘ ‘, the item category of the call off order with ‘B’. The billing relevance
of the contract item category should be ‘ ‘, while the billing relevance of the call
off order item category should be ‘B’.
The contract will be invoiced and the call off order will not be delivered:
The billing relevance of the contract item category should be ‘B’ or ‘I’, while the
billing relevance of the call off order item category should be ‘ ‘. The revenue
SAP AG 07/2005. All rights reserved.
recognition relevance of the contract and the call off order item categories should
be set to ‘B’.
General Information
Using time based and billing related revenue recognition, you can carry out
recognition on the basis of an invoice over a specific period of time. An example
of this is revenue recognition for the length of a service or rental contract after the
invoice is created and released. The proportions for the periods are equal.
Revenue recognition method = ‘D’.
Process 8 will be initialized at the point in time when the billing document is
released to accounting. Afterwards transaction VF44 is run.
The contract or the sales order will be created. Then the invoice will be created.
After the invoice was released to accounting all the Revenue Recognition tables are
Critical functions
Nothing.
Additional steps of the process can include the delivery of items and post goods issue,
which do not affect the revenue recognition process.
The cancellation of the invoice using transaction VF11 is starting its own revenue
recognition process. The releasing of the invoice cancellation document triggers the
creation of separate control, revenue and reference lines. The revenue recognition
cancellation process has no reference to the original revenue recognition process.
When creating and transferring a credit memo to accounting, the system checks,
whether a balance exists on the deferred revenue (D/R) account, otherwise the
posting is made to the unbilled receivables (U/R) account.
Revenue recognition method = ‘A’.
Process 9 demonstrates the credit memo processing, when transaction VF44 is
ran before creation of the credit memo.
Process 10 demonstrates the credit memo processing, when the credit memo is
posted before transaction VF44 is ran.
As a first step in the process the credit/debit memo request is created, which may
contain a billing plan. This sales document contains the line items, which have to be
billed as well as the relevant conditions. The saving of this document triggers the
creation of control lines (VBREVK) and the revenue lines (VBREVE) for each period.
With time-related revenue recognition the recognition is carried out between a specific
start and end date in equal parts. The start and end dates are determined on item level
in the sales document. Here the billing plan dates or the contract data dates will be
used. The number of periods between these dates is determined using the financial
calendar for the company code assigned to the document. The revenue lines are
calculated based on the number of periods and the amount to be billed.
Since the revenue recognition is now initialized, it is possible to realize the revenue
using transaction VF44. This triggers the update of the control lines with the realized
value, the new balance and the update of the revenue lines.
In case of the credit memo process, an accounting document is automatically created,
which posts to the accruals account ‘deferred revenues’ and to the revenue account.
In case of the debit memo process, an accounting document is automatically created,
which posts to the accruals account ‘unbilled receivables’ and to the revenue account.
When the invoice is created and released to accounting, another accounting document
is created, which balances (or reduces) the accruals account and posts to the
receivables account. The revenue recognition tables are also updated by this step. A
As a first step in the process the credit/debit memo request is created, which can
contain a billing plan. This sales document contains the line items, which have to be
billed as well as the relevant conditions. The saving of this document triggers the
creation of control lines (VBREVK) and the revenue lines (VBREVE) for each period.
With time-related revenue recognition the recognition is carried out between a specific
start and end date in equal parts. The start and end dates are determined on item level
in the sales document. Here the billing plan dates or the contract data dates will be
used. The number of periods between these dates is determined using the financial
calendar for the company code assigned to the document. According to the number of
periods and the amount to be billed, the revenue lines are calculated.
When the invoice is created and released to accounting a different accruals account is
posted together with the receivables account in the accounting documents.
In case of the credit memo process the accruals account is called ‘unbilled receivables’
account.
SAP AG File: RR_Best_Practice_Knowledge_Document_V1.doc Page: 45
Of: 91
Revenue Recognition - Best Practice 4 Description of Core Business Processes
Knowledge Document
In case of the debit memo process the accruals account is called ‘deferred revenues’
account.
Then transaction VF44 runs. This triggers the update of the control lines with the
realized value and the new balance and updates the revenue lines as well.
As a result the opposite accruals accounts will be used for the credit memo process
than for the debit memo process (invoices and debit memos have the same posting
logic in accounting).
Critical functions
Nothing.
The credit/debit memo processing with a credit/debit memo request can also be used as
standalone process. It triggers the same steps as described previously.
Nothing.
General Information
The credit/debit memo process will be created with reference to a preceding sales
document, and with revenue recognition type ‘F’ it updates the revenue recognition
tables of the preceding sales process.
When this type is set for the credit/debit memo request, the system checks whether the
reference document is relevant for 'time-related revenue recognition' (method 'A'). In
this case the subsequent credit/debit memo generates reference lines (VBREVR)
corresponding to the reference document.
The posting to the accounts depends on whether there is a balance on the D/R or the
U/R account (revenue recognition run is done and/or invoice is released to accounting
in the original process).
It is now possible to realize the corrected revenue using transaction VF44. This triggers
the update of the control lines and the update of the revenue lines. In FI an accounting
document is automatically created which posts to the accruals account of either the D/R
or U/R and to the revenue account.
Nothing.
Process 12 will be initialized at the point in time when the credit memo is
released to accounting. Afterwards transaction VF44 is ran.
If a credit memo/debit memo is created and the reference document is the billing
document, the credit memo/debit memo updates the revenue recognition tables of the
preceding sales process.
Therefore the posting to the accounts depends on whether there is a balance on the
D/R or the U/R account (revenue recognition run is run and/or invoice is released to
accounting).
Critical functions
For updating the revenue recognition tables (VBREVK and VBREVE) of the preceding
order process (after the credit/debit memo was created) it is necessary to do a manual
update using va02/va42 OR to run report ZZ_SALES_DOC_CHANGE from note
385149. This update will not be executed automatically.
In detail: In the VBREVK the field ACC_VALUE and in the VBREVE the field WRBTR
have to be updated. If revenues have already been posted, the system must enable a
correction posting (adjustment line).
SAP AG 07/2005. All rights reserved.
The return process will be created with reference to a preceding sales document and
with revenue recognition type ‘B’. It updates the revenue recognition tables of the
preceding sales process.
As a first step the return sales order is created with reference to the sales order. This
sales document contains the line items, which have to be credit as well as the relevant
conditions. The saving of this document triggers not the update of the control lines
(VBREVK). No revenue lines are created at this stage.
The next process step consists of the creation of the delivery with reference to the
return order; the line items are copied into this document. The goods receipt is posted.
This triggers the creation of the revenue lines (VBREVE) in service based revenue
recognition according to the document data.
It is now possible to realize the revenue using transaction VF44. This triggers the
update of the control lines with the realized value, a new balance, and the update of the
revenue lines. In FI an accounting document is automatically created, which posts to the
reconciliation account D/R or U/R and to the revenue account.
The posting to the accounts depends on whether there is a balance on the D/R or the
U/R account (revenue recognition run is done and/or invoice is released to accounting
in the original process).
The return process will be created with reference to a preceding sales document and
with revenue recognition type ‘B’. It updates the revenue recognition tables of the
preceding sales process.
As a first step the return sales order is created with reference to the sales order. This
sales document contains the line items, which have to be credit as well as the relevant
conditions. The saving of this document triggers not the update of the control lines
(VBREVK). No revenue lines are created at this stage
The next process step consists of the creation of the delivery with reference to the
return order; the line items are copied into this document. The goods receipt is posted.
This triggers the creation of the revenue lines (VBREVE) in service based revenue
recognition according to the document data.
Critical functions
Process 15 will be initialized at the point in time when the goods issue posting is
done for the return order. Afterwards transaction VF44 is run.
Critical functions
Nothing
In accordance with the above process, where the invoice is related to the contract and
the call off order is to be delivered, another scenario exists:
The call off order will be invoiced and delivered:
When the call off order is created with reference to the contract, the saving of the
call off order creates control lines (VBREVK). After the related delivery has
posted the goods issue, revenue lines (VBREVE) are created.
Important remark: The invoice has to be created in reference to the call off
order (order-related invoicing) and NOT in reference to the delivery (delivery-
related invoicing).
In the following return order processing the return order will be create with
reference to the call off order. The saving of the return order creates control lines
(VBREVK) with the document number of the return order. There is NO link
between the call of order and the return process. Also the return delivery and the
return credit memo create their entries with the number of the return order.
In order to implement the two scenarios, the following customizing settings must be
configured in the sales document types:
The contract will be invoiced and the call off order will be delivered:
The billing relevance of the contract item category should be ‘B’ or ‘I’, while the
billing relevance of the call off order and return order item category should be ‘ ‘.
The revenue recognition relevance of the contract / call off order / return order
item categories should be set to ‘B’.
The call of order will be invoiced and delivered:
The item category of the contract should be customized with revenue recognition
relevance ‘ ‘, the item category of the call off order and the return order with ‘B’.
The billing relevance of the contract item category should be ‘ ‘, while the billing
relevance of the call off order and the return order item category should be ‘B’.
SAP AG 07/2005. All rights reserved.
The next question is, why is an accurate monitoring that important? It‘s the first time that
SAP provides a functionality, which doesn‘t post the revenues directly with the billing
document, but distributes the realisation of revenues over a certain range of periods.
SAP AG 07/2005. All rights reserved.
An accurate monitoring ensures, that despite the mentioned decoupling finally those
revenues are realised, which are billed to the customer.
6.2 FI-Monitoring
Check Account Balances
In order to monitor the revenue recognition process, the first step is to check whether
there are balances on the accrual accounts or not. To display balances on accounts use
transaction FS10N.
SAP AG 07/2005. All rights reserved.
Alternatively transaction FBL3N can be used in order to show the line items of an
accrual account directly
If open item management is used only the line items respectively the sales documents
can be displayed which cause the balance on the account
SAP AG 07/2005. All rights reserved.
If balances are determined on the accrual accounts, they can be reconciled with the
revenue recognition data in SD on an aggregated level. You can use transaction VF48
to compare the FI and SD values created by the billing process as well as by the
revenue recognition run.
The reconciliation can be done for a certain range of periods.
In order to get an overview what happened in total with a sales document, the document
flow can be used first. Use to VA02/VA42 or VA03/VA43 to view the document flow.
A more value-oriented view is provided by the transaction VF45 from the sales
perspective and FBL3N from the FI perspective. VF45 displays the deferred revenues,
Prerequisites are:
SAP AG 07/2005. All rights reserved.
(1) Activate open item management in the master data of the accrual accounts (see
customizing in chapter 9).
Please note:
If you haven‘t yet activated open item management, create new accounts and do
not change the open item management flag for an existing, already in use
account.
(2) As a basis for the automatic clearing of the open items the field ‚Assignment‘has
to be maintained in the customizing transaction ‚Prepare Automatic Clearing‘.
The transaction VF45 is a more value-oriented view from the sales perspective. The
transaction displays the deferred revenues, the unbilled receivables, the billed and the
realized amounts on the level of a sales document item.
There is just one mandatory field in VF45, the field “sales document”.
The other fields can be used to increase the number of document to be analysed.
Company code
Sales document type
Sales document item
Sold-to party
From this report you can reach the follow-on document by double-click.
The transaction VF47 is a central point in the early stage of analysis the Revenue
Recognition on a customer’s system. If a sales document contains items relevant for
revenue recognition, various errors may occur during the processing of items.
The report of VF47 shows inconsistencies between the revenue recognition tables
VBREVK, VBREVE and VBREVR and the appropriate sales documents. Nethertheless
VF47 is a rather technical view on the revenue recognition tables.
Sales-, billing- and FI-documents can be taken into account to search for
inconsistencies beyond the revenue tables.
VF47 should be scheduled as a frequent batch process. Run VF47 every week, at least
once in a month to be sure that there are no problems or errors in your revenue
recognition data. For an analysis this report should not run in update mode (check box
SAP AG 07/2005. All rights reserved.
When starting VF47, you have to fill out a full screen of selection criteria. In the following
text the fields will be described.
company code
sales document type
sales document number mandatory entry. Enter the sales documents,
you want to analyse.
item number item numbers of the sales document
Check types:
SAP AG 07/2005. All rights reserved.
Compr. :
If also the FI documents for the billing documents are read, remember that the
billing document and the FI document do not have to match completely. This is
because the individual posting items can be summarized (compressed) in
financial accounting. For this case, this flag must be set. The data required for
simulating the missing reference lines is copied from the billing document.
However, this only occurs if the billing document was posted to 'deferred
revenues' or' non-billed receivables' only. If both accounts are involved, the
reference lines cannot be simulated. This flag is not set by default. The system
therefore attempts to link the billing document with the generated FI document.
The system assumes that the billing items have generated posting items in
chronological order. If this is not the case, the reference lines cannot be
simulated here either.
document data in order to check whether the status of the control lines is correct.
This is necessary because both the reason for rejection on item level and the
billing block on header and item level affect the control line status. With this
information, the system determines the status on the basis of the detail lines and
then compares it with the status of the respective control lines.
messages only once per document although the errors may occur more often.
Only docs with error messages:
Sales documents that do not have any errors are indicated with a green
checkmark in the log. If you set this flag, the system no longer displays these
correct sales document numbers in the log, but only the incorrect ones with their
corresponding error messages.
The report is able to make changes on the database. The scope of these corrections is
defined by the following selection options. That is, if you want to carry out a correction,
you must select at least one of these selection options. In addition, you must deselect
the 'Test Run without Update' flag
If you set this flag, the report generates revenue lines (VBREVE) if it detects
balances on both clearing accounts (E16). In this case, the report always
generates two revenue lines. Both lines have the same revenue value (VBREVE-
WRBTR) with one value being positive and the other one being negative. The first
line gets status (VBREVE-RRSTA) 'A' (to be recognized), the second gets status
'C' (recognized).
‘Posting period:’
Generally, the system determines a posting period for the new revenue lines to be
created. This posting period is always the first posting period (descending sort
order) of a sales document that no longer contains revenues to be recognized,
that is, all revenue lines of this sales document that concern the determined
posting period have status 'C' (VBREVE-RRSTA ='C'). However, if you want to
create revenue lines for a certain posting period, you can specify a period here.
This must be done in the 'YYYYPPP' format where 'Y' represents the year and 'P'
the period.
5273 01
(rrrel=D) Incorrect messages with category "D" in VF47
This compare report serves to explain the balance of an accruals account used in the
Revenue Recognition, or to check whether this balance corresponds to the SD data
(VBREVx tables). Its primary aim is to trace balances and not to trace possible
inconsistencies between SD and FI.
Transaction VF47 (Inconsistency Check in Revenue Tables) is available for
this purpose.
You must/can start the selection with the following selection parameters :
1. Company code (required entry field)
Enter the company code of the accruals account to be checked.
2. G/L account ( required entry field)
Enter the accruals account to be checked.
3. Posting period from/ to (required entry field)
Enter the period to be checked in posting periods.
4. Indicator: Only Not Cleared Documents (optional entry field)
If you set this indicator, only actions with incomplete revenue recognitions (revenue
postings and billing document postings) are taken into account, because only these
postings are necessary for an explanation of the balance. However, to trace the
balance, it may be necessary for the system to also display completed (cleared)
revenue recognition processes. In this case, the indicator must not be set.
Results of VF48
SAP AG File: RR_Best_Practice_Knowledge_Document_V1.doc Page: 78
Of: 91
Revenue Recognition - Best Practice 6 Monitoring of the revenue recognition data
Knowledge Document
If the necessary selection parameters were set and the report is started, a split screen
appears.
SAP AG 07/2005. All rights reserved.
Here per currency different balances are displayed. For each currency in the form of a
calculation. The calculation consists of the following:
d) Total balance
This is the balance of the accruals account for the selected period that was determined
in FI. If you now take the balance of revenue recognitions, minus the balance of billing
documents and minus the balance of other postings, then the result should reflect the
total balance in FI. If this is not the case, this result must be analyzed further, since
there is an inconsistency between FI and SD. Transactions VF47 and VF45 (among
others) are available for further analysis.
a) Billed revenues
For the relevant document item, the revenue billed in the selected period is displayed,
based on the billing items relevant for revenue recognition (this is the revenue that was
posted to the selected accruals account). Data is retrieved using the reference line table
(VBREVR).
b) Recognized revenues
For the relevant document item, the revenue recognized in the selected period is
displayed, based on the VBREVE table (this is the revenue that was posted to the
selected accruals account). Data is retrieved using the revenue line table (VBREVE).
c) Overview (F7)
This is where the revenue recognition data that is relevant for
the selected document item is listed. This is done in Transaction
VF45 - 'Revenue Recognition: Overview.' For more information, see
Note 787174.
7 Functional enhancements
Following is an overview of the technical extensions and new additions contained in the
special Support Package
.
46C SP49, additional notes from note 813850
470 SP23, additional notes from note 813850
The functions of each extension are described in detail in the composite SAP Note
800983.
Immediate update of sales documents, when invoices are created and the issue
of goods is posted.
Flagging documents, that are to be updated and updating them at a later time by
calling transaction VF42.
cancellation rows in the process and data control functions more clearly.
If a billing plan is used, the billing plan data has to be updated after the changes,
otherwise there is no VBREV* update.
Preconditions:
o The Corr field (FPLA-AUTKORR) has to be set, so that a correction
settlement period is created within the billing plan and then the VBREV*
tables are updated according to the change.
o In the customizing of the used data category, which is assigned to the
billing plan type, the pricing type must not be set to ‘B’. Then the billing
value will be redetermined and the VBREV* tables are updated (except
for the settlement periods that are invoiced).
If a condition is added manually in the invoice, not in the contract/order, and the
new condition is using separate accounts, the related conditions have to be
classified in a way that they are no longer relevant for revenue recognition. The
value of those conditions will be posted directly to a revenue account and not to a
clearing account. Please have look to note 496721. This issue applies when
SAP AG 07/2005. All rights reserved.
9 Other restrictions
allowed. This means that only postings from invoices (with revenue recognition-
relevance) and postings from revenue recognition (VF44 / VF46) are allowed.
Otherwise, reconciliation becomes difficult or impossible. For manually posted
accruals or other adjustments, separate accounts shall be used.
10 Important to do´s
Use go-live assessment offering in the implementation phase.
As transfer of old data into the revenue recognition processes is required,
consider SAPs consulting offering.
Set up revenue recognition functionality by SAP certified SD and FI consultants
and approve it by the responsible Head of Accounting and, if necessary, review it
by the external auditor of the company
- see chapter 5.
Avoid program modifications.
Don’t deactivate revenue recognition in the productive system landscape.
Important remarks to consider in the job planning:
SAP AG 07/2005. All rights reserved.
- Never run invoicing in parallel mode with the VF44 of the revenue recognition
process. before 46C HP 49 or 470 HP 23
- Schedule report ZZ_SALES_DOC_CHANGE / SDRRAV54. on a regular basis
to update the revenue recognition data in case of adjustments.
Important precondition for running report ZZ_SALES_DOC_CHANGE is the
implementation of note 568227.
Monitor continuously the results of the revenue recognition processes
- see chapter 6.
Implement the latest support package, especially the latest notes on revenue
recognition. Make sure that the functional enhancements are implemented
- see chapter 7 and 11.
Consider the latest version of the SAP R/3 Revenue Recognition Best Practices
Guide. The link can be found in note 779365.
Do not run VF44 and VF01 in parallel, when your system is not on the latest
support package for your release.
11 Important notes