You are here:
How Are Sales Agreement Actuals Calculated?
A daily automated process derives and calculates sales agreement actuals from orders, from orders associated with contracts, or from quantities imported from external systems. Users can also manually recalculate the actuals of an activated sales agreement.
Required Editions
| Available in: Lightning Experience |
| Available in: Enterprise, Unlimited, and Developer Editions |
How Are Actuals Derived?
Admins can choose how actuals for all sales agreements in your Salesforce org are calculated in the Sales Agreement settings in Setup. If users have access to the Actuals Calculation Mode field on the Sales Agreement object, they can choose how actuals are calculated for a sales agreement record.
Actuals for a sales agreement can be derived from these sources.
- Orders, if the actuals calculation mode is Automatically from direct orders.
- Orders associated with contracts, if the actuals calculation mode is Automatically from orders through contracts.
- Data imported from external systems, if the actuals calculation mode is Manually using API upload.
Where Are Actuals Stored and Shown?
The Actual Quantity and the Actual Amount fields on the Sales Agreement Product Schedules object store the actual values for a product or a category for a particular schedule of a sales agreement. The Total Actual Quantity and the Total Actual Amount fields on the Sales Agreement Product object aggregates the actual values for a product or a category for all schedules in a sales agreement. The values in all these fields are shown in the table on the Agreement Terms tab of a sales agreement.
How Are Actuals Updated?
An automated process runs every day at 1:00 AM in your org’s time zone and calculates and updates the sales agreement actuals. You can also click the Recalculate Actuals button on a sales agreement record page to recalculate the actuals of that sales agreement.
The automated process considers the quantity and amount of all order products associated with an order. The process considers active orders that have reached their start date in the current schedule of a sales agreement. For each product present in both the active order and the active sales agreement, the order quantity is added to the actual quantity in the sales agreement and the order amount is added to the actual amount in the sales agreement.
Here’s how the automated process updates the actuals of sales agreements.
- The process considers activated orders with start dates in the current schedule of a sales agreement.
- When the process calculates actuals for a new sales agreement for the first time, it considers orders that have start dates in the past schedules of a sales agreement. In subsequent runs for the sales agreement, the process doesn’t consider the orders that have start dates in the past schedules and have been activated in the current schedule. To consider the actuals of activated orders with start dates in past schedules, you must manually recalculate the actuals of that sales agreement.
- The process considers orders with start dates in the future schedules of a sales agreement that have been activated in the current schedule. You can specify upto 24 future schedules to be included in the actuals calculation.
- The process considers an order from the day after the order’s start date. For example, if the order start date is 1 January, the actual quantities of that order are considered for calculation from 2 January.
- The process only considers orders that have been activated until 11:00 PM for the actuals that are calculated on 1:00 AM the next day. All orders activated after 11:00 PM are considered the next time the process runs.
- For an order that has already been considered in a sales agreement, if you update the order in the current schedule, the updates aren’t considered by the process and its actuals aren’t recalculated. To consider the actuals of updated orders in a sales agreement, you must manually recalculate the actuals of that sales agreement.
- Actuals for a sales agreement are calculated based on the calculation mode at the time of activation. The automated process doesn’t consider any change to the actuals calculation mode during the active period.
- If there’s any active reduction order, the order quantity is deducted from the actual quantity in the sales agreement.
- Actuals for expired, canceled, and deleted sales agreements can’t be updated.
- The process considers the last actuals calculation date. If the last actuals calculation date is 4 May, and the current date is 19 May, the automated process for today only recalculates actual quantities for any order changes after 4 May.
- If you’ve manually calculated the actuals of a sales agreement on a certain day, the automated process doesn’t consider the sales agreement that day.
- Order products with negative quantities and unit prices are considered when actuals are calculated for sales agreements. Sales teams create orders with negative quantities to represent order returns or recalls. Negative quantities and unit prices for order products are reflected in the Actual Amount and Actual Quantity metrics on the Agreement Terms tab for a sales agreement record.
- If an order is created for a future effective date, later than the maximum date, such such an order is picked up only when the corresponding schedule becomes eligible for actuals calculation.
- If you upgrade your org, existing activated orders are not picked up immediately. They are picked when the next schedule starts. You can use the Recalculate Actuals option to reconcile the actuals metrics.
Actuals Calculation Modes
Sales agreement actuals are populated according to the Actuals Calculation Mode:
- Automatically from direct orders (Orders): Salesforce calculates actuals from the eligible activated orders linked to the sales agreement. A standard daily process updates them, and you can recalculate on demand to refresh them without waiting for the next run.
- Manually using API upload (Manual): Actuals come from an API upload, integration, or your own process instead of from orders. You can automate these updates with a custom flow or scheduled integration. See Import Data to Update Sales Agreement Actuals
- Data Processing Engine: Salesforce calculates actuals using a Data Processing Engine definition.
Actual values are stored on the Sales Agreement Product Schedule records.
