Entering or Generating Sales Forecasts for Revenue by Item

The Revenue by Item form shows Revenue data by Customer hierarchy for all Revenue Account and Item members. Actuals appear next to Forecast values so that you can compare end-of-year and future-year projections side-by-side.

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

Items that have previously been purchased by the selected Customer, or for which a Forecast has already been entered, are shown. You can also add additional Item rows for existing Items.

To enter sales Forecasts or have sales Forecasts generated by Item:

From the Home page, click the Revenue and Gross Margin card.
To go to the Trend Based Revenue forms, click the 1 tab on the left-hand side.
Click Revenue by Item.
In the Point of View, select a Version, Item Type, Subsidiary, Currency, Class, and Relationship.
To apply the changes, click the Go icon .

The Revenue General Ledger Account members appear in the first column. Items in the selected Item Type appear in the second column.
Click the arrow in the cell that intersects the relevant Item row and the Trend Revenue column.

Select the trend to use based on historical data. Alternatively, select Manual to manually enter Forecast values.

Note:
You can only enter Forecast values if you set the trend to Manual or if the trend is blank. If you select a trend based on historical data, the Forecast values automatically populate based on that selected trend.
For Item members set to a trend, 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.
For Item members set to Manual, enter the Forecast values for each Forecast period. Alternatively, in the Total column, enter the total Forecast value for the Forecast 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.
(Optional) To apply a value or percentage increase or decrease on an existing total:
1. Right-click the cell (data area) in the Total column for an Account, and then select Adjust > Adjust Data. You may need to use the horizontal scroll bar to see the Total column.
2. The Adjust Data popup window appears. In the Adjust By field, enter a value or percentage, and select either the Value icon or the Percentage icon .
3. Click Apply.
(Optional) To view detailed Revenue information for a specific Account, right-click an item row and select Drill to Account Details.
(Optional) To quickly go to the Revenue by Customer form to enter the Item Forecast by Customer, right-click an Item and select Revenue by Customer.

The Revenue by Customer form opens in a new tab within the application and shows the Forecast for the Item that you selected.
Click Save.
To populate top-level members with the adjusted data in input currency, right-click the data grid and select Aggregate to Income Statement.
(Optional) To have your changes reflected in the relevant financial statements in the input and reporting currencies:
1. Go to the Home page and click the Rules card.
2. Beside the ruleset NFS_All Accts Forecast Data Refresh, click the Launch arrow.

Additionally, you can add new Item rows to an Account to enter Forecast values for an existing Item. For more information, see Adding New Rows for an Existing Item to the Forecast.

Adding New Rows for an Existing Item to the Forecast

You can add to the Forecast existing Items that are not listed on the form. To enter Forecast values for an existing Item that is not currently listed in the Forecast, add a new Item row to an Account.

To add a new row for an existing Item:

In the first column, right-click the Account that you want to add a new Item row to and select Update Existing Item.

The page refreshes and the form shows new Item rows for you to populate.
Next to the relevant Account, click the arrow in the same cell that contains the o---------Select Item---------> text.
In the Search field, enter the Item name. Alternatively, scroll down the list and select the Item from the list.

The application adds the Customer to the selected Account.
Enter the Forecast values for the selected Item.
Click Save.

To enter sales Forecasts or have sales Forecasts generated by Item:

Adding New Rows for an Existing Item to the Forecast

To add a new row for an existing Item:

Related Topics