Hello:
I'm doing queries on sales order history. The tables I have used so far are:
OESalesOrderHeader_ao80ahed
OESalesOrderDetaiol_ao80alin

The problem is that these tables only go back a couple of months. I know there are tables out there because I can look up old orders.

Does anyone know where the history of all order headers and details would be stored?

Thanks in advance. I tried other order entry tables with the "History" name, but the queries just hang up and I end up having to terminate the Microsoft Access task.

Rich Locus

Hi Rich,

There will be tables OEHistoryHeader and OEHistoryDetail for historical transactions.

If you are using Adagio OrderEntry 9.2A, you will want to be using the 92A versions of the table, not the 80A versions, otherwise there may be a data mismatch. That may be the cause of your problem.

When OrderEntry 9.3A is released, there are newer 93A-level dictionaries that will be required, for the data structure changes done for both current and historical transactions.

Thank you!