Hello:
I am using the PODetailsMaster12Composite__au92acln to acquire information on the individual items ordered on a P.O. such as item number, quantity ordered, quantity received, etc. There are two dates in that table: MostRecentDate and ExpectedDate. The most recent date is not relevant. The ExpectedDate is a guess. Where is the actual Receipt Date? There isn't a field for that date. Is it in another table somewhere?

Thanks,
Rich Locus

Hi Rich, try this table:

POCompLinesHeader_au92bdh2

Vickie: Thanks for the response. We changed receiving methods last year, and now that table is Null. I wonder where else it could be hiding

Finally found it after importing every PO table. The receipt date for PO items is in POCompLinesHeader_au92adh2.