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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Item Transac...
Microsoft Dynamics GP (Archived)

Inventory Item Transaction Details - MO

(0) ShareShare
ReportReport
Posted on by babubaskaran@outloo... 12

Hello There,

I am trying to find all the Manufacturing Order number  related to a given Inventory item number.  Basically if select or enter a Inventory item it should give me what all are the MO used this item so far.  Anybody tried this  or any suggestion for this.

Thanks,

babu

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    MO numbers are not associated with item numbers but they are associated with inventory transactions that add each batch of those items to inventory.

    In Inventory, under Inquiry, select Transaction Inquiry.  Enter the item number you are researching.  On the inquiry window, check the sort by date.

    Find the transaction that placed the item in inventory, highlight it, and click on the Number hyperlink.  In the Source field will be the MO number.

    If you have your items serial or lot tracked, you can use the Serial/Lot Trace inquiry and chase a specific serial or lot number trough the item's history to the MO that created that specific unit.

  • Verified answer
    Bron Profile Picture
    Bron 4 on at

    Babu -

    I've found that the MOP10213 table (mfg activity) is pretty good starting point. It takes a little bit of effort to understand - example Numerical activity codes represent types of transactions - it does store the Inventory adjustment document number which can be linked to the IV30300 table to get specific item numbers and costs.

    Basically the table represents the data an end user would see if they go to the manufacturing activity (under inquiry) screen..........

    Regards.........

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    Babu,

    Find the script below for Mo_Activity_View, all you need to do is to filter by the "required item number" to get all manufacturing orders related to this item. Of course, this includes both "Issue" and "Finshed Goods" items (in and out)

    SELECT  A.MANUFACTUREORDER_I,
            CASE A.MO_ACTIVITY_REASON_I
            WHEN 34 THEN 'Issue'
            WHEN 39 THEN 'Finished Good Post'
            ELSE ''
            END AS ReasonCoede,
            CASE A.DOCTYPE
            WHEN 1 THEN 'IV Transaction'
            ELSE ' '
            END AS Document_Type,
            B.DOCNUMBR,
            B.DOCDATE,
            B.ITEMNMBR,
            B.QTYBSUOM*B.TRXQTY AS Quantity
            FROM [MOP10213] AS A
            LEFT OUTER JOIN IV30300 AS B
            ON A.IVDOCNBR = B.DOCNUMBR
            WHERE A.DOCTYPE = 1
            ORDER BY A.MANUFACTUREORDER_I, A.IVDOCNBR


  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Hi Richard & Mohmoud,

    Thanks to both of you for clarifying this.  Thanks a log Mahmoud for providing the code, should work for me and I can create a SSRS report taking the item no. as input and display the output.

    Thanks,

    Babu

  • babubaskaran@outlook.com Profile Picture
    babubaskaran@outloo... 12 on at

    Thanks Bron I missed your answer

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans