The place I'm at recently upgraded to the Sage 100 Standard 2016, not sure what they were using before, the answers I have been able to get are MAS90 or SMI.

The accounting department is using Report Manager, going to what they need and clicking Run. This will bring up a box that does some SQL database operations and then will say building Excel workbook, this goes for about 5 minutes.

After this is loaded, if they try to use BI Tools/add account to something in Excel, the dialog box pops up, but every single digit entered takes about 30 seconds to a minute.

This is running through a HyperV VM, and I uninstalled symantec to make sure the anti-virus wasn't causing issues.

From what I can gather I assume the database or something isn't configured correctly, but I don't really know anything about this system. If there is any further information needed or anything I can do to help find an answer to my problem just tell me.