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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :

Rev2 of importing production routes in D365FO

Rahul Mohta Profile Picture Rahul Mohta 21,042

Rev2 of importing production routes in D365FO

Sequence priority

Information

Data entity

Table

Additional criteria

1

Resource groups

Resource groups

WrkCtrTable

all

2

Resource groups

Resource group calendar assignments

 

all

3

Operations

Operations

RouteOprTable

all

4

Resources

Operations resource

WrkCtrTable

all

5

Resources

Resource group membership

 

    • All
    • Disable at data entity level -  business validations

6

Resources

Resource calendar assignments

 

all

7

Route table

Route headers

RouteTable

Route number

8

Route versions

Route versions

RouteVersion

Route number

9

Route details

Route operations V2

Route

Route number

10

Route details

Route operation properties V2

RouteOpr

    • Route Relation and then manually make it for all routes as default for operation (delete all from table routeopr and then import for clean)

11

Resource requirement

Resource requirements for route operation properties

 

    • Disable at data entity level -  business validations
    • Route Relation empty if applicable for all
    • Export RouteOprTable, RouteOpr,  WrkCtrActivityRequirementSet WRKCTRACTIVITYREQUIREMENT to get recid 
      • Normalization
    • Key = Operation ID and Site ID

Comments

*This post is locked for comments

  • Sandip Shah Profile Picture Sandip Shah 5
    Posted at
    Hi Rahul Mohta and Paul Rogers - I am getting this error when using "Resource requirements for route operation properties" - the error is "You can only specify one requirement of type Resource group. validateWrite failed on data source 'WrkCtrActivityResourceGroupRequirement (WrkCtrActivityResourceGroupRequirement)". I do not understand some of what is mentioned in step 11. above. Would appreciate some guidance I can do with.
  • Paul Rogers Profile Picture Paul Rogers
    Posted at
    Hi Rahul, We were able to get step 11 to load without having to disable business validations, like you first suggested in 2019. It looks like there have been a few bug fixes done by Microsoft since your post that no longer require this or other steps
  • Paul Rogers Profile Picture Paul Rogers
    Posted at
    thanks Rahul, this is very useful. Glad I am not the only one with users on "Resource requirements for route operation properties" .... Your additional criteria for row 11 is very helpful