We like to use automated reports. One of the gaps though is that someone still has to go in and refresh the store orders at 9:00PM when the report is sent in order to make sure all orders have been included.
This is obviously a task that needs to be cut away. I think there could be a timed store refresh or an indication to refresh store at either specific intervals or specific times.