I am putting together a Gridview that will allow us to see what item need to be ordered along with when the expected ship date of that item is.

I have 3 gv files
Items to Purchase (Displays items, qtys in our Whse, Minimum order qty)
Locations (Displays stock levels at different locations)
Back Order Report (When you double click on an item in items to purchase this will show the customers that have that item on order as well as the expected ship date)

What I want to do is have the expected ship date appear in the Items to Purchase window, showing the oldest date.

How do I do this?

Hi Lance,

The expected ship date for a particular item on a particular OE order can be found on the OE Sales Order Detail table. If you create a new View on this table and include just the item number and D:Expected ship date fields as columns, then you can create a 'lookup table' to determine the oldest date by item code.

In this new view, select both columns and 'Set a sort order', so that the primary sort is by item code, and dates sorted Ascending (with oldest at the top by item). Create a Filter to select only items that are still outstanding, such as:
AND( NOT({Complete?} ) , {D: Doc Type} = "O" , {Line Type} = "R" )
And save this view and include in your GridVew Workspace.

Then in your view where you want to see the oldest expected ship date, create a new Calculated column and on the left, use the External References tree to search for this new view and the Expected Ship Date column. Once saved and the column formatted as a date, you will see the dates in your view.

Finally, ensure that your new lookup view is calculated before your main view, so use the File / Set Workspace Recalc Order function to select the new view with the raw dates to come before your main view.
---------------
For others reading this, you could do this process for any date, numeric or text field. And for date/numeric fields where you want the biggest number/latest date, the only other change to be made is to sort the desired column in the raw lookup view as Descending rather than Ascending. You can also include identifying columns (such as order number, for example) if you wanted to see on which order the oldest expected ship date was on.