The "DARP Summary for Work Order based Service capabilities" states that IFS is planning to deprecate the Work Order (WO) based Service Management processes and capabilities by November 2027.
I would like to check if Service Contracts (Work Order based) exist. Could you please provide the SQL statement to extract the relevant entries?
The version is IFS Cloud 24R1.
Extraction of the Service Contracts (Work Order based)
Best answer by AveTonitM
If there is a record in the Services tab on the Service Contract page, can we assume that this Service Contract is a Service Contract (Work Order based)?

For your question regarding identifying Service Contracts (WO based) and Request Contracts (Request Based). The database view SC_SERVICE_CONTRACT has a column named “SOURCE_TYPE”. The possible values in this column are either “Service” or “Request”. If the value is “Service” then the row is related to Work Orders.
Regarding the broader migration question — the DARP document advises customers and partners to "engage with IFS or an IFS partner to understand available migration paths, best practices, and timelines." However, as an IFS partner managing multiple customer environments, I have not been able to identify a concrete channel to get this guidance.
- Who is the designated IFS contact (role or team) that IFS partners should engage to get migration path guidance for existing customers moving from Work Order based service to Request Management/NGSM?
- Is there a partner-facing migration guide or best practice document available today, or is this still being prepared?
- What is the expected timeline for IFS to publish formal migration tooling, documentation, or a transition framework ahead of the 27R2 removal?
With 27R1 being the last supported release and customers needing to plan now, we need a clear answer on where to direct migration planning conversations. Appreciate your help in pointing us to the right resource.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.