I am facing an issue in date format for Internal Customer Account Statement. It is coming in month/date/year format. I have changed the language of the customer to "en-gb’ thus the sale invoice date format and external customer account statement also coming correctly in terms of format i.e, date/month/year. But still Internal Customer Account Statment is coming mm/dd/yyyy format. Is anyone has any idea or solution.
Your help is appreciated.
have you change the date format.
thanks & Regards.
Check regional settings from your workstation from Windows Control Panel.
That is already done. It has nothing to do with the date format of statements.
I have already tried it. But it doesn’t work out…
I have made a small test in AX 2012 R2.
If I open the report using the language US (definable in options).
The date is displayed using format mm/dd/yyyy
If I change the language to Spanish, the date is displayed in format format dd/mm/yyyy
I hope it helps.
Have you checked by taking the Internal customer account statement? If it is coming also in date/month/year format, then it is very good.
By the way how did you change the report language? I am interested to know that.
Trying to find out the solution. Anyways thanks…
I didn’t change report language but the AX client language in File → Tools → Options
did anyone got solution for this?
i am also stuck on vendor account statement, entering date in dd/mm/yyyy format and it always dates in report as m/d/yyyy.
If you are using the SSRS to generate the report, you have to change the SSRS format.
Because the SSRS parameter is not following the AX one.