Reviewing and Adjusting Gross Margin Percentages
The Gross Margin form displays the gross profit margin percentages of Items. For each Item, the form displays the Actual percentage margin for the previous and current year, along with the forecasted percentage margin for open periods. You can use the form to set the gross margin percentages for open Forecast periods. You can enter Forecast margin percentages manually or have the percentages calculated based on the year-to-date (YTD) Actuals or Prior Year Actuals trends.
The margin percentages you enter on this form are used to calculate the Cost of Goods Sold for Inventory Items.
To review or adjust a gross margin Forecast values by Item:
-
From the Home page, click the Revenue and Gross Margin card.
-
Click the 2 tab on the left-hand side.
-
Click Trend Based Item Gross Margin.
-
In the Point of View, select a Version, Subsidiary, and Currency.
-
To apply the changes, click the Go icon
. -
Click the arrow in the cell that intersects the relevant Item row and the Trend Gross Margin column.
Select the trend to use. Alternatively, select Manual to manually enter Forecast values.
Note:You can only enter Forecast values where the trend is set to Manual or is blank. If you select a trend based on historical data, the Forecast values automatically populate based on that selected trend.
-
For Items 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.
-
For Items set to Manual, in the open Forecast periods, enter the margin percentages.
-
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:
-
Go to the Home page and click the Rules card.
-
Beside the ruleset NFS_All Accts Forecast Data Refresh, click the Launch arrow.
-