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
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.
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.
Source link