Technical Articles
Predictive Accounting for incoming sales orders in S/4HANA
In my previous post about Finance in S/4HANA 1809 I highlighted all the new functionalities in the 2018 release of S/4HANA On-Premise. As promised, in this blog I would like to go in to the details of the enhancements in Account Based COPA in version 1809.
You will read and learn more about Predictive Accounting for incoming sales orders in account ased COPA in this blogpost.
Both sales orders and statistical sales conditions were not possible in Account Based COPA before S/4HANA 1809. I will explain and show how the new functionality works.
Predictive Accounting for Incoming Sales Orders
SAP is making use of the extension ledger in accounting to store the values coming from incoming sales orders. Normally a sales order is not posting anything to accounting. We expect the first accounting entry at the time of goods issue. But when enabling Incoming Sales order functionality in COPA in S/4HANA 1809, sales orders will post entries in the extension ledger.
Next, I will show the configuration steps to enable this.
Configuration in Finance and Sales
We first need to define and assign an extension ledger before we can activate Predictive accounting for sales orders.
Next, we need to maintain the predictive accounting ledger 0E in table FINSV_PRED_RLDNR. You can maintain the table in SM30.
As a final step in the FiCo configuration we need to activate predictive accounting for incoming sales orders in the IMG:
In the SD area we also need to perform some configuration steps. The Sales Order types and billing types applying for predictive accounting must be maintained in the corresponding tables. Only the order types and item categories specified in the below tables qualify for predictive accounting. Additionally, you can assign billing types or billing relevance specifically for predictive accounting in case these items do not have an assignment in customizing.
- FINSV_PRED_FKART -> SD order types (you can specify predictive accounting billing type for order types that don’t have a billing type assigned).
- FINSV_PRED_FKREL -> SD Item Categories (you can assign billing relevance for predictive for item categories that don’t have a billing relevance).
Reporting in Predictive Accounting
Now, in contradiction to standard accounting in SAP, creating and saving an Sales Order will generate accounting entries in the extension ledger.
There are several ways to report the predictive accounting entries generated by the sales orders. Since there is a posting in the extension ledger you will be able to report directly on ACDOCA table. Basically, all financial accounting related queries and apps will show you the predictive accounting entries.
However, there is a specific Fiori app for Sales Order Predictive Accounting. In this app I have the possibility to easily sort and filter on material groups, customer groups or time dimensions.
The same data shown in the predictive accounting app can be seen in an ACDOCA query as well:
What happens after Sales Order gets delivered and billed?
After the sales order is processed accounting entries will be posted to the leading ledger as usual. Additionally, the predictive accounting entries will be credited!
I have delivered and billed sales order 1194. When you check the sales order in the Sales Order Actuals App, you will see the “real” posting entries in the leading ledger only:
The Actuals App will never show the predictive accounting entries.
In the ACDOCA table you can clearly see the predictive accounting entries in the first 2 rows. The other entries are posted after delivering and billing the Sales Order:
In upcoming blogpost, I will continue writing about new features in Account Bases COPA in S/4HANA 1809. Stay tuned.
This post appeared first on www.s4hanablog.com.
Hi Ugar
Thank you very much for the excellent blog. Its really fantastic information, you have provided complete e2e process of Sales orders transfer to Account based Profitability.
Thanks
Sai Krishna
Hi, does this work as well for PS sales order entry? What classically was transferred to CO-PA under the record type “I” during the settlement of the billing WBS element. Thanks for answering.
yes should work when you enable it for that SD document type.
HI,
I hope it will work for PS sales order if it has subsequent Delivery and Invoice Document. As per my knowledge, service based projects such as Customer Project Management (CPM & PS) are not consider under this Predictive Accounting.
Moreover, Settlement is not related Predictive Accounting & still it works same as in normal SAP.
Best Regards
Raj
Hello Ugur Hasdemir!
In my system, the entries in the predictive ledger are saved with the date of the sales order or current date, do you know of any notes that correct this problem?
Thanks
Hello Ugur!
I have a scenario that I would ask your help:
A sales document type has 3 items. Only one of them will be relevant to accounting (will be in the billing document).
This is because the real accounting postings are a sum of the 2 other sales order items, in one single profit center. This was a local requirement due to Brazil tax reasons.
But the customer wants to see the revenue+taxes opened by the 2 other profit centers that are in the sales order but were not billed.
Can I use the predictive accounting to post to an extension Ledger the values of these 2 other Items, even if they are not billed (so they will not be reversed)?
This way I could see them in the reports, and to avoid duplicity I would exclude the "consolidation" profit center (the one that was billed).
Was it clear?
kind regards
Mayumi
Very detailed blog! thanks
Hi Everyone - has anyone implemented predictive accounting in an already live system? E.g., as a post-Go Live activity?