I would like to see the OE Order, Invoice and Credit note tables indexed by date (preferably) or at least by year and period. Customers frequently want reports by date range, for daily and weekly reporting. Currently such reporting on a database with years of history is either very slow, or the users have to enter a starting Invoice number to minimise the amount of data to be read and excluded by the report.

Indexing by date for OE sales history detail would also be useful.

by: Mary O. | over a year ago | Operations Management