Follow one of these resolutions to resolve this problem:
Resolution 1 - Enter offsetting adjustments to trick the system into having activity for this month as follows:
1. Enter the cutoff date in the Reconcile Bank Statements window.
2. Click
Transactions button.
3. Click the
Adjustments button.
4. Enter two adjustments in the Reconcile Bank Adjustments window for $.01 that offset each other. Enter one as an
Interest Income and the other as an
Other Expense for $.01 each and hit the same GL account. Click
OK. (These will not post to GL since it is a zero dollar transaction.)
5. Click
Reconcile. The process should now run and update the Last reconciled date for the checkbook.
Resolution 2 - Update the displayed date directly in the SQL table.
Go into SQL Server Management Studio and manually run a script to update the LAST_RECONCILED_DATE field in the Checkbook Master (CM00100) table for that checkbook ID.
update CM00100 set Last_Reconciled_Date = '2011-09-30' where CHEKBKID = 'XX'
(Change the date as appropriate in the script above and replace the XX placeholder with the checkbook ID before executing against the company database.)