Date format converted to US format when Sale Order Header is imported

(6) Share

Report

Posted on by CU12050152-0

259

When Sale order header is imported the requested receipt date and ship date is reversed to US format. Client is from UK region, can anyone help why date is changed to US Format in the staging table

Regards

Prasad

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Adis 6,686 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Which app are you using F&O or Finance?

How do you import the data, with the DMF or another solution?

Kind regards, Adis

Was this reply helpful? Yes No
André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Prasad,

If you used the data management features, there is a setting to let the import know in what format the dates should be evaluated. This is managed on the Source data formats using the field Language locale. Another option is to present the dates in the US format in the source file.

Was this reply helpful? Yes No
Ankit Life 687 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please try with changing the language of the User from user options and then import.

Regards,

Ankit

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,613 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Prasad,

As suggested by Andre, check this feature out in Data Management under the Sources -> Regional settings. Screen clip for your reference. Check the source of data being used to import into D365 (if you are using file as a mode to import data). Change the language setting from en-us to en-uk.

If the above methodology is not being used to import data, then a few questions:

1. What's the integration component that you are using to import Sales order header data? Is it Logic Apps or through a Power Automate flow or a non-D365 application?

2. Are you pulling data from a blob storage or a from database?

Was this reply helpful? Yes No
Verified answer

CU12050152-0 259 on at

Like (0)

Report
Copy link

Link copied!

Thanks for everyone, we need to modify in the source data format , we used source data format of csv in that have changed language as en-gb and set Time zone preference as user . The user setting is set as en-gb, this resolved the issue. Thanks for all your support

Was this reply helpful? Yes No