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 show 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 them 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 the selected Customer has already purchased, or that already have a Forecast, are shown. You can also add more 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 open Trend Based Revenue forms, click the 1 tab on the left.
-
Click Revenue by Item.
-
In the Point of View, select a Version, Item Type, Subsidiary, Currency, Class, and Relationship.
-
The Revenue General Ledger Account members show in the first column. The Items in the selected Item Type show in the second column.
-
Click the arrow in the cell where the relevant Item row intersects the Trend Revenue column.
Select the trend to use based on historical data. Or, select Manual to manually enter Forecast values.
Note:You can only enter Forecast values if you set trend to Manual or if the trend is blank. If you select a trend based on historical data, the Forecast values fill in automatically based on that selected trend.
-
For Item members set to a trend, in the Adj (%) column, enter the percentage change 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 for an Item set to Manual, the adjustment won't be applied.
-
For Item members set to Manual, enter the Forecast values for each Forecast period. Or, in the Total column, enter the total Forecast value.
Note:If there are no previous values in the data grid for the Item row, the total spreads evenly over the periods. If previous values exist, the total spreads proportionally.
-
(Optional) To apply a value or percentage change on an existing total:
-
Right-click the cell in the Total column for an Account, and then select Adjust > Adjust Data. You might need to use the horizontal scroll bar to see the Total column.
-
The Adjust Data window opens. In the Adjust By field, enter a value or percentage, and select either the Value icon
or the Percentage icon
.
-
Click Apply.
-
-
(Optional) To see detailed Revenue information for a specific Account, right-click an item row and select Drill to Account Details.
-
(Optional) To 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 and shows the Forecast for the Item that you selected.
-
Click Save.
-
To update top-level members with the adjusted data in input currency, right-click the data grid and select Aggregate to Income Statement.
-
(Optional) To update the relevant financial statements in both input and reporting currencies:
-
Go to the Home page and click the Rules card.
-
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.
Adding New Rows for an Existing Item
If an existing Item isn’t shown on the Forecast form, you can add it. This lets you enter Forecast values for that Item. To add the Item, add a new Item row under the relevant Account.
To add a new row for an existing Item:
-
In the first column, right-click the Account where you want to add a new Item row and select Update Existing Item.
The page refreshes, and the form shows new Item rows for you to fill in.
-
Next to the relevant Account, click the arrow in the cell with the o---------Select Item---------> text.
-
In the Search field, enter the Item name. Or, scroll down and select the Item from the list.
The application adds the Customer to the Account you selected.
-
Enter the Forecast values for the Item.
-
Click Save.