Router Master - Query

Finance and Operations/AX Developer Forum
1

Hi ,

I have requirement where Production planning depart asking entire Route Master as Report to Verify the Run time ,setup time ,to hours .

am been trying through SQL Query ,Am not able to Pull the Resource ID ,Tohours with out join prodroute.

Below is the format.

Itemid , Oprnum , Oprid, Nextoprnum,runtime ,setuptime, tohours , Resourcetype,resource

Kindly advise any Standard report or x++ code pull the Route master from AX 2012 R2 .

Thanks

Raj

2

raj, may I remind you that developement-related questions belong to the Developer forum and not the Technical forum?

Also, please attach the version as a tag, instead of prefixing the title with it.

3

Sorry Mr.Martin.

I will make a Note.