Others

How to Fix Incorrect Cheque Date Formatting in AX 2012 R3

Elise Williams Sep 30, 2026 869 views

Question details

The user needs to resolve a discrepancy where vendor payment cheques print with an incorrect date format on the production server, despite working perfectly on the test server.

How to Fix Incorrect Cheque Date Formatting in AX 2012 R3

Product: Microsoft Dynamics AX 2012 R3
Device & OS: not provided
Scenario: Printing vendor payment cheques from a production server environment.
Observed behavior: The cheque date format prints incorrectly on the production server, likely due to configuration, regional settings, or printer driver differences.

Before you start

Ensure you have administrative access to both your production and test servers to accurately compare regional configurations and printer settings.

Solution 1Recommended

Consult the Dynamics 365 Community for Specialized Assistance

Since AX 2012 R3 issues are often environment-specific, consulting Dynamics experts is the best way to identify complex server discrepancies.

Microsoft Dynamics AX 2012 R3 relies heavily on a combination of SSRS report designs, server regional configurations, and printer environments. Discrepancies between test and production servers are best investigated by specialized ERP experts.

Access the Community

Navigate to the official Dynamics 365 Community forums at https://community.dynamics.com/.

Create a Detailed Post

Start a new thread outlining the cheque date formatting discrepancy between your test and production servers.

Provide Environment Details

Include your exact AX 2012 R3 version, report design configurations, Windows Server regional settings, and the specific printer models used in production.

Consult the Dynamics 365 Community for Specialized Assistance

Important Context: Providing complete and accurate configuration differences will help Dynamics specialists pinpoint the root cause of the formatting error much faster.

Solution 2

Compare Regional and Printer Settings Between Servers

Manually verify that the operating system date formats and printer configurations match perfectly between your test and production servers.

Free Microsoft Office alternative

Manage Exported Financial Reports Easily with WPS Office

While Microsoft Dynamics AX handles your core ERP and cheque printing tasks, WPS Office is the ideal lightweight alternative for analyzing exported financial reports, verifying cheque logs, and managing your daily spreadsheets without the high cost of traditional Office subscriptions.

1. Import Exported Logs: Open WPS Spreadsheet and load the CSV or XLSX cheque log files exported from your AX 2012 R3 system.
2. Format Date Columns: Highlight the date columns, right-click, and select 'Format Cells' to standardize the visual date structure.
3. Analyze and Save: Use built-in financial formulas to verify cheque amounts and save the document in a universally compatible format.

Seamlessly compatible with Microsoft Excel (.xlsx) and Word (.docx) formats for managing exported AX reports.Easily apply custom date formats and financial formulas in WPS Spreadsheet.Lightweight, fast installation with a highly familiar user interface.A completely free alternative for your team's document and spreadsheet needs.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the cheque date format change when printing from a production server?

Date formats on printed reports are frequently tied to the host server's local operating system settings or specific printer driver configurations. If the production server uses a different default regional format (e.g., MM/DD/YYYY instead of DD/MM/YYYY) compared to the test server, the AX 2012 R3 cheque report will inherit that format.

Can I hardcode the date format directly in the AX report design?

Yes, developers can modify the SSRS (SQL Server Reporting Services) report design used by AX 2012 R3 to format the date field explicitly using an expression. This ensures the date format remains consistent regardless of the underlying server's regional settings.

How do I check my server's default regional date settings?

You can check the regional settings by opening the Windows Control Panel on your server, selecting 'Clock and Region', and then clicking 'Region'. From there, you can view and adjust the 'Short date' and 'Long date' formats.

Office Quick Solutions