Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Attach Route Operation...
Finance | Project Operations, Human Resources, ...
Answered

Attach Route Operations with specific Resource AX2012

(0) ShareShare
ReportReport
Posted on by CBNestor 44

Hi All,

I want to set a 1-to-1 relation between an operation and a resource.

So every time a new route line for an item and/or production is added and I select an operation this operation will automatically set the related resource requirement.

this is what I tried to do:

Create an item code : All and set up the Resource requirement from there. but an error popsup after selecting the Resource (tip: the resources and operations have the same name)

pastedimage1619181658765v1.pngpastedimage1619181742228v2.png

Do you know what is going on? and how can I manage to set this up?

may thanks beforehand!

  • Suggested answer
    CBNestor Profile Picture
    CBNestor 44 on at
    RE: Attach Route Operations with specific Resource AX2012

    Hi André,

    After looking all tables related to RouteOpr I found out as you said some reference where missing.

    so I deleted all records with Item = "ALL" and Route= "ALL" and created back again by hand.

    So the references where populated from new a fresh by AX.

    now the operations are related 1-to-1 to the Resource  automatically as it should :)

    thanks for the help!

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,280 Super User 2025 Season 1 on at
    RE: Attach Route Operations with specific Resource AX2012

    Hi Nestor,

    The error might come due to missing related records. If you check the coding, it will try to get the company ID from some tables and if this is empty or part of a virtual company, this error is thrown. In your scenario, the company ID might be missing due to missing records.

    I would suggest to check if you need to copy data from the next tables as well:

    WrkCtrPCRouteOperationActivity

    WrkCtrProdRouteActivity

    WrkCtrProjForecastEmplActivity

    WrkCtrRouteOprActivity

  • CBNestor Profile Picture
    CBNestor 44 on at
    RE: Attach Route Operations with specific Resource AX2012

    list of table collections

    pastedimage1619414168208v1.pngpastedimage1619414828370v1.png

  • CBNestor Profile Picture
    CBNestor 44 on at
    RE: Attach Route Operations with specific Resource AX2012

    Hi André,

    No idea about table collections and/or virtual companies. haven't touch that. I am just migrating data from one company to another (but just main tables, parameters and groups) trying to "make a copy" to build another legal entity. I dont know if that has something to do.

    But at least I haven't mess with virtual/table collections as far as I know? How to check/fix that?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 293,280 Super User 2025 Season 1 on at
    RE: Attach Route Operations with specific Resource AX2012

    Hi Nestor,

    The error message is mentioning virtual companies. Have you shared tables via table collections and did setup virtual companies?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,280 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,034 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans