You are here:
Workflow of the Actuals Calculation Prebuilt App
Review the high-level workflow of the Actuals Calculation Using Data Processing Engine prebuilt app.
Required Editions
| Available in: Enterprise, Unlimited, and Developer Editions. |
Sales Agreements and Orders
When you create a sales agreement, make sure the following values are specified so that the Data Processing Engine considers them for calculation.
- Actuals Calculation Mode: Manually via API Upload
- Calculate actuals based on DPE is selected
Create orders and specify the effective start date because the actual quantity and actual revenue get reflected for the Sales Agreement Product Schedule which coincides with the order effective date. For example, if an order’s effective start date is May 16, the actual quantity and revenue is updated for the May period of a monthly sales agreement.
Data Processing Engine
The Calculate Actual Product Quantity and Revenue Data Processing Engine (DPE) template identifies valid orders and sales agreements, applies filters,and joins fields from multiple data source objects to calculate actual revenue and actual quantity for sales agreements. The sales agreements can be at a product level or at a category level, but they must be active. Clone the template and activate the definition to either run it from the builder or via a flow.
If you don’t use the Order object to derive actual quantities and revenues, make sure you customize all nodes in the definition to redirect the logic to the relevant data source.
Specify values for the following input variables before you run the definition:
- Sales Agreement: Enter All, or a specific sales agreement record ID, or a comma-separated list of record IDs
- Start Period: Enter zero to only calculate actuals for the current period. To calculate from a past period, enter a negative number. For example, to calculate from two months in the past, enter -2.
- End Period: Enter zero to only calculate actuals for the current period. To calculate until a future period, enter a positive number. For example, to calculate till two months in the future, enter 2.
- Order Status: Enter the status code name for orders depending on what you want to consider for the calculation. For example, enter Draft, Activated to consider draft and active orders in calculation.
Scheduled Flow
To automate the actuals calculation at regular intervals, run the Data Processing Engine via a scheduled flow. The Run Scheduled DPE Job to Calculate Actuals for Sales Agreements scheduled flow runs daily and by default it calculates actuals for the current period. But you can clone the flow template to create your own version and change the start and end date inputs to calculate actuals for multiple periods. This flow also requires an active DPE definition created from the Calculate Actual Product Quantity and Revenue template.
The scheduled flow sends an email to the flow user for the following scenarios:
- When an error occurred while executing the Data Processing Engine batch job
- When the details of a timed-out Data Processing Engine batch job are sent
- When the details of a timed-out Data Processing Engine can’t be found
- When the details of a Data Processing Engine batch job that changes status are sent
- When the details of a Data Processing Engine batch job that changes status can’t be found
