Andrew,

I go into OE, History, Item. I choose the specific item, the customers, and the dates. In the case I was just looking at, I needed know the total dollar amount charged for the 1 item to all my customers for the month of January. After entering the criteria I waited 5 minutes with only 1 blue bar showing and the computer was still thinking. I clicked on Cancel and it brought all that I needed up. This was not a problem before the update.

Thanks,
Janie

Hi Andrew,

It is only when looking at historical data.

thanks

Hi Janie/Clint,

The History files underwent a structural conversion for 9.3A, including a new index by date, so certainly there were changes in this area.

I suspect the size of the data is relevant. When I check with sample data (which is very small as compared to what you might have in history), the loading is instant.

When I check with a backup of client's data with 3 million history details, the results are extremely slow when a specific customer or range or customers is selected. It's much faster when there is no customer range (ie blank to ZZZZZZ).

On the same data, a specific item or range of items made things faster than all items, as I would have expected. So there is something different about a range of customers. I will forward your comments to R&D. Thank you both for bringing this to our attention.

I think for now, I would recommend not selecting a customer range, and if you really need a particular customer range, export the results to Excel from the Excel Direct button and do the filtering there.

Slow searching in History has been fixed in the OrderEntry 9.3A (180213) HF.