Sage 100

Data retention for AR Invoice History 4.10 + : I am pretty sure that the AR Open Invoice is purgeable on a different schedule than the AR Invoice History. Anyone know for sure which settings control which -- and more specifically how the AR Open Invoice file might purge but the AR History remain? I've got a customer who loves to see if I can reverse engineer Sage's logic to solve mysteries about what damaged their data --- with the leading cause proposed by them ""We didn't do anything"" which is followed (after about 5 hours of testing and queries) by ""oh yeah, now we remember"" .......

There are no setting for AR Invoice HIstory. You can only manually purge it. AR Open Invoice is that Days to Retain Paid Invoice thing in the setup options.

Remember that the days to retain paid invoices setting also purges the AP_TransactionPayment table (but not cash receipts). The TransactionPayment table would be useful for historical look ups.

Good info - thanks.