Statistical Sales Condition in Margin Analysis
In the area of margin analysis there is a requirement to calculate and post statistical information along with sales order which can be made available via standard reports/Apps. With this functionality, we can transfer statistical sales condition types (i.e. Warranty and Cash discount) to financial accounting. We can also view financial data using analytical apps from the extension ledger. There is an approach available to calculate and post statistical information to costing based COPA (Controlling profitability analysis) whereas this functionality is now available in margin analysis to calculate and post statistical information to financial accounting which can be reported against an extension ledger via Fiori Apps.
With this blog post I would like to walk you through the process of set-up and transfer of statistical condition type to Financial Accounting.
- Statistical condition types which are relevant for account determination. s
- Account key for statistical condition type.
- GL account assignment against Accounting key and Sales organization combination.
- Extension ledger and Ledger group to post statistical condition type.
- Ledger group to the processing of statistical condition type.
Process -Sales Order Accounting with Statistical Condition Type.
Step 1: Sales Order
Sales order creation along with two statistical condition types – DCD1 and DCD2.
Revenue – 17.55
COGS – 8.54
Step 2 : Post Goods Issue
Accounting Entry posted during PGI
Step 3 : Invoice
Cash discount entry posted during Invoice verification to the extension ledger ‘0C’.
Invoice entry posted to ledger ‘0L’ with revenue posting.
Receivable account gets debited and Revenue account gets credited during invoice processing.
Cash Discount entry posted to extension ledger ‘0C’ from the statistical condition type.
Step 4: Fiori App
Statistical condition gets posted during invoice verification. This will reflect in extension ledger ‘0C’ in Sales Order- Actuals Fiori app. These entries are statistical in nature and will reflect in the extension ledger.
Posting of Statistical condition values during invoicing will help business to analyze statistical costs at sales order level without impacting Financial book of accounts (leading ledger ‘0L’). These entries are also available at financial statement version at extension ledger level.
Reference SAP Best practice: Scope item 34B.
Thanks for reading this blog post. I would like to see your comments and would like to answer questions which u can post at Q&A tag area : https://answers.sap.com/tags/66233466-fcd6-45d2-a9ae-2cba38c72e19
Concise and clear. Well Penned !
Thank you very much!
Great insight on the topic with limited posts available on the community. Thanks for sharing !