today I want to leave a short note on Execution Timeout Expired. In case if you face it on your local dev environment, then consider adding following key in your web.config:
<add name="PXSqlDatabaseProvider" type="PX.Data.PXSqlDatabaseProvider,
PX.Data" ... queryTimeout="100" />
With that addition, you'll be able to execute long running queries without timeout.
But keep in mind, that such addition can affect performance of Acumatica for some cases. So use that freely for your dev instance, and be careful with your production instance.