Issue

A defect has been identified in Cashbook Reconciliation where selecting Accept after using the automatically populated reconciliation date can result in the following error:

"Date must be numeric"

Although the date displayed is correct, the system does not accept the pre-populated value.

Affected Versions

26.10.12

Symptoms

You may experience this issue when:

• Reconciling the cashbook for a single day.
• Entering the same Start Date and End Date.
• Selecting Accept after the date has been automatically populated.

Instead of continuing, Navigator displays:

Date must be numeric

Workaround

Until a permanent fix is available, the reconciliation can still be completed using the following workaround.

Steps

1. Navigate to Accounts > Cashbook > Reconcile.
2. Enter the required Start Date and End Date as normal.
3. Select Accept.
4. If the "Date must be numeric"message appears:
   • Click into the populated day field.
   • Delete the existing value.
   • Type only the day number (for example, type 2 if reconciling 02/07/26, or 15 if reconciling 15/07/26).
   • Do not re-enter the full date.
5. Select Accept again.
6. The reconciliation will continue successfully.

Important: Only the day number needs to be entered. The month and year do not need to be typed again.

Example

If you are reconciling 02/07/26:

• ❌ Do not re-enter 02/07/26
• ✅ Simply clear the field and type 2, then select Accept

Status

This behaviour has been identified as a suspected software defect under ID 18693 and has been logged for investigation by Development.

Until a permanent fix is available, the above workaround will allow the reconciliation to be completed successfully.