Looking at Manufacturing Orders Associated with Sales Order Lines in Dynamics GP 10

Here’s a query that will allow you to see which Open SO Lines have MOs associated with them and which MO exactly it is.

This is helpful when you’re looking to find “lost orders” that haven’t yet been processed in Manufacturing.

SELECT 
MO."MANUFACTUREORDER_I",
Sales."SOP Number",
Sales."Item Number",
Sales."Order Date",
Sales."QTY",
Sales."QTY Remaining",
Sales."Customer Name",
Sales."Item Description",
Sales."Due Date"
FROM dbo.SalesLineItems Sales
LEFT JOIN dbo.SOP10202ON Sales."SOP Number" = dbo.SOP10202.SOPNUMBEAND Sales."Line Item Sequence" = dbo.SOP10202.LNITMSEQ
LEFT JOIN dbo.IS010001 As MOON Sales."SOP Number" = MO.SOPNUMBEAND Sales."Line Item Sequence" = MO.LNITMSEQAND Sales."Item Number" = MO.ITEMNMBR
WHERE Sales."SOP Type" = 'Order' AND Sales."Sales Document Status" != 'Complete'AND Sales."QTY Remaining" > 0
ORDER BY "SOP Number" ASC
  1. No comments yet.

  1. No trackbacks yet.