Loading
 Experience Cloud – Feature Degradation on Lightning Web Runtime SitesRead More
The Trailblazer Community is now read-only Read More
Data Processing Engine Template for Calculating Actuals in Sales Agreements

Data Processing Engine Template for Calculating Actuals in Sales Agreements

Use the data processing engine template for Sales Agreements to calculate the actual revenue and quantity for sales agreements based on the sales data that's stored in order records, transaction journal records, or custom object records. Clone and use the template as is, or customize it to suit your unique needs.

Required Editions

Available in: Lightning Experience
Available in: Enterprise, Unlimited, and Developer Editions

The data processing engine job for calculating actuals is called Calculate Actual Metrics for Products. Use this definition to transform data from multiple data sources. Extend the calculation logic in the data processing engine to include custom fields or modify the calculation logic based on your business requirements.

Each Data Processing Engine run recalculates actuals from the current active orders, so re-running it is safe and produces consistent results. If you need custom calculation logic, you can modify the Data Processing Engine definition to fit your requirements.

Note
Note When calculating actual revenue and quantity for a sales agreement with a large volume of records (e.g., more than [approximate number]), we recommend extending the calculation logic in the Data Processing Engine by adding a custom numeric field to the Sales Agreement Product Schedule object and configuring a formula node to rank records by SAPSId before the writeback node.
 
Loading
Salesforce Help | Article