Skip to Content
Technical Articles
Author's profile photo Nicky Jindal

Periodic accrual process and configuration in accrual engine- S4 HANA 1909

Introduction

With S/4HANA 1909, accrual engine has introduced “Review and Approve accruals” transactions.

There are additional transactions introduced are as follows:

  1. ACEPROPOSALRUN – Propose Periodic Amounts
  2. FACRATIVL – Edit Time Intervals for Accruals Reviews and Approvals
  3. FACRARVWCO – Review Periodic Accruals – Controllers
  4. FACRAAPPRVGL – Approve Periodic Accruals – G/L Accountants

The process is driven by Standard accrual periodic flow wherein accrual object is created by preparer, reviewed by reviewer, approved by approver and then it is can be posted manually or by scheduling batch jobs.

In this blog, I would explore customising the periodic accrual – ACCRL_PER in manual accrual flow so that reviewer and approver concept is displayed. This will involve right from creating the accrual object, one with value lower than the threshold limit and other with value more than the threshold limit description the process in details.

 Please note:

  • The configurations described below are relevant for SAP S/4HANA 1909.
  • No coding is required to set up this flow, so this can be done without any development or ABAP knowledge.

Business Requirement

For the purpose of this blog, we would explore the requirements as follows:

  • Requirement that a low value transaction of less than USD 100 is not required to be reviewed or approved.
  • Reviewer and approver shall be different person with different authorisation.

 

Configuration Details

 Steps to set up the periodic accrual engine flow

Step 1. Assign company code to the S4 HANA accrual engine

  • Assign the company code for which accrual engine must be activated

Step 2. Close fiscal year for changes to Accrual objects

  • Mention the year for which accrual objects is not required to be change.

Step 3. Accrual Method

  • Define the different accrual method for accrual calculations along with the ABAP class so that the system calculates the accrual value due for the period or date.
  • LINEAR accrual method with ABAP class “CL_ACE_CFG_METHOD_LINEAR_P1” for period posting. Likewise, different standard ABAP class are to be selected and defined against each of the method.
  • New accrual method can be defined here other than standard through enhancements.

Step 4. Define reasons why adjusting periodic amount in review and approval of accruals

  • Reviewer has the authorisation to change the accrual amount on review due date or due period.
  • Define the possible reasons for change in the accrual value which will be used by the reviewer when any accrual due amount is changed to tag the reason for change against each change.
  • The comment may be made mandatory.

Step 5. Define threshold variants for review and approval of accruals

  • Define threshold limit against each currency under different threshold variant.
  • Define lower threshold and upper threshold amount along with currency for which no reviewer or approver is required in the system.
  • If the accrual amount in a given period is below the lower threshold, the accrual amount will not be approved automatically by the system, and the Approval Required checkbox on the Review and Approve Accruals screens will be read-only, that is, no user will be able to approve this amount. In this case, the Accrual Engine won’t post the accrual amount.
  • If the accrual amount in a given period exceeds the lower threshold, but is below the upper threshold, the accrual amount is automatically approved by the system on the screens for reviewing and approving accruals. The system also automatically approves accrual amounts equal to the lower threshold.
  • If you don’t want the system to approve accrual amounts automatically, you can enter the same amount for both the upper and lower threshold amounts. This prevents the system from approving accruals automatically and makes it necessary to approve them manually.
  • Default variant can also be selected from the defined list of thresholds.

Step 6. Define Time interval

  • Define time interval variants for reviewing and approving.
  • Give the description for different variant saved in the system.
  • Default variant can be selected from the defined list of threshold limit against each currency under different threshold variant.

  • Select the variant and save the time intervals for review and approval.
  • List the last day of period along with the following details:
    • Review start date
    • Review start time
    • Review end date
    • Review end time
    • Approval start date
    • Approval start time
    • Approval end date
    • Approval end time

Step 7. Define accrual item type

  • Define the standard periodic accrual type with the accrual method defined.
  • Linear method will enable the system to calculate the accrual value each period or date as per configuration depending on the life of the accrual object.
  • It can be defined as upload allowed, if accrual objects are created through excel upload.

Step 8. Item type settings for ledger group

  • Define the frequency of standard periodic accrual type.
  • Define the reversal posting type for standard accrual type.
  • Specify the ledger for accrual posting.
  • Define settings for review and approval
  • Select the variant which was defined for review and approval.

Step 9. Define Posting schema

  • Define which line items a posting can contain represented by a symbolic account.
  • Define the posting schema and give a description to it.

  • Appropriate account is derived from the symbolic account by using the account determination.
  • Define the symbolic account for periodic accruals.
  • Define the standard SLA line item type against each symbolic account.

 

