We are currently using Microsoft Access to collect AR Invoice History detail data. We have data from 1999 & use Access to lookup prior invoice line information detail, which
displays service performed. We search by a UDF_ServiceLocation field. If possible we'd like to use Sage100 BI Explorer to view this information, the problem we found is
we have too much data & it takes hours to pull the AR Invoice History data so we can view it. We can't even pull all the data or are maxing out the number of rows to include in the Explorer view.
Is there a faster way to filter the AR History data without archiving the AR Invoice History data?