There are additional efforts to use Crystal Reports 2020 (@Sage 100 2023) with MS Office or text files. I have Custom Reports that include links to Excel and MS access. Without the native connectors we will have to use downloaded add-ins. Does anyone know a workaround for this? For MS Office files, I see that it is now necessary to:

1. Install the 64-Bit Microsoft Access Database Engine 2010 Redistributable or the Microsoft Access Database Engine 2016 Redistributable
2. Map a drive to network location of Sage 100
3. Setup a separate system DSN for each Excel or MS Access file at each workstation that would sourced by Crystal Reports
4. For Excel files, add "System Tables" on the Database tab of Crystal Reports Options.

Am I missing something? The SAP knowledge base article for this issue is here. One use of Excel files it to match the vendors invoice reference # with a Sage 100 UDF as they receive payment information via an Excel file that must be matched against AR_OpenInvoice. I work with many others that use MS Office and/or text files with Crystal that aren't yet on Sage 2023. Yikes, this is a lot of work to visit each user's workstation to do these step.