When using Analysis Mode in the Open Customer Ledger Entries page and exporting data to Excel via Open in Excel, the Due Date column is not exported in a proper date format. As a result, Excel does not recognize these values as dates, which prevents users from filtering or grouping them by year, month, etc.

This behavior limits the usability of the exported data and requires manual reformatting, which is inefficient and error-prone.

Suggestion:

Ensure that date fields like Due Date are exported in a native date format compatible with Excel. This will allow users to take full advantage of Excel’s filtering and analysis capabilities without additional steps.