"child routing is inactive"

Question

In Sage 500 2014 - I have a routing that error on creating a work order. The error is "child routing is inactive" Does anyone know how to locate the child routing that is no active via a report or explorer. I have tried to check all the items on the BOM for routing active. There does not appear to be an inactive child within for this routing.

RussG · Accepted Answer

From the user interface you can run the BOM Where Used Report and have it return any Inactive Routings. (Run the report where "Active is equal to No". 
 If you have access to the database to run a query, the following will provide you with the list of Child Routings that are inactive and any Parent Routing that they are associated with. 
 select ChildRouting.RoutingId as 'ChildRoutingID', 
 ChildRouting.VersionId as 'ChildVersion', 
 ChildRouting.Active as 'ChildActive', 
 ParentRouting.RoutingId as 'ParentRoutingID', 
 ParentRouting.versionid as 'ParentVersion' 
 from tmfRoutDetl_HAI ParentDetail with (nolock) 
 join tmfRoutHead_HAI ParentRouting with (nolock) 
 on ParentDetail.RoutingKey = ParentRouting.RoutingKey 
 join tmfRoutHead_HAI ChildRouting with (nolock) 
 on ChildRouting.RoutingKey = ParentDetail.MatRoutKey 
 WHERE ChildRouting.Active = 0

jbrwn2 · Answer

Thanks for you feedback.

Sage 500

"child routing is inactive"

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING