Skip to Content
Product Information
Author's profile photo Camile Zhou

Accrual Calculation for 2VB: Purchase Order Accruals on S/4HANA Cloud (Part 2)

User cases with calculation example

User cases:

  • PO Item Without valuated GR

o Purchasing of consumable material or service – without goods receipts

o Purchasing of consumable material or service – with non-valuated goods receipts

  • PO Item with valuated GR

o Purchasing of consumable material – with valuated goods receipt postings

o Purchasing of service – with service entry sheet postings

User case.png

Example:

* Explanation of abbreviation in T-accounts

GR: Posting of valuated goods receipt

AC: Posting of accruals

SIV: Posting of invoice

ACRV: The accruals of the former period are reversed

User case A

Purchasing office material:

A PO post on 06/01/2020 with total amount of 6000 EUR without good receipts

Delivery Schedule:

12/02/2020 10 PCs

10/03/2020 15 PCs

09/04/2020 25 PCs

11/05/2020 10 PCs

Net price 100 EUR/PC

Invoice post on:

15/2/2020 500 EUR

25/03/2020 3500 EUR

06/06/2020 2000 EUR

Event:

A.1.png

Accrual Calculation:

A.2.png

T-accounts:

A.3.png

User case B

Purchasing office material:

A PO post on 06/01/2020 with total amount of 6000 with non-valuated goods receipts.


Good receipt(Non-valuated ):

12/02/2020 10 PCs

10/03/2020 15 PCs

09/04/2020 25 PCs

11/05/2020 10 PCs

Invoice post on:

15/2/2020 500 EUR

25/03/2020 3500 EUR

06/06/2020 2000 EUR

Event:

B.1.png

Accrual Calculation:

B.2.png

T-accounts:

B.3.png

User case C

Purchasing office material:

A PO post on 06/01/2020 with total amount of 6000 with valuated goods receipts

Delivery Schedule:

12/02/2020 10 PCs

10/03/2020 15 PCs

09/04/2020 25 PCs

11/05/2020 10 PCs

Net price 100 EUR/PC

GR post the cost on:

15/2/2020 500 EUR

25/03/2020 3500 EUR

06/06/2020 2000 EUR

Invoice post on:

05/03/2020 2000 EUR

16/06/2020 5000 EUR

Event:

C.1.png

Accrual Calculation:

c.2.png

T-accounts:

C.3.png

In this scenario will not consider invocie cost into actual cost.

User case D (1)

Standard PO total amount of 6000 EUR, item category E, post on 06/01/2020

Start date and end date respectively are 01.01.2020 to 31.06.2020

Received an invoice on 10.02.2020 with amount 1500 EUR

Received an invoice on 25.06.2020 with amount 4500 EUR

Event:

D.1.png

The frequency of accrual postings is customized to By Posting Period. As a consequence, the Accrual Engine splits the lifetime into intervals of dates which correspond to the first and last day of the fiscal periods. Afterwards it uses for each such interval the last day of each period as key date for the calculation of the accrual amounts. This will be the result:

Accrual Calculation:

D.2.png

T-accounts:

D1.3.png

User case D (2) – PO Amount is revised

On 15/04/2020 the total PO amount is changed from 6000 to 9000

Received an invoice on 10.02.2020 with amount 1500 EUR

Received an invoice on 25.06.2020 with amount 7500 EUR

Event:

D2.1.png

Accrual Calculation:

D2.2.png

T-accounts:

D2.3.png

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Suporte Inetum
      Suporte Inetum

      Hello Camile.

      Thanks for your articles here. They are very elucidative and help me understanding this functionality.

      I am having an issue that I want to share to see if you can help me.

      I run SAP Cloud, and I customized the Accrual Item Type as

      SACCRL with method SPLN-ACT

      SCSTPLN with method PLN_DSNVGR

      SCSTACT with method SACT-COSTS

      When I create a PO with a single account assignment to a cost center and I post a Non valuated Goods receipt. After run job "Propose Period Ammounts" the system determines the planned cost as the quantity received * net price as expected on the accrual object (1 subobject)

      But if my PO has Multiple Account assignment to for instance 2 costs centers (50% each), and I post a Goods receipt. After run job "Propose Period Ammounts" the system does not determine value for the planned cost. It considers 2 subobjects (one for each cost center) but the planned cost is zero.

      How can I solve this problem?

       

      Thanks.

       

       

       

      Author's profile photo Camile Zhou
      Camile Zhou
      Blog Post Author

      Hi Suporte,

      If you post the non-valuated GR, then the planned costs are decided from non-valuated GR.

      Best regards,

      Camile

      Author's profile photo Salman Akram
      Salman Akram

      Thank you for your awesome post!!! Can you pls advice why our actual cost calculation for valuated gr scenario could be wrong?

       

      Per your blog PO (goods or service based) with a valuated GR, the actual cost for accruals is determined based on the GR only and not IR. In our case while calculating actual cost its taking both GR and IR into consideration.
      Would you know why that could be the case?
      For example:-
      If during a particular MEC planned cost was $1000
      And IR was for $200
      And GR was for $500
      Actual Accrual should be: 1000 - 500 = 500
      We are getting Accrual as = 1000 - 500 - 200 = 300