the revenue account determination process to establish the revenue accounts to which prices, discounts, and surcharges are posted. The billing details are transferred from SD to FI by means of a Revenue Account Determination. The determination of the revenue account is one of the main elements of the condition technique. The search technique is the condition technique.
Table of Contents
Introduction of Account determination
Accounting accounts in SAP are vital for managing finances as they keep track of the financial transactions of an organization. They categorize and arrange financial information, which allows for structured record-keeping and reporting.SAP employs an accounting chart to identify different kinds of accounts used in financial accounting. The list comprises a general ledger account for liabilities, assets, revenue, equity, and expenses.
Every SAP account is assigned a specific number and a brief description based on an established structure in an accounting chart to allow for easy categorization. Transactions such as purchases, sales and other expenses are documented in accounts that are appropriate to them. SAP accounts, thereby updating balances and supplying a complete financial report. SAP lets you create different types of accounts, like customer, bank, vendor, and asset accounts.
SAP offers additional features concerning accounts, like reconciliation, account determination, and financial closing. The process assigns accounts specific to transactions in the business, which ensures accurate financial records. Reconciliation compares balances on accounts to external sources or conducts internal checks to ensure data accuracy. Financial closing adjusts the balances of accounts at the close of the accounting period for the purpose of reporting.
The accounts in SAP are vital to financial analysis and reporting and serve as the basis for generating the balance sheet, income statement, and cash statement of flow. They allow monitoring of the financial results, more informed decision-making, and adherence to the regulations.
What is the usage of account determination SAP?
- It will need to determine the accounts to be posted in several different areas.
- G/L accounts for posting sales revenue, sales deductions, and VAT are to be determined automatically when data is transferred from the billing document to FI.
- When processing cash sales, a G/L account must be set in the document for cash settlement
- When using payment cards, you also need to post to differing G/L accounts.
Condition technique for G/L Acc determination
- Account determination is carried out using the condition technique. Accounting procedures are allocated for G/L accounts, depending on the billing document type.
- This determination procedure contains one or more condition types to which an access sequence is assigned.
- This access series consists of individual accesses as status tables.
- The conditions table contains the various field combinations on which the determination of sales revenue depends on specific business scenarios.
- The various field combinations are filled in with record information so that the system is able to search for the appropriate G/L account from the records. An access sequence determines a G/L account from the combination, then it is determined by the accounting document and the search is terminated.
Prerequisites to perform a Revenue Account Determination
Account Assignment Group for Customers
Customer account assignment category to identify accounts based on customer account groups. One of the common criteria, for example, is to distinguish the sales of domestic customers from those of international customers. Hence, we create/maintain groups of accounts and assign them to the customer master records
Here are below SPRO Menu Path: IMG >Sales and Distribution > Basic Functions >Account Assignment/Costing >Revenue Acc Determination >check Master data Relevant for Account Assignment >Select Customer: Account Assignment Groups.
Account Assignment Group for Material
like ways, We need to maintain Master data Relevant for Account Assignment & Assign to Customer master data
Here are below SPRO Menu Path: IMG – Sales and Distribution – Basic Functions – Account Assignment/Costing – Revenue Acc Determination – check Master data Relevant for Account Assignment – Select Material: Account Assignment Groups
Step to perform Automatic Revenue Account Determination
- Create a condition table with key combinations
- Create an Access sequence with key combinations
- Create condition type
- Define Acc Determination Procedure
- Assign Acc Determination Procedure to billing document type
- Define Account keys
- Assign Account keys to Pricing Procedure
- Assign G/L Accounts
Create Condition table:
In this step, We need to create a condition table with key combinations. If the standard table is not meet a specific requirement.
Here are below SPRO Menu IMG –> SD –>Basic Functions –>Account Assignment/Costing – >Revenue Acc Determination –> Define dependencies of revenue acc determination. alternatively, you may run T-Code: V/12
Example: 1. Customer group / Material group / Account key. Here we are using 001 standard tables with selected fields
Create an Access sequence with key combinations.
After specifying the condition table, we need to specify the access sequence with the below combination
Here are below SPRO Menu Path: IMG – >Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Revenue Acc Determination – >Define Access sequence and Account determination type
Create condition type
In these steps, We are going to use the standard account determination condition type KOFI
- KOFI Acc determination without controlling
- KOFK Acc determination with controlling
Here are below SPRO Menu Path: IMG – >Sales and Distribution – >Basic Functions – >Account Assignment/Costing –> Revenue Account Determination –> Define Account determination type. There are two condition types available.
Here an Account determination type will be assigned to an Access sequence
Define Account Determination Procedure type
In these steps, we are going to steps account determination procedure as per the standard
Here are below SPRO Menu Path: IMG – >Sales and Distribution – >Basic Functions – >Account Assignment/Costing –> Revenue Acc Determination –> Define and assign Account Determination Procedure
Additionally, We may use used ( Requirement Routine ) to verify a specific condition and execute a specific condition only if that condition is satisfied.
Assign Account Determination Procedure to billing document type
Here, we need to specify the account Determination Procedure with the list billing document type
Here are below SPRO Menu Path: IMG – Sales and Distribution – Basic Functions – Account Assignment/Costing – Revenue Account Determination – Define and assign Account Determination Procedure
Define and Assign Account keys
The account key allows the system to post amounts into the specific G/L account such as revenue, fright
Here is the SPRO Menu Path: IMG –> Sales and Distribution – >Basic Functions – >Account Assignment/Costing – >Revenue Account Determination –> Define and assign Account Keys
Define and Assign Account keys
In the steps, we are going to specify account keys with the Pricing Procedure
Here are below SPRO Menu Path:IMG – Sales and Distribution – Basic Functions – Account Assignment/Costing – Revenue Account Determination – Define and assign Account Keys
Maintain Account determination procedure in billing document type
Lastly, We need to specify the account determination procedure, So that whenever a billing document is created, it will automatically be posted to the accounting system.
Transaction Code: VOFA
Account determination troubleshooting
Go to VF02 and do a review of the Account Determination (Shift + F11) to figure out the justification for accounting.
The log is not being produced. This will help you understand why any account settings are missing.
I hope you like the account determination configuration, Check out these tutorial links to learn more about SAP. Happy Learning ..!!
- Available to Promise (ATP) in SAP
- Replenishment lead time (RLT)
- SAP Sales Integration with other Modules
- SD Advanced Pricing
- SAP S/4HANA
- Third-Party Sales in SAP
- Output determination
- Route determination