Step 10. Assignment of accrual item types to posting schemas

  • Define journal entry type to be used in the accrual postings.
  • Define posting schema for each accrual item type.
  • Define document type for each of these accrual item types.

Step 11. Create basic account determination

  • Account determination for accrual postings by entering at least the symbolic account and the G/L account to be used for accruals.
  • Define G/L account to be used in the accrual postings.

Step 12. Define accrual object categories

  • Define object category to group together accrual objects of a similar nature.
  • Object category like salary, legal expenses, etc can be created.

Step 13. Assign parameters to Accrual object categories

  • Any field which is required to be incorporated in accrual can be defined here as a parameter.

Step 14. Define number range for accrual object

  • Number range may be internal or external to be defined at company code level.
  • In case of external number range, we need to give the accrual object while creating the same.

Step 15. Assign number range to object categories

  • Assign the defined number range to object categories created.
  • Different defined number ranges can be assigned to different object categories.

Periodic Accrual Process Flow

The following flowchart describes the Periodic accrual accounting process via accrual engine (example).

The above diagram explains step by step periodic accrual process using accrual engine. Please note that this is the standard step by step SAP flow. This flow may be modified as per client requirement and through various enhancements.

Step 1: Create accrual object

Transaction: ACACTREE01

Enter

Click on download excel template

Click on option 1 for periodic accruals and save it in your system.

Fill in the excel template.

Step 2: Upload the excel template

Transaction: ACACTREE01

Navigation

Attach the file form the system

Execute the process in test run

  • Since no errors were encountered, it will be uploaded in actual run by unticking the test run option.

Execute

Two accrual objects got created with number 12 and 13 amounting to 90000 USD and 45 USD respectively.

Step 3: Propose periodic run

Transaction: ACEPROPOSALRUN

Navigation

Enter the parameters

  • Company code: 0001
  • Accrual item type: ZSALARY
  • Last day of period: 30.04.2020
  • Accrual object: ZSALARY 12 and 13

Tick test run to check for any error

  • Execute in test run mode to check for any errors.

  • Since no errors are encountered, it will be executed in actual run.

Execute

Within threshold limit?

  • Two columns which are highlighted are review status and review type.

Review status details

  • Review status as X – reviewed for accrual object 12 is because the accrual value is more than threshold limit.
  • Review status as U – not applicable for accrual object 13 is because the accrual value is less than the lower threshold limit of 100 USD.

Review type details

  • Review type as E- Explicit review is required as accrual value is more than the upper threshold limit of 1000 USD.
  • Review type as B – No review required as accrual value is less than the lower threshold limit if 100 USD.

Since, two accrual object is created, accrual object number 12 will follow step 5 and 6 but, accrual object number 13, accrual engine will not post any document as it is below threshold limit.

Step 4: Edit time interval for review and approval

Transaction: FACRATIVL

Navigation

Enter

  • Select the variant

  • Below intervals are defined in the variant.
  • It can be changed on requirement or any other reason like management decision or change in timelines, etc.
  • Edit the time interval for 30.04.2020 as we want to review and approve on 02.04.2020, though ideally it should be in month of may.

Changed value for April 20

  • Time can also be set here depending on the country time zone.

Step 5: Review Periodic accruals

Transaction: FACRARVWCO

Navigation

Enter the parameters

  • Company code: 0001
  • Accrual type: ACCRL_PER
  • Accrual Object: ZSALARY 0000000000000000000012
  • Last Day of period: 30.04.2020

Execute

  • Accrual Value of 10000 USD can be changed by the reviewer, select the adjustment reason for the same and comment on the same.
  • Changing the accrual value from 10000 USD to 11000 USD.

  • Tick the amount review tab and click on set as reviewed tab

  • Save the screen to complete the review.

Step 6: Approve Periodic accruals

Transaction: FACRAAPPRGL

Navigation

Enter the parameter:

  • Company code: 0001
  • Accrual item type: ACCRL_PER
  • Accrual Object: ZSALARY 0000000000000000000012
  • Last Day of period: 30.04.2020

Execute

  • Both the accrual value is displayed, proposed and reviewed accrual value.
  • Adjustment reason and comment is also displayed to the approver given by reviewer.
  • Tick on amount approver and click on approve tab.

  • Save the screen changes.

Step 7: Periodic posting run

Transaction: ACEPOSTINGRUN

Navigation

Enter the parameter:

  • Company code:0001
  • Accrual Type: ACCRL_PER.
  • Last day of period: 30.04.2020
  • Accrual Object: ZSALARY 0000000000000000000012
  • Execution in test run to check for errors.

Execute

  • No error encountered.

Execute

Step 8: Reverse Periodic posting

Transaction: ACACTREE02

Navigation

