Skip to main content

Posts

Showing posts with the label How to join or link RouteVersion table with ProdRoute table?

Relation between RouteVersion and ProdRoute in Axapta or D365Fno

 What is  link RouteVersion table with ProdRoute table? Answer: a route is made of up the tables RouteTable  and Route .  Additional data (like process time, etc.) is stored in table RouteOpr in rule form. There is not direct relation between  RouteVersion table with ProdRoute table because prodroute table used in route form as temperary table so you can get data in RouteOpr data using item id not any other record reference.   Then RouteVersion is used to associate a RouteTable record with an InventTable record, or a released product, using ItemId as the relationship.  single route can be associated with multiple released products.    I hope it will help you to save lot of time if you are technical. Thanks in advance.