I have a Gridview using table *OE Ord Detail w Head, Head Ext with Cust#, Bill Name, Item #, OELine Qty Backordered, OE Line Description, Order#, Order Date. This is working well to provide us with a list of back orders. Is there a table that would give me the ability to add Qty on PO and Expected Receipt Date?

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.

Thanks Bruce. We're making good use of Gridview these days! Once these views are set up and added to the views menu in OE and other modules, they are a real time saver throughout the day.