Enter the parameter:

  • Company code: 0001
  • Accrual object Category: ZSALARY
  • Accrual Object Number : 12

Execute

  • Click on Postings tab

  • Accrual entry posted by the system – document number 100000015.
  • Select the line item to be reversed and click on reverse tab.

  • Enter the date manually on which date it is to be reversed.

Enter

  • Reversal document posted by the system.

 

Conclusion

Periodic accrual flow in accrual engine has reviewer and approver option available in standard. Custom workflow is thereby not required as the purpose it met by assigning standard roles of Controllers and G/L accountant along with threshold flexibility.

References:

SAP Help for Configuration guide : https://help.sap.com/viewer/651d8af3ea974ad1a4d74449122c620e/1909.000/en-US/3c245920e1d2420ea7ae3bb37af21ef8.html

Assigned Tags

      25 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Vincent V.
      Vincent V.

      Thank you very much for all the screenshots(!)

       

      I forecast SAP to die soon. They say they are making it easier, but they are making it more complex release after release.

      You should be a PhD to DESIGN the system.

       

      Not to customize it, let alone be a simple operator.

       

      SAP now enforces these 2 latter to be a PhD too.

       

      This will not last.

      Author's profile photo Nicky Jindal
      Nicky Jindal
      Blog Post Author

      Hi Vincent,

       

      SAP is making the solution simpler and lengthy but according to me it is as per latest requirement.Client these days ask for review and approval by different users in the system. In case such mechanism are not made, we are forced to deliver custom program to suit the business requirement.

       

      If a standard is delivering that functionality, it is easy for client to accept and use it

       

      Thanks,

      Nicky

       

      Author's profile photo Soufiane Machrouhi
      Soufiane Machrouhi

      totally agree Nicky Jindal

      1 - do you know if there is any FIORI app within 1909 for accruals mgt?

      2 - also, do you know if the reversal postings can be automated ? (this can be very helpfull in order to avoid manual opetarions and accelerate the closing)

      3 - What is SAP roadmap for the next releases?

      Thanks

      Soufiane

      Author's profile photo Vikas Tayal
      Vikas Tayal

      Hi Nicky,

       

      It’s very interesting concept and well documented with complete screen shots.

      I learnt new things in accrual through your document. Thank you very much for your time and effort.

       

      Thanks!

      Rajani

      Author's profile photo Saul Brennan
      Saul Brennan

      Thank you Nicky, really interesting.

      Author's profile photo Venugopal Battepati
      Venugopal Battepati

      Hello,

      Appreciate your efforts on documenting this and thanks for sharing ?. I used the same in our project in 1809, however couldn’t achieve 2 things.

      1. Multiple line items in single accrual posting (say it includes tax line as well).

      2. Cross company code accruals. This should be available in 1909 as I heard from sap.

      Please let me know your findings on these in 1909 if you come across

       

      Thanks again!

      Venu

      Author's profile photo Nicky Jindal
      Nicky Jindal
      Blog Post Author

      Hi Venu,

       

      As per S4 HANA 1909,

      • Multiple line items in single accrual postings is not possible in 1909 also. It is only possible by creating multiple accrual types (SAP confirmed) or by enhancements (read in some article).
      • I haven't tried cross company code accruals, will try and let us know whether it works in 1909 or not.

      Thanks,

      Nicky

      Author's profile photo Gourav Jain
      Gourav Jain

      Hi Nicky,

      Can you please help me when assigning the accrual object category with parameter Example, I am getting below error:

      Number range z is reserved for customer defined parameter

      Message no. ACac009

      Author's profile photo Nicky Jindal
      Nicky Jindal
      Blog Post Author

      Hi Gaurav,

       

      Customer parameter is always starting with Z in SAP. So, that the reason you are getting the error " Number range Z id reserved for customer defined parameter".

      if you have any field which you want it to assign in parameter, then you can be assigned in this config:

       

      Thanks,

      Nicky

      Author's profile photo Attila Szasz
      Attila Szasz

      Good post but unfortunately the customizing transaction codes or the exact IMG locations  are not showed.

       

       

      Author's profile photo Nicky Jindal
      Nicky Jindal
      Blog Post Author

      Hi Attila,

      Customising transaction is clearly given in the screenshot attached in the article.

      Nicky

      Author's profile photo Gourav Jain
      Gourav Jain

      Hi Nicky,

       

      Have you configured the same and tested end to end. Actually I am testing the same with Linear in which the monthly posting is not posted and I am getting an error dump. Can you please help me over that.

      Thx

      Author's profile photo Nicky Jindal
      Nicky Jindal
      Blog Post Author

      Yes Gaurav,

      I have tested the functionality end to end and its working in the system. Let me know where are you getting the error.

      Regards

      Nicky

      Author's profile photo Soufiane Machrouhi
      Soufiane Machrouhi

      Nicky,

      Brilliant job, thanks for much for this detailed tuto

      i have followed step by step your advices but i'm stuck when launching the "Propose periodic amounts". the system does not find any results where i'm sure my objects have been correctly created ! below some screeshots:

      display accruals objects - i have created two objects assigned to "COSTS" item type as you can see below:

      when i go to "Propose periodic amount", i can see my objects

      BUT when i execute, nothing is found !!!

      i verified dozens of times and changed my selection criterias multiple times. do you know what can it be please?

       

      Thanks for you help,

      Soufiane

      Author's profile photo Jasmit Singh Sarna
      Jasmit Singh Sarna

      Hello,

      Please check SU53 whether you have proper authorization to run the proposal program. I faced a similar problem which was resolved after getting the authorization.

      Regards

      Jasmit

      Author's profile photo Venkatesh K
      Venkatesh K

      Hi Nicky,

       

      Good document.

       

      Is it possible to share relevant reports.

       

      Regards,

      Venkatesh. k

      Author's profile photo Kunal Kumar Rajan
      Kunal Kumar Rajan

      Hi Nicky,

      Really nice document with SAP Accrual Engine  1809/1909.

       

      Cheers,

      Kunal

       

      Author's profile photo Sandeep Parasramka
      Sandeep Parasramka

      I appreciate for the blog but Accrual engine  most disaster solution from SAP its not fully build we cannot use for prepaid accural

      Author's profile photo Vusal Mamiyev
      Vusal Mamiyev

      Hi Nicky Jindal ,

      First of all it's great work, thank you for detailed explanation.

      I want to ask about accrual posting,  if you don't mind.

      Is it possible to create accrual object and post 12 periods together in different period (with different FI documents) >?

      Thanks in Advance!

       

      Author's profile photo Nancy Yuan
      Nancy Yuan

      Hi Nicky Jindal,

       

      Thanks for the detailed guide!

      One quick question about the threshold variant. Is there a step to assign this threshold variant? Is yes, would it be assigned to Accrual object category, or assigned to Accrual item type? or it's assigned in Accrual object creation?

       

      Author's profile photo Soufiane Machrouhi
      Soufiane Machrouhi

      hi Nancy Yuan

      Yes you should assign your threshold variant to the accrual item type. follow this path:

      Basic settings>Accrual item types>define accrual item types>Item type setting for ledger group inc. rep ledger

      hope it helps

      Soufiane

      Author's profile photo Tushar Poddar
      Tushar Poddar

      Hi Nicky,

       

      What business scenarios can  be managed by new Accrual engine offered by S/4 HANA

      Please note that none of my customers have found ECC accrual engine useful as it can only manage prepaid accounting only that too with cumbersome process and limitations.

      Moreover, the term "Accrual" is highly confusing what business business considers as accruals and what SAP has solution for  !!!

      Please provide your view on above, if any.

      Thanks

      Tushar

      Author's profile photo Chris Kim
      Chris Kim

      Hello Nicky,

      Thank you for your document.

      It is so helpful for me to understand SAP accrual functionality.

       

      I have a question for you.

      Our system has a lot of accrual object and posting data so it takes a long time to execute 'ACACPSITEMS' transaction.

      When I look into the accrual object data, I found out many past-due data is included at this 'ACACPSITEMS' transaction.

      Also I found out if I do the action for terminating permanently against past-due objects, I can skip the data at 'ACACPSITEMS' transaction.

      As I mentioned, our system has a lot of data to terminate permanently.

      But, I do not know how to do it with mass volume.

       

      Could you let me know how I can terminate a lot of accrual object data permanently at one time?

       

      Thank you for your help in advance.

      BR,

      Chris Kim

      Author's profile photo Daisy Saavedra - Barbarona
      Daisy Saavedra - Barbarona

      Hi Nicky,

      Thanks for your blog post. It is very helpful.

      By the way, I tried doing the upload (using 1st template) and I got an error "Enter the transaction currency for accrual item ACCRL_PER/."  The load file has the currency which I set similar to config. Would you know where else did I miss? Thanks.

       

      Author's profile photo Balaji S
      Balaji S

      Hi ,

      In ACAC component we do rejection in APPROVAL T CODE -FACRAAPRVGL what would be effect in accural object in which place we can see the changes for rejection  ?

      2- Which tables rejection value is getting stored ?

      3- In STD any specific configuration for assigning REVIEW and APPROVAL TCODE i mean authorisation to user so when approver reject the object so reviewer  will get notification about this object for rejected  ?

      4- status will get change once ACAC object got rejected ?

       

      Need your reply for the above query ?

      Regards,

      BalajI s(banknews20@gmail.com)