Skip to main content

Excluding Invoices or Invoice Transactions From Forecast Data

Distributor steps for excluding special-event invoices or invoice lines from sales forecast data on the Exclude Invoices from Forecast dashboard in Encompass, and undoing it. Requires v23.10+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 23.10

Steps

If special order invoices are skewing your forecasted sales data, and you just want the sales from those invoice out of forecast data, this feature is for you! Special event invoices might include sales for fairs and rodeos, concerts, or even displays promotions.

How to exclude an invoice transaction or an entire invoice from forecasts:

  1. Go to the Exclude Invoices from Forecast Dashboard
    ​
    ​

  2. Apply any filters including Route, Customer, Invoice Num, Product, and Date Range
    ​
    ​

  3. Check the box next to any transaction that is to be excluded from forecasts
    ​
    ​

  4. Check the box next to any invoice to exclude the entire invoice from forecasts
    ​
    ​

  5. Click Save Changes
    ​
    ​

How to Exclude from the Forecasting Dashboard:

  1. Click on a link for any sales values for Sales, Backorders, or Backfills
    ​
    ​

  2. This will open the Forecast Sales Report Drilldown fusion report in a new tab
    ​
    ​

  3. Click on the Exclude link in the report, this will open the Exclude Invoices from Forecasts Dashboard
    ​
    ​

  4. Follow steps 3 - 5 above.


How to "undo" an invoice transaction or entire invoice that has previously been excluded from forecasts:

  1. Go to the Exclude Invoices from Forecast Dashboard
    ​
    ​

  2. Filter on the Invoice Num, Product, or Date Range
    ​
    ​

  3. Un-check the box next to the transaction or invoice
    ​
    ​

  4. Click Save Changes


How to see changes in Forcasting:

  1. In the Forecast dashboard, click the Refresh Data button to see updated sales forecasts after invoice data has bee excluded.
    ​
    ​

  2. These changes will not be reflected immediately and will require the data warehouse to sync, which runs every 15 minutes.

Did this answer your question?