You’re offline. This is a read only version of the page.
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
Thanks Bron I missed your answer
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
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
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.........
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (