Work in Progress Report

Hi,

In BEAS for Manufacturing, Is there a report that shows a detailed valuation of "Work in Progress", ie Items issued from stores against all WO currently out on the shop floor ?

for example

WO Num, Child PN , Qty, Price Ea 
WO-1001, Pn-5123, 5, 81.50
WO-1001, Pn-8478, 12, 1.50
WO-1001, Pn-1005, 10, 2.25
WO-1005, Pn-4150, 1, 125.14
Etc...

If not an existing report is there any SQL that i can adapt?