Hey Everybody!

From what I understand the OE Sales Report is all the sales from the last time the report was printed and cleared. What I'm curious about is how it knows the last time it was cleared. Does it store that date in a table and then just read the data from the standard tables checked against the stored date...or does it store the sales report data in a file and then just delete the file when chosen to clear?

If it's the latter, what is the file and where is it located? Is it a table accessible from ODBC or Gridview?

If it's the former, what table stores that date?

thanks!
Lucas

Never mind Everybody, I found it!

It's a table in Gridview called Sales Summary.

I appreciate those who were ready to help but I beat to the punch

Hi Lucas

That report is a dinosaur from the 1980s and is almost useless. It still exists because of the rule that a developer can never remove a function no matter how obsolete, because there might be one user in the world who would get upset.

If you want a meaningful sales report, you could look under Inquiries | Display History | Items, and select a customer, item and date range. If this isn't adequate, then Adagio SalesAnalysis can do a lot more. And neither of these depend on data that must be purged and therefore lost periodically.

Steve