you can try master scheduling, this can be the forecast maintenance.

Hi Ron,

we developed a BI solution and combined CustomerInvoiceLines (CIL) and CustomerOrderLines(COL)
(and 8 other “data layers”) into a major FACT_Sales table.
The COL are filtered to “not yet invoiced”.
From this COL-“layer” we created a field called “ExpectedInvoice” and a field “ExpectedInvoiceDate”.
There is some logic in both fields but the main idea is:
Look into COL and ask: When do they probably get invoiced?

Imagine a “hard fact” TurnOver Line the weeks until yesterday (we fetch data every night)
and a “soft fact” ExpectedTurnOverLine beginning with today and reaching out into the near future.

The same with OrderQuotationLines (OQL), one of the mentioned “data layer” in the FACT_Sales.
Even BusinessOportunities (BO) are integrated but not yet “lined up” to ExpectedTurnover.

Very interesting stuff you are talking about!

We are working on a solution called RoFo - Rolling Forecast especially for individual production
(all companies using IFS project management and/or service management)

All the best

Michael