When we run a Gridview using O/E History Detail, we can retrieve the "unit price" for any item on any invoice and it will show the "unit price" as it was on that invoice, even if the base price is different today.
To retrieve the "standard cost" we have to "insert related column" and retrieve that field from IC Item. So, the "standard cost" always reports as of what the "standard cost" is today.
We want to retrieve the standard cost as of the date of the invoice. Is there any way to accomplish this?
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario