Quantity On Order - SQL Query

[TheGoldMineGuru]

Great Plains v10

I can see within IV00102 that my ItemNmbr '123' has QtyOnOrd = 10. Could someone please direct me to the necessary table(s) to find out where these are?

I do not doubt it is more complicated then a single table, but any help or direction would be great appreciated!!

 

[Dukester0122]

To check open orders for this item:

select SOPNUMBE,ITEMNMBR,QUANTITY from SOP10200
where itemnmbr = '123'

 

[TheGoldMineGuru]

Thanks for the post. I actually found what I was looking for. The QtyOnOrd from the Inventory record is located in POP10110. I joined this with POP10100 and the results appear to be accurate so far.

I could be wrong but so far it looks good.