Reviewing and Adjusting Gross Margin Percentages

The Gross Margin form shows the gross profit margin percentages for Items. For each Item, the form shows the Actual percentage margin for the previous and current year, along with the forecasted percentage margin for open periods. Use the form to set gross margin percentages for open Forecast periods. Enter Forecast margin percentages manually, or have them calculated based on the year-to-date (YTD) Actuals or Prior Year Actuals trends.

The margin percentages that you enter in this form are used to calculate the cost of goods sold (COGS) for Inventory Items.

To review or adjust the gross margin Forecast values by Item:

  1. From the Home page, click the Revenue and Gross Margin card.

  2. Click the 2 tab on the left.

  3. Click Trend Based Item Gross Margin.

  4. In the Point of View, choose a Version, Subsidiary, and Currency.

  5. Click the arrow in the cell where the relevant Item row intersects the Trend Gross Margin column.

    Select the trend to use. 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.

  6. For Items 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.

  7. For Items set to Manual, enter the margin percentages in the open Forecast periods.

  8. Click Save.

  9. To update top-level members with the adjusted data in input currency, right-click the data grid and select Aggregate to Income Statement.

  10. (Optional) To update the relevant financial statements in both input and reporting currencies:

    1. Go to the Home page, and then click the Rules card.

    2. Beside the ruleset NFS_All Accts Forecast Data Refresh, click the Launch arrow.

Related Topics

General Notices