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!