Hello All,

Please help me with creating a relationship between WorkOrder and POLINE when material is ordered out of storeroom. 

I want to fetch receiptscomplete field from poline for Workorder with the same line items. (I was able to fetch receiptscomplete for lineitems which has to be directly issue because in that case prnum is populated at wpmaterial, but I am struggling in storerooms case)

Thanks in Advance!

------------------------------
Abhilasha Gupta
------------------------------

Hello Abhilasha,

I assume that you meant this to be an internal PO as no vendor is involved in this Purchase order. If that's the case, have you tried with wonum in (select wonum from ponum where wonum=:wonum and siteid=:siteid and ponum in (select ponum from po where ponum=poline.ponum and siteid=poline.siteid and isinternal=1)). I don't recall the exact attribute for Internal order but check for this flag on the screen.