[jboogie]

I am working on a saved search for our sales group and I am trying to include the "date of first sale" for items. I can't seem to find a way to get this added in. Any suggestions?
This is a cached copy. Click here to see the original post.

[MChammaTX]

This is not available natively, you will have to rely on joins to the transaction and use min to get the earliest date.

[SererraMike]

If this is an item search, you should be able to set criteria "Transaction Type = Sales Order/Invoice/Cash Sales (depending what you're keying off of" and on the results tab, include the transaction date, summary type = minimum. You'll have to group all of your other results columns, but it should give you what you're looking for.

[jboogie]

Sorry for the slow response..I've been super busy. This did work. Thank you very much.

[Author]

Posts