Skip to Content
User Experience Insights
Author's profile photo Durga sai ram Naraharisetty

Predictive Accounting in SAP S/4HANA 1909

Hi Friends!

This is my first blog post, I will explain how Predictive Accounting in SAP S/4HANA 1909 and below blog post divided into 3 areas like Configuration, Apps and Reporting.

Predictive accounting enables you to take the most up-to-date data from areas in S/4HANA outside of Finance, such as Sales; other integrated products, such as SAP Concur; or external systems, and use it to predict future results at any time. You then have a better understanding of what your accounting results, at the end of the current period or quarter.

SAP S/4HANA 1809 has introduced predictive accounting and some improvements in the 1909 version like the Monitor Quality Predictive App

(A) Availability:

Scope item 2FD (Accounting for Incoming Sales Orders) as BP content covers the predictive accounting for incoming sales orders.

(B) Customization Setup:

The setup to activate predictive accounting is quite simple and straight forward. It involves below steps:

1. Define Settings for Ledgers and Currency Types

Path: SPRO -> Financial Accounting -> Financial Accounting Global Settings-> Ledgers-> Define Settings for Ledgers and Currency Types

Transaction Code: FINSC_LEDGER

 

Here a new ledger is to be created as extension ledger with type as “P – line Items with technical Numbers / no deletion possible”. This type is newly introduced in version 1909. The base ledger for this should always be leading ledger, so that the report can contain the actual data coming from leading ledger and predictive data from this extension ledger.

Once ledger created it can be extended to the relevant company codes:

 

Accounting principal assigned to this extension should be same as leading ledger, as predictive accounting is just an extension of your main reporting with forward-looking data.

2.Define Ledger Group

Path: SPRO -> Financial Accounting -> Financial Accounting Global Settings-> Ledgers->Ledger-> Define Ledger Group

Transaction Code: S_AL0_19000001

Here you create a new ledger group which contains only above special extension ledger created for predictive accounting:

 

3. Map the predictive ledger to the control settings:

Transaction Code: SM30

Table: FINSV_PRED_RLDNR

Here this dedicated extension ledger for predictive accounting should be maintained, so that SAP know which one is to be used for posting of incoming sales orders:

 

4. Activate Predictive Accounting for Incoming Sales Orders

Path: SPRO -> Controlling -> Profitability Analysis -> Flows of Actual Values -> Transfer of Incoming Sales Orders -> Activate Predictive Accounting for Incoming Sales Orders

Transaction Code: FINS_PRED_INC_SO_ACT

For the controlling area, activate the incoming sales order with indicator “Active with date of entry”:

 

5. Maintain Billing Types for Predictive Accounting

Transaction Code: SM30

Table:  FINSV_PRED_FKART

Here, all the billing types which you want to get considered by predictive accounting must be maintained, e.g.:

 

6. Maintain SD item categories for Predictive Accounting

Transaction Code: SM30

Table: FINSV_PRED_FKREL

Here, all the SD item categories which you want to get considered by predictive accounting must be maintained, e.g.:

 

7.Mapping of Financial Statement version to semantic tag

Transaction Code: FINSC_FAGL2SEMTA

In this Transaction Code maintain the mapping of FSV to semantic tags. This is an important step to get the data and display in the apps.

Analysis:

  • When Sales Order is created (Transaction Code: VA01), two documents created in the predictive ledger. At this time no entries created in the leading ledger.

Transaction Code: VA03 (Display Sales Order)

Accounting Entries in Prediction Ledger:

Two Predictive Entries are created as below:

  • PGI Transaction type: RMWL
  • IR Transaction type: SD00

Use Fiori App “Display Predictive Accounting Document” to view the predictive accounting document.

Post Goods Issue:

Document: PA000000B0

IR:

Document: PA000000B1

  • After PGI, one document is created in the leading ledger and one document in the prediction ledger with reduction status as 3(Reduction Posting).

Entries in Leading Ledger (0L):

Document: 4900000013 (PGI Accounting Document)

Entries in Predictive Ledger:

One Entry Created with reduction Posting Status 3

 

Document: PA000000L0

  • After IR created, one document is created in the leading ledger and one document in the prediction ledger with reduction status as 3 (Reduction Posting).

Entries in Ledger 0L in ACDOCA:

Document: 9300000004

 

Accounting Entries in Ledger PA :

One Entry Created for Billing with reduction status 03.

Document: PA000000M0

Final Overview:

Ledger 0L PA
Sales Order (92) No Entries Two Entries (Doc No : PA000000B0,PA000000B1)
PGI 4900000013 PA000000L0 with reduction status 3
Billing 9300000004 PA000000M0 with reduction status 3

Table: FINS_PR_ACCNOTIF

In this table we can see all sales order created with different status as 01 (Processed Successfully),02 (Processed with Errors) and 03(Cancelled)

Reporting and Analytics for Predictive Accounting:

Apps:

Sales Accounting Overview:

Here you can see that data from leading ledger and prediction ledger can be combined to see the incoming sales order impact even if there is no actual PGI/Billing:

Incoming sales Order:

This report shows the incoming sales order details with postings for prediction ledger:

Monitor predictive Accounting App:

This App shows only an errors in when sales order created.

Gross Margin:

This fiori application show the prediction postings with actual postings allows users to analyze the expected results at period/quarter end:

 

Issue Identified:

In the Monitor predictive Accounting App shows non activated company code of predictive ledger.

Solution: Implement the note 3074498

Restrictions:

In SAP S/4HANA 1809 and 1909, the following restrictions apply for predictive accounting for sales

processes:

Refer the SAP Note: 2931453

1)       Predictive accounting is not supported for the following business processes:

  • Customer project management
  • Project-based services

2)   For the “intercompany sales within selling company” business process, the following                           restrictions apply:

  • Predictive journal entries can only be correctly created for the following source documents:
  • Goods issue issued by the delivering company code
  • Customer invoice issued by the selling company code

3)    No predictive journal entries are created for the following source documents:

  • Intercompany invoice issued by the delivering company code
  • Intercompany supplier invoice issued by the selling company code

4)    For the “third-party direct shipment” business process, predictions for the goods issues are not           supported.

A) Predictive accounting only processes the following SD document categories:

  • C – Order
  • H – Returns
  • I – Order Without Charge
  • K – Credit Memo Request
  • L – Debit Memo Request

B) Split valuation with batches of sales order items is not supported. Predictive accounting may not be able to correctly valuate the predicted amounts for items processed in this way.

C) Predictive accounting does not support changes to items in a sales order with a billing plan after predictive journal entries for the items have been reduced.

Conclusion:

This blog post addressed Predictive accounting functionalities and some known issues with their solutions. As Predictive accounting is a full-blown solution. It is impossible to cover all the business scenarios in just one document especially events which occurs during life cycle of Sales orders. Hence, I will continue writing about new features in predictive accounting. Stay Tuned!

Thank you for going through the post. Your feedback and comments will help me make it more relevant to the community.

Regards,

Durga Sai Ram

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Govindasamy Bhaskaran
      Govindasamy Bhaskaran

      Hi Durga Sai Ram,

      Appreciate the good blog with steps and explanations.

      Regards

      Bhaskaran G