We are a muti site manufacturing business. We do a stock take every week for filtered by site(location), inventory posting group, limited to a week back. Oldest site takes about 1hr to calculate the stock. almost 20% of the ILE are for 1 product which I think is the cause for the delay. Please let me hvae your thoughts how to improve this. There are 50,342,477 records in ILE.