You try to run your Microsoft Dynamics SL AP Check Register for a specific date, using the AP03630MC_WRK.DATE field as shown here:
When doing so, your report is completely blank, even though there are checks for this date. This is due to Microsoft Dynamics SL 2011 Bug 23391. Here are the steps to correct it:
Log into SQL Management Studio for the correct SQL instance. Click “New Query” to start a new SQL Query. Copy and paste this script and run it against the appropriate application database. Click here for the script.
You can now select checks by date in the AP Check Register report.
If you need assistance, please send us an email at Support@Crestwood.com