web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

How to Retrieve Active Route and Associated Route Operations for an Item in D365 F&O

(2) ShareShare
ReportReport
Posted on by 30
Hi everyone,
 
I’m working in Dynamics 365 Finance and Operations and need to programmatically retrieve the active route assigned to a released product (or item), along with the associated route operations.
 
Could someone please guide me on:
 
1. How to identify and retrieve the active route (i.e., the one currently used or approved for production)?
 
 
2. How to get the related Route Operations (such as operations number, resource requirement, times, etc.) linked to that active route?
 
If there are specific tables (like RouteTable, Route, RouteOpr, or others) or recommended APIs/X++ patterns to follow, I’d appreciate some direction or sample code.
 
In simple words, I want to write a function where I can pass itemid and in return I want to get active routeid and relevant operations.
 
Thanks in advance!
I have the same question (0)
  • Suggested answer
    udaY-ch Profile Picture
    5,106 on at
    How to Retrieve Active Route and Associated Route Operations for an Item in D365 F&O
    Hi
     
    An item can have multiple routes attached to it. At the time of production order creation, system will pick the active and most recent route by default and you can also select the route that you wanted to attach on the production order.
     
    When you are having multiple active and approved, you can select the most recent active one.
     
    Here is the table flow,
     
    RouteVersion -> RouteTable -> Route 
     
    Thanks
    Uday
     
    If you found this answer helpful, kindly mark it as verified so it can assist others facing similar issues.
  • MA-23041314-0 Profile Picture
    30 on at
    How to Retrieve Active Route and Associated Route Operations for an Item in D365 F&O
     
    Hi Uday,
     
    Thanks for your response and for outlining the table flow – that helps clarify the structure.
     
    However, I have a slightly different requirement. I want to add custom fields to the route at the item level (for example, fields that hold item-specific processing information). Then, when a production order is created and the route is attached, I want to pull those custom field values into the production order route operations.
     
    Thanks 
  • Suggested answer
    udaY-ch Profile Picture
    5,106 on at
    How to Retrieve Active Route and Associated Route Operations for an Item in D365 F&O
    Hi MA
     
    You have to extend Route and ProdRoute table for your custom fields.  Look how prodroute is populating while creating the production order
     
    Classes/Tables  to start with
     
    ProdRoute\initfromRoute
    ProdTabletype\updatecopying
    RouteCopyFromRoute
     
    Thanks
    Uday
     
    If you found this answer helpful, kindly mark it as verified so it can assist others facing similar issues.
  • MA-23041314-0 Profile Picture
    30 on at
    How to Retrieve Active Route and Associated Route Operations for an Item in D365 F&O
    Hi Uday,
     
    Thanks for the prompt response.
     
    Actually, I’m facing an issue. On the item-level routes, I understand that the main table which holds the route operations is Route and RouteVersion, I’ve added my custom fields to both Route and ProdRoute tables. However, the problem I’m encountering is that the system is not allowing me to save data into these custom fields at the item-level.
    I.e. I have added these fields in the grid, and fields 
    Datasource is ProdRoute and mapped with custom fields.
     
     
    What I’m trying to achieve is:
     
    1. First, I want to save the custom field data on the item-level route definition (before a production order is created).
     
     
    2. Later, when the production order is created and the route is copied, I want to fetch and populate those custom fields into the corresponding ProdRoute record.
     
     Technically speaking i have similar requirements 
     
    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,029

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 871 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 582 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans