AdvAccountForecastSet Metadata Type in SFDX

Architectural Overview#

Advanced Account Forecasting (AAF) powers multi-horizon demand and revenue planning across Manufacturing Cloud, Consumer Goods Cloud, and Enterprise Sales. The AdvAccountForecastSet metadata type is the core configuration blueprint that binds together your forecast periodicity, custom fact tables, dimensions (such as Product, Region, or Ship-To Location), measures, adjustment rules, and Data Processing Engine (DPE) calculation definitions.

For enterprise architects, treating AdvAccountForecastSet as version-controlled source code prevents formula drift and ensures that DPE regeneration jobs and rolling forecast rollups behave identically in UAT and production.

SFDX Directory & File Suffix#

Key Metadata Fields#

Declarative XML & package.xml Examples#

Sample .advAccountForecastSet-meta.xml#

<?xml version="1.0" encoding="UTF-8"?>
<AdvAccountForecastSet xmlns="http://soap.sforce.com/2006/04/metadata">
    <calculationFrequency>Monthly</calculationFrequency>
    <description>Rolling 12-month OEM account revenue and quantity forecast set.</description>
    <forecastFactObjectName>AdvAcctForecastFact</forecastFactObjectName>
    <generationDpeDefName>Generate_OEM_Account_Forecast</generationDpeDefName>
    <masterLabel>Global OEM Revenue Forecast</masterLabel>
    <recalculationDpeDefName>Recalculate_OEM_Account_Forecast</recalculationDpeDefName>
    <rolloverDpeDefName>Rollover_OEM_Account_Forecast</rolloverDpeDefName>
    <rolloverFrequency>Monthly</rolloverFrequency>
    <status>Active</status>
</AdvAccountForecastSet>

Sample package.xml Manifest#

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
    <types>
        <members>Global_OEM_Revenue_Forecast</members>
        <name>AdvAccountForecastSet</name>
    </types>
    <version>68.0</version>
</Package>

SOQL Query & SFDX CLI Commands#

Inspect Active Forecast Sets via SOQL#

SELECT Id, DeveloperName, MasterLabel, Status, CalculationFrequency,
       RolloverFrequency, ForecastFactObjectName
FROM AdvAccountForecastSet
WHERE Status = 'Active'
ORDER BY MasterLabel ASC

Retrieve and Deploy via Salesforce CLI#

# Retrieve all Advanced Account Forecast Sets
sf project retrieve start --metadata "AdvAccountForecastSet:*"

# Deploy a specific forecast set
sf project deploy start --metadata "AdvAccountForecastSet:Global_OEM_Revenue_Forecast"

Senior Architect Best Practices & Gotchas#

• Deploy DPE Definitions First or Together: An AdvAccountForecastSet references BatchCalcJobDefinition (Data Processing Engine) records for generation, recalculation, and rollover. Ensure those DPE definitions are activated before deploying the forecast set with <status>Active</status>.
• Custom Fact Table Indexing: When using a custom CustomObject as your forecastFactObjectName, mark key dimension lookup fields as External IDs or request custom indexes from Salesforce Support to avoid DPE job timeouts on multi-million-row fact tables.

Frequently asked questions

What is AdvAccountForecastSet used for in Salesforce?

It defines the configuration for Advanced Account Forecasting, specifying forecast horizons, periodicity, dimensions, measures, and Data Processing Engine jobs.

Where are AdvAccountForecastSet files located in SFDX?

They are stored in the force-app/main/default/advAccountForecastSets directory with the .advAccountForecastSet-meta.xml file suffix.

What dependencies must exist before deploying AdvAccountForecastSet?

The referenced PeriodGroup, Data Processing Engine BatchCalcJobDefinition, custom fact objects, and forecast dimensions must exist in the target org before deployment.

Can I query AdvAccountForecastSet records using SOQL?

Yes, you can query the AdvAccountForecastSet standard object in SOQL or Tooling API to inspect Status, CalculationFrequency, and linked DPE job IDs.