Hi Andrew:

Can you please explain to me what the OE Header table contains versus the OE Hist Header table? I don't use ACCPAC, so I don't really know how this all works. I'm just trying to recreate these Reportmaster reports for our sales team, so please forgive my ignorance.
I assume that OE information, at some point, gets moved from OE to OE History. Correct? Where would I find out when that happens?

I just tried to use the OE Hist HEader table with Cust, Terms and put only three fields into that report: Cust#, Inv Total YTD annd Inv Total LY. I didn't get anything back in GridView, which makes me think there's nothing i that OE Hist table.
The SR table appears to be huge... more than 700000 entries. Takes forever to query. Would that be my only hope to catch last (fiscal) year's sales?

Thx,

Andre