Sending your Sales Forecast to the Financial Budget

This functionality allows you to bring your sales forecast values into the budget.

Note  

  • Make sure that the Sales accounts have been excluded from your budget when you generated it.

  • If you are forecasting by Quantities, make sure to have assigned a Price List to your forecast.

  1. In the Data Models and Views tab, expand the folders Universal Data Model > Financial Budgeting and Sales Forecast > Sales Forecast to Financial Budget.
  2. Right-click the Load to Account Configuration data model and select View Info Pages.

  3. Create a new configuration:

    1. In the Config Name field, enter a new name.

    2. Click Create for SQL Server or Oracle.

  4. Map the account you want to load:

    1. Expand the Load to Account Configuration data model and open the Account Mapping worksheet.

    2. Assign the account to load to in the Account ID column. If your ERP has a subaccount that is not included in the account code, such as Acumatica, specify the subaccount code in the Subaccount ID column as well. (For example, the account code is 40000 but the subaccount code is CAN-000.)

      Otherwise, leave the Subaccount ID column empty. You can also put your account ID in the Subaccount ID column, which is often used to retrieve the account segments.

  5. Restrict the data to which this configuration has access, similarly to the Forecast and Budget configuration:

    1. Expand the Data Restriction data model and open the Data Restriction worksheet.

    2. Enter the appropriate values in the Include and Exclude columns.

    Tip

    To restrict your data more easily, you can use special syntax to select more than one value at a time:

    • * is an infinite wild card;

    • ? is a single wild card;

    • : defines a range.

      Note:  The range is applied by characters strings so even strings that are more than 5 characters long will be included, such as 4567890.

  6. Map the fields in Sales into the budget:

    1. Expand the Dimension Mapping data model and open the Dimension Mapping worksheet.

    2. Enter the appropriate value in the SO column for the dimension. If your UDM Finance cube uses Customer Statistical Group 1 as Dimension 01, you might want to map it to that dimension to have the same level of details.

    Note:  The dimension mapping is shared with all configurations.

  7. Load the sales forecast to the budget:

    1. Right-click the Info Page: Load to Budget data model and select View Info Pages.

    2. In the Forecast Name field, enter or select the Sales forecast.

    3. In the Forecast Revision Number field, enter or select the appropriate number.

    4. In the Year field, enter or select the year that is shared by both the forecast and the budget.

    5. In the Budget Name field, enter or select the budget.

    6. In the Budget Revision Number field, enter or select the appropriate number.

    7. In the Loading Config field, select the configuration you created in Step 3.

    8. Click Load for SQL Server or Oracle. This will delete the previously loaded forecast with this configuration and reload the forecast into the budget.

  8. Repeat these steps (except Step 6) if you need to load sales into different accounts (for example, Canada Sales into one account, USA Sales into another account, etc.).