Manufacturing Cloud: Sales Agreement Actual Orders column not updating from linked orders

Follow the steps based on the calculation mode configured for your Sales Agreement. Identify the mode in Setup under Sales Agreements > Default Actuals Calculation Mode, or on the Sales Agreement record in the Actuals Calculation Mode (ActualsCalculationMode) field.

Cause 1: Sales Agreement or Order is not activated

1. Open the Sales Agreement record and verify that the Status (Status) is set to Activated. Sales Agreements in Draft, Approved, Expired, Cancelled, Rejected, or Under Revision status are not processed by the daily job.
2. Open each related Order and confirm that its Status is Activated. Orders in Draft status are ignored.
3. Wait for the next scheduled run at 1:00 AM in the organization’s time zone, or click Recalculate Actuals from the Agreement Terms tab on the Sales Agreement.

Cause 2: Order start date or product mismatch

1. On each Order, verify that the Order Start Date falls within the Sales Agreement’s active schedule window, typically on or after the Sales Agreement Start Date and before the End Date. The Order Start Date is used as the primary mapping date for schedule assignment.
2. In the Order Products related list, confirm that each product exists on the Sales Agreement. For category-based agreements, ensure the Sales Agreement category is set as the Primary Category on the product.
3. If using the Automatically from orders through contracts mode, confirm that a Contract is linked to both the Sales Agreement and the Order, the Contract Start Date is on or after the Sales Agreement Start Date, and the Order Start Date is on or after the Contract Start Date.

Cause 3: Future schedules count set to 0

1. Edit the Sales Agreement and update Future Schedules to Include in Actuals Calculations (FutureActCalcSchedules) to a value greater than 0 that reflects the number of future schedules to include (for example, 12 for monthly schedules across one year).
2. Save the record and select Recalculate Actuals from the Sales Agreement.

Cause 4: Can't edit actuals because they are auto-calculated from Orders error

1. This behavior is expected when the Actuals Calculation Mode is set to Automatically from direct orders or Automatically from orders through contracts, where Actual Quantity is derived from the automated process and cannot be manually edited.
2. To allow manual updates, navigate to Setup > Sales Agreements and change the Default Actuals Calculation Mode to Manually using API upload, or update the Actuals Calculation Mode (ActualsCalculationMode) field on the Sales Agreement record. This requires Override Predefined Status Validations to be enabled in Setup > Sales Agreements.
3. Note that switching the calculation mode removes previously calculated actuals, and they are not retained.
4. Ensure users who need to update actuals manually are assigned the Edit Actual Quantity of Sales Agreements Products permission when using the manual mode.

Cause 5: Sales Agreement is in Expired status

1. Actuals on Expired Sales Agreements cannot be modified, even when Override Predefined Status Validations is enabled. Errors such as “You can't modify an Expired Sales Agreement” are expected behavior.
2. To update historical actuals, either revert the Status to Activated (if allowed by validations) or extend the End Date before recalculating actuals.

Now, click Recalculate Actuals from the Agreement Terms tab on the Sales Agreement and verify that the Actual Quantity and Actual Amount fields are populated correctly for the matching schedule period. Also confirm that the LastActualsCalculatedDate field reflects the latest run timestamp.