Sage 100

Sage Intell v2016 Customer needs the item details for all invoices that had payments in user defined date range (parameter). Is the best option, creating a new SQL Join connector with AR Transaction linked AR Invoice History Detail and filter on transaction type?

isn't the AR transaction table purged during period end processing based on the # of days to retain invoices in the AR Options table? Cash receipts history might be a more reliable source.

ARTransactionHistory was used in order to catch applied credit memos too.

Devil and a hard place.