Supply Chain › Demand Planning
Forecast Lines
One item, one place, one period. Five quantities, because the statistical number, what sales think, what marketing think, what was agreed and what happened are five different facts.
Where to find it
- Module: Supply Chain
- Group: Planning
- Section: Demand Planning
- Screen: Forecast Lines
Address in the console: /scm/demand-forecasts
List · 12 columns · 19 fields on its form · 4 of them required
What the list shows
These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.
| Column | Kind | Field name |
|---|---|---|
| Plan | Code | plan_no |
| Item | Code | item_no |
| Name | Text | item_name |
| Period | Code | period_code |
| History | Number | history_quantity |
| Statistical | Number | statistical_quantity |
| Consensus | Number | consensus_quantity |
| Planned | Number | planned_quantity |
| Actual | Number | actual_quantity |
| Error % | Number | ape_pct |
| Override % | Number | override_pct |
| Locked | Yes or no | is_locked |
The form
What is asked for when a record is created here. Required fields are marked; a choice drawn from a configuration list is one an administrator can extend without a release.
| Field | Type | Choices | Notes |
|---|---|---|---|
| Plan required | Choice | Looked up from existing records | |
| Item required | Choice | Looked up from existing records | |
| Warehouse | Choice | Looked up from existing records | |
| Customer | Choice | Looked up from existing records | |
| Period from required | Date | ||
| Period to required | Date | ||
| Period code | Text | ||
| Unit | Choice | Looked up from existing records | |
| Sales says | Number | ||
| Marketing says | Number | ||
| Agreed | Number | ||
| Final | Number | ||
| Unit price | Number | ||
| Currency | Choice | Configuration list | |
| Why it was overridden | Long text | An override with no reason is an override nobody can review. | |
| Promotional | Yes or no | ||
| Promotion reference | Text | ||
| New product | Yes or no | ||
| Locked against recalculation | Yes or no |
The rules that apply here
Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:
- Narrowing a list — search, conditions, sort, totals, export and saved views.
- What may be changed — the five grounds a record may not be edited on.
- Companies and business units — what the switcher above this list is doing to it.
- Creating a record — required fields, where choices come from, and how the number is allocated.
- Importing a spreadsheet — this screen accepts one, and it runs through the same rules as typing.