Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Daryle Ridley]

Our ops department needed a Stock Status with Outstanding MOs showing on it.  I created a refreshable Excel report that pulled in the Inventory Stock Status from Victoria Yudias script and the ManufacturingOrders view from Sql.  I am using the end qty on the view from ManufacturingOrders.  This qty becomes inaccurate when we partially receive a MO.   Where can I find the “Received Qty” of an MO.  

I was able to see the qty I wanted in the excel file in the Inquiry-Manufacturing-Manufacturing Orders-Item Transactions window.  (see attached).

——————————
Daryle Ridley
Director of IT
Formetco
Duluth GA
——————————

[Harry Lee]

Daryle –

Work Order/MO Receipts are found in MOP1100 .QTYRECVD (table.field). The following code is from a backflush SQL view I created for a client that identifies when a line has been invoiced (after shipment), but the total of the receipts does not match the End Qty, as it should.  

The query groups by the MO, and sums up multiple receipts.

———————– SQL Code to summarize MO Receipts ————————–
left join (select manufactureorder_I, sum(QTYRECVD) Qty_Received from MOP1100 (nolock)
Group BY MANUFACTUREORDER_I) RCTS

— left join this code to any table containing MO numbers!
———————– End Code to summarize MO Receipts ————————–

——————————
Harry Lee
Managing Consultant
2015 & 2016 Microsoft MVP – Dynamics GP
Conexus SG
The Colony TX
——————————
——————————————-

[Sunny Mattoon]

?On the MOP1100 table, be sure to limited your query so it doesn’t include Reversed Receipts.

Add this and it should filter those out:
WHERE REVERSED_RECEIPT_I = 0

——————————
Sunny Mattoon
Implementing Consultant
InterDyn BMI
Portland OR
——————————
——————————————-

[Keith Paul]

Depending on what you are trying to track, You may want to include reversed receipts if you are looking to get the net received to stock.  I’m curious why you may be looking at work order receipts to indicate what has been invoiced. Wok Order order receipts place product into inventory. Invoicing is typically through the Sales Order module and processes.

——————————
Keith Paul
VP Business Management Systems
Unicom Engineering, Inc.
Plano TX
——————————
——————————————-

[Daryle Ridley]

Thanks for this tip Sunny.  I added to the query.

——————————
Daryle Ridley
Director of IT
Formetco
Duluth GA
——————————
——————————————-

[Daryle Ridley]

This was exactly what I was looking for Harry.  Thanks

Daryle

——————————
Daryle Ridley
Director of IT
Formetco
Duluth GA
——————————
——————————————-