Hello Susan:

There is a composite table that provides i) OE Details, ii) OE Header and iii) IC Item Master. ("OE Ord Detail with Head, IC")

The IC Item Master would tell you "Qty on PO" but it doesn't know about "Expected Receipt Date(s)". That's in the POA tables.

If the number of Items on PO is small enough, you could use an Optional Field on the Item Master and update the Date manually. However I know that you have thousands of items so I don't think that is practical for you.

You could create a linked View into the POA Details. To see the Expected Receipt dates, you would double-click on the item in which you are interested and all of the matching POA records for that item would appear inthe linked View. This works well on-screen though not on paper or Excel.