Entering or Generating Sales Budget for Revenue by Item

The Revenue by Item Budget form shows revenue data by Customer hierarchy for all revenue Account and Item members. The form lists Items for which a Budget has already been entered.

Use this form to enter sales Budgets or have sales Budgets generated based on trends for Items for the selected Customer and Class. You can work with an individual Customer Budget or review the total revenue Budget for all Customers by the selected Class and Subsidiary.

To enter sales Budgets or have sales Budget generated by Item:

  1. From the Home page, click the Budget card.

  2. Click the 2 tab on the left-hand side.

  3. Click Revenue by Item.

  4. In the Point of View (POV), select a Scenario, Version, Item Type, Subsidiary, Currency, Class, and Relationship.

    Note:

    To enter Budget values or make adjustments in this form, you must set your POV to level 0 members.

    If you use Forms 1.0, click the Go icon Screenshot of the Go icon to apply the changes to the POV.

  5. Click the arrow in the cell that intersects the relevant Item row and the Trend Revenue Budget column.

    Select Prior Yr Forecast. Alternatively, select Manual to manually enter Budget values.

    Note:

    You can only enter Budget values only if you set the trend to Manual or if the trend is blank.

  6. For Item members set to Prior Yr Forecast, in the Adj (%) column, enter the percentage increase or decrease as a decimal value. For example, enter 0.01 for a 1% increase or -0.01 for a 1% decrease.

    Warning:

    In the Adj (%) column, if you enter a percentage value for an Item set to Manual, the adjustment will not be applied.

  7. For Item members set to Manual, enter the Budget values for each Budget period. Alternatively, in the Total column, enter the total Budget value for the Budget periods.

    Note:

    If there are no previous values in the data grid for the Item row, the total spreads back over the periods evenly. If previous values exist in the data grid for the Item row, the total spreads back over the periods proportionally.

  8. Click Save.

  9. To populate top-level members with the adjusted data in input currency, right-click the data grid, and then select Agg to Income Statement Budget.

General Notices