Inventory Item Transaction Details - MO

(0) Share

Report

Posted on by babubaskaran@outloo...

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)

All responses (5)

Answers (2)

Suggested answer

Richard Whaley 25,195 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Bron 4 on at

Like (0)

Report

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.........

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report

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

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

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

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

Thanks Bron I missed your answer

Was this reply helpful? Yes No

Community site session details

Inventory Item Transaction Details - MO

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

Inventory Item Transaction Details - MO

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates