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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Route and Bom report
Microsoft Dynamics AX (Archived)

Route and Bom report

(0) ShareShare
ReportReport
Posted on by CaspJegl 70

Hello
I need to create a 'technological guide' report for a production order. It is supposed to be primarily a surgery and a used BOM. Eg, operation number = 10, operation id = Packing, ItemId (From Bom) and ItemName (From Bom). My question is how to get the BOM to the operation number. I tried in a few different ways but every time the query returns only one record to me, and sometimes several records are assigned to one operation (itemId). Could you help?

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,782 Super User 2025 Season 2 on at
    RE: Route and Bom report

    Hi CaspJegl,

    Can you explain what exact attempts you did? How did you define the query?

  • gkumar Profile Picture
    gkumar 740 on at
    RE: Route and Bom report

    Hi Caspel,

    As far as understand you are trying to query: for the operation number which BOM id of the item  was used.

    BOM Id and Route Id (Operations id/name and resource)are related to the Production order and Production order is related with the Finished good item id.

    You need to include this relation in your query to get your required output.

    Thanks,

    Ganesh

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,888 on at
    RE: Route and Bom report

    Your route needs to be set up with route relations to link items to operations -  see https://technet.microsoft.com/en-us/library/aa584158.aspx

  • CaspJegl Profile Picture
    CaspJegl 70 on at
    RE: Route and Bom report

    One operation contains several used BOM elements. E.g:

    Operation No. 10, Operation Id - Assembly.

    I would like my query to return all used items in this operation.

    in the case of the above example, there are 7 items assigned to the indicated operation, but my query returns only 1. I am new to Dynamics. Could you show me how to create the correct query?

  • CaspJegl Profile Picture
    CaspJegl 70 on at
    RE: Route and Bom report

    Problem solved.

  • Verified answer
    gkumar Profile Picture
    gkumar 740 on at
    RE: Route and Bom report

    Hi Caspjegl,

    Please update the status to resolved.

    Thanks,

    Ganesh

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
AlissonGodoy Profile Picture

AlissonGodoy 2

#2
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans