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?

SalesAnalysis has the standard cost as of the date of the invoice.

Is there any other way? We don't use Sales Analysis.

Susan:

Not if you want the Standard Cost at the time you made the sale.

Sales Analysis is a must have module for anyone doing distribution.