| Change Log | Date |
|---|---|
Object Overview and Relationships
Description:
The Product Forecast object is designed to hold forecasted financial, volumetric, and probability-weighted metrics for specific products associated with opportunities. This object facilitates forecasting and revenue prediction by allowing users to aggregate data at the product-opportunity level and analyze it across various financial and time-based dimensions.
Related Objects:
Opportunity: The Product Forecast object is associated with the Opportunity object via a Master-Detail relationship. This enables consolidated reporting and tracking of forecasted metrics across different opportunities.
Product: There is a Lookup relationship with the Product object, tying each forecast to a product. This supports detailed product-level forecasting and analysis.
Opportunity Realized Sales Year: While not directly referenced, historical data from Opportunity Realized Sales Year can inform or validate forecasts, providing a comparison of past actuals versus forecasted metrics.
Fields
| Field Label | API Name | Data Type | Description |
| CM Calculation Method | SLV_CM_Calculation_Method__c | Picklist | Method used to calculate the contribution margin, allowing flexibility in forecasting calculations based on different pricing or cost models. |
| Contribution Margin (%) | SLV_Contribution_Margin__c | Percent (3, 2) | The profit margin percentage after deducting variable costs, indicating profitability on a percentage basis. |
| Contribution Margin (Amount) | SLV7_PF_Contribution_Margin_Tot_Amount__c | Formula (Currency) | Total contribution margin amount, representing profit in currency value. |
| Contribution Margin (Amount) in EUR | FX_Contribution_Margin_Amount_EUR__c | Formula (Number) | Contribution margin amount in EUR, allowing for profitability comparison across regions. |
| Contribution Margin (Amount) Old | SLV_Contribution_Margin_Amount__c | Currency (16, 2) | Previously used contribution margin amount, retained for historical reference or calculations. |
| Contribution Margin (Amount) per UoM | SLV7_PF_Contribution_Margin_Amount_UoM__c | Currency (16, 2) | Contribution margin per unit of measure, useful for assessing profitability on a per-unit basis. |
| Contribution Margin (Amount) per UoM EUR | FX_Contribution_Margin_Amount_UoM_EUR__c | Number (16, 2) | Per-unit contribution margin in EUR, standardizing profitability analysis. |
| Created By | CreatedById | Lookup (User) | User who created the forecast record, used for audit and tracking purposes. |
| Currency | CurrencyIsoCode | Picklist | The currency code associated with this forecast, ensuring consistent financial reporting. |
| Forecast Yearly Revenue in Euro | SLV11_Revenue_Euro__c | Formula (Number) | Projected revenue for the forecasted year, expressed in EUR. |
| Forecasted Yearly Revenue | SLV_Revenue__c | Formula (Currency) | Forecasted annual revenue for this product, calculated in the object’s primary currency. |
| Forecasted Yearly Revenue in EUR | FX_Revenue_EUR__c | Formula (Number) | Forecasted yearly revenue in EUR for multi-currency analysis. |
| Last Commercial Roadmap Update | SLV3_Last_Commercial_Roadmap_Update__c | Date/Time | Timestamp of the last roadmap update, useful for tracking recent forecast adjustments. |
| Last Modified By | LastModifiedById | Lookup (User) | User who last modified the forecast, allowing change tracking and accountability. |
| Opp Probability | Opp_Probability__c | Formula (Percent) | Probability percentage of the associated opportunity’s closure, influencing revenue forecasts. |
| Opportunity | SLV_Opportunity__c | Master-Detail (Opportunity) | Link to the Opportunity object, tying the forecast data to specific sales opportunities. |
| Opportunity Product ID | SLV_Opportunity_Product_Id__c | Text (18) | Unique identifier linking the forecast to a specific product in the opportunity, providing line-item level forecast data. |
| Pivot Volume in T | SLV5_Pivot_volume_in_T__c | Formula (Number) | Alternative measurement for volume, possibly used for specific product forecasts, measured in tons. |
| Price | SLV_Price__c | Currency (16, 2) | Unit price of the product, aiding in revenue and profitability calculations. |
| Price in EUR | FX_Price_EUR__c | Number (16, 2) | Price in EUR, enabling standardized price analysis across different currencies. |
| Probability Weighted Revenue | Probability_Weighted_Amount__c | Formula (Currency) | Revenue forecast adjusted by opportunity probability, indicating expected revenue based on win likelihood. |
| Probability Weighted Revenue in EUR | FX_Probability_Weighted_Amount_EUR__c | Formula (Number) | Probability-weighted revenue in EUR, standardizing expected revenue reporting. |
| Probability Weighted Volume | SLV5_1_PF_Probability_Weighted_Volume__c | Formula (Number) | Expected volume adjusted by opportunity probability. |
| Probability Weighted Volume in T | SLV29_PF_Probability_Weighted_Volume_T__c | Formula (Number) | Probability-adjusted volume in tons, supporting specific product forecasts. |
| Product | SLV_Product__c | Lookup (Product) | Link to the Product object, associating forecast data with individual products. |
| Product Name | Product_Name__c | Formula (Text) | Name of the product, for quick reference in reports and dashboards. |
| S.No | Name | Auto Number | Auto-generated unique identifier for each forecast record. |
| SLV7 Warning Indicator | SLV7_Warning_Indicator__c | Formula (Number) | Indicator field, potentially used to highlight forecasts that require review or have significant risk. |
| UnicValueByYear | SLV4_UnicValueByYear__c | Text (25) (External ID) | Unique external ID combining year and other factors, ensuring each forecast record is uniquely identifiable. |
| Unit of Measure | SLV5_PF_Unit_of_Measure__c | Picklist | Specifies the unit in which the product volume is measured, standardizing forecast data across products. |
| Visibility | SLV_Visibility__c | Picklist | Controls visibility settings for the forecast, allowing customization for different user groups. |
| Volume | SLV_Volume__c | Number (16, 2) | Forecasted quantity of the product expected to be sold, essential for production and inventory planning. |
| Year | SLV_Year__c | Picklist | Specifies the year for which the forecast is relevant, useful for annual segmentation. |
| Year Formula | Year_Formula__c | Formula (Text) | A formula field that calculates the year based on other date fields, ensuring alignment with forecast ye |
Automation
Flow Name: Create Product Forecasts
Purpose:
This flow creates a forecast record for each Opportunity Line Item added to an opportunity, ensuring that forecasts are generated and updated based on specific business rules.
Trigger
- Type: Record-Triggered Flow
- Event: Triggered each time an Opportunity Product record is created.
- Entry Conditions: None – the flow runs for all Opportunity Products and executes immediately.
Logic and Flow Steps
Retrieve Existing Forecasts
- The flow first checks if any forecast records already exist for the Opportunity.
- It retrieves records from Product Forecast where:
- SLV_Product__c equals
$Record > Product ID - SLV_Opportunity__c equals
$Record > Opportunity ID
- SLV_Product__c equals
Check for Existing Forecasts
- Decision: If forecast records exist, the flow ends.
- If No Forecasts Exist: The flow proceeds to a counter-based decision to manage forecast creation.
Counter Logic and Forecast Creation
Counter Check (Counter < 5):
- If fewer than 5 forecasts exist, the flow:
- Assigns values to all relevant fields in the forecast record.
- Sets the Year field to:
- If fewer than 5 forecasts exist, the flow:
TEXT(YEAR(DATEVALUE(DATETIMEVALUE({!SLV7_OPP_Targeted_first_delivery_date}))) + {!counter}) |
Counter Check (Counter ≥ 5):
- When the counter reaches 5, it stops assigning values and creates the forecast records with the previously assigned field values.
Field Assignments (Set Values)
- The following fields are populated from the Opportunity Line Item to the Forecast record:
- Currency ISO Code
- Opportunity
- Unit of Measure
- Opportunity Product ID
- Product
- CM Calculation Method
- Volume
- Price
- Contribution Margin (Amount) per UoM
- Contribution Margin
- Year
- The following fields are populated from the Opportunity Line Item to the Forecast record:
|
