logo

Are you need IT Support Engineer? Free Consultant

Quantity-Based Accrual Calculation and Review

  • By Sanjay
  • 18/11/2026
  • 21 Views



Quantity-Based Accrual Calculation: Available as of Release 1809 SP4 and 1909 SP1 

Availability: 

  • Quantity-Based Accrual Calculation is available starting from SAP S/4HANA Release 1809 SP4 (Support Package 4) and Release 1909 SP1 (Support Package 1) onwards. 

For Earlier Versions: 

  • If you are using an earlier support package than those specified above, you must apply SAP Note 2838538 titled “Accrual Engine: Quantity Based Calculation” to enable this functionality. 

 

Quantity-Based Accrual Calculation: Motivation 

Current Default Approach – Amount-Based: 

  • By default, periodic accrual amounts are calculated using an amount-based approach. 
  • Amount-based calculation ignores quantities in both planned costs and actual costs. 
  • Accruals are calculated by simply subtracting actual costs from planned costs. 

Limitations of Amount-Based Approach: 

  • This approach ignores differences in both price and quantity between planned and actual costs. 
  • When actual costs are posted with a different price, or with both a different price and different quantity compared to planned costs, calculating accruals based on amounts alone is inaccurate. 
  • Example: When posting the supplier invoice a different price is used compared to the purchase order. 

Advantages of Quantity-Based Approach: 

Accuracy: 

  • It is more accurate to calculate accruals by considering both planned and actual quantities alongside amounts. 

Usability for Reviewers: 

  • Quantity-based accruals are more useful for review purposes at the end of a fiscal period. 
  • Amount-based reviews can be difficult for reviewers to validate as correct. 
  • For non-accountant reviewers (such as project managers), reviewing quantities is more intuitive and natural than reviewing amounts. 
  • Example: Purchasing of consulting. It is easier for the project manager to judge the number of man days compared to consulting costs.

Quantity-Based Accrual Calculation: Algorithm 

Definition: Quantity-Based Accrual Calculation means accrual amounts are calculated using the formula: 

Accrual Amount = (Cumulated Planned Quantity − Cumulated Actual Quantity) × Net Price 

How the Formula Works: 

  • First, the accrual quantity is calculated as planned quantity minus actual quantity. 
  • Afterwards, the accrual quantity is multiplied by the net price to get the accrual amount. 

Net Price Source: The Net Price in this formula is taken from the purchase order item. 

Remark – Cases Where Quantity Is Not Considered: 

In the below service PO Items, if the unit is unconvertible (namely, no dimension is defined for this unit), the quantity will not be considered: 

  • Lean Service: Product Type Group is 2 and Item Category is empty 
  • Enhanced Limit: Product Type Group is 2 and Item Category is E 
  • Item Category is D 

Some common unconvertible units are EA, PC, AU, etc., but whether they are convertible or not is defined in table T006 Units of Measurement. 

Quantity-Based Accrual Calculation: Customizing 

Activation: To activate the quantity-based calculation for accrual amounts, the indicator Quantity-Based Accrual Calculation must be set in the IMG activity: 

Accruals Management → Basic Settings → Accrual Item Types → Define Accrual Item Types, in the section Item Type Settings for Ldrgrp incl. Repr. Ledger (see transaction ACEIMG). 

  • Technically, this is customizing viewcluster VC_TACE_ITEMTY. 

Plan Minus Actual Approach: If the Plan Minus Actual approach is used to calculate the accruals, the indicator Quantity-Based Accrual Calculation must be set only for the accrual item type that calculates the accrual amounts. 

  • In the default customizing settings, this is the accrual item type ACCRL. 
  • Do not set the indicator in the other two accrual item types for planned costs and actual costs. 

Purpose of the Indicator: The indicator only needs to be set for the accruals item type (ACCRL) so that the system uses the formula: Accrual Amount = (Planned Quantity − Actual Quantity) × Net Price 

  • In the planned costs and actual costs, the Accrual Engine anyway always has the quantities available. 
  • By setting the indicator Quantity-Based Accrual Calculation for ACCRL, the Accrual Engine “just” switches: 
  • From: the standard formula: Accrual Amount = Cumulated Planned Costs − Cumulated Actual Costs 
  • To: the quantity-based formula: Accrual Amount = (Cumulated Planned Quantity − Cumulated Actual Quantity) × Net Price 

Ujhelyi_Zsuzsi_0-1794993383837.Png

Amount-Based Accrual Calculation: Display of Quantities is Possible 

  • Displaying quantities in the Accrual Engine screens is possible even if the accrual calculation is done amount-based. 
  • In the amount-based approach—which is the default—the quantities are ignored when it comes to calculating the accrual amounts. 
  • In transaction PACOTREE03, activating quantity-based accrual calculation affects “only” the algorithm of how the columns for the accrual amounts are calculated.

Ujhelyi_Zsuzsi_1-1794993499043.Png

Quantity-Based Accrual Calculation: Example – Purchase Order 

The effects of quantity-based accrual calculation are explained through an example. The example includes the following key points: 

  • Starting point: The example begins with the creation of a purchase order that has a delivery schedule with partial deliveries. 
  • Goods receipt: No goods receipt is expected. 
  • Cost posting: The costs will be posted by the supplier invoice. 

Ujhelyi_Zsuzsi_2-1794993530585.Png

 

 





Source link

Leave a Reply

Your email address will not be published. Required fields are marked *

Chat with us on WhatsApp!