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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Report Production Pick...
Microsoft Dynamics AX (Archived)

Report Production Picklist

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I want to make a report for Production people to print multiple Job orders which are coming from one SO  in to one report.

I am used to report builder i can connect to AX Database directly and create a report with the help of Report Builder 3.

Can any one help me with the tables i need to lookup for data and the relationship.

After checking tables i found below mentioned tables pls help me to link the tables.

PRODTABLE

PRODBOM

INVENTDIM

PRODJOURNALBOM

I need to have the following fields in my report.

SALESID,PRODID,ITEMID,TRANSDATE,INVENTBATCHID,BOMITEMID,

Thank you.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    I have done something similar and would take a look at REQTRANS, REQTRANSCOV and REQTRANSPO, but you will have to recurse through the relations to get through any intervening higher level production, transfer order, quality orders, etc. If you have pegged orders, you could do similar through using INVENTREFID and INVENTREFTYPE following the chain of orders through to the SALESID.

  • Community Member Profile Picture
    Community Member on at

    Hi,

    Thank you for the reply.

    I still try to find the table which has got batchid with transactions.

    Thanks

  • Suggested answer
    Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    Something like:

    ProdTable.InventDimID --> InventDim.InventDimID

    ProdTable.ProdID --> ProdBom.ProdID (outer join)

    ProdTable.ProdID --> ProdJournalBom.ProdID (outer join)

    ...but I guess you want the query for this. I would need to be at my computer to do that, but hopefully you'll find the query.

    Why do you want ProdJournalBom in there?

    No routes?

  • Suggested answer
    Fredrik Sætre Profile Picture
    Fredrik Sætre 12,644 on at

    InventDim has the Batch Number (inventBatchId).

  • Community Member Profile Picture
    Community Member on at

    Hi Fredrik,

    Thank you so much for the reply.

    I will check and let you know.

  • Community Member Profile Picture
    Community Member on at

    Sorry Error

    Thank you

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=Texas++Firm+Registration+No+Lexitas+295+Madison+Avenue%22" - Nested quantifier +.